connectionfactory.java

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

package connections;

import java.sql.*;

public class ConnectionFactory {
  private static ConnectionFactory ref = new ConnectionFactory();
  private ConnectionFactory() {
    try {

      // Class.forName("COM.cloudscape.core.JDBCDriver");
      Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
      System.out.println("ERROR: exception loading driver class");
    } 
  }

  public static Connection getConnection() throws SQLException {

    // String url = "jdbc:cloudscape:c:/wrox/database/Wrox4370.db";
    // return DriverManager.getConnection(url);
    String url = "jdbc:oracle:thin:@dbserver:1521:database";
    return DriverManager.getConnection(url, "helen", "wrox");
  } 

  public static void close(ResultSet rs) {
    try {
      rs.close();
    } catch (Exception ignored) {}
  } 

  public static void close(Statement stmt) {
    try {
      stmt.close();
    } catch (Exception ignored) {}
  } 

  public static void close(Connection conn) {
    try {
      conn.close();
    } catch (Exception ignored) {}
  } 
}