Connecting to an Oracle Database

最新推荐文章于 2023-08-18 13:04:18 发布

原创最新推荐文章于 2023-08-18 13:04:18 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #oracle #string #jdbc #url #null

JAVA 专栏收录该内容

142 篇文章

订阅专栏

此博客介绍了使用Oracle JDBC驱动连接Oracle数据库实例的示例，重点围绕数据库连接展开，涉及信息技术中数据库连接相关内容。

This example uses an Oracle JDBC driver to connect to an Oracle database instance located at 127.0.0.0:1521 with an sid called mydatabase.

    Connection connection = null;
    try {
        // Load the JDBC driver
        String driverName = "oracle.jdbc.driver.OracleDriver";
        Class.forName(driverName);
    
        // Create a connection to the database
        String serverName = "127.0.0.1";
        String portNumber = "1521";
        String sid = "mydatabase";
        String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
        String username = "username";
        String password = "password";
        connection = DriverManager.getConnection(url, username, password);
    } catch (ClassNotFoundException e) {
        // Could not find the database driver
    } catch (SQLException e) {
        // Could not connect to the database
    }