问题: 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]
<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]
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货