<insert id="insert" keyProperty="adId" parameterType="com.zhdm.pojo.Advertise">
<!-- WARNING - @mbggenerated This element is automatically generated by
MyBatis Generator, do not modify. This element was generated on Wed Jun 18
09:55:34 CST 2014. -->
insert into ad_advertise_t (ad_id, ad_type, is_del,
is_audit, crtime,
user_id,
scope, user_ids)
values (#{adId,jdbcType=BIGINT},
#{adType,jdbcType=TINYINT},
#{isDel,jdbcType=BIT},
#{isAudit,jdbcType=BIT}, #{crtime,jdbcType=TIMESTAMP},
#{userId,jdbcType=INTEGER},
#{scope,jdbcType=INTEGER},
#{userIds,jdbcType=LONGVARCHAR})
//获取插入的id
<selectKey resultType="java.lang.Long" order="AFTER"
keyProperty="adId">
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
数据库中插入一条记录后获取主键id
最新推荐文章于 2021-02-18 02:58:37 发布