MyBatis动态sql_trim自定义字符串截取

　　Mybatis动态sql_trim自定义字符串截取

　　EmployeeMapperDynamicSQL.javapackage com.cn.mybatis.dao;import java.util.List;import com.cn.zhu.bean.Employee;public interface EmployeeMapperDynamicSQL {//public List getEmpsByConditionIf(Employee employee);///测试trim截取字符串 List getEmpsByConditionTrim(Employee employee);}

　　EmployeeMapperDynamicSQL.xml select * from tbl_employee id=#{id} and id=#{id} and last_name like #{lastName} and email=#{email} and gender=#{gender}

　　MyBatisTest.java @Testpublic void testDynamicSql() throws IOException{SqlSessionFactory sqlSessionFactory=getSqlSessionFactory();SqlSession openSession=sqlSessionFactory.openSession();try {EmployeeMapperDynamicSQL mapper=openSession.getMapper(EmployeeMapperDynamicSQL.class);///测试if where Employee employee=new Employee(null, "%h%", null, null);List emps= mapper.getEmpsByConditionIf(employee);for(Employee emp: emps)System.out.println(emp);// 查询时，如果没有某些条件，sql组装可能会出现问题/// 1.给where 后加1=1，以后的条件都是and //2. mybatis 使用where 包括所有查询条件在内的标签。// mybatis 将where标签背后的第一个and 去掉// where只会去掉第一个多出的and 或者 orList emps2=mapper.getEmpsByConditionTrim(employee);for(Employee emp: emps2 ){System.out.println(emp);}///测试Trim} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}}