XML有关键字无法识别怎么办?

来源:互联网 发布:天音淘宝店铺 编辑:程序博客网 时间:2024/05/16 23:59

比如XML会视< 或 >为标记的开始结束,这时候就需要用<![CDATA[ xxxxxx ]]> 把你需要写入的结点内容括起来,如下

    <select id="PickUpCalUnit_LNGJTM" parameterClass="Hashtable">      <![CDATA[     SELECT  b.CalculatorUnitID ,            b.BackupYear ,            a.UnitID ,            a.UnitName ,            a.GeoID ,            c.WorkID,            c.CLLevelID    FROM    dbo.T_Unit a            INNER JOIN t_calculatorunit b ON a.unitid = b.unitid            INNER JOIN T_LatestResult c ON a.UnitID = c.UnitID    WHERE   a.UnitID IN (            SELECT  UnitID            FROM    T_LatestResult            WHERE   WorkID = ( SELECT   MAX(a.WorkID) AS WorkID                               FROM     T_LatestResult a                                        JOIN T_Work b ON a.WorkID = b.WorkID                                        JOIN DM_WorkStutas c ON b.StandardID = c.StandardID                                                              AND b.WorkStutasID = c.WorkStutasID                               WHERE    a.CLLevelID = 1                                        AND b.StandardID = 1                                        AND DATEPART(year, b.WorkYear) < $Year$                             ) )            AND c.WorkID = ( SELECT MAX(a.WorkID) AS WorkID                             FROM   T_LatestResult a                                    JOIN T_Work b ON a.WorkID = b.WorkID                                    JOIN DM_WorkStutas c ON b.StandardID = c.StandardID                                                            AND b.WorkStutasID = c.WorkStutasID                             WHERE  a.CLLevelID = 1                                    AND b.StandardID = 1                                    AND DATEPART(year, b.WorkYear) < $Year$                           )       ]]>    </select>