XML这个文件在SQL2005中怎么不能测试输出数据呀？

feifeiyaqi3

问题： 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"
xmlnssi="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]