两种方法:
<span style="white-space:pre"> </span><insert id="addRole" parameterType="role" useGeneratedKeys="true" keyProperty="id">
<![CDATA[ insert into ptc_role(name,is_validate) values(#{name},#{isValidate}) ]]>
</insert>
<insert id="addRole" parameterType="role">
<![CDATA[ insert into ptc_role(name,is_validate) values(#{name},#{isValidate}) ]]>
<selectKey order="AFTER" resultType="int" keyProperty="id">
select last_insert_id() as id
</selectKey>
</insert>
执行插入操作后,当前对象的 id 就有值了,耶!
<span style="white-space:pre"> </span>service.addRole(role);
service.addRolePri(role.getId(),privileges);