mapper文件的代码为:
<insert useGeneratedKeys="true" keyProperty="userid" id="insertUser" parameterType="users">
insert into users(username,password,sex,birthday,age)
values(#{username},#{password},#{sex},#{birthday},#{age})
</insert>
userGeneratekeys=“true”
keyProperty=“主键名”
测试类中代码,以及输出结果
public class Test1 {
public static void main(String[] args) {
SqlSession session= SessionUtil.getsession();
UsersDao dao= session.getMapper(UsersDao.class);
Users u=new Users(1,"abc1111","111",12,new Date(),'男');
int k=dao.insertUser(u);
session.commit();
System.out.println("userid="+u.getid());//输出方式直接用get()
System.out.println("k="+k);
}
}
返回的结果保存在对象 “u” 里面