mysql插入一条数据后返回该数据的自增id

一.在mybatis中的加入useGeneratedKeys和keyProperty

例如:

  <insert id="insert" parameterType="com.hy.common.entity.User"
          useGeneratedKeys="true" keyProperty="id">
    insert into user (name, age)
    values ( #{name,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER})
  </insert>

二.取值示例

实体类:

package com.hy.common.entity;

import java.io.Serializable;

public class User implements Serializable {
    private Integer id;

    private String name;

    private Integer age;

    private String des;

    private static final long serialVersionUID = 1L;

    public User(Integer id, String name, Integer age, String des) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.des = des;
    }

    public User() {
        super();
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getDes() {
        return des;
    }

    public void setDes(String des) {
        this.des = des == null ? null : des.trim();
    }

}

数据库表:

取出插入后的id值:

    @Override
    @Transactional(readOnly = false)
    public int insertUser() {
        User user = new User();
        user.setName("why");
        user.setAge(18);

        int count = userMapper.insert(user);
        System.out.println(count);   // 插入的条数
        int id = user.getId();   
        System.out.println(id); // 自增的id

        return id;
    }

输出:

1
3

插入后的表: