<select id="selectData" resultMap="ResultMap" parameterType="fr.gk.com.xxzx.common.pojo.Mark">
select * from mark
where 1=1
<if test="user != null and user != '' ">
and user like '%${user}%'
</if>
<if test="itime != null and itime != '' ">
and DATE_FORMAT(itime, '%Y-%m-%d') = DATE_FORMAT(#{itime},'%Y-%m-%d')
</if>
<if test="func != null and func != '' ">
and func like '%${func}%'
</if>
<if test="detail != null and detail != '' ">
and detail like '%${detail}%'
</if>
order by mark.itime desc
limit #{pageStart ,jdbcType=INTEGER}, #{pageSize ,jdbcType=INTEGER}
</select>
****写法:DATE_FORMAT(itime, ‘%Y-%m-%d’) = DATE_FORMAT(#{itime},’%Y-%m-%d’)
这里面,pojo里面传来的#{itime}是一个Date类型数据,可以用此方法尽心模糊查询,前段jsp文件中搜索框是一个时间输入插件,日期格式为‘yyyy-MM-DD’。实现了模糊查询。。。