springboot集成关系型数据库

一、mysql
1、jar包

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

2、配置文件

spring.datasource.url=jdbc:mysql://localhost/spring_boot_demo?useUnicode=true&character
Encoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

驱动其实可以不配置 springboot可以根据jdbc:mysql来区分

2、jpa

<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>

配置文件

# JPA 程序每次启动都去去检查表 如果没有就自动创建
spring.jpa.hibernate.ddl-auto= update 
#显示 sql 语句 
spring.jpa.show-sql=true 

接口定义

public interface RoncooUserLogDao extends JpaRepository<RoncooUserLog, Integer>{
}