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

╰+哭是因爲堅強的太久メ 2021-09-10 12:48 376阅读 0赞

[林炳文Evankaka][Evankaka]原创作品。转载请注明出处[http://blog.csdn.net/evankaka][http_blog.csdn.net_evankaka]

在[【Mybatis】Mybatis入门概述及第一个Mybatis实例实现增删改查 ][Mybatis_Mybatis_Mybatis_]和[【Mybatis】Mybatis接口编程方式实现增删改查 ][Mybatis_Mybatis_]演示了如何使用XML来操作Mybatis实现CRUD，但是大量的XML配置文件的编写是非常烦人的。因此Mybatis也提供了基于注解的配置方式，下面我们来演示一下使用接口加注解来实现CRUD的的例子。

[本文工程免费下载][Link 1]

一、创建数据库、数据表

use test;  
    create table t_employeer(  
    employeer_id int not null  primary key AUTO_INCREMENT ,  
    employeer_name varchar(50) default null,  
    employeer_age int default null,  
    employeer_department varchar(100) default null,  
    employeer_worktype varchar(100) default null  
    )

二、创建工程

整个工程目录如下：

![20150515142950649][]

记得要导入相应的包！

1、雇员对应的类Employeer.java

package com.mucfc.model;
    /**
     * 雇员信息类
     *@author linbingwen
     *@time 2015.5.11
     */
    public class Employeer {
    	private Integer employeer_id;
    	private String employeer_name;
    	private Integer employeer_age ;
    	private String employeer_department;
    	private String employeer_worktype;
    	
    	public Employeer() {
    		super();
    	}
    	public Integer getEmployeer_id() {
    		return employeer_id;
    	}
    	public void setEmployeer_id(Integer employeer_id) {
    		this.employeer_id = employeer_id;
    	}
    	public String getEmployeer_name() {
    		return employeer_name;
    	}
    	public void setEmployeer_name(String employeer_name) {
    		this.employeer_name = employeer_name;
    	}
    	public Integer getEmployeer_age() {
    		return employeer_age;
    	}
    	public void setEmployeer_age(Integer employeer_age) {
    		this.employeer_age = employeer_age;
    	}
    	public String getEmployeer_department() {
    		return employeer_department;
    	}
    	public void setEmployeer_department(String employeer_department) {
    		this.employeer_department = employeer_department;
    	}
    	public String getEmployeer_worktype() {
    		return employeer_worktype;
    	}
    	public void setEmployeer_worktype(String employeer_worktype) {
    		this.employeer_worktype = employeer_worktype;
    	}
    	@Override
    	public String toString() {
    		return "Employeer [employeer_id=" + employeer_id + ", employeer_name="
    				+ employeer_name + ", employeer_age=" + employeer_age
    				+ ", employeer_department=" + employeer_department
    				+ ", employeer_worktype=" + employeer_worktype + "]";
    	}
    	
    
    
    }

Employeer.xml文件，用来放置一些映射，删除了Sql语句了

<?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.mucfc.dao.EmployeerMapper">
     
     
     <resultMap type="Employeer" id="employeerResultMap">
        <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>
        
     </mapper>

2、配置mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
    
    <configuration>
    	
    	<typeAliases>
    		<typeAlias alias="Employeer" type="com.mucfc.model.Employeer"/>
    	</typeAliases>
    	
    	
    	<environments default="development">
    		<environment id="development">
    			<transactionManager type="JDBC" />
    			<dataSource type="POOLED">
    			<property name="driver" value="com.mysql.jdbc.Driver"/>
    			 <property name="url" value="jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8"/> 
    			<property name="username" value="root"/> 
    			<property name="password" value="christmas258@"/>  
    			</dataSource>
    		</environment>
    	</environments>
    	
    	
    	<mappers>
    		<mapper resource="com/mucfc/model/Employeer.xml" />
    	</mappers>
    </configuration>

3、EmployeerMapper.java在添加Sql映射语句，使用注解的方式来实现

package com.mucfc.dao;
    
    import java.util.List;
    import java.util.Map;
    
    import org.apache.ibatis.annotations.Delete;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.ResultMap;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.SelectKey;
    import org.apache.ibatis.annotations.Update;
    
    import com.mucfc.model.Employeer;
    
    /**
     * SQL语句映射类
     * @author linbingwen
     * @time 2015.5.11
     */
    public interface EmployeerMapper {
        @Select("select * from `t_employeer` where employeer_name like #{employeer_name}")
    	@ResultMap("employeerResultMap")
    	public List<Employeer> findEmployeerByName(String employeer_name);    
        
        @Select("select* from `t_employeer` where employeer_name=#{0} and employeer_department=#{1}")
    	@ResultMap("employeerResultMap")
        
    	public List<Employeer> findEmployeerByNameandDep(String employeer_name,String employeer_department); 
    	@ResultMap("employeerResultMap")
    	@Select("select* from `t_employeer` where employeer_name=#{key1} and employeer_department=#{key2}")
    	public List<Employeer> findEmployeerByNameandDep1(Map<String,String> map);
    	
    	
    
    	@Select("select* from `t_employeer` where employeer_id =#{id}")
    	@ResultMap("employeerResultMap")
    	public Employeer findEmployeerByID(int id);
    
         @Insert(" insert into `t_employeer`(employeer_name,employeer_age,employeer_department,employeer_worktype) values(#{employeer_name},#{employeer_age},#{employeer_department},#{employeer_worktype})")
    	public void addEmployeer(Employeer employeer);
    
        @Delete("delete from `t_employeer` where employeer_id = #{employeer_id}")
    	public void deleteEmployeer(int id);
    
        @Update(" update t_employeer set employeer_name = #{employeer_name},employeer_age= #{employeer_age},employeer_department = #{employeer_department} ,employeer_worktype=#{employeer_worktype}  where employeer_id = #{employeer_id}  ")
    	public void updateEmployeer(Employeer employeer);
    
    }

4、测试使用

（1）单参数查找

/**
    	 * 查找
    	 */
    	public static Employeer findEmployeerById(int id) {
    		SqlSession session = null;
    		Employeer employeer=null;
    		try {
    			session = sqlSessionFactory.openSession();
    			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
    			employeer=employeerMapper.findEmployeerByID(id);
    		} finally {
    			session.close();
    		}
    		return employeer;
    	}

对应SQL语句：

@Select("select* from `t_employeer` where employeer_id =#{id}")
    	@ResultMap("employeerResultMap")
    	public Employeer findEmployeerByID(int id);

调用：

System.out.println(findEmployeerById(10));
    	  System.out.println(findEmployeerById(11));

结果：

![20150515143647002][]

（2）  添加

/**
    	 * 增加
    	 */
    	public static void addEmployeer(Employeer employeer){
    		SqlSession session = null;
    		try {
    			session = sqlSessionFactory.openSession();
    			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
    			employeerMapper.addEmployeer(employeer);
                session.commit() ;  		
    		} finally {
    			session.close();
    		}
    		
    	}

对应SQL语句：

@Insert(" insert into `t_employeer`(employeer_name,employeer_age,employeer_department,employeer_worktype) values(#{employeer_name},#{employeer_age},#{employeer_department},#{employeer_worktype})")
    	public void addEmployeer(Employeer employeer);

（3）更改

/**
    	 * 更改
    	 */
    	public static void updateEmployeer(Employeer employeer){
    		SqlSession session = null;
    		try {
    			session = sqlSessionFactory.openSession(); 
    			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
    			employeerMapper.updateEmployeer(employeer);
                session.commit() ;  		
    		} finally {
    			session.close();
    		}
    		
    	}

对应SQL语句：

@Update(" update t_employeer set employeer_name = #{employeer_name},employeer_age= #{employeer_age},employeer_department = #{employeer_department} ,employeer_worktype=#{employeer_worktype}  where employeer_id = #{employeer_id}  ")
    	public void updateEmployeer(Employeer employeer);

（4）删除

/**
    	 * 删除
    	 * 
    	 */
    	public static void deleteEmployeer(int id){
    		SqlSession session = null;
    		try {
    			session = sqlSessionFactory.openSession();
    			EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
    			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<Employeer> getEmployeerList(String employeer_name){
    		SqlSession session = null;
    		 List<Employeer> 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<Employeer> getEmployeerList(String employeer_name,String employeer_department){
    		SqlSession session = null;
    		 List<Employeer> 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<Employeer> getEmployeerList(Map<String, String> map){
    		SqlSession session = null;
    		 List<Employeer> 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<Employeer> findEmployeerByName(String employeer_name);    
        
        @Select("select* from `t_employeer` where employeer_name=#{0} and employeer_department=#{1}")
    	@ResultMap("employeerResultMap") 
    	public List<Employeer> findEmployeerByNameandDep(String employeer_name,String employeer_department); 
    	@ResultMap("employeerResultMap")
    	@Select("select* from `t_employeer` where employeer_name=#{key1} and employeer_department=#{key2}")
    	public List<Employeer> findEmployeerByNameandDep1(Map<String,String> map);
    	
    	
    	@Select("select* from `t_employeer` where employeer_id =#{id}")
    	@ResultMap("employeerResultMap")
    	public Employeer findEmployeerByID(int id);

测试：

System.out.println("=========================使用单参数查询===========================");
    		List<Employeer> employeers=getEmployeerList("张三");
    		 for(Employeer employeer:employeers){
                 System.out.println(employeer);
             }
    	 System.out.println("=========================使用多单参数查询===========================");
    		 List<Employeer> employeers1=getEmployeerList("张三","产品二部");
    		 for(Employeer employeer1:employeers1){
                 System.out.println(employeer1);
             }
    		 System.out.println("=========================使用多单参数map方式查询===========================");
    		 Map<String, String> map = new HashMap<String, String>(); 
    		 map.put("key1", "明明"); 
    		 map.put("key2", "财会部");
    		 List<Employeer> employeers2=getEmployeerList(map);
    		 for(Employeer employeer2:employeers2){
                 System.out.println(employeer2);
             }

结果：

![20150515144105650][]

[林炳文Evankaka][Evankaka]原创作品。转载请注明出处[http://blog.csdn.net/evankaka][http_blog.csdn.net_evankaka]

[本文工程免费下载][Link 1]

[Evankaka]: http://my.csdn.net/Evankaka
[http_blog.csdn.net_evankaka]: http://blog.csdn.net/evankaka
[Mybatis_Mybatis_Mybatis_]: http://blog.csdn.net/evankaka/article/details/45647401
[Mybatis_Mybatis_]: http://blog.csdn.net/evankaka/article/details/45670527
[Link 1]: http://download.csdn.net/detail/evankaka/8703487
[20150515142950649]: /images/20210811/e92aeb8b5b654e6c80b582c5112b5021.png
[20150515143647002]: /images/20210811/c00c61b3c03d45db8fd0601af278c2b3.png
[20150515144105650]: /images/20210811/1ebbf01061be46908fb6dd35488c1bf3.png