springboot jpa 单表操作

95 阅读 0 评论 63 点赞

我是靠谱客的博主轻松诺言，这篇文章主要介绍springboot jpa 单表操作，现在分享给大家，希望可以做个参考。

springboot jpa 单表操作

*************************

相关类与接口

基础接口

复制代码

1
2
3
4
5
6
7
public interface Repository <T, ID>
public interface CrudRepository<T, ID> extends Repository<T, ID>
public interface PagingAndSortingRepository<T, ID> extends CrudRepository<T, ID>
public interface JpaRepository<T, ID> extends PagingAndSortingRepository<T, ID>,
QueryByExampleExecutor<T>
public interface JpaSpecificationExecutor<T>

使用说明：单表操作继承JpaRepository接口即可，如需动态查询可在此基础上继承JpaSpecificationExecutor

Sort：排序

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
public class Sort implements Streamable<Sort.Order>, Serializable
public static Sort by(Sort.Direction direction, String... properties)
public static Sort by(Sort.Direction direction, String... properties)
public Sort and(Sort sort)
public Sort ascending()
public Sort descending()
**********
内部枚举：Sort.Direction
public static enum Direction {
ASC,
DESC;
private Direction() {
}
public boolean isAscending() {
public boolean isDescending() {
public static Sort.Direction fromString(String value) {
public static Optional<Sort.Direction> fromOptionalString(String value) {

PageRequest：分页

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
public class PageRequest extends AbstractPageRequest {
private static final long serialVersionUID = -4541509938956089562L;
private final Sort sort;
protected PageRequest(int page, int size, Sort sort) {
public static PageRequest of(int page, int size) {
public static PageRequest of(int page, int size, Sort sort) {
public static PageRequest of(int page, int size, Direction direction, String... properties) {
public Sort getSort() {
public Pageable next() {
public PageRequest previous() {
public Pageable first() {
public boolean equals(@Nullable Object obj) {
public int hashCode() {
public String toString() {

Pageable

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
public interface Pageable {
int getPageNumber();
int getPageSize();
long getOffset();
Sort getSort();
Pageable first();
Pageable next();
Pageable previousOrFirst();
boolean hasPrevious();
static Pageable unpaged() {
return Unpaged.INSTANCE;
}
default boolean isPaged() {
return true;
}
default boolean isUnpaged() {
return !this.isPaged();
}
default Sort getSortOr(Sort sort) {
Assert.notNull(sort, "Fallback Sort must not be null!");
return this.getSort().isSorted() ? this.getSort() : sort;
}
default Optional<Pageable> toOptional() {
return this.isUnpaged() ? Optional.empty() : Optional.of(this);
}
}

*************************

使用示例

**************

dao层

UserRepository

复制代码

1
2
3
4
5
6
7
8
public interface UserRepository extends JpaRepository<User,Integer> {
User findUsersByName(String name);
List<User> findUsersByAge(Integer age);
Integer countDistinctByAge(Integer age);
Integer deleteByName(String name);
Integer deleteByAge(Integer age);
}

说明：自定义的delete方法需要在Transactional中使用，不然会报错

**************

service层

UserService

复制代码

1
2
3
4
5
public interface UserService {
Integer deleteByName(String name);
Integer deleteByAge(Integer age);
}

**************

serviceImpl 层

UserServiceImpl

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserRepository userRepository;
@Override
@Transactional
public Integer deleteByName(String name) {
return userRepository.deleteByName(name);
}
@Override
@Transactional
public Integer deleteByAge(Integer age) {
return userRepository.deleteByAge(age);
}
}

**************

controller层

UserController

复制代码

@RestController
public class UserController {
@Autowired
private UserRepository userRepository;
@Autowired
private UserService userService;
@RequestMapping("/save")
public String save(){
for(int i=0;i<100;i++){
User user=new User();
user.setName("瓜田李下"+i);
user.setAge(i);
userRepository.save(user);
}
return "success";
}
@RequestMapping("/delete")
public String delete(){
userRepository.deleteByName("瓜田李下"+2);
return "success";
}
@RequestMapping("/delete2")
public Integer delete2(){
return userRepository.deleteByAge(23);
}
@RequestMapping("/delete3")
public void delete3(){
userRepository.deleteById(5);
}
@RequestMapping("/findByPage")
public List<User> find(){
//测试分页
PageRequest pageRequest=PageRequest.of(0,10);
Page<User> page=userRepository.findAll(pageRequest);
return page.getContent();
}
@RequestMapping("/sort")
public List<User> sort(){
//测试分页、排序
Sort sort=Sort.by(Sort.Direction.ASC,"age");
Page<User> page=userRepository.findAll(PageRequest.of(0,10,sort));
return page.getContent();
}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
@RestController
public class UserController {
@Autowired
private UserRepository userRepository;
@Autowired
private UserService userService;
@RequestMapping("/save")
public String save(){
for(int i=0;i<100;i++){
User user=new User();
user.setName("瓜田李下"+i);
user.setAge(i);
userRepository.save(user);
}
return "success";
}
@RequestMapping("/delete")
public String delete(){
userRepository.deleteByName("瓜田李下"+2);
return "success";
}
@RequestMapping("/delete2")
public Integer delete2(){
return userRepository.deleteByAge(23);
}
@RequestMapping("/delete3")
public void delete3(){
userRepository.deleteById(5);
}
@RequestMapping("/findByPage")
public List<User> find(){
//测试分页
PageRequest pageRequest=PageRequest.of(0,10);
Page<User> page=userRepository.findAll(pageRequest);
return page.getContent();
}
@RequestMapping("/sort")
public List<User> sort(){
//测试分页、排序
Sort sort=Sort.by(Sort.Direction.ASC,"age");
Page<User> page=userRepository.findAll(PageRequest.of(0,10,sort));
return page.getContent();
}
}