MyBatis-Plus 的简单查询

最新推荐文章于 2023-10-01 18:04:28 发布

chengqiuming

最新推荐文章于 2023-10-01 18:04:28 发布

阅读量982

点赞数

分类专栏： MyBatis 文章标签： mybatis

本文链接：https://blog.csdn.net/chengqiuming/article/details/120587089

版权

MyBatis 数据库删除测试批量操作

关键词由CSDN通过智能技术生成

一数据库

mysql> select * from user;
+---------------------+--------------+------+--------------------+---------------------+---------------------+---------+
| id                  | NAME         | age  | email              | create_time         | update_time         | version |
+---------------------+--------------+------+--------------------+---------------------+---------------------+---------+
|                   0 | auto         |   20 | 1243@qq.com        | NULL                | NULL                |    NULL |
|                   1 | Jone         |   18 | test1@baomidou.com | NULL                | NULL                |    NULL |
|                   2 | Jack         |   20 | test2@baomidou.com | NULL                | NULL                |    NULL |
|                   3 | Tom          |   28 | test3@baomidou.com | NULL                | NULL                |    NULL |
|                   4 | Sandy        |   21 | test4@baomidou.com | NULL                | NULL                |    NULL |
|                   5 | Billie       |   24 | test5@baomidou.com | NULL                | NULL                |    NULL |
| 1443158688033337346 | lucymaryupup |   20 | 1243@qq.com        | NULL                | 2021-09-30 08:51:12 |    NULL |
| 1443378040145903617 | ASSIGN_ID    |   20 | 1243@qq.com        | 2021-09-30 08:51:56 | 2021-09-30 08:51:56 |    NULL |
| 1444192337759502338 | zhangsan     |   20 | 1243@qq.com        | 2021-10-02 14:47:40 | 2021-10-02 14:55:10 |       2 |
+---------------------+--------------+------+--------------------+---------------------+---------------------+---------+

二根据id删除记录

1 测试代码

// 根据 id 删除
@Test
public void testDeleteId() {
    int rows = userMapper.deleteById(1444192337759502338L);
    System.out.println(rows);
}

2 测试结果

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a0df195] was not registered for synchronization because synchronization is not active
2021-10-02 16:28:36.039  INFO 17328 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2021-10-02 16:28:37.808  INFO 17328 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@605600260 wrapping com.mysql.cj.jdbc