最近插入一条数据同时,想获取新插入数据的主键id(注意:主键值是自动生成的),实现方法如下:
对象: public class People{ ....
private Integer id; private String name; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } ..... }
插入此对象:
useGeneratedKeys:自动生成主键
keyProperty:对象中的属性一致
<insert id="insert" parameterType="com.test.People" useGeneratedKeys="true" keyProperty="id">
insert into people (id, name)
values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR})
</insert>