mybatis 添加一条新数据并返回此数据的ID(主键)

通常数据库中表的主键是‘自动递增(mysql)’或’序列(oracle)‘，但插入数据后又要取得些条数据的ID(将ID做为主键)

利用Mybatis 的 selectKey来获得：

[html]  view plain  copy

1. <!-- 添加部门 返回部门ID -->  
2. <insert id="addDept" parameterType="com.demo.model.Department" keyProperty="id">  
3.     <selectKey keyProperty='id' resultType='int' order='AFTER'  >  
4.         select LAST_INSERT_ID();  
5.     </selectKey>  
6.      insert into department(<include refid="departmentAllField"/>)   
7.         values(#{departmentId},#{departmentName},#{departmentManagerName},#{companyId});  
8.  </insert>  

或

[html]  view plain  copy

1. <insert id="addDept" parameterType="com.demo.model.Department" useGeneratedKeys="true" keyProperty="id">  
2.   insert into department(<include refid="departmentAllField"/>)   
3.    values(#{departmentId},#{departmentName},#{departmentManagerName},#{companyId});  
4. </insert><span style="font-family: Arial, Helvetica, sans-serif;"></span>  

注意：insert 标签中的 keyProperty  和  selectKey标签块中的 LAET_INSERT_ID() ,另外 order属性 对于 oracl为 BEFORE; mysql为AFTER

实体类：

[java]  view plain  copy

1. public class Department {  
2.     private int id;  
3.     private int departmentId;  
4.     private String departmentName;  
5.     private String departmentManagerName;  
6.     private int companyId;  
7.     private List<Employee> employees;  
8.     //...GET SET ...  
9. }  

测试：

[java]  view plain  copy

1. @Test  
2. public void testDao(){  
3.     deptDao = session.getMapper(DepartmentDao.class);  
4.   
5.     Department department = new Department();  
6.     department.setDepartmentName("ares");  
7.     department.setDepartmentManagerName("tom");  
8.     department.setDepartmentId(32);  
9.     department.setCompanyId(6201);  
10.   
11.     deptDao.addDept(department);  
12.     System.out.println("新部门ID:"+department.getId());  
13. }  

输出成功！