springboot-data-jpa 操作

1. 插入数据：

User save = userRepository.save(user);

2. 查询所有数据：

List<User> list = userRepository.findAll();

3. 根据id查询：

User user = userRepository.findById(1L).orElse(null);

4. 根据用户名查询：

User user = userRepository.findByUserName("zhangsan");

5. 分页查询：

Pageable pageable = PageRequest.of(0, 1);
Page<User> page = userRepository.findAll(pageable);

6. 自定义分页查询：

Pageable pageable = PageRequest.of(0, 1);
Page<User> page = userRepository.findAllByUserName("zhangsan", pageable);

7. 自定义sql：

@Query(nativeQuery = true,value = "select * from t_user where user_name = :userName")
List<User> findListByUserName(String userName);

8. hql查询：

@Query("select u from User u where u.userName = :userName")
List<User> findListByUserName1(String userName);

9. 动态查询：

Pageable pageable = PageRequest.of(0, 1);
Specification<User> specification = (entity, query, cb) -> {
    List<Predicate> predicates = new ArrayList<>();
    predicates.add(cb.equal(entity.get("userName"), "zhangsan"));
    return cb.and(predicates.toArray(new Predicate[0]));
};
Page<User> page = userRepository.findAll(specification, pageable);

10. like查询：

List<User> list = userRepository.findByUserNameLike("%san%");