user_deal.jsp

JSP+ORCLE 实现后台登陆

<%@ 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");
		}
	}
%>