如何用jdbc连接opengauss

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class OpenGaussExample {
    private static final String URL = "jdbc:postgresql://10.0.3.15/:26000/postgres";
    private static final String USER = "omm";
    private static final String PASSWORD = "wyh031218@";

public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

try {
            Class.forName("org.postgresql.Driver");
            connection = DriverManager.getConnection(URL, USER, PASSWORD);
            System.out.println("连接成功！");

statement = connection.createStatement();
            String sql = "SELECT version();"; // 查询数据库版本
            resultSet = statement.executeQuery(sql);

while (resultSet.next()) {
                System.out.println("Database Version: " + resultSet.getString(1));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (resultSet != null) resultSet.close();
                if (statement != null) statement.close();
                if (connection != null) connection.close();
            } catch (Exception ex) {
                ex.printStackTrace();
            }
        }
    }
}

openGauss/openGauss-connector-jdbc

内容风险标识

评论 (2)

openGauss/openGauss-connector-jdbc .gitee-modal { width: 500px !important; }

内容风险标识