mybatis插入SQL语句返回该条SQL的ID
将下面两个属性添加到insert标签中 即可得到返回的SQL ID
useGeneratedKeys="true" keyProperty="id"
例
<insert id="insert" parameterType="com.entity.RiskClientGs" useGeneratedKeys="true" keyProperty="id">
insert into risk_client_gs (id,phone, create_time,update_time)
values (#{id,jdbcType=BIGINT}, #{phone,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP},#{updateTime,jdbcType=TIMESTAMP})
</insert>
service获取ID
public Long insertSelective(@RequestBody RiskClientGs record) {
riskClientGsMapper.insertSelective(record);
return record.getId();
}
https://marketing.csdn.net/poster/112?utm_source=1538247462&spm=1000.2116.3001.4180