class (classId PK, className)nclass (nclassId PK, nclassName, parentId FK → class.classId)<%@ page contentType="text/html;charset=GB2312" language="java" errorPage="../error.jsp" %>
<%@ include file="../conn.jsp" %>
<%@ include file="../ds.jsp" %>
<%@ taglib uri="https://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="https://java.sun.com/jsp/jstl/core" prefix="c" %>
<% request.setCharacterEncoding("gb2312"); %>
<html><head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>二級聯動選單</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head><body>
<!-- 1. 後端查詢所有二級分類,輸出為 JS 陣列 -->
<%
String sql = "SELECT nclassId, nclassName, parentId FROM nclass ORDER BY nclassId";
java.sql.ResultSet rs = stmt.executeQuery(sql);
%>
<script type="text/javascript">
var subcat = new Array();
<%
int count = 0;
while (rs.next()) {
%>
subcat[<%= count %>] = [<%= rs.getString("nclassName") %>,
<%= rs.getString("nclassId") %>,
<%= rs.getString("parentId") %>];
<%
count++;
}
rs.close();
%>
var onecount = <%= count %>;
// 2. 聯動邏輯:依一級分類 ID 篩選二級選項
function changelocation(locationId) {
var select2 = document.myform.nclassId;
select2.length = 0; // 清空現有選項
select2.options[0] = new Option("==請選二級分類==", "");
for (var i = 0; i < onecount; i++) {
if (subcat[i][2] == locationId) { // parentId 比對
select2.options[select2.length] = new Option(subcat[i][0], subcat[i][1]);
}
}
}
</script>
<form name="myform" method="POST" action="adminsave.jsp?action=add">
<table>
<tr>
<td>一級分類</td>
<td>
<select name="classId" onchange="changelocation(this.value)">
<option value="">==請選一級分類==</option>
<sql:query var="qry" dataSource="${dataSource}">
SELECT classId, className FROM class ORDER BY classId
</sql:query>
<c:forEach var="row" items="${qry.rows}">
<option value="${row.classId}">${row.className}</option>
</c:forEach>
</select>
</td>
<td>二級分類</td>
<td>
<select name="nclassId">
<option value="">==請選二級分類==</option>
</select>
</td>
</tr>
</table>
</form>
</body></html>
[顯示名稱, 值, 父分類ID],便於前端比對 parentId。<sql:query> 簡化一級分類查詢與迴圈輸出。function changelocation(locationId) {
var select2 = document.myform.nclassId;
select2.length = 0;
select2.options[0] = new Option("載入中...", "");
fetch('getSubClass.jsp?parentId=' + encodeURIComponent(locationId))
.then(r => r.json())
.then(list => {
select2.length = 0;
select2.options[0] = new Option("==請選二級分類==", "");
list.forEach(item =>
select2.options[select2.length] = new Option(item.name, item.id));
});
}
getSubClass.jsp 回傳 JSON:[{"id":"1","name":"子分類1"},...]
onload 呼叫 changelocation(defaultId) 初始化二級選單。document.forms['formName'] 或 document.getElementById 精確定位,避免 document.myform 命名衝突。