--用JS写联动

js如下 <%!public String getDeptUsers(Connection conn) { StringBuffer users = new StringBuffer(); String sql = "SELECT dept_CODE, dept_NAME, user_code, user_name " + "FROM SYS_DIC_dept, sys_dic_user " + "WHERE user_dept = dept_CODE(+) " + "ORDER BY dept_CODE"; Statement stmt = null; ResultSet rs = null; try { stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next()) { users.append((rs.getString("dept_CODE") != null ? rs.getString("dept_CODE").trim() : "") + ", " + (rs.getString("dept_NAME") != null ? rs.getString("dept_NAME").trim() : "") + ", " + (rs.getString("user_code") != null ? rs.getString("user_code").trim() : "") + ", " + (rs.getString("user_name") != null ? rs.getString("user_name").trim() : "") + ", "); } } catch (SQLException sqle) { } finally { try { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } } catch (SQLException ignore) { } } return users.toString();} %> <script language="javascript" type="text/javascript"> var deptUsers = new Array(); var errorMessage = ""; function DeptUser() { this.deptId = ""; this.deptName = ""; this.userIds = new Array(); this.userNames = new Array(); } function initUserData(users) { var tempArr = users.split(", "); var currId = ""; var user = null; for (var loop=0; loop<tempArr.length-1; loop+=4) { if (currId.toUpperCase() != tempArr[loop + 1].toUpperCase()) { user = new DeptUser(); deptUsers.push(user); currId = tempArr[loop + 1]; } user.deptId = tempArr[loop]; user.deptName = tempArr[loop + 1]; user.userIds.push(tempArr[loop + 2]); user.userNames.push(tempArr[loop + 3]); } } function getDepts(formIndex, deptTarget, name) { var target = document.forms[formIndex][deptTarget].options; for (var index=0; index<deptUsers.length; index++) { var opt = new Option(); opt.value = deptUsers[index].deptId; opt.text = deptUsers[index].deptName; target.add(opt, index); } for (var index=0; index<target.length&&name!=""; index++) { if (target[index].text == name || target[index].value == name) { target[index].selected = true; } } } function getDeptUsers(formIndex, deptTarget, userTarget, userCode) { var deptIndex = -1; var targetForm = document.forms[formIndex]; var dept = targetForm[deptTarget]; var users = targetForm[userTarget]; for (var index=0; index<dept.options.length; index++) { if (dept.options[index].selected) { deptIndex = index; } } for (var index=0; index<users.length; index++) { users.remove(index); index--; } for (var index=0; index<deptUsers[deptIndex].userIds.length; index++) { var target = users.options; var opt = new Option(); opt.value = deptUsers[deptIndex].userIds[index]; opt.text = deptUsers[deptIndex].userNames[index]; target.add(opt, index); } for (var index=0; (index<target.length)&&(userCode!=""); index++) { if (target[index].value == userCode) { target[index].selected = true; } } } function addOptions(formIndex, fromName, toName) { var targetForm = document.forms[formIndex]; var optFrom = targetForm[fromName].options; var optTo = targetForm[toName].options; for (var index=0; index<optFrom.length; index++) { if (optFrom[index].selected && !isExist(optTo, optFrom[index].text)) { var opt = new Option(); opt.value = optFrom[index].value; opt.text = optFrom[index].text; optTo.add(opt, optTo.length); } } } function addAllOptions(formIndex, fromName, toName) { var targetForm = document.forms[formIndex]; var optFrom = targetForm[fromName].options; var optTo = targetForm[toName].options; for (var index=0; index<optFrom.length; index++) { if (!isExist(optTo, optFrom[index].text)) { var opt = new Option(); opt.value = optFrom[index].value; opt.text = optFrom[index].text; optTo.add(opt, optTo.length); } } } function removeOptions(formIndex, targetName) { var target = document.forms[formIndex][targetName].options; for (var index=0; index<target.length; index++) { if (target[index].selected) { target.remove(index); index--; } } } function removeAllOptions(formIndex, targetName) { var target = document.forms[formIndex][targetName].options; for (var index=0; index<target.length; index++) { target.remove(index); index--; } } function isExist(object, str) { for (var index=0; index<object.length; index++) { if (object[index].text == str) { return true; } } return false; }</script> jsp如下 <script>initUserData("<%=getDeptUsers(conn)%>");</script> <select name="user_dept" onChange="getDeptUsers(0,'user_dept', 'fileplan_man');"> <script>getDepts(0,"user_dept");</script> </select> <select name="fileplan_man"> <script>getDeptUsers(0,"user_dept", "fileplan_man");</script> </select>

阅读全文(1544) | 回复(0) | 编辑 | 精华

发表评论：

昵称：
密码：
主页：
标题：

验证码： (不区分大小写,请仔细填写,输错需重写评论内容！)

站点首页 | 联系我们 | 博客注册 | 博客登陆

Sponsored By W3CHINA
W3CHINA Blog 0.8 Processed in 0.484 second(s), page refreshed 144795876 times.
《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
苏ICP备05006046号