问题: XML这个文件在SQL2005中怎么不能测试输出数据呀? 这个语句错误在那儿呀 
<update id="UpdateNews" parameterClass="News"> 
      UPDATE [TB_News] SET [Title] = #Title#, [Content] = #Content#, [Author] = #Author#, [AddTime] = #AddTime#, [UserId] = #UserId# 
      WHERE [NewsId] = #NewsId# 
    </update> 
消息 102,级别 15,状态 1,第 1 行 
' <' 附近有语法错误。 
消息 102,级别 15,状态 1,第 4 行 
' <' 附近有语法错误。 
--------------------------------------- 1.    NEWS。XML <?xml version="1.0" encoding="utf-8" ?> 
<sqlMap namespace="News" 
xmlns="http://ibatis.apache.org/mapping" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">   <alias> 
    <typeAlias alias="News" type="DG_URCM.Model.News, DG_URCM.Model" /> 
  </alias>   <resultMaps> 
    <resultMap id="News_Result" class="News"> 
      <result property="NewsId" column="NewsId" /> 
      <result property="Title" column="Title" /> 
      <result property="Content" column="Content" /> 
      <result property="Author" column="Author" /> 
      <result property="AddTime" column="AddTime" /> 
      <result property="UserId" column="UserId" /> 
    </resultMap> 
  </resultMaps>   <cacheModels> 
    <cacheModel id="News_Cache" implementation="LRU"> 
      <flushInterval hours="120"/> 
      <flushOnExecute statement="InsertNews"/> 
      <flushOnExecute statement="UpdateNews"/> 
      <flushOnExecute statement="DeleteNews"/> 
      <property name="CacheSize" value="20"/> 
    </cacheModel> 
  </cacheModels>   <statements> 
    <select id="FindNews" parameterClass="String" resultMap="News_Result" cacheModel="News_Cache"> 
      SELECT * FROM [TB_News] WHERE NewsId = #value# 
    </select> 
    <insert id="InsertNews" parameterClass="News"> 
      INSERT INTO [TB_News] ([NewsId], [Title], [Content], [Author], [AddTime], [UserId]) 
      VALUES (dbo.fn_CreateNewsId(), #Title#, #Content#, #Author#, #AddTime#, #UserId#) 
    </insert> 
    <update id="UpdateNews" parameterClass="News"> 
      UPDATE [TB_News] SET [Title] = #Title#, [Content] = #Content#, [Author] = #Author#, [AddTime] = #AddTime#, [UserId] = #UserId# 
      WHERE [NewsId] = #NewsId# 
    </update> 
    <delete id="DeleteNews" parameterClass="String"> 
      DELETE FROM [TB_News] WHERE [NewsId] = #value# 
    </delete> 
    <select id="FindAllNews" parameterClass="map" resultMap="News_Result" cacheModel="News_Cache"> 
      SELECT * FROM [TB_News] 
      <dynamic prepend="Where"> 
        <isNotEmpty property="Title" prepend="And"> 
          Title Like '%$Title$%' 
        </isNotEmpty> 
        <isNotEmpty property="AddTime" prepend="And"> 
          AddTime = #AddTime# 
        </isNotEmpty> 
        <isNotEmpty property="Year" prepend="And"> 
          DATEPART(year, AddTime) = #Year# 
        </isNotEmpty> 
      </dynamic> 
      Order By AddTime Desc 
    </select> 
    <select id="GetNewsCount" parameterClass="map" resultClass="int"> 
      SELECT Count(*) FROM [TB_News] 
      <dynamic prepend="Where"> 
        <isNotEmpty property="Title" prepend="And"> 
          Title Like '%$Title$%' 
        </isNotEmpty> 
        <isNotEmpty property="AddTime" prepend="And"> 
          AddTime = #AddTime# 
        </isNotEmpty> 
        <isNotEmpty property="Year" prepend="And"> 
          DATEPART(year, AddTime) = #Year# 
        </isNotEmpty> 
      </dynamic> 
    </select> 
    <select id="FindNewsByTime" parameterClass="map" resultMap="News_Result" cacheModel="News_Cache"> 
      SELECT * FROM [TB_News] 
      <dynamic prepend="Where"> 
        <isNotEmpty property="AddTime" prepend="And"> 
          datediff(dd,#AddTime#,addtime)=0 
        </isNotEmpty> 
      </dynamic> 
    </select> 
    <select id="FindNewsByKeyWord" parameterClass="map" resultMap="News_Result" cacheModel="News_Cache"> 
      SELECT * FROM [TB_News] 
      <dynamic prepend="Where"> 
        <isNotEmpty property="Title" prepend="And"> 
          Title Like '%$Title$%' 
        </isNotEmpty> 
        </dynamic> 
  </select> 
    <select id="FindNewsByTimeAndKeyword" parameterClass="map" resultMap="News_Result" cacheModel="News_Cache"> 
      SELECT * FROM [TB_News] 
      <dynamic prepend="Where"> 
        <isNotEmpty property="AddTime" prepend="And"> 
          datediff(dd,#AddTime#,addtime)=0 
        </isNotEmpty> 
        <isNotEmpty property="Title" prepend="And"> 
          Title like '%$Title$%' 
        </isNotEmpty> 
      </dynamic> 
    </select> 
  </statements> 
</sqlMap> 
---------------------------------------------- 
2.  news table descriptions: CREATE TABLE [dbo].[TB_News]( 
[NewsId] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, 
[Title] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, 
[Content] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NOT NULL, 
[Author] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, 
[AddTime] [datetime] NOT NULL CONSTRAINT [DF_TB_News_AddTime]  DEFAULT (getdate()), 
[UserId] [int] NOT NULL, 
CONSTRAINT [PK_TB_News] PRIMARY KEY CLUSTERED 

[NewsId] ASC 
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY]