JSP → JavaBean (DBconn) → JDBC-ODBC Bridge → ODBC 驅動 → Access 資料庫
注意:JDBC-ODBC Bridge 自 Java 8 起移除。現代專案請直接使用資料庫原生 JDBC 驅動(如 UCanAccess for Access、MySQL Connector/J、PostgreSQL JDBC 等)。
Customers.mdbCustomers:id(自增主鍵)、name(Text 10)、address(Text 30)、info(Memo)Customers,選擇 Customers.mdbpackage beans;
import java.sql.*;
public class DBconn {
private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
private static final String URL = "jdbc:odbc:Customers";
public DBconn() {
try { Class.forName(DRIVER); }
catch (ClassNotFoundException e) { System.err.println("Driver load failed: " + e.getMessage()); }
}
public ResultSet executeQuery(String sql) {
try {
Connection conn = DriverManager.getConnection(URL);
Statement stmt = conn.createStatement();
return stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("Query error: " + ex.getMessage());
return null;
}
}
}
javac -d WEB-INF/classes beans/DBconn.java
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312" %>
<jsp:useBean id="db" scope="page" class="beans.DBconn" />
<html><body>
<h2>客戶信息調查</h2>
<%
ResultSet rs = db.executeQuery("SELECT * FROM Customers");
while (rs != null && rs.next()) {
out.println("<li>" + rs.getString("name") + "</li>");
out.println("<li>" + rs.getString("address") + "</li>");
out.println("<li>" + rs.getString("info") + "</li>");
}
if (rs != null) rs.close();
%>
</body></html>
<jsp:useBean> 核心屬性| 屬性 | 說明 |
|---|---|
id | 頁面內引用變數名 |
scope | page/request/session/application |
class | Bean 完整類名 |
type | 宣告型別(可為介面) |
beanName | Beans.instantiate() 使用的名稱 |
net.sf.ucanaccess:ucanaccess:5.0.1@Transactional 聲明式事務PreparedStatement 防 SQL 注入String url = "jdbc:ucanaccess://C:/data/Customers.accdb"; // .accdb 或 .mdb
try (Connection conn = DriverManager.getConnection(url);
PreparedStatement ps = conn.prepareStatement("SELECT * FROM Customers WHERE name LIKE ?")) {
ps.setString(1, "%" + keyword + "%");
try (ResultSet rs = ps.executeQuery()) {
while (rs.next()) { /* 處理 */ }
}
}