📄 qxiantlook.jsp
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@include file="..\..\const\global.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../../css/style.css" type="text/css">
<title>用户目录权限设置</title>
</head>
<body background="../../image/backg2.gif">
<%
String StrMsg="";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
sqlCon = java.sql.DriverManager.getConnection(ConnStr,ConnUser,ConnPassword);
sqlStmt = sqlCon.createStatement();
String userid=new String(request.getParameter("userid").getBytes("8859_1"));
int filejb=0;
strSQL="select * from userlist where userid='"+userid+"'";
sqlRst = sqlStmt.executeQuery(strSQL);
if(sqlRst.next()){
filejb=sqlRst.getInt("filejb");
}
sqlRst.close();
%>
<center>
<h5>权限管理-->权限设置</h5>
<p align="left">用户名：<%=userid%></p>
<form name="roleForm" method="post" action="qxsave.jsp">
<input type="hidden" name=userid value="<%=userid%>">
<TABLE align=center cellPadding=3 cellSpacing=1 width="80%" class="main">
<tr>
<td width=150> 可检索的文件级别</TD>
<td>
<select name="filejb" disabled>
<option value="">------------</option>
<%
strSQL="select * from filejb order by jbbh";
sqlRst = sqlStmt.executeQuery(strSQL);
while(sqlRst.next()){
if(filejb==sqlRst.getInt("jbbh")){
out.println("<option selected value="+sqlRst.getInt("jbbh")+">"+sqlRst.getInt("jbbh")+"*"+sqlRst.getString("jbname")+"</option>");
}
else{
out.println("<option value="+sqlRst.getInt("jbbh")+">"+sqlRst.getInt("jbbh")+"*"+sqlRst.getString("jbname")+"</option>");
}
}
sqlRst.close();
%>
</select>
</TD>
</tr>
</table>
<TABLE align=center cellPadding=3 cellSpacing=1 width="80%" class="main">
<tr><td> 目录权限</TD></tr>
<tr><td align="center" valign="middle" width="100%">
<select size="20" style="width:98%" name="rolerightlist">
<%
strSQL="select * from tree_user where userid='"+userid+"' and len(id)<5 order by id";
sqlRst = sqlStmt.executeQuery(strSQL);
while(sqlRst.next()){
String id=sqlRst.getString("id");
String name=sqlRst.getString("name");
String ischeck=sqlRst.getString("ischeck");
if(id.length()==2){
out.println("<option value='"+id+"'>"+name+"</option>");
}
else{
if(ischeck.equals("1")){
out.println("<option value='"+id+"'> √ "+name+"</option>");
}
else{
out.println("<option value='"+id+"' style='color:gray;'> × "+name+"</option>");
}
}
}
sqlRst.close();
%>
</select>
</td></tr>
</table>
<table border="0" width="80%" cellspacing="1" cellpadding="3" class="main">
<%
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlCon.close();
}catch(SQLException s) {
StrMsg="SQL错误信息："+s.toString()+" "+s.getErrorCode()+" "+s.getSQLState();
}catch(Exception e) {
StrMsg="错误信息："+e.toString()+e.getMessage();
}
if(!StrMsg.equals("")){
out.println("<font color=red>"+StrMsg+"</font>");
}
%>
</table>
<hr width="80%">
【<a href="default.jsp">取消</a>】
<br><br>
</form>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -