本文彙整四個 JSP 開發常見需求的實用程式碼片段:資料庫用戶驗證、Application 全域變數操作、防止瀏覽器快取 JSP、HTML 特殊字元編碼。
public String validateUser(String inputUserid, String inputPwd) throws SQLException {
String returnString = null;
String dbUser = "userid", dbPwd = "password";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:myDriver", dbUser, dbPwd);
Statement stmt = con.createStatement();
// ⚠️ 風險:字串拼接 SQL,易受 SQL Injection 攻擊
String sql = "SELECT USERID FROM USERTABLE WHERE USERID = '" + inputUserid
+ "' AND PASSWORD = '" + inputPwd + "'";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
returnString = rs.getString("USERID");
}
stmt.close(); con.close();
return returnString;
}
安全修正:實務務必使用 PreparedStatement 參數化查詢,防止 SQL 注入。
application 隱含物件對應 ServletContext,生命週期 = Web 應用存活期間,所有用戶共享。
<%
synchronized (application) {
Integer count = (Integer) application.getAttribute("counter");
if (count == null) count = 0;
count++;
application.setAttribute("counter", count);
}
%>
<h1>歡迎訪客 #<%= application.getAttribute("counter") %></h1>
ServletContext application = getServletContext();
// 後續操作同 JSP,同樣需 synchronized 區塊
<%
response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1
response.setHeader("Pragma", "no-cache"); // HTTP 1.0
response.setDateHeader("Expires", 0); // 立即過期
%>
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Expires" content="0">
Server.HTMLEncode)public static String asHTML(String text) {
if (text == null) return "";
StringBuilder result = new StringBuilder(text.length() + 16);
for (int i = 0; i < text.length(); i++) {
char c = text.charAt(i);
switch (c) {
case '&': result.append("&"); break;
case '<': result.append("<"); break;
case '>': result.append(">"); break;
case '"': result.append("""); break;
default: result.append(c);
}
}
return result.toString();
}
用途:將使用者輸入內容安全輸出至 HTML 頁面,防止 XSS (跨站腳本攻擊)。現代專案建議使用成熟庫如 Apache Commons Text StringEscapeUtils.escapeHtml4() 或模板引擎內建轉義。