Mybatis获取插入记录的自增长字段值
①在Mapper.xml文件中添加属性 “useGeneratedKeys” 和 “keyProperty” ,其中keyProperty是Java对象(即对应实体类)的属性名
<insert id="insert" parameterType="com.lv.bean.User" useGeneratedKeys="true"
keyProperty="id">
insert into user(name,age)values(#{name},#{age})
</insert>
实体类User
public class User {
private int id;
private String name;
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
②执行完插入语句后,自动将自增长的的id值赋给User的属性id。通过id的getter方法获取此id
@RequestMapping(value="/insert")
@ResponseBody
public int insert(User user){
int count=userMapper.insert(user);//count>0表示新增成功
//执行完增加操作后获取自增id
int id=user.getId;
return id;
}