<!-- 根据条件查询 -->
<select id="selectDeptRecord" resultType="com.xx.entity.job">
select * from job
<where>
1=1
<if test='Wtime!="" and Wtime!=null'>
and Wtime=#{Wtime}
</if>
<if test='Uname!="" and Uname!=null'>
and Uname=#{Uname}
</if>
</where>
</select>
<select id="selectDeptRecord" resultType="com.xx.entity.job">
select * from job
<where>
1=1
<if test='Wtime!="" and Wtime!=null'>
and Wtime=#{Wtime}
</if>
<if test='Uname!="" and Uname!=null'>
and Uname=#{Uname}
</if>
</where>
</select>