xml 方式:
<insert id="insertUserAndGetId" parameterType="com.bl.crud01.mapper.User">
<selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
select last_insert_id();
</selectKey>
insert into user(username, birthday, sex, address)
values(#{username}, #{birthday}, #{sex}, #{address});
</insert>
注解方式:
@Insert("insert into user(username,address,sex,birthday) values(#{username},#{address},#{sex},#{birthday})")
@Options(useGeneratedKeys=true,keyProperty = "id", keyColumn = "id")
void insertUser(User user);