首先介紹幾個Oracle相關的知識！

使用sqlplus進行登錄

%sqlplus Enter user-name: Enter password:

查詢數據庫版本：

select * from v$version;

Oracle的jdbc在只能在../oracle/app/product/11.2.0/dbhome_1/jdbc/lib

下面有ojdbc6.jar，ojdbc5.jar

mvn install:install-file -Dfile=ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.1 -Dpackaging=jar

下面是對應的maven

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.1.16.RELEASE</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>cn.it1995</groupId><artifactId>demo</artifactId><version>0.0.1-SNAPSHOT</version><name>demo</name><description>Demo project for Spring Boot</description><properties><java.version>1.8</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>com.oracle</groupId><artifactId>ojdbc6</artifactId><version>11.2.0</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>

application.properties

spring.datasource.url=jdbc:oracle:thin:@//ip:port/實例名 spring.datasource.username=用戶名 spring.datasource.password=密碼 spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

MyTest.java

package cn.it1995.demo;import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.test.context.junit4.SpringRunner;import java.util.List; import java.util.Map;@RunWith(SpringRunner.class) @SpringBootTest public class MyTest {@Autowiredprivate JdbcTemplate jdbcTemplate;@Testpublic void test(){String sql = "SELECT * from v$version";List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);System.out.println("over");sql = "SELECT * from xxxxxx";List<Map<String, Object>> list1 = jdbcTemplate.queryForList(sql);System.out.println(list1);} }

程序運行截圖如下：

?

總結

以上是生活随笔為你收集整理的Java笔记-Spring Boot JDBC连接Oracle数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。