列:
<selectKey keyProperty="id" resultType="integer" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey>
插入位置:
<insert id="insert" parameterType="com.wesure.securitywesure.bean.UploadFileDetail"><selectKey keyProperty="id" resultType="integer" order="AFTER"> SELECT LAST_INSERT_ID() </selectKey> insert into sr_upload_file_detail (id, user_id, upload_file_id, upload_file_name, upload_file_size, upload_file_time, upload_file_type, product_id, download_count, reserve_one, reserve_two, reserve_three ) values (#{id,jdbcType=INTEGER}, #{userId,jdbcType=VARCHAR}, #{uploadFileId,jdbcType=VARCHAR}, #{uploadFileName,jdbcType=VARCHAR}, #{uploadFileSize,jdbcType=VARCHAR}, #{uploadFileTime,jdbcType=TIMESTAMP}, #{uploadFileType,jdbcType=VARCHAR}, #{productId,jdbcType=INTEGER}, #{downloadCount,jdbcType=VARCHAR}, #{reserveOne,jdbcType=VARCHAR}, #{reserveTwo,jdbcType=VARCHAR}, #{reserveThree,jdbcType=VARCHAR} ) </insert>