loginservlet.java

大型数据库课程设计源码

package servlet;
import java.io.IOException;
import java.io.PrintWriter;

import javax.jms.Session;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class LoginServlet extends HttpServlet {

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		String name=(String)request.getParameter("usrname").trim();
		String pwd=(String)request.getParameter("psw").trim();
		
		String sql="select * from netbankcustomer where name='"+name+"' and pwd= '"+pwd+"'";
		db.DBManager.getConnection();
		int i=db.DBManager.executeQuery(sql);
		if(i!=0){
			response.sendRedirect("/netservice/jsp/loginerror.jsp");
		}else{
			HttpSession session=request.getSession(true);
			session.setAttribute("name",name);
			response.sendRedirect("/netservice/jsp/Service.jsp");
		}
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException{
		doPost(request,response);
	}

}