Mybatis框架-Delete节点元素的使用

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

这个就也比较简单，需求：将我们最新插入的那条数据删除掉，从用户表中。

UserMapper.xml

UserMapper.java

编写测试方法：

     @Test

     public void testDelete() {

         SqlSession sqlSession = null;

         Integer id=21;

         int count=0;//返回受影响的行数

         try {

             sqlSession = MyBatisUtil.createSqlSession();

             //调用mapper接口的方式实现

              count= sqlSession.getMapper(UserMapper.class).deleteUser(id);

             // int i=1/0;//模拟异常  后台日志打印出rolling back表示没有插入成功，事务进行了回滚

             mlogger.info("返回受影响的行数：" + count);

             sqlSession.commit();//后台日志打印出rolling back表示没有提交事务，事务进行了回滚，所以必须得提交事务才行

         } catch (Exception e) {

             // TODO: handle exception

         } finally {

             // 最后一定要注意：关闭会话

             MyBatisUtil.closeSqlSession(sqlSession);

         }

     }

运行结果：

 [DEBUG] 2019-11-05 21:47:04,506 org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection

 [DEBUG] 2019-11-05 21:47:04,799 org.apache.ibatis.datasource.pooled.PooledDataSource - Created connection 176065613.

 [DEBUG] 2019-11-05 21:47:04,802 cn.smbms.dao.user.UserMapper.deleteUser - ooo Using Connection [com.mysql.jdbc.JDBC4Connection@a7e8c4d]

 [DEBUG] 2019-11-05 21:47:04,803 cn.smbms.dao.user.UserMapper.deleteUser - ==>  Preparing: delete from smbms_user where id=?

 [DEBUG] 2019-11-05 21:47:04,899 cn.smbms.dao.user.UserMapper.deleteUser - ==> Parameters: 21(Integer)

 [INFO] 2019-11-05 21:47:04,902 cn.smbms.dao.test.UserMapperTest - 返回受影响的行数：1

 [DEBUG] 2019-11-05 21:47:04,903 org.apache.ibatis.transaction.jdbc.JdbcTransaction - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@a7e8c4d]

 [DEBUG] 2019-11-05 21:47:04,907 org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@a7e8c4d]

 [DEBUG] 2019-11-05 21:47:04,908 org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@a7e8c4d]

 [DEBUG] 2019-11-05 21:47:04,909 org.apache.ibatis.datasource.pooled.PooledDataSource - Returned connection 176065613 to pool.