loginaction.java~30~

Spring +Web 的完整 MyEclipse 项目源码,使用者可以作为入门材料可以在此基础上深入学习

package login;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import java.sql.*;
import javax.servlet.http.HttpSession;


public class LoginAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest servletRequest,
                               HttpServletResponse servletResponse) {
    LoginActionForm loginActionForm = (LoginActionForm) actionForm;
    String password="";
   try{
     Class.forName("org.gjt.mm.mysql.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root","123321");
            Statement stmt=conn.createStatement();


            String sql="select password from user where username ='"+loginActionForm.getUsername()+"'";
     ResultSet rs=stmt.executeQuery(sql);

     /*
       javax.sql.DataSource ds = getDataSource(servletRequest);

            Connection conn = ds.getConnection();
            Statement stmt=conn.createStatement();

            String sql=
       "select password from user where username ='"
       +loginActionForm.getUsername()+"'";
     ResultSet rs=stmt.executeQuery(sql);

 */


    while(rs.next())
    {
    password=rs.getString("password");
    }

    rs.close();
    stmt.close();
    conn.close();

   }catch(Throwable e){e.printStackTrace();}

   if(password.equals(loginActionForm.getPassword()))
       {

         HttpSession session=servletRequest.getSession();
      System.out.print(password);
//添加属性
         session.setAttribute("username",loginActionForm.getUsername());

//删除session
         session.invalidate();
         return(actionMapping.findForward("loginsuccess"));
       }

    else
    {
      return(actionMapping.findForward("loginfail"));
    }
  }
}