dbconnection.java

来自「說明JSP平台、開發環境」· Java 代码 · 共 34 行

package bean;
import java.sql.*;
public class DBConnection {
   private Connection con = null;
   public DBConnection() {
   }
   //
   public void setConnection(String dbName) {
      String JDBCDriver, strUrl;
      if (dbName.indexOf("mysql") != -1) {
      	 JDBCDriver = "com.mysql.jdbc.Driver";
      	 strUrl = "jdbc:mysql://127.0.0.1:3306/test?user=root&characterEncoding=big5";
      } else {  //default is Access
      	 JDBCDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
      	 strUrl = "jdbc:odbc:JSPAll";
      }
      // System.out.println("strUrl: " + strUrl);
      
      try {
	 Class.forName(JDBCDriver);
	 con = DriverManager.getConnection(strUrl);
      } catch (SQLException se) {
      	 System.out.println("Error: " + se.toString());
      } catch (Exception e) {
      	 System.out.println("Error: " + e.toString());
      }
      // return con;
   }
   //
   public Connection getConnection() {
      return con;
   }
}