比如:
<insert id = "add" parameterType = “net.lrd.video” userGeneratedKeys ="true" keyProperty = "id" key Column = "id">
insert into 'video' ('title' , 'summary' , 'cover_img' ,'price' , 'create_time')
values(
#{title,jdbcType = VARCHAR} ,#{summary,jdbcType = VARCHAR},#{cover_img,jdbcType = VARCHAR}
,#{price,jdbcType = INTEGER},#{create_time,jdbcType = TIMESTAMP} )
</insert>
userGeneratedKeys ="true" keyProperty = "id" key Column = "id" 就可以获取自增的主见