<update id="update" parameterType="User">
UPDATE t_user SET name = #{name}, age = #{age},
address = #{address} WHERE id = #{id};</update>
(Ⅱ)、在UserMapper接口里增加update()方法
intupdate(User user);
(Ⅲ)、在测试类TestUserMapper里添加测试方法testUpdate()
@TestpublicvoidtestUpdate(){int id =4;
User user = userMapper.findById(id);
System.out.println("更新前的记录:"+ user);
user.setName("李小海");
user.setAge(18);
user.setAddress("北京市朝阳区");int count = userMapper.update(user);
sqlSession.commit();//提交数据库if(count >0){
System.out.println("更新成功!");
System.out.println("更新后记录:"+ userMapper.findById(id));}else{
System.out.println("更新失败!");}}
(Ⅳ)、运行测试方法testUpdate(),查看结果
Ⅳ、删除表记录
(Ⅰ)、在UserMapper.xml文件里添加映射语句deleteById
<delete id="deleteById" parameterType="int">
DELETE FROM t_user WHERE id = #{id};</delete>
(Ⅱ)、在UserMapper接口里增加deleteById()方法
intdeleteById(int id);
(Ⅲ)、在测试类TestUserMapper里添加测试方法testDeleteById()
@TestpublicvoidtestDeleteById(){int id =4;
User user = userMapper.findById(id);
System.out.println("待删除的记录:"+ user);
userMapper.deleteById(id);
sqlSession.commit();//提交数据库
System.out.println("编号为["+ id +"]的记录删除成功!");
user = userMapper.findById(id);if(user != null){
System.out.println(user);}else{
System.out.println("编号为["+ id +"]的用户未找到。");}}