📄 seldadbm_backup.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
字号:
<%
/**********************************************************
Copyright (C),2003-10-12, Beijing  USTB.
All rights reserved.
Filename: selDadbm.jsp
Author:    
Version 1.0
Date:2003-10-12
Description://详细说明此程序文件完成的基本功能，与其他模块的或函数的接口、输出值、取值范围、含义及参数间的控制、顺序、独立或依赖等关系
Other://其它内容说明
Function List://主要方法列表
1.  ...
History://修改历史纪录表,包括修改日期、修改者、修改内容简述
1.  Date:
    Author:
    Modification:
2.  ...
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString,javax.swing.tree.DefaultMutableTreeNode,java.util.Hashtable"%>
<%
oa.bean.DepartmentBean myBean = null;

try{
	myBean = new oa.bean.DepartmentBean();

	if(myBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}

	DealString ds = new DealString();
	String uid=ds.toString((String)session.getAttribute("zgbh"));//取得职工编号
%>




<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>选择上级部门</title>
<link href="../css/person.css" type=text/css rel=stylesheet>
<script language="javascript" src="../scripts/department.js"></script>
<script>
	function Updbm(radsel,flg)//选择部门
	{
		var e2="";
		var e3="";
		var num = radsel.length;
		var flag = false;
		//alert("num="+radsel.length);

		if(radsel.checked)	//数组只有一个元素时 执行此语句，不执行下面的for语句
		{
			flag = true;
			e2 = radsel.value;
			e3 = radsel.id;
		}
		for(var i=0;i<num;i++)
		{
			if(radsel[i].checked)
			{
				flag = true;
				e2 = radsel[i].value;
				e3 = radsel[i].id;
			}
		}
		if(flag == false)
		{
			alert("请选定一个部门或取消！");
			return false;
		}
		if(flg==1){//修改一个部门的上级部门
			window.opener.document.all.txt_lastbm.value = e3;
			window.opener.document.all.hid_bmno.value = e2;
			window.close();
		}
		if(flg==2){//分配人员的职务PersonDuty
			window.opener.document.all.txt_dutyBmName.value = e3;
			window.opener.document.all.hid_dutybmno.value = e2;
			window.close();
			parent.opener.form1.submit();
		}
		if(flg==3){ //修改人员信息
			window.opener.document.all.txt_bmmc.value = e3;
			window.opener.document.all.txt_bmno.value = e2;
			window.close();
		}
		return true;
	}

</script>
</head>
	
<body topmargin=0 leftmargin=0>
<form name="formselorg" method=post>

  <q id="0011" align=left>
    <table id="t1" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="D0E7FF" width="95%" height="2">
       <tr><td>
			<input type="button" value="全部展开" class=fashion onmouseover="msover();" onmouseout="msout();"onclick="allopen()">
			&nbsp;
			<input type="button" value="全部折叠" class=fashion onmouseover="msover();" onmouseout="msout();"onclick="allclose()">
<%
String flg = (String)request.getParameter("flg");
//if(flg!=null && flg.equals("1")){
%>
	<!--		<input type="submit" name="subbtn" value="选定" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="return Updbm(document.formselorg.radsel,1)"> ---->
<%
//}
//if(flg!=null && flg.equals("2")){
%>	
	<!---		<input type="submit" name="subbtn" value="选定" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="return Updbm(document.formselorg.radsel,2)"> ------>
<%//}%>
<!------------->
			<input type="button" name="subbtn" value="选定" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="return Updbm(document.formselorg.radsel,<%=flg%>)"> 
<!------------->
			<input type="button" name="btcancel" value="取消" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="self.close()"> 
	    </td>
	   </tr>
     </table>
	<table border="0" cellpadding="0" style="border-collapse: collapse; color:#FFFFFF" width="95%" height="18" bgcolor="#007EAE">
	  <tr>
	    <td align="left" width="16%">&nbsp;<b>总公司</b></td>
	    <td align="left" width="84%">&nbsp;<b>各级部门</b></td>
	  </tr>
	</table>
  
<%	
		int sub = 1;
		int nItem = 0;
		String outPrint = "";
		String strOrgNO = "";
		String tHead1="<div style=\"display:none\"  id=\"" ;
		String tHead2="\"><table><tr>";
		String tEnd="</tr></table></div>"; 
	
		DefaultMutableTreeNode myTree = myBean.buildSelectedBMTree(uid);//当前操作者
		DefaultMutableTreeNode root, currentNode, lastNode;
		root = myTree;
		outPrint = (String) ((Hashtable) root.getUserObject()).get("BMMC");
		strOrgNO = (String) ((Hashtable) root.getUserObject()).get("BMBH");
		String strEnabled = ds.toString((String) ((Hashtable) root.getUserObject()).get("Enabled"));
		boolean enabled = strEnabled.equals("True");



%>
<!-- 处理根节点------------------------------------------------------------------- -->
   
	<table border="0" cellpadding="0" style="border-collapse: collapse; color:#FFFFFF" width="95%" height="18" >
	  <tr>
		<td>
		<%if(enabled){%><input type="radio" id="<%=outPrint%>" name="radsel" value="<%=strOrgNO%>"><%}//end if%>
		<q class="MOUT" onclick=<%="\"Expand(0)\""%> style="cursor:hand;" oncontextmenu="onclickshow('<%=strOrgNO%>')"><img id='0' src="../images/plus.gif" >&nbsp;<font color="blue"><b><%=outPrint%></b></font></q></td>
	  </tr>
	</table>
<!----------------------------------------------------------------------------- -->
    
<%
//		out.println("Root:" + root);

		
	if (root.getChildCount()!=0)
	{
		currentNode = (DefaultMutableTreeNode) root.getFirstChild();
		sub++;
		out.println(tHead1+nItem+tHead2);
		while ((currentNode != null) && (currentNode != root)) 
		{
			outPrint = (String) ((Hashtable) currentNode.getUserObject()).get("BMMC");
			strOrgNO = (String) ((Hashtable) currentNode.getUserObject()).get("BMBH");

			strEnabled = ds.toString((String) ((Hashtable) currentNode.getUserObject()).get("Enabled"));
		    enabled = strEnabled.equals("True");
%>
		<table border="0" cellpadding="0" style="border-collapse: collapse; color:#FFFFFF" width="95%" height="18"><tr><td>
<%
			//控制
			for (int i = 1; i < sub; i++)
				out.print("&nbsp;&nbsp;&nbsp;");
			if ((currentNode.getChildCount()) != 0) 
			{
				nItem++;
			
				
%>
<!-- 处理有子节点的树---------------------------------------------------    -->
		<%if(enabled){%><input type="radio" id="<%=outPrint%>" name="radsel" value="<%=strOrgNO%>"><%}//end if%>
		<q class="MOUT" oncontextmenu="onclickshow('<%=strOrgNO%>')" onclick=<%="\"Expand("+nItem+")\""%> style="cursor:hand;"><img id='<%=nItem%>' src="../images/plus.gif" ><font color="blue">&nbsp;<b><%=outPrint%></b></font>
	   </q>		
		</td>
		</tr></table>
<!-- --------------－－－－－－－－-------------------------------------    -->
<%

			
			out.println(tHead1+nItem+tHead2);	


			} else {

%>
<!-- 处理无子节点的叶---------------------------------------------------    -->
		<%if(enabled){%><input type="radio" id="<%=outPrint%>" name="radsel" value="<%=strOrgNO%>"><%}//end if%>
		<q class="MOUT" oncontextmenu="onclickshow('<%=strOrgNO%>')" style="cursor:hand;">&nbsp;&nbsp;&nbsp;<font color="blue"><b><%=outPrint%></b></font>
	   </q>	

		</td>
		</tr></table>

<!-- --------------－－－－－－－－-------------------------------------    -->
<%
			}
			if ((currentNode.getChildCount()) == 0) {
				if ((currentNode.getNextSibling() == null)) {
					//当前节点即没有子节点又没有兄弟节点,则返回父节点
					currentNode =
						(DefaultMutableTreeNode) currentNode.getParent();
					sub--;
					out.println(tEnd);
					if (currentNode == null)
						continue;

				}
			} else {
				//当前节点有子节点
				currentNode =
					(DefaultMutableTreeNode) currentNode.getFirstChild();
				sub++;
				continue;
			}

			lastNode = currentNode.getNextSibling();
			if (lastNode != null) {
				currentNode = lastNode;

			} else {
				while ((currentNode.getNextSibling() == null)&&(currentNode!=root)) {

					currentNode =
						(DefaultMutableTreeNode) currentNode.getParent();
					sub--;
					out.println(tEnd);
				}
				currentNode = currentNode.getNextSibling();
			} //end if else

		}

	}
		out.println("</Table></div>");
	
%>

</q>
</form>
</body>
</html>
<script>
	Expand(0);
</script>
<%}finally{
	if(myBean!=null)myBean.closeConn();
}
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -