SpringBoot整合SpringData Jpa

（1）、添加依赖

1         <dependency>
2             <groupId>org.springframework.boot</groupId>
3             <artifactId>spring-boot-starter-data-jpa</artifactId>
4         </dependency>
5         <dependency>
6             <groupId>mysql</groupId>
7             <artifactId>mysql-connector-java</artifactId>
8             <version>8.0.15</version>
9         </dependency>

（2）、编写实体类

 1 package cn.coreqi.entities;
 2 
 3 import javax.persistence.*;
 4 
 5 @Entity
 6 @Table(name = "users")
 7 public class User {
 8     @Id //标识当前类主键
 9     @GeneratedValue(strategy = GenerationType.IDENTITY) //自增主键
10     private Integer Id;
11     @Column(name = "UserName")
12     private String UserName;
13     @Column(name = "PassWord")
14     private String PassWord;
15     @Column(name = "Enabled")
16     private Integer Enabled;
17 
18     public User(String userName, String passWord, Integer enabled) {
19         UserName = userName;
20         PassWord = passWord;
21         Enabled = enabled;
22     }
23 
24     public Integer getId() {
25         return Id;
26     }
27 
28     public void setId(Integer id) {
29         Id = id;
30     }
31 
32     public String getUserName() {
33         return UserName;
34     }
35 
36     public void setUserName(String userName) {
37         UserName = userName;
38     }
39 
40     public String getPassWord() {
41         return PassWord;
42     }
43 
44     public void setPassWord(String passWord) {
45         PassWord = passWord;
46     }
47 
48     public Integer getEnabled() {
49         return Enabled;
50     }
51 
52     public void setEnabled(Integer enabled) {
53         Enabled = enabled;
54     }
55 
56     public User() {
57     }
58 }

　　

（3）、配置Jpa

1 spring.datasource.username=root
2 spring.datasource.password=123456
3 spring.datasource.url=jdbc:mysql://localhost:3306/JdbcDemo?serverTimezone=UTC
4 spring.datasource.driver-class-name=com.mysql.jdbc.Driver
5 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
6 
7 spring.jpa.show-sql=true
8 spring.jpa.hibernate.ddl-auto=update

（4）、编写一个Dao接口来操作实体类对应的数据表（Repository）

 1 package cn.coreqi.dao;
 2 
 3 import cn.coreqi.entities.User;
 4 import org.springframework.data.jpa.repository.JpaRepository;
 5 import org.springframework.stereotype.Repository;
 6 import org.springframework.data.domain.Page;
 7 import org.springframework.data.domain.Pageable;
 8 
 9 /**
10  * 通过继承JpaRepository来完成对数据库的操作
11  * 第一个泛型为实体类名称
12  * 第二个泛型为实体类主键类型
13  */
14 @Repository
15 public interface UserRepository extends JpaRepository<User,Integer> {
16 　　Page<User> findUsersByUsername(String username, Pageable pageable);
17 }
1     @GetMapping("/findusers")
2     public List<User> findUsersByUsername(@RequestParam(required=false) String usernmae, @PageableDefault(page = 0,size = 10,sort = "id,asc") Pageable pageable){
3         ...
4     }

 使用@PageableDefault注解控制默认的分页参数

相关测试及调用可以借鉴https://www.cnblogs.com/fanqisoft/p/10356698.html

posted @ 2019-02-01 20:24  SpringCore  阅读(557)  评论(0)  编辑  收藏  举报