mybatis insert返回主键

1.student实体

@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class Student implements Serializable {

    private Long id;

    private String name;

    private SexEnum sex;

    private Date birthday;

    private Date createTime;

    private Classes classes;
}

2.mapper.xml

<!-- 主键返回：useGeneratedKeys="true" keyProperty="id"-->
    <insert id="insert" useGeneratedKeys="true" keyProperty="id">
        insert into student(name, sex, birthday, create_time) values(#{s.name}, #{s.sex}, #{s.birthday}, #{s.createTime})
    </insert>

3.mapper.java

int insert(@Param("s") Student student);

4.测试

	/**
     * @Description: 测试insert主键返回
     * @param: []
     * @return: void
     * @author: RenYuWen
     * @date: 2020/4/9 15:38
     */
    @Test
    public void insertTest() {
    
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        
        Student student = Student.builder().name("ccc").sex(SexEnum.FEMAIL).birthday(new Date()).createTime(new Date()).build();

        int result = sqlSession.getMapper(StudentMapper.class).insert(student);

        sqlSession.commit();

        if (result != 0) {
            System.out.println("插入成功！返回的id为：" + student.getId());
        } else {
            System.out.println("插入失败！");
        }
        
        sqlSession.close();
    }

5.SqlSessionUtil

package org.jgs1904.util;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

/**
 * @ClassName SqlSessionUtil
 * @Description mybatis 核心对象工具类
 * @Author RenYuWen
 * @Since 2020/4/9 12:46
 */
public class SqlSessionUtil {

    private SqlSessionUtil(){}

    private static SqlSessionFactory sqlSessionFactory = null;

    static {
        // 读取核心配置文件
        InputStream is = null;
        try {
            is = Resources.getResourceAsStream("mybatis-config.xml");
        } catch (IOException e) {
            e.printStackTrace();
        }
        // 创建SqlSessionFactory
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
    }

    /**
     * @Description: 获取SqlSession
     * @param: [autocommit] 是否自动提交事务
     * @return: org.apache.ibatis.session.SqlSession
     * @author: RenYuWen
     * @date: 2020/4/9 12:52
     */
    public static SqlSession getSqlSession(boolean autocommit){
        return sqlSessionFactory.openSession(autocommit);
    }

    /**
     * @Description: 获取SqlSession
     * @param: []
     * @return: org.apache.ibatis.session.SqlSession
     * @author: RenYuWen
     * @date: 2020/4/9 12:53
     */
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();
    }
}