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

利用Mybatis 的 selectKey来获得：

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>
9. 
   

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

在xml文件里加入<selectKey>，然后在程序中就可以用getId拿到了。