首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 媒体动画 > flex >

flex ibatis java 透过sql语句进行多条件模糊查询

2012-12-27 
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 &gt; 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 &lt; = #{beforelogintime}
      </if>  
       <if test="laterlogintime != null and beforelogintime != ''">
      and startTime &gt; = #{laterlogintime}
      </if>  
       <if test="today != null and today != ''">
      and convert(varchar,starttime,23) like #{today}
      </if>    
      <if test="betweenSmallTime != null and betweenSmallTime != ''">
      and startTime &gt;= #{betweenSmallTime}
      </if>      
       <if test="betweenBigTime != null and betweenBigTime != ''">
      and startTime &lt;= #{betweenBigTime}
      </if>   
        </select>      
    </mapper>
 

热点排行