1、依赖添加
// 添加spring data jpa依赖
compile('org.springframework.boot:spring-boot-starter-data-jpa')
// 添加mysql驱动
compile('mysql:mysql-connector-java:6.0.5')
// 运行时内嵌数据库
runtime('com.h2database:h2:1.4.193')
2、配置数据源
spring.datasource.driverClassName=com.mysql.jdbc.Driver
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/blog?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=
#启用h2控制台
#spring.h2.console.enabled=true
#JPA
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=create-drop
3、重点在编码CRUD接口
①、实体JPA化
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
/**
* User 实体
* @author zemel
*
*/
@Entity
public class User {
@Id
@GeneratedValue
private Long id; //唯一标识
private String name; //名称
private String email;
protected User(){ // 防止直接使用
}
public User(Long id, String name, String email){
this.id = id;
this.name = name;
this.email = email;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
String.format("User [id=%d]", id);
return "User [id=" + id + ", name=" + name + ", email=" + email + "]";
}
②、Repository接口
import org.springframework.data.repository.CrudRepository;
import com.example.demo.domain.User;
/**
* UserRepository 接口
*
* @author Administrator
*
*/
public interface UserRepository extends CrudRepository<User, Long>{
}