MyBatis 中 where 条件的书写格式代码,Js代码库,德仔网

代码语言

代码分类

【Js】 MyBatis 中 where 条件的书写格式

作者:泽文 / 发布于2017/9/4/ 573

<select id="findInfo" resultType="BizInfoBar" parameterType="map">
   select v1.ID as id,v1.NAME as name,v1.STATE as states ,v1.PID as pid,v1.CREATE_DATE as createDate,v1.TYPE as type from BIZ_INFO_BAR v1
   <trim prefix="where" prefixOverrides="and">
       <if test="id != null and id !=''">
           and v1.PID=#{id} 
       </if>
       <if test="name != null and name != ''">
           and v1.NAME like concat(#{name},'%') 
       </if>
       <if test="pid != null and pid !=''">
          and v1.PID=#{pid} 
       </if>
   </trim>
   and v1.type <![CDATA[ <> ]]> '2'
   order by v1.CREATE_DATE desc
</select>


and o.create_time <= #{endTime,jdbcType=TIMESTAMP}//小于
 and o.create_time >= #{startTime,jdbcType=TIMESTAMP}//大于
and i.status_flag <![CDATA[ <> ]]> 'F'//不等于
<if test="dutyGroupName != null and dutyGroupName != '' " >
    AND DUTY_GROUP_NAME like '%'||#{dutyGroupName}||'%'    //模糊查询
   </if>

试试其它关键字

同语言下

可能有用的

泽文贡献的其它代码(6)