ibatis语句

<insert id="addCUMTActivitys"
parameterClass="com.njfj.xapp.cumt.bean.CUMTActivitys">
<![CDATA[insert into cumt_activitys
(userId, theme, startDate, endDate, location, organizers, introduction, picUrl)
values(#userId#, #theme#, #startDate#, #endDate#, #location#, #organizers#, #introduction#, #picUrl#)]]>
</insert>


<update id="updateCUMTActivitys"
parameterClass="com.njfj.xapp.cumt.bean.CUMTActivitys">
<![CDATA[update cumt_activitys set id=id ]]>
<isNotNull prepend=" , " property="userId">
userId=#userId#
</isNotNull>
<isNotNull prepend=" , " property="theme">
theme=#theme#
</isNotNull>
<isNotNull prepend=" , " property="startDate">
startDate=#startDate#
</isNotNull>
<isNotNull prepend=" , " property="endDate">
endDate=#endDate#
</isNotNull>
<isNotNull prepend=" , " property="location">
location=#location#
</isNotNull>
<isNotNull prepend=" , " property="organizers">
organizers=#organizers#
</isNotNull>
<isNotNull prepend=" , " property="introduction">
introduction=#introduction#
</isNotNull>
<isNotNull prepend=" , " property="picUrl">
picUrl=#picUrl#
</isNotNull>
<![CDATA[where id=#id# ]]>
</update>


<select id="queryCUMTActivitysList"
parameterClass="com.njfj.xapp.cumt.bean.CUMTActivitys"
resultClass="com.njfj.xapp.cumt.bean.CUMTActivitys">
<![CDATA[select * from cumt_activitys where 1=1 ]]>
<isNotEmpty prepend=" and " property="id">id=#id#</isNotEmpty>
<isNotEmpty prepend=" and " property="userId">
userId=#userId#
</isNotEmpty>
</select>


<select id="queryCUMTActivitysListCount"
parameterClass="java.util.HashMap" resultClass="java.lang.Integer">
<![CDATA[select count(*) from cumt_activitys where 1=1 ]]>
<isNotEmpty prepend=" and " property="filter.id">
id=#filter.id#
</isNotEmpty>
<isNotEmpty prepend=" and " property="filter.userId">
userId=#filter.userId#
</isNotEmpty>
</select>


<select id="queryCUMTActivitysListByPage"
parameterClass="java.util.HashMap"
resultClass="com.njfj.xapp.cumt.bean.CUMTActivitys">
<![CDATA[select * from cumt_activitys where 1=1 ]]>
<isNotEmpty prepend=" and " property="filter.id">
id=#filter.id#
</isNotEmpty>
<isNotEmpty prepend=" and " property="filter.userId">
userId=#filter.userId#
</isNotEmpty>
<isNotNull prepend=" " property="page">
limit #start#,#size#
</isNotNull>
</select>


<delete id="delCUMTActivitys"
parameterClass="com.njfj.xapp.cumt.bean.CUMTActivitys">
<![CDATA[delete from cumt_activitys where 1=1]]>
<isNotNull prepend=" and " property="id">id=#id#</isNotNull>
<isNotNull prepend=" and " property="userId">
userId=#userId#
</isNotNull>
</delete>