Java mybatis insert语句返回插入数据ID

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