📄 seldadbm_below.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
字号:
<%
/**********************************************************
Copyright (C),2003-10-12, Beijing  USTB.
All rights reserved.
Filename: selDadbm_below.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>

</head>
	
<body topmargin=0 leftmargin=0>

<form name="formselorg" method=post>
  <q id="0011" align=left>
	<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 display;
		//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("<div style=\"display:\"  id=\"" +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>
<!-- --------------－－－－－－－－-------------------------------------    -->
<%

			
			if(sub==1)
				display = "";
			else
				display = "none";
			out.println("<div style=\"display:"+display+"\"  id=\"" +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>
<%}finally{
	if(myBean!=null)myBean.closeConn();
}
%>
⌨️ 快捷键说明

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