左側下拉選單選擇部門,右側動態載入該部門人員;中間按鈕控制人員在「待選」與「已選」兩個多選框間雙向移動,最後將選中人員回傳父頁面。
<%@ 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>
<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>
<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
<optgroup> 原生分組替代二級聯動,或採用 Select2/Chosen 等增強組件postMessage 替代 opener,支援跨域