springboot整合mybatis-plus（3）条件查询

• 根据指定id查询

 	@Test
    void findUserById(){
        User user = userMapper.selectById(2l);
        System.out.println(user);
    }

• 测试批量查询

 @Test
    void testBatchId(){
        List<User> users = userMapper.selectBatchIds(Arrays.asList( 2, 3,4));
        users.forEach(System.out::print);
    }

• 自定义查询

	@Test
    void testBatchMap(){
        Map<String, Object> map = new HashMap<>();
        map.put("name","yangqian");
        map.put("age",23);
        List<User> users = userMapper.selectByMap(map);
        users.forEach(System.out::print);
    }

• 测试分页查询
  • 注册分页插件组件

  @Bean
  public PaginationInterceptor paginationInterceptor(){
      return new PaginationInterceptor();
  }
  

  • 测试分页查询

  @Test
  void testPage(){
      Page<User> page = new Page<>(1,5);
      Page<User> userPage = userMapper.selectPage(page, null);
      page.getRecords().forEach(System.out::print);
      System.out.println(page.getRecords());
  }