<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="Account" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Account" type="UserObject.EntityClass.Account,UserObject" />
</alias> <cacheModel id="Account_cache" type ="LRU" readOnly="true" serialize="false">
<flushInterval seconds="60"/>
<property name="cache-size" value="1000" />
</cacheModel>
<resultMaps >
<resultMap id="AccountAllResult" class="Account"> <result property="Id" column= "Id" />
<result property="StrAccount" column= "StrAccount" />
<result property="StrPassword" column= "StrPassword" />
<result property="RegTime" column= "RegTime" />
<result property="LoginTime" column= "LoginTime" />
<result property="Email" column= "Email" />
<result property="Type" column= "Type" />
<result property="Sid" column= "Sid" />
<result property="LoginIp" column= "LoginIp" />
<result property="VipTime" column= "VipTime" />
<result property="FreezeTime" column= "FreezeTime" />
<result property="ChatTime" column= "ChatTime" />
<result property="OnlineTimeNum" column= "OnlineTimeNum" />
<result property="GoodsOnlineTimeNum" column= "GoodsOnlineTimeNum" />
<result property="IdCard" column= "IdCard" />
<result property="OfflineTime" column= "OfflineTime" />
<result property="SpreadCode" column= "SpreadCode" />
<result property="UserInviteCode" column= "UserInviteCode" />
<result property="LeagueInviteCode" column= "LeagueInviteCode" />
<result property="CountryInviteCode" column= "CountryInviteCode" />
<result property="LimitChat" column= "LimitChat" />
<result property="LimitLogin" column= "LimitLogin" />
</resultMap>
</resultMaps> <statements> <select id="SelectAllAccount" resultMap="AccountAllResult" resultClass="Account" cacheModel="Account_cache">
select * from Account
</select>
<update id="UpdateAccount" parameterClass="Account">
update Account
set
`StrAccount` = #StrAccount#, `StrPassword` = #StrPassword#, `RegTime` = #RegTime#, `LoginTime` = #LoginTime#, `Email` = #Email#, `Type` = #Type#, `Sid` = #Sid#, `LoginIp` = #LoginIp#, `VipTime` = #VipTime#, `FreezeTime` = #FreezeTime#, `ChatTime` = #ChatTime#, `OnlineTimeNum` = #OnlineTimeNum#, `GoodsOnlineTimeNum` = #GoodsOnlineTimeNum#, `IdCard` = #IdCard#, `OfflineTime` = #OfflineTime#, `SpreadCode` = #SpreadCode#, `UserInviteCode` = #UserInviteCode#, `LeagueInviteCode` = #LeagueInviteCode#, `CountryInviteCode` = #CountryInviteCode#, `LimitChat` = #LimitChat#, `LimitLogin` = #LimitLogin#
where `Id` = #Id#
</update>
<insert id="InsertAccount" parameterClass="Account">
insert into Account
(`StrAccount`,`StrPassword`,`RegTime`,`LoginTime`,`Email`,`Type`,`Sid`,`LoginIp`,`VipTime`,`FreezeTime`,`ChatTime`,`OnlineTimeNum`,`GoodsOnlineTimeNum`,`IdCard`,`OfflineTime`,`SpreadCode`,`UserInviteCode`,`LeagueInviteCode`,`CountryInviteCode`,`LimitChat`,`LimitLogin`)
values
(#StrAccount#,#StrPassword#,#RegTime#,#LoginTime#,#Email#,#Type#,#Sid#,#LoginIp#,#VipTime#,#FreezeTime#,#ChatTime#,#OnlineTimeNum#,#GoodsOnlineTimeNum#,#IdCard#,#OfflineTime#,#SpreadCode#,#UserInviteCode#,#LeagueInviteCode#,#CountryInviteCode#,#LimitChat#,#LimitLogin#) <selectKey resultClass="int" type="post" Property="Id" >
SELECT @@IDENTITY AS Id
</selectKey>
</insert> <delete id="DeleteAccount" parameterClass="string">
delete from Account where Id=#Id#
</delete>
</statements>
</sqlMap>
这是我配置的ibatisnet 的sqlmap的xml文件, 为什么红色字体出引用ibatis的缓存Id 一直要报错,, 有大神帮忙看下没C#
<sqlMap namespace="Account" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
<alias>
<typeAlias alias="Account" type="UserObject.EntityClass.Account,UserObject" />
</alias> <cacheModel id="Account_cache" type ="LRU" readOnly="true" serialize="false">
<flushInterval seconds="60"/>
<property name="cache-size" value="1000" />
</cacheModel>
<resultMaps >
<resultMap id="AccountAllResult" class="Account"> <result property="Id" column= "Id" />
<result property="StrAccount" column= "StrAccount" />
<result property="StrPassword" column= "StrPassword" />
<result property="RegTime" column= "RegTime" />
<result property="LoginTime" column= "LoginTime" />
<result property="Email" column= "Email" />
<result property="Type" column= "Type" />
<result property="Sid" column= "Sid" />
<result property="LoginIp" column= "LoginIp" />
<result property="VipTime" column= "VipTime" />
<result property="FreezeTime" column= "FreezeTime" />
<result property="ChatTime" column= "ChatTime" />
<result property="OnlineTimeNum" column= "OnlineTimeNum" />
<result property="GoodsOnlineTimeNum" column= "GoodsOnlineTimeNum" />
<result property="IdCard" column= "IdCard" />
<result property="OfflineTime" column= "OfflineTime" />
<result property="SpreadCode" column= "SpreadCode" />
<result property="UserInviteCode" column= "UserInviteCode" />
<result property="LeagueInviteCode" column= "LeagueInviteCode" />
<result property="CountryInviteCode" column= "CountryInviteCode" />
<result property="LimitChat" column= "LimitChat" />
<result property="LimitLogin" column= "LimitLogin" />
</resultMap>
</resultMaps> <statements> <select id="SelectAllAccount" resultMap="AccountAllResult" resultClass="Account" cacheModel="Account_cache">
select * from Account
</select>
<update id="UpdateAccount" parameterClass="Account">
update Account
set
`StrAccount` = #StrAccount#, `StrPassword` = #StrPassword#, `RegTime` = #RegTime#, `LoginTime` = #LoginTime#, `Email` = #Email#, `Type` = #Type#, `Sid` = #Sid#, `LoginIp` = #LoginIp#, `VipTime` = #VipTime#, `FreezeTime` = #FreezeTime#, `ChatTime` = #ChatTime#, `OnlineTimeNum` = #OnlineTimeNum#, `GoodsOnlineTimeNum` = #GoodsOnlineTimeNum#, `IdCard` = #IdCard#, `OfflineTime` = #OfflineTime#, `SpreadCode` = #SpreadCode#, `UserInviteCode` = #UserInviteCode#, `LeagueInviteCode` = #LeagueInviteCode#, `CountryInviteCode` = #CountryInviteCode#, `LimitChat` = #LimitChat#, `LimitLogin` = #LimitLogin#
where `Id` = #Id#
</update>
<insert id="InsertAccount" parameterClass="Account">
insert into Account
(`StrAccount`,`StrPassword`,`RegTime`,`LoginTime`,`Email`,`Type`,`Sid`,`LoginIp`,`VipTime`,`FreezeTime`,`ChatTime`,`OnlineTimeNum`,`GoodsOnlineTimeNum`,`IdCard`,`OfflineTime`,`SpreadCode`,`UserInviteCode`,`LeagueInviteCode`,`CountryInviteCode`,`LimitChat`,`LimitLogin`)
values
(#StrAccount#,#StrPassword#,#RegTime#,#LoginTime#,#Email#,#Type#,#Sid#,#LoginIp#,#VipTime#,#FreezeTime#,#ChatTime#,#OnlineTimeNum#,#GoodsOnlineTimeNum#,#IdCard#,#OfflineTime#,#SpreadCode#,#UserInviteCode#,#LeagueInviteCode#,#CountryInviteCode#,#LimitChat#,#LimitLogin#) <selectKey resultClass="int" type="post" Property="Id" >
SELECT @@IDENTITY AS Id
</selectKey>
</insert> <delete id="DeleteAccount" parameterClass="string">
delete from Account where Id=#Id#
</delete>
</statements>
</sqlMap>
这是我配置的ibatisnet 的sqlmap的xml文件, 为什么红色字体出引用ibatis的缓存Id 一直要报错,, 有大神帮忙看下没C#
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货