问题: 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]