Examples with User com.baomidou.mybatisplus.samples.pagination.entity.User used on opensource projects

Example 1 with User

use of com.baomidou.mybatisplus.samples.pagination.entity.User in project tutorials-java by Artister.

the class PaginationTest method tests1.

@Test
public void tests1() {
    System.out.println("----- baseMapper 自带分页 ------");
    Page<User> page = new Page<>(1, 5);
    IPage<User> userIPage = mapper.selectPage(page, new QueryWrapper<User>().eq("age", 20).eq("name", "Jack"));
    assertThat(page).isSameAs(userIPage);
    System.out.println("总条数 ------> " + userIPage.getTotal());
    System.out.println("当前页数 ------> " + userIPage.getCurrent());
    System.out.println("当前每页显示数 ------> " + userIPage.getSize());
    print(userIPage.getRecords());
    System.out.println("----- baseMapper 自带分页 ------");
    System.out.println("json 正反序列化 begin");
    String json = JSON.toJSONString(page);
    Page<User> page1 = JSON.parseObject(json, TypeBuilder.newInstance(Page.class).addTypeParam(User.class).build());
    print(page1.getRecords());
    System.out.println("json 正反序列化 end");
    System.out.println("----- 自定义 XML 分页 ------");
    MyPage<User> myPage = new MyPage<User>(1, 5).setSelectInt(20).setSelectStr("Jack");
    ParamSome paramSome = new ParamSome(20, "Jack");
    MyPage<User> userMyPage = mapper.mySelectPage(myPage, paramSome);
    assertThat(myPage).isSameAs(userMyPage);
    System.out.println("总条数 ------> " + userMyPage.getTotal());
    System.out.println("当前页数 ------> " + userMyPage.getCurrent());
    System.out.println("当前每页显示数 ------> " + userMyPage.getSize());
    print(userMyPage.getRecords());
    System.out.println("----- 自定义 XML 分页 ------");
}

Example 2 with User

use of com.baomidou.mybatisplus.samples.pagination.entity.User in project mybatis-plus-samples by baomidou.

the class PaginationTest method tests1.

@Test
void tests1() {
    log.error("----------------------------------baseMapper 自带分页-------------------------------------------------------");
    Page<User> page = new Page<>(1, 5);
    page.addOrder(OrderItem.asc("age"));
    Page<User> userIPage = mapper.selectPage(page, Wrappers.<User>lambdaQuery().eq(User::getAge, 20).like(User::getName, "Jack"));
    assertThat(page).isSameAs(userIPage);
    log.error("总条数 -------------> {}", userIPage.getTotal());
    log.error("当前页数 -------------> {}", userIPage.getCurrent());
    log.error("当前每页显示数 -------------> {}", userIPage.getSize());
    List<User> records = userIPage.getRecords();
    assertThat(records).isNotEmpty();
    log.error("----------------------------------json 正反序列化-------------------------------------------------------");
    String json = JSON.toJSONString(page);
    log.info("json ----------> {}", json);
    Page<User> page1 = JSON.parseObject(json, new TypeReference<Page<User>>() {
    });
    List<User> records1 = page1.getRecords();
    assertThat(records1).isNotEmpty();
    assertThat(records1.get(0).getClass()).isEqualTo(User.class);
    log.error("----------------------------------自定义 XML 分页-------------------------------------------------------");
    MyPage<User> myPage = new MyPage<User>(1, 5).setSelectInt(20).setSelectStr("Jack");
    ParamSome paramSome = new ParamSome(20, "Jack");
    MyPage<User> userMyPage = mapper.mySelectPage(myPage, paramSome);
    assertThat(myPage).isSameAs(userMyPage);
    log.error("总条数 -------------> {}", userMyPage.getTotal());
    log.error("当前页数 -------------> {}", userMyPage.getCurrent());
    log.error("当前每页显示数 -------------> {}", userMyPage.getSize());
}

Example 3 with User

use of com.baomidou.mybatisplus.samples.pagination.entity.User in project mybatis-plus-samples by baomidou.

the class PaginationTest method rowBoundsTest.

@Test
void rowBoundsTest() {
    RowBounds rowBounds = new RowBounds(0, 5);
    List<User> list = mapper.rowBoundList(rowBounds, Maps.newHashMap("name", "%"));
    System.out.println("list.size=" + list.size());
}

Example 4 with User

use of com.baomidou.mybatisplus.samples.pagination.entity.User in project mybatis-plus-samples by baomidou.

the class PaginationTest method test.

@Test
void test() {
    userService.lambdaQuery().like(User::getName, "a").list().forEach(System.out::println);
    Page page = userService.lambdaQuery().like(User::getName, "a").page(new Page<>(1, 10));
    page.getRecords().forEach(System.out::println);
}

Example 5 with User

use of com.baomidou.mybatisplus.samples.pagination.entity.User in project mybatis-plus-samples by baomidou.

the class PaginationTest method selectAndGroupBy.

@Test
void selectAndGroupBy() {
    LambdaQueryWrapper<User> lq = new LambdaQueryWrapper<>();
    lq.select(User::getAge).groupBy(User::getAge);
    for (User user : mapper.selectList(lq)) {
        System.out.println(user.getAge());
    }
}