login.jsp

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

<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="yhgl.connectDB" />
<%
	String name = request.getParameter("username");
	String psw = request.getParameter("password");
	if(name == null || psw == null || name.equals("") || psw.equals(""))
	{
		session.setAttribute("error","1");
		response.sendRedirect("error.jsp");
	}
	else
	{
		try
		{
			String sql = "select * from YHGL_TABLE where USER_NAME = '"+name+"' and USER_PSW = '"+psw+"'";
			ResultSet rs = db.executeQuery(sql);
			if(rs.next())
			{
				String priority = rs.getString("user_priority");
				session.setAttribute("username",name);
				session.setAttribute("userpsw",psw);
				session.setAttribute("userid",rs.getString("user_id"));
				session.setAttribute("userpriority",priority);
				response.sendRedirect("list.jsp");
			}
			else
			{
				session.setAttribute("error","2");
				response.sendRedirect("error.jsp");
			}
		}
		catch(Exception e)
		{
			session.setAttribute("error","3");
			response.sendRedirect("error.jsp");
			e.printStackTrace();
		}
	}
%>