3.3.7 修改和删除
七、修改和删除
1. 修改
<!-- 修改 -->
<update id="updUser" parameterType="user">
update t_user set username=#{username}, password=#{password} where id=#{id}
</update>
@Test
public void testUpd() {
SqlSession session = MyBatisUtil. getSession();
User user = new User();
user.setId(9);
user.setUsername(" 大名");
user.setPassword("abc");
int num = session. update("com.bjsxt.mapper.UserMapper.updUser",
user);
if (num > 0) {
System. out.println("SUCCESS");
session.commit();
} else {
System. out.println("FAILED");
session.rollback();
}
session.close();
}
2. 删除
<!-- 删除 -->
<delete id="delUser" parameterType="int">
delete from t_user where id=#{0}
</delete>
@Test
public void testDel() {
SqlSession session = MyBatisUtil. getSession();
int num = session. delete("com.bjsxt.mapper.UserMapper.delUser", 9);
if (num > 0) {
System. out.println("SUCCESS");
session.commit();
} else {
System. out.println("FAILED");
session.rollback();
}
session.close();
}