采用maven配置
项目结构:
添加相关依赖
<!-- SpringData-Jpa依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- mysql驱动:com.mysql.jdbc.Driver -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
application.yml
spring:
datasource:
url: jdbc:mysql://localhost:3306/test
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
jpa:
properties:
hibernate:
hbm2ddl.auto: create-drop
UserRepository
public interface UserRepository extends JpaRepository<User,Integer> {
@Query("From User")
public List<User> findTest();
public List<User> findByUsernameLike(String username);
}
更多查询规则 详情见 jpa查询详解