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();

}

 

转载于:https://www.cnblogs.com/kendyho/p/10812732.html