806c681a1f7e001d159b811981b6d6a9

Servlet 、Jsp 、数据库结合

package mypack;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Check extends HttpServlet {
	public Check() {
		super();
	}

	public void destroy() {
		super.destroy();
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String username=(String)request.getParameter("username");
		String password=(String)request.getParameter("password");
		//调用SQLQuery类中的静态方法validate()验证数据信息
		if(!SQLQuery.validate(username, password)){
			//密码错误情况
			request.setAttribute("error.message","非法登录");
			//页面转向
			RequestDispatcher requestDispatcher=request.getRequestDispatcher("login.jsp");
			requestDispatcher.forward(request,response);
		}
		else
		{   //登录成功,密码正确
			request.getSession().setAttribute("username",username);
			//页面转向
			RequestDispatcher requestDispatcher=request.getRequestDispatcher("success.jsp");
			requestDispatcher.forward(request,response);
		}
	}
}