spring boot2.0 连接mysql ，自定义JpaRepository 分页， 封装jpa底层sql（二）

创建spring boot项目可以看（一）

1.我们先在springboot 项目的pom.xml 添加访问mysql所需要的包关联。

            <!-- 连接数据库 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>

</dependency>

2.然后在 application.properties 写上 自己数据库信息

3.建立一个实体User

package com.example.entity;

import java.util.Date;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

import org.hibernate.annotations.GenericGenerator;

@Entity  
@Table(name = "user")
public class User {
	
	@Id
	@GeneratedValue(generator="system-uuid")
	@GenericGenerator(name="system-uuid", strategy="uuid")
	private String id; 
	
	private String name;
	
	private int age;
	
	@Temporal(TemporalType.DATE)  
    private Date birthday;  
  
    @Temporal(TemporalType.TIMESTAMP)  
    private Date sendtime; // 日期类型，格式：yyyy-MM-dd HH:mm:ss
    
    private String workAddress;

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	public Date getSendtime() {
		return sendtime;
	}

	public void setSendtime(Date sendtime) {
		this.sendtime = sendtime;
	}

	public String getWorkAddress() {
		return workAddress;
	}

	public void setWorkAddress(String workAddress) {
		this.workAddress = workAddress;
	}
    
    
}

4.我们建立一个dao 继承jpa的JpaRepository

package com.example.dao.sys;


import org.springframework.data.jpa.repository.JpaRepository;

import com.e