Java 简单连接Oracle 测试代码

为验证应用服务器连接数据库没有问题，

通过编写java代码建立数据库连接来验证

需要根据oracle版本和jdk版本选择ojdbc驱动,

下面使用ojdbc6.jar

import java.sql.*;
public class OracleConn {
    public static void main(String[] args) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@//10.20.30.40:1521/serviceName","oracleID","oracleMM");
            System.out.println(connection.getMetaData());
            PreparedStatement preparedStatement = connection.prepareStatement("select sysdate from dual");
            ResultSet resultSet = preparedStatement.executeQuery();
            while(resultSet.next()) {
                String dname = resultSet.getString("SYSDATE");
                System.out.println(dname);
            }
           if(resultSet != null) {
                resultSet.close();
            }
            if(preparedStatement != null) {
                preparedStatement.close();
            }
            if(connection != null) {
                connection.close();
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

复制

查看服务器jdk版本#java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
#javac -version
javac 1.8.0_171
复制

编译java程序

# javac -cp ./ojdbc6.jar OracleConn.java
复制

运行java程序

# java -cp .:/root/ojdbc6.jar OracleConn

oracle.jdbc.driver.OracleDatabaseMetaData@71e7a66b
2023-01-05 08:57:46.0
复制