onblur) 觸發驗證。CheckServlet,攜帶 userid 參數。user 表,回傳 JSON 格式結果:[{flag:'true',alertTest:'aaa'}] 或 [{flag:'false',alertTest:'bbb'}]。package Servlet;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CheckServlet extends HttpServlet {
private static final String DBDRIVER = "com.mysql.jdbc.Driver";
private static final String DBURL = "jdbc:mysql://localhost:3306/spring";
private static final String DBUSER = "root";
private static final String DBPASS = "liangke";
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("gbk");
response.setContentType("text/html;charset=UTF-8");
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
PrintWriter out = response.getWriter();
String userid = request.getParameter("userid");
try {
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
String sql = "SELECT * FROM user WHERE username=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, userid);
rs = pstmt.executeQuery();
StringBuilder jsonStr = new StringBuilder();
jsonStr.append("[{flag:'");
if (rs.next()) {
jsonStr.append("true',alertTest:'aaa'}]");
} else {
jsonStr.append("false',alertTest:'bbb'}]");
}
out.println(jsonStr.toString());
} catch (Exception e) {
e.printStackTrace();
} finally {
try { if (rs != null) rs.close(); } catch (SQLException e) {}
try { if (pstmt != null) pstmt.close(); } catch (SQLException e) {}
try { if (conn != null) conn.close(); } catch (SQLException e) {}
}
}
}
<%@ page language="java" pageEncoding="utf-8"%>
<html>
<body>
<script>
window.onload = initPage;
function initPage() {
document.getElementById("userid").onblur = checkUserid;
}
var request;
function createRequest() {
try { request = new XMLHttpRequest(); }
catch (tryMS) {
try { request = new ActiveXObject("Msxml2.XMLHTTP"); }
catch (otherMS) {
try { request = new ActiveXObject("Microsoft.XMLHTTP"); }
catch (failed) { request = null; }
}
}
return request;
}
function checkUserid() {
request = createRequest();
var theName = document.getElementById("userid").value;
request.open("POST", "CheckServlet?userid=" + encodeURIComponent(theName), true);
request.onreadystatechange = checkUseridCallback;
request.send(null);
document.getElementById("msg").innerHTML = "正在驗證...";
}
function checkUseridCallback() {
if (request.readyState == 4 && request.status == 200) {
var v = request.responseText;
var value1 = eval(v)[0]; // 注意:eval 有風險,建議用 JSON.parse
if (value1.flag == "true") {
document.getElementById("msg").innerHTML = "用戶ID重複";
} else {
document.getElementById("msg").innerHTML = "此用戶ID可以註冊";
}
}
}
</script>
<form action="check.jsp" method="POST">
用戶ID:<input type="text" id="userid" name="userid">
<span id="msg"></span><br>
姓名:<input type="text" name="name">
</form>
</body>
</html>
| 原寫法 | 建議改為 | 理由 |
|---|---|---|
eval(v) | JSON.parse(v) | 避免程式碼注入風險 |
| 手寫 JSON 字串拼接 | 使用 Jackson/Gson 序列化 | 防止語法錯誤、支援複雜物件 |
| JDBC 硬編碼連線參數 | 資料來源 DataSource + 連線池 (HikariCP/Druid) | 效能、安全、可維護 |
gbk 編碼 | 全鏈路 UTF-8 | 避免中文亂碼 |
同步 XMLHttpRequest 封裝 | fetch / axios + async/await | 可讀性、錯誤處理、取消請求 |
{available: true/false},避免洩露其他欄位。PreparedStatement 防 SQL 注入 (範例已正確使用)。此範例展示了經典 AJAX 表單驗證的完整鏈路。雖然技術棧 (Servlet/JSP/原生 JS) 已非主流,但非同步驗證、伺服器端唯一性檢查、前端即時回饋的核心模式在現代前後端分離架構 (React/Vue + Spring Boot/Node.js) 中依然適用,只是工具與寫法更新而已。