user_upgrade.jsp

JSP+oracle开发实例精粹》随书光盘

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="qyxx.userDB" />
<%
	String [] user = request.getParameterValues("choose");
	String priority = (String)session.getAttribute("priority");
	if("2".equals(priority))
	{
		try
		{
			if(db.editUserPriority(user,2) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功！");
				self.location.href="user_list_z.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");
			}
		}
	}
	else
	{
		if("3".equals(priority))
		{
			ResultSet rs = null;
			String sql = "";
			try
			{
				if(db.editUserPriority(user,3) == 1)
				{
				%>
				<script language="javascript">
					alert("操作成功！");
					self.location.href="user_list_j.jsp";
				</script>
				<%
				}
			}
			catch(Exception e)
			{
				session.setAttribute("error","1");
				response.sendRedirect("error.jsp");
			}
			finally
			{
				try
				{
					db.closeDB();
					rs.close();
				}
				catch(Exception ee)
				{
					session.setAttribute("error","1");
					response.sendRedirect("error.jsp");
				}
			}
		}
		else
		{
			session.setAttribute("error","3");
			response.sendRedirect("error.jsp");
		}
	}

%>