Search in sources :

Example 1 with User

use of org.ko.web.domain.User in project tutorials-java by Artister.

the class ApplicationTests method pageTest.

@Test
public void pageTest() {
    /**
     * @see PageRequest
     * page 从0开始
     * size 大小
     */
    Pageable pageable = new PageRequest(0, 5);
    Page<User> Users = pagingSortRepository.findAll(pageable);
    out.println("总页数" + Users.getTotalPages());
    out.println("总记录数" + Users.getTotalElements());
    out.println("当前第几页" + Users.getNumber() + 1);
    out.println("当前页面的集合" + Users.getContent());
    out.println("当前页面的记录数" + Users.getNumberOfElements());
}
Also used : PageRequest(org.springframework.data.domain.PageRequest) Pageable(org.springframework.data.domain.Pageable) User(org.ko.web.domain.User) Test(org.junit.Test)

Example 2 with User

use of org.ko.web.domain.User in project tutorials-java by Artister.

the class ApplicationTests method specificationTest.

/**
 * 1) 分页
 * 2) 排序
 * 3) 条件: age > 50
 */
@Test
public void specificationTest() {
    Sort.Order order = new Sort.Order(Sort.Direction.ASC, "id");
    Sort sort = new Sort(order);
    Specification<User> specification = new Specification<User>() {

        /**
         * @param root  查询的类型-User
         * @param criteriaQuery 添加查询条件
         * @param criteriaBuilder 构建Predicate
         * @return
         */
        @Override
        public Predicate toPredicate(// 查询的实体类-根对象
        Root<User> root, // 查询的语句
        CriteriaQuery<?> criteriaQuery, // 
        CriteriaBuilder criteriaBuilder) {
            // root (User (age))--->从root到age就是这个path
            Path path = root.get("age");
            // 就是条件
            return criteriaBuilder.gt(path, 50);
        }
    };
    Pageable pageable = new PageRequest(0, 5, sort);
    Page<User> Users = jpaRepository.findAll(specification, pageable);
    out.println("总页数" + Users.getTotalPages());
    out.println("总记录数" + Users.getTotalElements());
    out.println("当前第几页" + Users.getNumber() + 1);
    out.println("当前页面的集合" + Users.getContent());
    out.println("当前页面的记录数" + Users.getNumberOfElements());
}
Also used : User(org.ko.web.domain.User) Specification(org.springframework.data.jpa.domain.Specification) PageRequest(org.springframework.data.domain.PageRequest) Pageable(org.springframework.data.domain.Pageable) Sort(org.springframework.data.domain.Sort) Test(org.junit.Test)

Example 3 with User

use of org.ko.web.domain.User in project tutorials-java by Artister.

the class ApplicationTests method UserRepositoryTest1.

@Test
public void UserRepositoryTest1() {
    User User = userRepository.findByName("张三");
    out.println(User.getId());
}
Also used : User(org.ko.web.domain.User) Test(org.junit.Test)

Example 4 with User

use of org.ko.web.domain.User in project tutorials-java by Artister.

the class ApplicationTests method saveTest.

@Test
public void saveTest() {
    ArrayList<User> Users = new ArrayList<User>();
    User User = null;
    for (int i = 0; i < 100; i++) {
        User = new User();
        User.setAge(i);
        User.setName("小小" + i);
        Users.add(User);
    }
    userService.save(Users);
}
Also used : User(org.ko.web.domain.User) ArrayList(java.util.ArrayList) Test(org.junit.Test)

Example 5 with User

use of org.ko.web.domain.User in project tutorials-java by Artister.

the class ApplicationTests method testInsert.

@Test
public void testInsert() {
    User user = new User();
    user.setName("张三");
    user.setAge(17);
    user = crudRepository.save(user);
    Assert.assertNotNull(user.getId());
}
Also used : User(org.ko.web.domain.User) Test(org.junit.Test)

Aggregations

User (org.ko.web.domain.User)10 Test (org.junit.Test)9 PageRequest (org.springframework.data.domain.PageRequest)3 Pageable (org.springframework.data.domain.Pageable)3 Sort (org.springframework.data.domain.Sort)2 ArrayList (java.util.ArrayList)1 Before (org.junit.Before)1 Specification (org.springframework.data.jpa.domain.Specification)1