Mybatis

insert返回主键

1
2
3

<insert id="insertSelective" parameterType="com.web.quickwork.entity.UserProject"
  useGeneratedKeys="true" keyProperty="id">
</insert>

<insert id="insertSelective" parameterType="com.zjchey.xxfy.geoCity.entity.Report">
  <selectKey keyProperty="uid" order="BEFORE" resultType="java.lang.Object">
    SELECT uuid_generate_v4()
  </selectKey>
</insert>

<insert id="insertSelective" parameterType="com.web.quickwork.entity.UserProject" >
  <selectKey resultType="long" order="AFTER" keyProperty="id">
    SELECT MAX (ID) FROM USERPROJECT
  </selectKey>
</insert>