Connecting to an Oracle Database - Java JDBC

Java examples for JDBC:Oracle

  1. HOME
  2. Java
  3. JDBC
  4. Oracle

Description

Connecting to an Oracle Database

Demo Code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
  public static void m() {
    Connection connection = null;
    try {//from w w  w .j  av a2s . c om
      // 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
    }
  }
}

Related Tutorials