mysql 主键返回

<insert id="insert" parameterType="com.entity.User">

<!-- 此处的主键不让自增 -->

<selectKey keyProperty="id" resultType="java.lang.String" order="before">

        select uuid() as uuid

</selectKey>

<!-- 主键返回之自增主键 -->

<selectKey keyProperty="id" resultType="java.lang.Long" order="after">

        select LAST_INSERT_ID()

</selectKey>

insert into user_info(id, user_name)values(#{uuid}, #{userName});

insert into user_sore(user_info_id, sore) values

<foreach collection="User.list" separator="," item="item">

        (#{uuid}, #{item.sore})

</foreach>

</insert>