loginhandleservlet.java

学生管理系统

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package warren.eaststd.jsp.stuinfo;

import java.io.*;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.Cookie;

/**
 *
 * @author Administrator
 */
public class LoginHandleServlet extends HttpServlet {
   
    /** 
    * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
    * @param request servlet request
    * @param response servlet response
    */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=GBK");
        PrintWriter out = response.getWriter();
        String userName = request.getParameter("userName");
        String passwd = request.getParameter("passwd");
        String role = request.getParameter("role");
        String timeoutStr = request.getParameter("timeout");
        int timeout = -1;
        if(timeoutStr.equals("minute")){
            timeout = 60;
        }
        if(timeoutStr.equals("hour")){
            timeout = 60*60;
        }
        if(timeoutStr.equals("day")){
            timeout = 60*60*24;
        }
         try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        String url = "jdbc:oracle:thin:warren/effort@localhost:1521:foster";
       Connection conn = DriverManager.getConnection(url);
        PreparedStatement ps = conn.prepareStatement("select * from member where name=? and passwd=?");
        ps.setString(1, userName);
        ps.setString(2, passwd);
        ResultSet rs = ps.executeQuery();
       
        if(rs.next()){
            Cookie c = new Cookie("userName",userName);
            c.setMaxAge(timeout);
            response.addCookie(c);
            HttpSession session = request.getSession(true);
            session.setAttribute("userName",userName);
            response.sendRedirect(request.getContextPath()+"/main.jsp");
            return;
        }else{
            response.sendRedirect(request.getContextPath()+"/login.jsp");
        }
        }catch(Exception e){
            e.printStackTrace();
        } 
         
         finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet 鏂规硶銆傚崟鍑诲乏渚х殑 + 鍙蜂互缂栬緫浠ｇ爜銆?>
    /** 
    * Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
    * Handles the HTTP <code>POST</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
    * Returns a short description of the servlet.
    */
    public String getServletInfo() {
        return "Short description";
    }
    // </editor-fold>
}