MyBatis动态sql_where查询条件

MyBatis动态sql_where查询条件

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); 	 } 

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.cn.mybatis.dao.EmployeeMapperDynamicSQL"> 	<!-- 查询员工，要求，携带了哪个字段查询条件就带上这个字段的值 --> 	<!--public List<Employee> getEmpsByConditionIf(Employee  employee);  --> 	<select id="getEmpsByConditionIf" resultType="com.cn.zhu.bean.Employee"> 		select * from tbl_employee  where  			<!-- 				test 判断表达式(OGNL) C:if test OGNL参照ppt或者官方文档 c:if test 从参数中取值进行判断 				遇见特殊符号应该去写转义字符 			--> 			<if test="id!=null"> 				 id=#{id}         </if> 			<if test="lastName!=null &&