萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> JSP 程式設計

JSP + JavaScript 實現二級聯動選單:部門選人與雙向移動選單

功能場景

左側下拉選單選擇部門,右側動態載入該部門人員;中間按鈕控制人員在「待選」與「已選」兩個多選框間雙向移動,最後將選中人員回傳父頁面。

完整代碼結構

頁面指令與樣式

<%@ page import="java.util.Date,java.sql.*,yava.fileapp.*" contentType="text/html;charset=GB2312" pageEncoding="GB2312" %>
<style>
  .f9 { font-size: 9pt; }
  .bgc { background-color: #AECAF9; color: #0033FF; }
  .buttons { font-family: Arial; font-size: 13px; font-weight: bold; background-color: #6796E4; color: white;
    border-top: solid 2px #AACAFB; border-bottom: solid 1px #4E7DC1;
    border-left: solid 1px #AECAF9; border-right: solid 1px #5679BD; padding: 1px; margin: 0px; }
</style>

JavaScript 核心邏輯

<script>
// 1. 從資料庫載入所有人員,構建二維陣列 arr[索引][0]=姓名, [1]=部門
var arr = new Array();
<%
  CDataSource ds = new CDataSource();
  Connection conn = ds.getConnection();
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery(
      "SELECT t1.fno, t1.fname, t2.fname AS fdept FROM tuser t1 LEFT JOIN TDept t2 ON t1.fdept = t2.fno ORDER BY t2.fname");
  int temp = 0;
  while (rs.next()) {
%>
arr[<%= temp %>] = new Array("<%= rs.getString("fname") %>", "<%= rs.getString("fdept") %>");
<%
      temp++;
  }
%>
var temp = <%= temp %>;

// 2. 部門變更時篩選人員
function ChangeLocation(deptName) {
    document.combo_box.city.length = 0;
    document.combo_box.city.options[0] = new Option('-------', '');
    for (var i = 0; i < temp; i++) {
        if (arr[i][1] == deptName) {
            document.combo_box.city.options[document.combo_box.city.length] = 
                new Option(arr[i][0], arr[i][0]);
        }
    }
}

// 3. 雙向移動選項
function move(fbox, tbox) {
    var arrF = [], arrT = [], lookup = {};
    for (var i = 0; i < tbox.options.length; i++) {
        lookup[tbox.options[i].text] = tbox.options[i].value;
        arrT[i] = tbox.options[i].text;
    }
    for (var i = 0; i < fbox.options.length; i++) {
        lookup[fbox.options[i].text] = fbox.options[i].value;
        if (fbox.options[i].selected && fbox.options[i].value != "") {
            arrT[arrT.length] = fbox.options[i].text;
        } else {
            arrF[arrF.length] = fbox.options[i].text;
        }
    }
    arrF.sort(); arrT.sort();
    fbox.length = 0; tbox.length = 0;
    for (var c = 0; c < arrF.length; c++) {
        var opt = new Option(); opt.value = lookup[arrF[c]]; opt.text = arrF[c]; fbox[c] = opt;
    }
    for (var c = 0; c < arrT.length; c++) {
        var opt = new Option(); opt.value = lookup[arrT[c]]; opt.text = arrT[c]; tbox[c] = opt;
    }
}

// 4. 確認選擇,回傳父頁面並關閉
function rv() {
    var val = "";
    for (var i = 0; i < document.combo_box.list2.length; i++) val += "," + document.combo_box.list2[i].value;
    if (val.charAt(0) == ",") val = val.substring(1);
    opener.form1.frecname.value = val;
    self.close();
}
</script>

HTML 表單結構

<form name="combo_box">
<table border="0" width="590" height="210">
  <tr height="24">
    <td class="buttons" align="center"><font color="#ffffff">部門選擇</font></td>
    <td class="buttons" align="center"><font color="#ffffff">人名選擇</font></td>
    <td class="buttons" align="center"><font color="#ffffff">添加/移除</font></td>
    <td class="buttons" align="center"><font color="#ffffff">最終人</font></td>
  </tr>
  <tr>
    <td>
      <select multiple id="prov" name="prov" onchange="ChangeLocation(this.options[this.selectedIndex].text);" style="width:150;height:200" class="bgc">
        <option value="0">請選擇部門</option>
        <%
          Statement stmt = conn.createStatement();
          ResultSet rs = stmt.executeQuery("SELECT * FROM tdept");
          while (rs.next()) {
        %>
        <option name="<%= rs.getString("fno") %>"><%= rs.getString("fname") %></option>
        <% } %>
      </select>
    </td>
    <td><select multiple id="city" style="width:150;height:200" class="bgc"></select></td>
    <td align="center" class="bgc">
      <input type="button" value="<<" onclick="move(this.form.list2, this.form.city)" class="buttons"><br>
      <input type="button" value=">>" onclick="move(this.form.city, this.form.list2)" class="buttons">
    </td>
    <td><select multiple size="10" name="list2" style="width:150;height:200" class="bgc"></select></td>
  </tr>
  <tr class="bgc">
    <td colspan="4" align="center"><input type="button" value="選好了!" onclick="rv()" class="buttons"></td>
  </tr>
</table>
</form>

資料表設計

TDept: fno (PK), fname          -- 部門表
tuser: fno (PK), fname, fdept   -- 人員表,fdept 關聯 TDept.fno

改進建議

  • 將人員數據改為 AJAX 異步載入,避免首屏渲染大量 JS 陣列
  • 使用 <optgroup> 原生分組替代二級聯動,或採用 Select2/Chosen 等增強組件
  • 後端改用連線池 + PreparedStatement 防注入
  • 彈窗通訊改用 postMessage 替代 opener,支援跨域
copyright © 萬盛學電腦網 all rights reserved