MyBatis-Plus 的简单查询

拼搏现实的明天。 2022-09-14 09:10 148阅读 0赞

# 一 数据库 #

# 二 根据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.ConnectionImpl@14229fa7] will not be managed by Spring
    ==>  Preparing: DELETE FROM user WHERE id=?
    ==> Parameters: 1444192337759502338(Long)
    <==    Updates: 1
    Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a0df195]
    1

### 3 测试后的数据库 ###

# 三 批量删除 #

### 1 数据库 ###

### 2 测试代码 ###

// 批量删除
    @Test
    public void testDeleteBatchIds() {
        int result = userMapper.deleteBatchIds(Arrays.asList(4, 5));
        System.out.println(result);
    }

### 3 测试结果 ###

Creating a new SqlSession
    SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ae7deac] was not registered for synchronization because synchronization is not active
    2021-10-02 16:31:28.742  INFO 11032 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    2021-10-02 16:31:30.613  INFO 11032 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    JDBC Connection [HikariProxyConnection@314966354 wrapping com.mysql.cj.jdbc.ConnectionImpl@2e807c54] will not be managed by Spring
    ==>  Preparing: DELETE FROM user WHERE id IN ( ? , ? )
    ==> Parameters: 4(Integer), 5(Integer)
    <==    Updates: 2
    Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ae7deac]
    2

### 4 测试后的数据库 ###

# 四 简单条件删除 #

### 1 数据库 ###

### 2 测试代码 ###

// 简单条件查询
    @Test
    public void testDeleteByMap() {
        HashMap<String, Object> map = new HashMap<>();
        map.put("name", "Jone");
        map.put("age", 18);
        int result = userMapper.deleteByMap(map);
        System.out.println(result);
    }

### 3 测试结果 ###

Creating a new SqlSession
    SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@9255c05] was not registered for synchronization because synchronization is not active
    2021-10-02 16:34:38.932  INFO 16992 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    2021-10-02 16:34:40.681  INFO 16992 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    JDBC Connection [HikariProxyConnection@204844842 wrapping com.mysql.cj.jdbc.ConnectionImpl@44550792] will not be managed by Spring
    ==>  Preparing: DELETE FROM user WHERE name = ? AND age = ?
    ==> Parameters: Jone(String), 18(Integer)
    <==    Updates: 1
    Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@9255c05]
    1

### 4 测试后的数据库 ###