基于注解实现增删查改和多参数列表查询 - 数据库编程

employeerMapper.deleteEmployeer(id); session.commit() ; } finally { session.close(); } }
对应SQL语句：

    @Delete("delete from `t_employeer` where employeer_id = #{employeer_id}")
	public void deleteEmployeer(int id);

（5）列表查询

/**
	 * 单参数查询列表
	 */
	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 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; } /** * 多参数查询列表，使用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; }

对应的Sql语句

    @Select("select * from `t_employeer` where employeer_name like #{employeer_name}")
	@ResultMap("employeerResultMap")
	public List
  
    findEmployeerByName(String employeer_name);    
    
    @Select("select* from `t_employeer` where employeer_name=#{0} and employeer_department=#{1}")
	@ResultMap("employeerResultMap") 
	public List
   
     findEmployeerByNameandDep(String employeer_name,String employeer_department); @ResultMap("employeerResultMap") @Select("select* from `t_employeer` where employeer_name=#{key1} and employeer_department=#{key2}") public List
    
      findEmployeerByNameandDep1(Map
     
       map); @Select("select* from `t_employeer` where employeer_id =#{id}") @ResultMap("employeerResultMap") public Employeer findEmployeerByID(int id);

测试：

	System.out.println("=========================使用单参数查询===========================");
		List
  
    employeers=getEmployeerList("张三");
		 for(Employeer employeer:employeers){
             System.out.println(employeer);
         }
	 System.out.println("=========================使用多单参数查询===========================");
		 List
   
     employeers1=getEmployeerList("张三","产品二部"); for(Employeer employeer1:employeers1){ System.out.println(employeer1); } 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); }

结果：

基于注解实现增删查改和多参数列表查询(三)