Java连接Oracle数据库

首先需要准备好oracle数据库以及Java开发环境。

接下来在Java的pom.xml文件中加入以下依赖：

`

   <dependency>
        <groupId>com.oracle.database.jdbc</groupId>
        <artifactId>ojdbc8</artifactId>
        <version>19.3.0.0</version>
    </dependency>  `

然后程序如下：

`

import java.sql.*;

/**
 hostname：Oracle数据库的主机名称或IP地址
 username和 password：登录Oracle数据库的用户名和密码
 table_name：要查询的表的名称
 column_name：要查询的表中的列名
 **/


public class OracleJDBCExample {
    static final String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";
    static final String DB_URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

    static final String USER = "liuyijia";
    static final String PASS = "123456";

    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        try{
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(DB_URL, USER, PASS);

            stmt = conn.createStatement();
            String sql = "select * from regions ";
            ResultSet rs = stmt.executeQuery(sql);

            while(rs.next()){
                int id  = rs.getInt("REGION_ID");
                String name = rs.getString("REGION_NAME");
                System.out.print("ID: " + id);
                System.out.print(", Name: " + name);
                System.out.println();
            }
            rs.close();
        }catch(SQLException se){
            se.printStackTrace();
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            try{
                if(stmt!=null)
                    stmt.close();
            }catch(SQLException se2){
            }
            try{
                if(conn!=null)
                    conn.close();
            }catch(SQLException se){
                se.printStackTrace();
            }
        }
    }
}



`