📄 dealbatchset.jsp
字号:
<%@ page session="true" contentType="text/html; charset=GB2312" import="java.sql.*,java.util.*,java.lang.*,net.xerllent.campus.util.*,net.xerllent.campus.database.*,net.xerllent.campus.sysadmin.*" %>
<%
security.checkAuth(session,"Ic",response,request);
int AuthLevel=security.getAuthLevel(session,"Ic");
%>
<html>
<head>
<title>校园.NET</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0">
<%
//如有删除标志，则删除该条记录
if(ParamUtils.getParameter(request,"ondelete").equals("1"))
{
if(AuthLevel<3)
{
response.sendRedirect("/prog/nopermission.jsp");
}
else
{
int count=ParamUtils.getIntParameter(request,"recordcount",10);
User myUser=new User();
for(int i=0;i<count;i++)
{
if(ParamUtils.getParameter(request,"deletechk"+i)!=null)
{
int userid=ParamUtils.getIntParameter(request,"deletechk"+i,0);
myUser.delete(userid);
int LogID=0;
if(session.getAttribute("LogID")!=null)
LogID=((Integer)session.getAttribute("LogID")).intValue();
security.recordAction(LogID,"删除用户"+User.getUserTrueName(userid));
}
}
}
}
//不然就执行用户所作的修改操作，记录在数据库
else
{
if(AuthLevel<2)
{
response.sendRedirect("/prog/nopermission.jsp");
}
else
{
int count=ParamUtils.getIntParameter(request,"recordcount",10);
Connection conn=DbConnectionManager.getConnection();
Statement sta=conn.createStatement();
for(int i=0;i<count;i++)
{
String teamname=ParamUtils.getParameter(request,"select"+i);
int teamid=Team.getTeamID(teamname);
int userid=User.getUserID(ParamUtils.getParameter(request,"username"+i));
sta.executeUpdate("update act_user set UserMTeamName='"+teamname+"',ConstrainIPPassed='"+ParamUtils.getParameter(request,"ipconstrainchk"+i,"0")+"',ArchiveEditKey='"+ParamUtils.getParameter(request,"archeditkeychk"+i,"0")+"',UserPassed='"+ParamUtils.getParameter(request,"permitchk"+i,"1")+"' where UserID='"+userid+"'");
if(!teamname.equals("无部门"))
{
sta.executeUpdate("delete from act_teamuser where UserID='"+userid+"' and TeamID='"+teamid+"'");
sta.executeUpdate("update act_teamuser set MainMark=0 where UserID='"+userid+"'");
sta.executeUpdate("insert into act_teamuser values ("+Team.getTeamID(teamname)+","+userid+",1,0)");
}
int LogID=0;
if(session.getAttribute("LogID")!=null)
LogID=((Integer)session.getAttribute("LogID")).intValue();
security.recordAction(LogID,"修改用户"+User.getUserTrueName(userid));
}
sta.close();
conn.close();
}
}
//返回到前一页面
response.sendRedirect("batchset.jsp");
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -