3.MyBatis常用

DATE_FORMAT(measuring_time, ‘%Y-%m-%d‘) AS measuring_time,

<if test="beginDate != null and beginDate != ‘‘">
  AND DATE_FORMAT(measuring_time, ‘%Y-%m-%d‘) >= #{beginDate}
</if>
<if test="endDate != null and endDate != ‘‘">
  AND DATE_FORMAT(measuring_time, ‘%Y-%m-%d‘) <= #{endDate}
</if>

<if test="healthStatuses != null">
  AND ha.health_status IN
  <foreach collection="healthStatuses" item="item" index="index" open="(" close=")" separator=",">
    #{item}
  </foreach>
</if>

<if test="teamName != null and teamName != ‘‘ ">
  AND team_name LIKE CONCAT(‘%‘, #{teamName} ,‘%‘)
</if>