mybatis 查询语句(按条件查询)

<select id="getAllDitch" parameterType="xxx.xx.entity.CheckDitch" resultType="xxx.xx.entity.CheckDitch">
select
<include refid="checkDitchColumns"/>
from check_ditch a
<where>
a.status not in (-1)
<if test="generalizeScene != null and generalizeScene != ''">
AND a.generalize_scene like concat('%',#{generalizeScene},'%')
</if>
<if test="useagePerson != null and useagePerson != ''">
AND a.useage_person like concat('%', #{useagePerson},'%')
</if>
<if test="generalizeWay != null and generalizeWay != ''">
AND a.generalize_way = #{generalizeWay}
</if>
<if test="status != null and status != ''">
AND a.status = #{status}
</if>
<if test="startTime != null and startTime != ''">
AND a.create_time >= #{startTime}
</if>
<if test="endTime != null and endTime != ''">
AND a.create_time &lt;= #{endTime}
</if>
</where>
<choose>
<when test="page !=null and page.orderBy != null and page.orderBy != ''">
ORDER BY ${page.orderBy}
</when>
<otherwise>
ORDER BY a.status DESC,a.update_time DESC,a.create_time DESC
</otherwise>
</choose>
</select>

 

切记:<if>标签语句一定要用and