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

最新推荐文章于 2025-06-26 09:33:53 发布

原创最新推荐文章于 2025-06-26 09:33:53 发布 · 2.2w 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #selectKey #keyProperty

spring+mybatis 专栏收录该内容

11 篇文章

订阅专栏

本文介绍如何在Mybatis中通过selectKey和insert标签实现获取插入数据后的ID值，以及实体类的设计和测试过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

利用Mybatis 的 selectKey来获得：

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

或

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

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

实体类：

public class Department {
	private int id;
	private int departmentId;
	private String departmentName;
	private String departmentManagerName;
	private int companyId;
	private List<Employee> employees;
	//...GET SET ...
}

测试：

@Test
public void testDao(){
	deptDao = session.getMapper(DepartmentDao.class);

	Department department = new Department();
	department.setDepartmentName("ares");
	department.setDepartmentManagerName("tom");
	department.setDepartmentId(32);
	department.setCompanyId(6201);

	deptDao.addDept(department);
	System.out.println("新部门ID:"+department.getId());
}

输出成功！