@Transactional
<insert id="insert" parameterType="com.yunkai.training.assistant.model.Resource">
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">
SELECT LAST_INSERT_ID()
</selectKey>
insert into resource (file_name, file_size, dest_name,
file_type, create_time, deleted
)
values (#{fileName,jdbcType=VARCHAR}, #{fileSize,jdbcType=BIGINT}, #{destName,jdbcType=VARCHAR},
#{fileType,jdbcType=TINYINT}, #{createTime,jdbcType=TIMESTAMP}, #{deleted,jdbcType=TINYINT}
)
</insert>
select 和 insert 一个事务