flex ibatis java 通过sql语句进行多条件模糊查询。!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3
flex ibatis java 通过sql语句进行多条件模糊查询。
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.rainmon.pm.sqlmapper.SQLMoUserSetManager" >
<insert id="insertInspectLog" parameterType="com.rainmon.pm.model.PojoMoUserSetAction">
<select id="searchLog" parameterType="com.rainmon.pm.model.PojoMoUserSetAction" resultType="HashMap">
select * from inspectLog
where userNum > 1
<if test="userCode != null and userCode != 0">
and userNum like #{userCode}
</if>
<if test="ip != null and ip!=''">
and ip like #{ip}
</if>
<if test="beforelogintime != null and beforelogintime != ''">
and startTime < = #{beforelogintime}
</if>
<if test="laterlogintime != null and beforelogintime != ''">
and startTime > = #{laterlogintime}
</if>
<if test="today != null and today != ''">
and convert(varchar,starttime,23) like #{today}
</if>
<if test="betweenSmallTime != null and betweenSmallTime != ''">
and startTime >= #{betweenSmallTime}
</if>
<if test="betweenBigTime != null and betweenBigTime != ''">
and startTime <= #{betweenBigTime}
</if>
</select>
</mapper>
