MyBatis（四）添加数据获取主键

在mapper.xml中设置两个属性

• useGeneratedKeys：设置使用自增的主键key
• Property：因为增删改有统一的返回值是受影响的行数，因此只能将获取的自增的主键放在传输的参数user对象的某个属性中

<!--void insertUser(User user);-->
<insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
	insert into t_user values (null,#{username},#{password},#{age},#{sex},#{email})
</insert>

package com.nmg.test;

import com.nmg.mybatis.mapper.SqlMapper;
import com.nmg.mybatis.pojo.User;
import com.nmg.mybatis.utils.SqlSessionUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;


public class sqlTest {

    @Test
    public void test1(){
        SqlSession sqlsession = SqlSessionUtils.getSqlsession();
        SqlMapper mapper = sqlsession.getMapper(SqlMapper.class);

        User user3 = new User(null,"赵六","4321",12,"男","321@sina.com");
        mapper.insertGetId(user3);
        System.out.println(user3);
    }
}

//返回：User{id=17, username='赵六', password='4321', age=12, sex='男', email='321@sina.com'}