添加数据在usermapper.xml中
<insert id="addUser" parameterType="com.zjh.pojo.User">
insert into t_user set name=#{name},pwd=#{pwd},sex=#{sex},age=#{age},did=#{did}
</insert>
查询其自增元素只需要在中间加入一下内容即可
<insert id="addUser" parameterType="com.zjh.pojo.User">
<!--keyProperty是指哪个属性自增,resultType指的是返回的类型是什么,order指的是在什么时候查询-->
<selectKey keyProperty="id" resultType="int" order="AFTER">
select LAST_INSERT_ID()
</selectKey>
insert into t_user set name=#{name},pwd=#{pwd},sex=#{sex},age=#{age},did=#{did}
</insert>
测试类:
@Test
public void adduser(){
User user = new User();
user.setName("找机会");
user.setPwd("666");
user.setSex("男");
user.setDid(1);
user.setAge(13);
sqlSession.insert("test.addUser",user);
sqlSession.commit();
System.out.println(user.getId());
}
结果:
DEBUG [main] - ==> Preparing: -- keyProperty是指哪个属性自增,resultType指的是返回的类型是什么,order指的是在什么时候查询 insert into t_user set name=?,pwd=?,sex=?,age=?,did=?
DEBUG [main] - ==> Parameters: 找机会(String), 666(String), 男(String), 13(Integer), 1(Integer)
DEBUG [main] - <== Updates: 1
DEBUG [main] - ==> Preparing: select LAST_INSERT_ID()
DEBUG [main] - ==> Parameters:
DEBUG [main] - <== Total: 1
DEBUG [main] - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@6e01f9b0]
29