📄 search.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
try
{
java.lang.String yhzbm=request.getParameter("yhzbm");
int checknum=-1;
int i=0;//计数器
java.lang.String czydm="";
java.lang.String sql="";
java.sql.ResultSet rs=null;
//支持十几级以内的动态菜单
java.sql.ResultSet result[]=new java.sql.ResultSet[3];
for(i=0;i<3;i++) result[i]=null;
i=0;//计数器复位，以备后用
java.lang.String genScript="";
java.lang.String[] cdxbm={"","",""};
java.lang.String[] cdxmc={"","",""};
java.lang.String[] sjdm ={"","",""};
int zxgs=0;
//下面动态生成SCRIPT语句
i=0;//计数器复位，以备后用
sql="SELECT DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS FROM DBO.CDXZD WHERE DBO.CDXZD.SJDM='000' AND DBO.CDXZD.CDXBM<>'000' ORDER BY CDXBM";
result[0]=DbBean.sqlQuery(sql);
while(result[0].next())
{
cdxbm[0]=((java.lang.String)(result[0].getString("CDXBM"))).trim();
cdxmc[0]=((java.lang.String)(result[0].getString("CDXMC"))).trim();
zxgs=result[0].getInt("ZXGS");
if(zxgs==0)
{ //如果是终节点，根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
checknum++;
sql="SELECT COUNT(*) AS NUM FROM DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[0]+"') AND (DBO.YHZQXB.YHZBM='"+yhzbm+"'))";
rs=DbBean.sqlQuery(sql);
rs.next();
if(rs.getInt("NUM")>0)
{
genScript+="cdxdmtext["+checknum+"].checked=true;";
}
else
{
genScript+="cdxdmtext["+checknum+"].checked=false;";
}
rs.close();//释放资源
rs=null;
}
else
{//文件夹
//genScript+="cdxdmtext["+checknum+"].checked=false;";
i=1;
sql="SELECT DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS FROM DBO.CDXZD WHERE DBO.CDXZD.SJDM='"+cdxbm[0]+"' ORDER BY CDXBM";
result[1]=DbBean.sqlQuery(sql);
while(result[1].next())
{
checknum++;
cdxbm[1]=((java.lang.String)(result[1].getString("CDXBM"))).trim();
cdxmc[1]=((java.lang.String)(result[1].getString("CDXMC"))).trim();
zxgs=result[1].getInt("ZXGS");
if(zxgs==0)
{ //各个节点之间可能不同的地方class='***Item' or '***Folder';src='';href=;
//如果是终节点，根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
sql="SELECT COUNT(*) AS NUM FROM DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[1]+"') AND (DBO.YHZQXB.YHZBM='"+yhzbm+"'))";
rs=DbBean.sqlQuery(sql);
rs.next();
if(rs.getInt("NUM")>0)
{
genScript+="cdxdmtext["+checknum+"].checked=true;";
}
else
{
genScript+="cdxdmtext["+checknum+"].checked=false;";
}
rs.close();//释放资源
rs=null;
}
else
{ //文件夹
//genScript+="cdxdmtext["+checknum+"].checked=false;";
i=2;
sql="SELECT DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS FROM DBO.CDXZD WHERE DBO.CDXZD.SJDM='"+cdxbm[1]+"' ORDER BY CDXBM";
result[2]=DbBean.sqlQuery(sql);
while(result[2].next())
{ //现在金支持到这一级菜单
//如果是终节点，根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
checknum++;
cdxbm[2]=((java.lang.String)(result[2].getString("CDXBM"))).trim();
cdxmc[2]=((java.lang.String)(result[2].getString("CDXMC"))).trim();
zxgs=result[2].getInt("ZXGS");
sql="SELECT COUNT(*) AS NUM FROM DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[2]+"') AND (DBO.YHZQXB.YHZBM='"+yhzbm+"'))";
rs=DbBean.sqlQuery(sql);
rs.next();
if(rs.getInt("NUM")>0)
{
genScript+="cdxdmtext["+checknum+"].checked=true;";
}
else
{
genScript+="cdxdmtext["+checknum+"].checked=false;";
}
rs.close();//释放资源
rs=null;
}
result[2].close();//释放资源
result[2]=null;
}
}
result[1].close();//释放资源
result[1]=null;
}
}
result[0].close();//释放资源
result[0]=null;
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<LINK rel="stylesheet" href="/theme/Master.css" type="text/css">
<TITLE>用户组权限维护查询</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript">
function setcheck()
{
with(opener.document.czform)
{
<%=genScript%>
}
window.close();
}
</SCRIPT>
</HEAD>
<BODY bgcolor="#FFFFFF" onload="setcheck()">
</BODY>
</HTML>
<%
}
catch( Throwable e)
{
DbBean.clear();
if(((e.getMessage())).equals("ResultSet is closed"))
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/blank.html';");
out.println("</SCRIPT>");
}
else if(e.getMessage()==null)
{
out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！");
}
else out.println(e.getMessage());
return;
}
finally
{
System.gc();
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -