多参数查询与列表查询不同方式实现

	/**
	 * 注意要和Employeer.xml的方法名对应
	 */
	public List findEmployeerByName(String employeer_name);   

	/**
	 * 查询列表
	 */
	public static List getEmployeerList(String employeer_name){
		SqlSession session = null;
		 List employeers=null;
		try {
			session = sqlSessionFactory.openSession(); 
			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
			 employeers = employeerMapper.findEmployeerByName(employeer_name);	
            session.commit() ;  		
		} finally {
			session.close();
		}
		return employeers;
   
    }
	public static void main(String[] args) {							
		List employeers=getEmployeerList("张三");
		 for(Employeer employeer:employeers){
             System.out.println(employeer);
         }

	}

结果：

其中的数据的之前插入的，现在要查找张三的列表全部都列出来了。

二、多参数查询

（1）方法一

EmployeerMapper中定义

	/**
	 * 多参数查询，注意要和Employeer.xml的方法名对应
	 */
	public List findEmployeerByNameandDep(String employeer_name,String employeer_department);

<!-- 定义数据库字段与实体对象的映射关系 -->  
<resultMap type="Employeer" id="resultMap">  
   <id property="employeer_id" column="employeer_id"/>   
   <result property="employeer_name" column="employeer_name"/>  
   <result property="employeer_age" column="employeer_age"/>  
   <result property="employeer_department" column="employeer_department"/>  
   <result property="employeer_worktype" column="employeer_worktype"/>  
</resultMap>  

<!--多参数 查找 返回list 的select 语句，注意 resultMap 的值是指向前面定义好的 -->  
     <select id="findEmployeerByNameandDep"  resultMap="resultMap">  
     select* from `t_employeer` where employeer_name=#{0} and employeer_department=#{1}  
     </select>   

测试代码：

	/**
	 * 多参数查询列表
	 */
	public static List getEmployeerList(String employeer_name,String employeer_department){
		SqlSession session = null;
		 List employeers=null;
		try {
			session = sqlSessionFactory.openSession(); 
			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
			 employeers = employeerMapper.findEmployeerByNameandDep(employeer_name, employeer_department);
            session.commit() ;  		
		} finally {
			session.close();
		}
		return employeers;
   
    }

    public static void main(String[] args) {   
         System.out.println("=========================使用多单参数查询===========================");
         List employeers1=getEmployeerList("张三","产品二部");
         for(Employeer employeer1:employeers1){
             System.out.println(employeer1);
         }

方法二：

将 resultMap="resultMap" 改成 resultType="Employeer"

<!--多参数 查找 返回list 的select 语句，注意 resultMap 的值是指向前面定义好的 -->  
     <select id="findEmployeerByNameandDep"  resultType="Employeer">  
     select* from `t_employeer` where employeer_name=#{0} and employeer_department=#{1}  
     </select>   

	/**
	 * 多参数查询，注意要和Employeer.xml的方法名对应
	 */
	public List findEmployeerByNameandDep1(Map map);

<!--多参数 查找 返回list 的select 语句，注意 resultMap 的值是指向前面定义好的,注意key1和key2为传入的map的键值 -->  
<select id="findEmployeerByNameandDep1" parameterType="map" resultType="Employeer">  
select* from `t_employeer` where employeer_name=#{key1} and employeer_department=#{key2}  
</select>   

测试使用：

	/**
	 * 多参数查询列表，使用map
	 */
	public static List getEmployeerList(Map map){
		SqlSession session = null;
		 List employeers=null;
		try {
			session = sqlSessionFactory.openSession(); 
			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
			 employeers = employeerMapper.findEmployeerByNameandDep1(map);
            session.commit() ;  		
		} finally {
			session.close();
		}
		return employeers;
   
    }

		 System.out.println("=========================使用多单参数map方式查询===========================");
		 Map map = new HashMap(); 
		 map.put("key1", "明明"); 
		 map.put("key2", "财会部");
		 List employeers2=getEmployeerList(map);
		 for(Employeer employeer2:employeers2){
             System.out.println(employeer2);
         }

结果：