Mybatis的insert
2020.02.05 18:41
2020.02.05 18:41
1. Insert标签
1.1. 获取自增ID
对于mysql等来说,我们添加时有一个自增的字段(一般为id),那么在Mybatis中,怎么获取呢?
配置mapper.xml
添加两个属性:
- useGeneratedKeys="true"
- keyProperty
<!--
useGeneratedKeys="true";使用自增主键获取主键值策略
keyProperty;指定对应的主键属性,也就是mybatis获取到主键值以后,将这个值封装给javaBean的哪个属性
-->
<insert id="insert" parameterType="com.misiai.bean.Employee" useGeneratedKeys="true" keyProperty="id">
insert into employee (last_name, email, gender) values (#{lastName},#{email},#{gender});
</insert>
测试方法:
@Test
public void test04() throws IOException {
SqlSession sqlSession = getSqlSession();
EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
Employee employee = new Employee("TestInsert", "TestInsert@misiai.com", "男");
mapper.insert(employee);
// 获取自增的id
System.out.println(employee.getId());
sqlSession.commit();//记得提交
}
本节阅读完毕!
(分享)