dao:
public List<Application> selectListByClassIdAndApprovalStateAndleaveType(String classId, String approvalState,
String leaveType, boolean flag) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("classId", classId);
map.put("approvalState", approvalState);
map.put("leaveType", leaveType);
map.put("flag", flag);
return sqlSession
.selectList("com.sict.dao.ApplicationDao.selectListByClassIdAndApprovalStateAndleaveType", map);
}
mybatis映射文件:
<choose>
<when test="leaveType==null">
<!-- 什么都不做 -->
</when>
<when test="leaveType=='12'.toString()">
sla.sla_leave_type in ('1','2')
</when>
<otherwise>
sla.sla_leave_type=#{leaveType}
</otherwise>
</choose>
注意: <when test="leaveType=='12'.toString()"> 字符串12后面要调用toString()方法