輕量級桌面型 Web 應用、原型開發、教學演示。注意:JDBC-ODBC Bridge 已在 Java 8 移除,現代環境建議使用 UCanAccess 或遷移至 SQLite/MySQL。
UserDatabase.mdb,表 UserInformation(UserName, PassWord)。<%@ page import="java.sql.*" contentType="text/html;charset=UTF-8"%>
<%
// 獲取 .mdb 絕對路徑
String p = request.getServletPath();
String path = request.getRealPath(p);
path = path.substring(0, path.lastIndexOf("\\")); // 注意 Windows 路徑分隔符
String dbPath = path + "\\UserDatabase.mdb";
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + dbPath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM UserInformation");
while (rs.next()) {
out.println("用戶名:" + rs.getString("UserName") + "<br>");
out.println("密碼:" + rs.getString("PassWord") + "<br>");
}
rs.close(); stmt.close(); conn.close();
%>
在 server.xml <Host> 下添加 <Context path="/myapp" docBase="專案目錄" />,瀏覽器訪問 https://localhost:8080/myapp/sub/DatabaseDemo.jsp。
UCanAccess:jdbc:ucanaccess://D:/path/UserDatabase.mdb,無需 ODBC DSN。