MybatisPlus

1.官网

MyBatis-Plus (baomidou.com)

2.加入依赖包

Spring Boot项目如下：

导入依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.2</version>
</dependency>

在配置文件加如下配置
mybatis-plus.type-aliases-package=com.beiyou.entity
mybatis.mapper-locations = classpath:mapper/*Mapper.xml

3.在启动类加上配置

4.Model

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@TableName("user")
public class User {
    @TableId(type = IdType.AUTO)
    private Integer id;
    private String username;
    private String password;
    private Date birthday;
    @TableField("sexqq")
    private String sex;
    private String address;
}

5.使用

6.使用单元测试测试

  <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.3.2</version>
    </dependency>
    <dependency>
      <groupId>org.junit.jupiter</groupId>
      <artifactId>junit-jupiter-api</artifactId>
      <version>5.6.0</version>
      <scope>test</scope>
    </dependency>

@SpringBootTest
@MapperScan("com.by.dao")
@Slf4j
@RestController
class AppTest {
   @Autowired
    UserMapper userMapper;

    @Test
    void test() {
      User user = User.builder().username("张三").password("123").address("河南").birthday(new Date()).sex("男").build();
        userMapper.insert(user);
    }

    @Test  //mybatisplus批量插入
    void test2(){
        List<User>userList =new ArrayList<>();
        for (int i = 0; i < 5; i++) {
            User user = User.builder().username("李四"+i).password("123"+i).address("河南").birthday(new Date()).sex("男").build();
            userList.add(user);
        }
        Integer integer = userMapper.insertBatch(userList);
    }
    @Test
    void test3(){
//        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
//        QueryWrapper<User> wrapper = queryWrapper.eq("username", "张三");
        LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
        LambdaQueryWrapper<User> wrapper = queryWrapper.ge(User::getId, 30);
        int delete = userMapper.delete(wrapper);
    }

    @Test
    void test4(){
        int i = userMapper.deleteById(39);
    }
    @Test
    void test5(){
        User user = userMapper.selectById(40);
        int i = userMapper.deleteById(user);
    }

    @Test
    void test6(){
        User user = userMapper.selectById(41);
    }

    @Test
    void test7(){
        //使用hutoll的工具进行新建集合
        List<User> userList = userMapper.selectBatchIds(CollUtil.newArrayList(7,8,9));
    }

    @Test
    void test8(){
        LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
        LambdaQueryWrapper<User> wrapper = queryWrapper.ge(User::getId, 30);
        Page page =new Page(2,3);
        Page page1 = userMapper.selectPage(page, wrapper);
    }

    @Test
    void test9(){
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
//        QueryWrapper<User> wrapper = queryWrapper.eq("username", "李四");
//        QueryWrapper<User> wrapper = queryWrapper.ge("id", 5);
//        QueryWrapper<User> wrapper = queryWrapper.gt("id", 5);
//        QueryWrapper<User> wrapper = queryWrapper.like("username", "李");
//        QueryWrapper<User> wrapper = queryWrapper.lt("id", 40);
//        QueryWrapper<User> wrapper = queryWrapper.in("id", 7, 8, 9);
//        QueryWrapper<User> wrapper = queryWrapper.between("id", 7, 9);
        QueryWrapper<User> wrapper = queryWrapper.orderBy(true, false, "id");
        List<User> userList = userMapper.selectList(wrapper);
    }
    @Test
    void test10(){
        int update = userMapper.updateById(User.builder().id(48).username("王五").build());
    }
    @Test
    void test11(){
        User user = User.builder().username("哇哈哈").build();
        LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
        LambdaQueryWrapper<User> wrapper = queryWrapper.ge(User::getId, 40);
        int update = userMapper.update(user, wrapper);
    }

}