获取新增数据的主键

1 获取自增主键

方法一:selectKey

   <insert id="insertStudent" parameterType="com.softeem.entity.Student2">
        <selectKey resultType="int" keyColumn="id" keyProperty="id" order="AFTER">
            SELECT last_insert_id()
        </selectKey>
        INSERT INTO student3(`name`,create_time) VALUES(#{name},#{createTime})
    </insert>

方法二:官方推荐

    <insert id="insertStudent2" parameterType="com.softeem.entity.Student2"
            useGeneratedKeys="true" keyProperty="id" keyColumn="id">
INSERT INTO student3(`name`,create_time) VALUES(#{name},#{createTime})
</insert>

2 获取主键(非自增)

   <insert id="insertStudent" parameterType="com.softeem.entity.Student3">
        <selectKey resultType="string" keyColumn="id" keyProperty="id" order="BEFORE">
            SELECT REPLACE(UUID(),'-','')
        </selectKey>
        INSERT INTO student4(id,`name`,create_time) VALUES(#{id},#{name},#
        {createTime})
    </insert>