mapper
List<listByConditionDTO> listByCondition(@Param("workType") Integer workType);
对应xml
<select id="listByCondition" resultType="com.komlin.modular.smart.pojo.dto.listByConditionDTO">
select room_work_type.*, mr_name,mr_place
from room_work_type
left join meet_room on rwt_room_id = mr_id
<if test="workType != null">
where rwt_work_type = #{workType}
</if>
</select>
这里面的workType的判断条件不能写成
<if test="workType != null and workType !=''">
加了and workType !=''
,当传入0时,会自动转化成空字符。