Mybatis插入一条新纪录(mysql中)，获得它的自增长id

两种方法：

<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);