三级联动文档和代码

最新推荐文章于 2021-08-05 13:57:29 发布

greenraindh

最新推荐文章于 2021-08-05 13:57:29 发布

阅读量1.2k

点赞数

分类专栏： Java开发常见问题文章标签：文档 string xml function xmlhttprequest sql

本文链接：https://blog.csdn.net/greenraindh/article/details/1206700

版权

Java开发常见问题专栏收录该内容

15 篇文章 0 订阅

订阅专栏

三级联动 文档和代码

如人员管理的对应的界面和代码

其涉及的文件有adminuser_list.jsp 、web.xml和SelectCropDepartServlet2.java、SelectDepartChuServlet.java 两个Servlet类文件。

其对应的adminuser_list.jsp 文件如下。

<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>

<%@ page import ="pub.*" %>

int xxxx=Check.CheckPage(request,"admin_adminuser_list");

String Error="";

if (xxxx==1){

Error="<script>alert('你已掉线，需要重新登陆!');top.location.href='../login.jsp'</script>";

}else{

if (xxxx==2){

Error="<script>alert('你无权进入该页面!');history.back();</script>";

}

<%=Error%>

if (xxxx!=0){

return;

}

<html>

<head>

<title>机构类型设置人员管理</title>

</head>

var req;

var number='all'; //外,下拉框可显示全部部门&处

window.οnlοad=function()

{

}

function Change_Select(flag)

{

var flag1=flag;//是为了解决onchange()后值要改变＆onload()(查询提交)后值要保存的问题

//alert(flag1);

var zhi = document.getElementById('Corp').value;

var hidden_depart=document.all.HiddenKeyDepart.value;

var url = "../selectCropDepart2?state="+number+"&keyDepart="+hidden_depart+"&id=" + escape(zhi)+"&flag="+flag1;

//alert(url);

if (window.XMLHttpRequest) {

req = new XMLHttpRequest();

}else if (window.ActiveXObject) {

req = new ActiveXObject("Microsoft.XMLHTTP");

}

if(req){

req.open("GET", url, true);

req.onreadystatechange = callback;

req.send(null);

}

function callback() {

if (req.readyState == 4) {

if (req.status == 200) {

parseMessage();

// update the HTML DOM based on whether or not message is valid

}else{

alert ("Not able to retrieve description" +req.status+req.statusText);

}

function parseMessage() {

var xmlDoc = req.responseXML.documentElement;

var xSel = xmlDoc.getElementsByTagName('select');

var select_root = document.getElementById('Depart');

select_root.options.length=0;

for(var i=0;i<xSel.length;i++)

{

var xValue = xSel[i].childNodes[0].firstChild.nodeValue;

var xText = xSel[i].childNodes[1].firstChild.nodeValue;

var option = new Option(xText,xValue);

try

{

select_root.add(option);

}

catch(e)

{

}

function Change_Select2()

{

var zhi = document.getElementById('Depart').value;

var url = "../selectDepartChu?state="+number+"&id=" + escape(zhi);

if (window.XMLHttpRequest) {

req = new XMLHttpRequest();

}else if (window.ActiveXObject) {

req = new ActiveXObject("Microsoft.XMLHTTP");

}

if(req){

req.open("GET", url, true);

req.onreadystatechange = callback2;

req.send(null);

}

function callback2() {

if (req.readyState == 4) {

if (req.status == 200) {

parseMessage2();

// update the HTML DOM based on whether or not message is valid

}else{

alert ("Not able to retrieve description" +req.status+req.statusText);

}

function parseMessage2() {

var xmlDoc = req.responseXML.documentElement;

var xSel = xmlDoc.getElementsByTagName('select');

var select_root = document.getElementById(' Chu ');

select_root.options.length=0;

for(var i=0;i<xSel.length;i++)

{

var xValue = xSel[i].childNodes[0].firstChild.nodeValue;

var xText = xSel[i].childNodes[1].firstChild.nodeValue;

var option = new Option(xText,xValue);

try

{

select_root.add(option);

}

catch(e)

{

}

function loads(flag){

Change_Select(flag);

//Change_Select2();

}

function Add()

{

document.formlist.action="adminuser_edit.jsp?Oper=add&Key=0";

document.formlist.submit();

}

function Edit(key)

{

document.formlist.action="adminuser_edit.jsp?Oper=edit&Key="+key;

document.formlist.submit();

}

function Del (key)

{

if (window.confirm("确实要删除吗？"))

{

var a=showModalDialog("adminuser_ctl.jsp?Oper=del&Key="+key,"","status:no;resizable:yes;dialogHeight:410px;dialogWidth:460px;unadorne:yes");

if ((a==0))

{

document.formlist.submit();

}

function Purview(key)

{

var a=showModalDialog("role_purview.jsp?Oper=del&Key="+key,"","status:no;resizable:yes;dialogHeight:410px;dialogWidth:460px;unadorne:yes");

}

</script>

String strCorp=request.getParameter("Corp");

String strDepart=request.getParameter("Depart");

String strChu=request.getParameter(" Chu ");

String strChuName="";

String strUserName=request.getParameter("UserName");

if(strCorp==null) strCorp="";

if(strDepart==null) strDepart="";

if(strChu==null) strChu="";

if(strUserName==null) strUserName="";

String strCropID1=(String)session.getAttribute("cropid");

//判断如果登陆员工是总公司之外的就只显示此员工所在的公司

if(strCropID1.equals("1")==false) strCorp=strCropID1;

Conn conn=new Conn ();

DataTable dtChuName=new DataTable();

String SqlChuName="";

<tr>

</tr>

</table>

<tr>

</tr>

</table>

String sql="select a.UserID, a.UserCode,a.UserName,";

sql+=" CorpName=(Select MachName from sys04_Machine c where a.CropID=c.MachID ),";

sql+=" DepartName=(Select MachName from sys04_Machine d where a.DepartID=d.MachID ),";

sql+=" ChuName=(Select MachName from sys04_Machine e where a.ChuID=e.MachID ),";

sql+=" RoleName=(select RoleName from sys05_role b where b.roleid=a.roleid ) from employee01_Basic a where a.CropID=a.CropID";

if(strCorp.length()>0)

sql+=" and a.CropID = "+strCorp;

if (strDepart.length()>0 && strDepart.equals("Pselect")==false )

sql+= " AND a.DepartID = "+PubClass.getString(strDepart)+" ";

if (strChu.length()>0 && strChu.equals("Pselect")==false ) {

sql+= " AND a.ChuID = "+PubClass.getString(strChu)+" ";

SqlChuName="select * from sys04_Machine where MachID="+strChu;

conn.querySql(SqlChuName,dtChuName);

strChuName=dtChuName.getItemForName(0,"MachName").toString();

}

if (strUserName.length()>0 && strCorp.length()>0)

sql+= " AND a.UserName like '%"+PubClass.getString(strUserName)+"%'";

else if(strUserName.length()>0 && strCorp.length()==0)

sql+= " and a.UserName like '%"+PubClass.getString(strUserName)+"%'";

DataGrid dg=new DataGrid("1",request,"formlist",15,"");

DataGridColumnItem dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="人员编码";

dgci.BindField="UserCode";

dgci.Width="20%";

dg.addColumn(dgci);