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.