?? user_deal.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="xwfb.connectDB" />
<%
String action = request.getParameter("action");
String [] name = request.getParameterValues("choose");
try
{
if("delete".equals(action))
{
String sql = "";
for(int i=0; i<name.length; i++)
{
sql = "delete from XWFB_USER where username='"+name[i]+"'";
db.executeUpdate(sql);
}
}
if("grad".equals(action))
{
String sql = "";
for(int i=0; i<name.length; i++)
{
sql = "update XWFB_USER set priority='2' where username='"+name[i]+"'";
db.executeUpdate(sql);
}
}
if("degrad".equals(action))
{
String sql = "";
for(int i=0; i<name.length; i++)
{
sql = "update XWFB_USER set priority='1' where username='"+name[i]+"'";
db.executeUpdate(sql);
}
}
%>
<script language="javascript">
alert("操作成功");
self.location.href="admin.jsp";
</script>
<%
}
catch(Exception e)
{
session.setAttribute("error","1");
response.sendRedirect("error.jsp");
}
finally
{
try
{
db.closeDB();
}
catch(Exception ee)
{
session.setAttribute("error","1");
response.sendRedirect("error.jsp");
}
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -