以前做過用jsp連接配接Access,但時間久了都忘了。這次發出來,作個備忘。
Connection conn; //連接配接對象
Statement stmt; //語句對象
PreparedStatement pStatement = null;
ResultSet rs; //結果集對象
String accessdriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //儲存Access驅動程式字元串
String accessURL =
"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; //儲存Access連接配接字元串
String realPath = request.getRealPath("\\WEB-INF\\db\\rsc.mdb");//Access資料庫絕對路徑
……
try {
//資料庫連接配接
Class.forName(accessdriver);
conn = DriverManager.getConnection(accessURL + realPath);
//資料庫查詢
pStatement = conn.prepareStatement(sql01);
pStatement.setString(1, myid);
rs = pStatement.executeQuery();
while (rs.next()){……
}
rs.close();
pStatement.close(); //第一次查詢完畢,關閉rs和pStatement
}
catch (Exception e) {
System.out.println(e.getMessage());
}