Spring Data JpaRepository数据库增、删、改、查接口快速实现

1. Controller（EventController.java）

@RestController
@RequestMapping("/Event")
public class EventController {
    // 案件信息
    @Autowired
    EventRepository eventRepository;

    // 添加、编辑
    @PostMapping("/addEvent")
    public ResponseObject addEvent(@RequestBody Event event) {
        eventRepository.save(event);
        return ResponseObject.ok("添加成功");
    }

    // 删除
    @PostMapping("/delEvent")
    public ResponseObject delEvent(@RequestBody Map<String,String> Map) {
        eventRepository.deleteById(Map.get("id"));
        return ResponseObject.ok("删除成功");
    }

    // 查询
    @PostMapping("/getEventList")
    public ResponseObject getEventList(@RequestBody Map<String,String> Map) {
        Page<Event> pagePage = eventRepository.findAll(PageRequest.of(Integer.parseInt(Map.get("page")) - 1, Integer.parseInt(Map.get("limit"))));
        List<Event> list = pagePage.getContent();
        Map<String, Object> map = new HashMap<>();
        map.put("total", list.size());
        map.put("rows", list);
        return new ResponseObject(200, "查询成功", map);
    }
}
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

条件查询

// 查询条件
Specification<Event> specification = (root, query, builder) ->
        query.where(
                builder.equal(root.get("id"), item.getId())
        ).getRestriction();

// 查询
List<Event> list = eventRepository.findAll(specification);
1
2
3
4
5
6
7
8

2. 实体类（Event.java）

这里使用了lombok插件，自动省略了get、set方法。

<dependency>
	<groupId>org.projectlombok</groupId>
	<artifactId>lombok</artifactId>
	<optional>true</optional>
</dependency>
1
2
3
4
5

@Data
@Entity
@Table(name = "database")
public class Event {
    @Id
    private String id;

    // 联系电话
    private String tel;

    // 姓名
    private String name;

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14

3. Repository（EventRepository.java）

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
1
2
3
4

public interface EventRepository extends JpaSpecificationExecutor<Event>,JpaRepository<Event,String> {

}
1
2
3

4. 配置数据库（Application.properties）

### web
server.port=8080

### resources
spring.resources.static-locations=classpath:/static/

# 配置SQLServer数据库连接
spring.datasource.url = jdbc:sqlserver://localhost:1433;DatabaseName=Database
spring.datasource.username = ***
spring.datasource.password = ***
spring.datasource.driver-class-name = com.microsoft.sqlserver.jdbc.SQLServerDriver

# 配置JPA
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15