MyBatis动态sql_choose分支选择
EmployeeMapperDynamicSQL.java
package com.cn.mybatis.dao;
import java.util.List;
import com.cn.zhu.bean.Employee;
public interface EmployeeMapperDynamicSQL {
//<!-- 查询员工,要求,携带了哪个字段查询条件就带上这个字段的值 -->
public List<Employee> getEmpsByConditionIf(Employee employee);
//测试trim截取字符串
public List<Employee> getEmpsByConditionTrim(Employee employee);
// 测试choose
public List<Employee> getEmpsByConditionChose(Employee employee);
}
EmployeeMapperDynamicSQL.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.o