connectionmanager.java

本套光盘提供了本书各章实例的所需的部分源程序文件以及数据库文件。读者 需要使用JDK 1.4(必需）版

import java.sql.*;

public class ConnectionManager {
  private static ConnectionManager ref = new ConnectionManager();
  private ConnectionManager() {
    try {
	//加载SQL Server数据库驱动程序
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	//加载Oracle数据库驱动程序
	  // Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
      System.out.println("ERROR: exception loading driver class");
    } 
  }

  public static Connection getConnection() throws SQLException {
	//连接SQL Server数据库
String url = "jdbc:microsoft:sqlserver://localhost:1433;User=JavaDB;Password=javadb;DatabaseName=northwind";
	
//连接Oracle数据库
//String url = "jdbc:oracle:thin@javadb:1521:database";
	return DriverManager.getConnection(url, "javadb", "javadb");
  } 

  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) {}
  } 
}