makingastatement.java

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· Java 代码 · 共 34 行

import java.sql.*;

public class MakingTheConnection {
  public static void main(String[] args) {

    // Load the driver
    try {

      // Load the driver class
      Class.forName("oracle.jdbc.driver.OracleDriver");

      // Define the data source for the driver
      String sourceURL = "jdbc:oracle:thin:@server:1521:databasename";
      String user = "beg";
      String password = "java";

      // Create a connection through the DriverManager
      Connection databaseConnection = 
        DriverManager.getConnection(sourceURL, user, password);

      // We made it!
      System.out.println("Connection established successfully!");

      // close connection
      databaseConnection.close();
    } 
      catch (ClassNotFoundException cnfe) {
      System.err.println(cnfe);
    } 
      catch (SQLException sqle) {
      System.err.println(sqle);
    } 
  }
}