sql里条件设置 及日期

//条件遍历

<if test="paramMap.source !=null and paramMap.source.size() != 0" >

and 1=1

<if test="! paramMap.source.contains('99'.toString()) ">

and uc.source in

<foreach collection="paramMap.source" item="source" index="index" open="(" close=")" separator=",">

#{source}

</foreach>

</if>

</if>

//起止日期设置

<if test="paramMap.crtTmStar != null and paramMap.crtTmStar != ''">

and convert(uc.crtTm,DATETIME) &gt;=#{paramMap.crtTmStar}

</if>

<if test="paramMap.crtTmEnd != null and paramMap.crtTmEnd != '' ">

and convert(uc.crtTm,DATETIME) &lt;= DATE_ADD(#{paramMap.crtTmEnd},interval 1 day )

</if>