添加依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
配置文件
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/dblog_study?useUnicode=true&chararaterEncoding=utf-8&serverTimezone=Asia/Shanghai
username: root
password: root
#配置springDataJPA相关设置
jpa:
#显示sql语句
show-sql: true
#配置正向工程
hibernate:
ddl-auto: update
实体类
@Entity
@Table(name = "tbl_user")
@Data
@NoArgsConstructor
@AllArgsConstructor
@ToString
public class User {
@Id
@GeneratedValue
private int id;
@Column
private String name;
@Column
private String password;
@Column
private int age;
@Column
private String email;
}
继承JpaRepository接口
package com.example.dblog_study.dao.respository;
import com.example.dblog_study.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
public interface UserRepository extends JpaRepository<User, Integer> {
}
测试一下
@RunWith(SpringRunner.class)
@SpringBootTest
public class UserServiceTest {