mybaties之for each

mybatis中条件in之for each

 实体中定义变量

private List<Long> unitIdList;//门店id集合

 xml中

<if test="unitIdList != null ">
	and b.store_unit_id in 
	<foreach collection="unitIdList" open="(" close=")" separator="," index="index" item="item">
		#{item}
	</foreach>
  </if>

mybaties中大于号等处理,符号说明

<if test="bigAmount != null and bigAmount != ''">
  <![CDATA[ and a.bigAmount <=#{bigAmount} ]]>     
</if>

mybaties中choose when

<if test="validateStatusSelect != null and validateStatusSelect != ''">
	<choose>
                <when test="validateStatusSelect == 'UNVERIFIED'">
                       AND  (a.validate_status=#{validateStatusSelect} or a.validate_status is null)
                </when>
                <otherwise>
                         AND  a.validate_status=#{validateStatusSelect} 
                 </otherwise>
       	</choose>
</if>

mybaties 中 case when

 CASE
    WHEN equipment_source = 'cy' 
    THEN '超仪' 
    WHEN equipment_source = 'ym' 
    THEN '云丁' 
  END AS source,

mybaties中设置年月日 时分秒后按日期查找

&gt; 是>  &lt;是小于，是><在mybaties的另一种处理

AND info.meterReadDate &gt;= #{selectDate}
        AND info.meterReadDate &lt; date_add(#{selectDate}, interval 1 day)

代码是自己写的，最早是在哪个博客看到了忘记了。。。。