Mybatis
使用useGeneratedKeys和keyProperty设置目标属性值
User user = User.builder().name(name).address(address).build(); // user.id 是null
mapper.saveUser(user); // user.id 非null,为主键值
// UserMapper.java
Integer saveUser(@Param("user") User user);
<insert id="saveUser" useGeneratedKeys="true" keyProperty="user.id" parameterType="com.example.sprintbootdemo.bean.User" >
insert into user
(<include refid="baseColumns" />)
values
(
#{user.id},
#{user.name},
#{user.address,typeHandler=com.example.sprintbootdemo.typehandler.AddressTypeHandler}
)
</insert>
xxx
Last updated