<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