mysql和sqlserver支持自增长字段,可使用如下方法获取插入数据的主键值
- mybatis sql管理文件,keyProperty对应User中用来存放主键值的字段,执行插入操作后,主键值会被放入parameterType的keyProperty属性中。
<insert id="insertUserAndGetUserId" useGeneratedKeys="true" keyProperty="userId" parameterType="com.study.User">
insert into tb_user (userName,password) values (#{userName},#{password})
</insert>
- User类
package com.study;
public class User {
//对应keyProperty中配置的userId
private Integer userId;
private String userName;
private String password;
public Integer getUserId() {
return userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}