www.pudn.com > jinxiaoxitong.rar > ConnectionManager.java~3~

package jxc;

/**
 * 
Title: jxc demo
 * 
Description: 
 * 
Copyright: Copyright (c) 2003
 * 
Company: 
 * @author cwx
 * @version 1.0
 */

import java.sql.*;

public class ConnectionManager {
  public ConnectionManager() {
  }
  static public Connection getConnection(){
    try{
      //使用用来连接ODBC数据源的JDBC驱动，以连接到Access数据库
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //DBQ参数用来指定Access数据库所在的位置,读者需要把它改为自己机器上的实际路径
      Connection conn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};"+
          "DBQ=C:\\cwx\\books\\jxc\\jxc\\WEB-INF\\db.mdb");
      return conn;
    }
    catch(java.lang.ClassNotFoundException e){
      System.err.print("get connection error!");
      System.err.print(e);
    }
    catch(java.sql.SQLException e){
      System.err.print("get connection error!");
      System.err.print(e);
    }

    return null;
  }

}