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

前端之家收集整理的这篇文章主要介绍了XML有关键字无法识别怎么办?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

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

  1. <select id="PickUpCalUnit_LNGJTM" parameterClass="Hashtable">
  2. <![CDATA[
  3. SELECT b.CalculatorUnitID,b.BackupYear,a.UnitID,a.UnitName,a.GeoID,c.WorkID,c.CLLevelID
  4. FROM dbo.T_Unit a
  5. INNER JOIN t_calculatorunit b ON a.unitid = b.unitid
  6. INNER JOIN T_LatestResult c ON a.UnitID = c.UnitID
  7. WHERE a.UnitID IN (
  8. SELECT UnitID
  9. FROM T_LatestResult
  10. WHERE WorkID = ( SELECT MAX(a.WorkID) AS WorkID
  11. FROM T_LatestResult a
  12. JOIN T_Work b ON a.WorkID = b.WorkID
  13. JOIN DM_WorkStutas c ON b.StandardID = c.StandardID
  14. AND b.WorkStutasID = c.WorkStutasID
  15. WHERE a.CLLevelID = 1
  16. AND b.StandardID = 1
  17. AND DATEPART(year,b.WorkYear) < $Year$
  18. ) )
  19. AND c.WorkID = ( SELECT MAX(a.WorkID) AS WorkID
  20. FROM T_LatestResult a
  21. JOIN T_Work b ON a.WorkID = b.WorkID
  22. JOIN DM_WorkStutas c ON b.StandardID = c.StandardID
  23. AND b.WorkStutasID = c.WorkStutasID
  24. WHERE a.CLLevelID = 1
  25. AND b.StandardID = 1
  26. AND DATEPART(year,b.WorkYear) < $Year$
  27. )
  28. ]]>
  29. </select>

猜你在找的XML相关文章