📄 qxiant.jsp
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@include file="..\..\const\global.jsp"%>
<html>
<head>
<script language="JavaScript" src="../../js/js.js"></script>
<script language="JavaScript" src="../../js/rightopt.js"></script>
<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">
<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> 目录权限 <INPUT TYPE="button" value="全 选" onclick="selectAll(rolerightlist)"> <INPUT TYPE="button" value="清 空" onclick="selectNone(rolerightlist)"></TD></tr>
<tr><td align="center" valign="middle" width="100%">
<select size="20" style="width:98%" name="rolerightlist" onclick="checkItem(this)" ondblclick="changeRight(this)">
<%
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%">
<input type="submit" name="b_submit" value="保存" onclick="return saveRight();;return submitAction(this);">
【<a href="default.jsp">取消</a>】
<br><br>
</form>
</center>
</body>
</html>
<SCRIPT LANGUAGE="JavaScript">
<!--
function saveRight()
{
document.roleForm.rolerightlist.multiple=true;
if(!confirm("您确认更新该角色的权限吗？"))
{
document.roleForm.rolerightlist.multiple=false;
return false;
}
for(var i=0;i<document.roleForm.rolerightlist.options.length;i++)
{
document.roleForm.rolerightlist.options[i].selected=true;
}
for(var i=0;i<document.roleForm.rolerightlist.options.length;i++)
{
var e = document.roleForm.rolerightlist.options[i];
var sTemp="";
sTemp=e.text;
if(sTemp.search("√")!=-1)
document.roleForm.rolerightlist.options[i].selected=true;
else
document.roleForm.rolerightlist.options[i].selected=false;
}
return true;
}
//-->
</SCRIPT>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -