📄 qxsave.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="../../../../const/style.css" type="text/css">
</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"));
String rolerightlist[] = request.getParameterValues("rolerightlist");
String filejb=new String(request.getParameter("filejb").getBytes("8859_1"));
String isC="",isB="";
for(int i=0;i<rolerightlist.length;i++){
isC=isC+"'"+rolerightlist[i]+"',";
isB=isB+"'"+rolerightlist[i].substring(0,2)+"',";
}
if(!isC.equals("")){
isC=isC.substring(0,isC.length()-1);
isB=isB.substring(0,isB.length()-1);
}
strSQL="update userlist set filejb='"+filejb+"' where userid='"+userid+"'";
sqlStmt.executeUpdate(strSQL);
strSQL="update tree_user set ischeck='0' where userid='"+userid+"'";
sqlStmt.executeUpdate(strSQL);
strSQL="update tree_user set ischeck='1' where userid='"+userid+"' and left(id,4) in ("+isC+")";
sqlStmt.executeUpdate(strSQL);
strSQL="update tree_user set ischeck='1' where userid='"+userid+"' and id in ("+isB+")";
sqlStmt.executeUpdate(strSQL);
response.setHeader("Refresh","0;URL=default.jsp");
//关闭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>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -