accessdb.java

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

package bean;
import java.sql.*;
public class accessDB {
   private Connection con = null;
   private ResultSet rs = null;
   public accessDB() {
   }
   //
   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;
   }
   //
   public ResultSet getResultSet(String sql) {
      Statement stmt = null;
      
      try {
	 stmt = con.createStatement();
	 rs = stmt.executeQuery(sql);
      } catch (SQLException se) {
      	 System.out.println("Error: " + se.toString());
      } catch (Exception e) {
      	 System.out.println("Error: " + e.toString());
      }
      return rs;
   }
   //
   public int getUpdate(String sql) {
      int intNo = 0;
      Statement stmt = null;
      
      try {
	 stmt = con.createStatement();
	 intNo = stmt.executeUpdate(sql);
      } catch (SQLException se) {
      	 System.out.println("Error: " + se.toString());
      } catch (Exception e) {
      	 System.out.println("Error: " + e.toString());
      }
      return intNo;
   }
}