Java笔记-Spring Boot JDBC连接Oracle数据库

最新推荐文章于 2024-08-18 22:05:18 发布

IT1995

最新推荐文章于 2024-08-18 22:05:18 发布

阅读量4.1k

点赞数

本文链接：https://blog.csdn.net/qq78442761/article/details/108272721

版权

Java 同时被 2 个专栏收录

370 篇文章 20 订阅

订阅专栏

Web相关技术

160 篇文章 8 订阅

订阅专栏

首先介绍几个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 {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public 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);
    }
}

程序运行截图如下：