Springboot 连接数据库问题

• Springboot 连接Mysql

springboot的Maven项目连接mysql比较简单，在pom.xml文件中添加依赖即可

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

application.yml文件中配置数据库

spring:
  datasource:
    name: test
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: 1234
    driver-class-name: com.mysql.jdbc.Driver

• Springboot连接Oracle

springboot的Maven项目连接Oracle可没有那么简单，需要手动安装驱动jar包
首先，根据jdk版本下载合适jar包
我下载的版本是ojdbc8-12.2.0.1.jar
下载地址：

https://download.csdn.net/download/qq_39548700/12326164

其次，将jar包导入到maven中
进入maven目录，cmd进入命令提示符
bin目录下， 输入指令：mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc -Dversion=12.2.0.1 -Dpackaging=jar -Dfile=D:\maven\new\ojdbc8-12.2.0.1.jar

<!-- https://mvnrepository.com/artifact/com.oracle/ojdbc8 -->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>12.2.0.1</version>
    <scope>provided</scope>
</dependency>

出现BUILD SUCCESS，导入成功：

D:\maven\new\apache-maven-3.5.3\bin>mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc -Dversion=12.2.0.1 -Dpackaging=jar -Dfile=D:\maven\new\ojdbc8-12.2.0.1.jar
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------< org.apache.maven:standalone-pom >-------------------
[INFO] Building Maven Stub Project (No POM) 1
[INFO] --------------------------------[ pom ]---------------------------------
[INFO]
[INFO] --- maven-install-plugin:2.4:install-file (default-cli) @ standalone-pom ---
[INFO] Installing D:\maven\new\ojdbc8-12.2.0.1.jar to D:\maven\repository\com\oracle\ojdbc\12.2.0.1\ojdbc-12.2.0.1.jar
[INFO] Installing C:\Users\Lenovo\AppData\Local\Temp\mvninstall8124629171342484867.pom to D:\maven\repository\com\oracle\ojdbc\12.2.0.1\ojdbc-12.2.0.1.pom
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  1.709 s
[INFO] Finished at: 2020-04-13T09:23:32+08:00
[INFO] ------------------------------------------------------------------------

D:\maven\new\apache-maven-3.5.3\bin>

最后，在pom.xml文件中添加依赖即可

<dependency>
	<groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
  	<groupId>com.oracle.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>12.2.0.1</version>
</dependency>

application.yml文件中配置数据库

spring:
  datasource:
    name: test
    url: jdbc:oracle:thin:@localhost:1521:soarnew
    username: root
    password: 1234
    driver-class-name: oracle.jdbc.driver.OracleDriver