user_deal.jsp

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

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*,qyxx.*"%>
<jsp:useBean id="db" class="qyxx.userDB" />
<%
	String action = request.getParameter("action");
	if("login".equals(action))
	{
		String name = request.getParameter("user");
		String psw = request.getParameter("psw");
		try
		{
			userTable ut = db.loginCheck(name,psw);

			if(ut != null)
			{
				session.setAttribute("username",ut.getUsername());
				session.setAttribute("priority",ut.getPriority());
				session.setAttribute("name",ut.getName());
				session.setAttribute("age",ut.getAge());
				session.setAttribute("sex",ut.getSex());
				session.setAttribute("department",ut.getDepartname());
				session.setAttribute("departid",ut.getDepartid());

				%>
				<script language="javascript">
					top.location.href="index.html";
				</script>
				<%
			}
			
		}
		catch(Exception e)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}

	if("add".equals(action))
	{
		String user = request.getParameter("user");
		String psw = request.getParameter("psw");
		String name = new String((request.getParameter("name")).getBytes("ISO8859_1"));
		String age = new String((request.getParameter("age")).getBytes("ISO8859_1"));
		String sex = new String((request.getParameter("sex")).getBytes("ISO8859_1"));
		String departid = request.getParameter("departid");

		userTable ut = new userTable();
		ut.setUsername(user);
		ut.setPassword(psw);
		ut.setName(name);
		ut.setAge(age);
		ut.setSex(sex);
		ut.setDepartid(departid);

		try
		{
			if(db.addUser(ut) == 1)
			{
			%>
			<script language="javascript">
				alert("添加成功");
				window.close();
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
	if("editpriority".equals(action))
	{
		String [] user = request.getParameterValues("user");
		try
		{
			if(db.editUserPriority(user,1) == 1)
			{
			%>
			<script language="javascript">
				alert("添加成功");
				self.location.href="user_list.jsp";
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}

	if("edit".equals(action))
	{
		String psw = request.getParameter("psw");
		String name = new String((request.getParameter("name")).getBytes("ISO8859_1"));
		String age = new String((request.getParameter("age")).getBytes("ISO8859_1"));
		String sex = new String((request.getParameter("sex")).getBytes("ISO8859_1"));
		String departid = request.getParameter("departid");
		userTable ut = new userTable();
		ut.setName(name);
		ut.setPassword(psw);
		ut.setAge(age);
		ut.setSex(sex);
		ut.setDepartid(departid);
		ut.setUsername((String)session.getAttribute("username"));

		try
		{
			ut = db.editUser(ut);
			if(ut != null)
			{
				session.setAttribute("name",ut.getName());
				session.setAttribute("age",ut.getAge());
				session.setAttribute("department",ut.getDepartname());
				session.setAttribute("departid",ut.getDepartid());
				%>
				<script language="javascript">
					alert("添加成功");
					window.close();
					opener.top.location.reload();
				</script>
			<%
			}
			else
			{
				%>
				<script language="javascript">
					alert("添加不成功");
					window.close();
				</script>
				<%
			}
			
		}
		catch(Exception e)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
	if("delete".equals(action))
	{
		String [] user = request.getParameterValues("user");
		try
		{
			if(db.deleteUser(user) == 1)
			{
			%>
			<script language="javascript">
				alert("删除成功");
				self.location.href="user_list.jsp";
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
%>