import java.sql.*; import java.sql.SQLException; public class dbOperate { //非資料源方式(即非橋接方式),連接配接Access資料庫字元串,Database3.mdb為要連接配接的資料庫 String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\Database3.mdb"; Statement stmt = null; Connection conn = null; ResultSet rs = null; public dbOperate() throws Exception{ //加載驅動 try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //連接配接Access資料庫 conn=java.sql.DriverManager.getConnection(url); }catch(SQLException e){ System.out.println(e.toString()); } } public void dbClose() throws SQLException { if(rs != null){ try{ rs.close(); }catch(SQLException e){ e.printStackTrace(); } } if(stmt !=null ){ try{ stmt.close(); }catch(SQLException e){ e.printStackTrace(); } } if(conn !=null ){ try{ conn.close(); }catch(SQLException e){ e.printStackTrace(); } } } public ResultSet db_SQLQuery(String str)throws SQLException { try{ //stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); stmt = conn.createStatement(); //查詢資料庫中的表 rs=stmt.executeQuery(str); }catch(Exception e){ e.printStackTrace(); dbClose(); } return rs; } }