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

不念不忘少年蓝@ 2023-10-09 09:37 50阅读 0赞

### **一.在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();
        }
    
    }

**数据库表:**

![20190924215640369.png][]

**取出插入后的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

**插入后的表:**

![20190924220148504.png][]

[20190924215640369.png]: https://img-blog.csdnimg.cn/20190924215640369.png
[20190924220148504.png]: https://img-blog.csdnimg.cn/20190924220148504.png