<update id="UpdateUser" parameterType="com.mybatis.pojo.User">
UPDATE USER SET username = #{username} WHERE id = #{id}
</update>
<delete id="deleteUser" parameterType="int">
DELETE FROM `user` WHERE `id` = #{id1}
</delete>
test
public void testUpdateUser() throws IOException {
// 创建SqlSession对象
SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
User user = new User();
user.setId(30);
user.setUsername("鸡儿张");
//修改
sqlSession.update("user.UpdateUser", user);
System.out.println(user);
// 提交事务
sqlSession.commit();
// 释放资源
sqlSession.close();
}
@Test
public void testdeleteUser() throws IOException {
// 创建SqlSession对象
SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
sqlSession.delete("user.deleteUser",34);
// 提交事务
sqlSession.commit();
// 释放资源
sqlSession.close();
}