Java MyBatis 插入数据库返回主键
1.首先mapper层
int insertUser(User u);
实体类
@Data
public User{
private Integer userId;
private String userName
private String password
private String comment
}
xml层
<insert id="insertUser" useGeneratedKeys="true" keyProperty="userId" parameterType="com.mybatis.User">
insert into user(userName,password,comment)
values(#{userName},#{password},#{comment})
</insert>
Tips:
useGeneratedKeys=“true” 表示给主键设置自增长
keyProperty=“userId” 表示将自增长后的Id赋值给实体类中的userId字段