📄 qx_tree.jsp

📁 一个较好的公务员管理系统软件源代码
💻 JSP
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@ page import = "com.vstsoft.std.*" %>
<%@ page import = "java.sql.*" %>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />

<% if (jcypurview.checkLogin() == false)
   {
%>   
	<Script Language=javascript>
		alert("用户已断线或未正常登录，请重新登录!")
		window.open("../index.htm","_top")
	</Script>
<%  return;}
   String Userid = "";
   Userid = jcypurview.getUserid();     //取当前公务员编号

   if (jcypurview.purviewVerdict("B0500006") == false)
  {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限!")
		window.open("../index.jsp","_top")
	</Script>
<%  return;  }  %>


<%
	vststd tra = new vststd("jc");	
	String squery = tra.getValue(request,"query");
	String suid = "";
	String sucode = "";
	String suname = "";
	String sdm = "";
	String smc = "";
	String sdwdm = "";
	String sdwmc = "";
	String szbdm = "";
	String szbmc = "";
%>

<html>

<head>
<style>
BODY {
	SCROLLBAR-FACE-COLOR: #FFE6D4; 
	SCROLLBAR-HIGHLIGHT-COLOR: white; 
	SCROLLBAR-SHADOW-COLOR: white; 
	SCROLLBAR-3DLIGHT-COLOR: white; 
	SCROLLBAR-ARROW-COLOR: white; 
	SCROLLBAR-TRACK-COLOR: #FFE6D4; 
	SCROLLBAR-DARKSHADOW-COLOR: #FFE6D4
}
</style>
<link rel="stylesheet" href="../style.css" type="text/css">
<title>权限管理</title>
<script language="JavaScript" src = "js/tree.js"></script>
</head>

<body bgcolor="#EEF9FF">
<table width="100%" height="23" border="0">
  <tr> 
    <td width="13%" height="19"> 
      <div align="left"></div></td>
    <td width="87%"> &nbsp;&nbsp;
      <script>
	foldersTree = gFld("<b><font color=#174ca3>权限管理</font></b>", "")
	aux1 = insFld(foldersTree, gFld("<b><font color=#174ca3>人员管理</font></b>", ""))

	<% sun.jdbc.rowset.CachedRowSet rs_qx = tra.getResultBySelect("select dm,mc from DM_MX where dmm = '0001' order by dm ");
	while(rs_qx.next())
	{
		sdm = rs_qx.getString(1);
		if (sdm == null) sdm = "";
		smc = rs_qx.getString(2);
		if (smc == null) smc = "";
		%>
	    aux2 = insFld(aux1, gFld("<font size=2 color=#174ca3><a href='qx_ry_view.jsp?key=query&zt=qx&qxdm=<%=sdm%>&dwdm=null&zbdm=null' target='tabFrame'><%=smc%></a></font>", ""));
		<%
			sun.jdbc.rowset.CachedRowSet rs_dw = tra.getResultBySelect("select dwdm,dwmc from jcy_dw where qx = '" + sdm + "' order by dwmc");
			while(rs_dw.next())
			{ 
				sdwdm = rs_dw.getString(1);
				if (sdwdm == null) sdwdm = "";
				sdwmc = rs_dw.getString(2);
				if (sdwmc == null) sdwmc = "";
			%>

				aux3 = insFld(aux2, gFld("<font size=2 color=#174ca3><a href='qx_ry_view.jsp?key=query&zt=dw&qxdm=<%=sdm%>&dwdm=<%=sdwdm%>&zbdm=null' target='tabFrame'><%=sdwmc%></a></font>", ""));
			<%
		        sun.jdbc.rowset.CachedRowSet rs_zb = tra.getResultBySelect("select zbdm,zbmc from jcy_zb where dwdm = '"+ rs_dw.getString(1) + "' order by zbmc");
				while(rs_zb.next())
				{
					szbdm = rs_zb.getString(1);
					if (szbdm == null) szbdm = "";
					szbmc = rs_zb.getString(2);
					if (szbmc == null) szbmc = "";
					%>
						aux4 = insFld(aux3, gFld("<font size=2 color=#174ca3><a href='qx_ry_view.jsp?key=query&zt=zb&qxdm=<%=sdm%>&dwdm=<%=sdwdm%>&zbdm=<%=szbdm%>' target='tabFrame'><%=szbmc%></a></font>", ""));
					<%
				}
			}
		}%>
	aux1 = insFld(foldersTree, gFld("<b><font size=2 color=#174ca3><a href='qx_js_dtab.jsp?key=query' target='tabFrame'>角色管理</a></font></b>", ""));
	<% sun.jdbc.rowset.CachedRowSet rs_group = tra.getResultBySelect("select id ,name from QX_GROUP where id <> 1 order by name");
	while(rs_group.next())
	{%>
		insDoc(aux1, gLnk(2, "<font size=2 color=#174ca3><a href='qx_js_tab.jsp?ID=<%=rs_group.getString(1)%>' target='tabFrame'><%=rs_group.getString(2)%></a></font>", ""));
	<%}%>
		
</script>
&nbsp;
<script>
	initializeDocument()
</script>
</td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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