loginaction.java

网上商城

package store;
import java.sql.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.validator.DynaValidatorForm;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
public class LoginAction extends Action {
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
      throws Exception {
       HttpSession session=request.getSession();
       DynaValidatorForm tform=(DynaValidatorForm)form;
       ActionErrors errors=new ActionErrors ();
       String username=(String)tform.get("username");
       String password=(String)tform.get("password");
       String pageForward="";
        try{
          DBConn conn =new DBConn();
          String sql="SELECT * FROM customer WHERE username='"+
                      username+"' AND password='"+password+"'";
          ResultSet rs=conn.query(sql);
          if(rs.next()){
             session.setAttribute("customer",rs.getString("name"));
             session.setAttribute("userid",new Integer(rs.getInt("id")));
             pageForward="default";
          }
          else{
            ActionError err= new ActionError ("error.log");
            errors.add(ActionErrors.GLOBAL_ERROR,err);
            this.saveErrors(request,errors);
            pageForward="default";
          }
        }
        catch(Exception e){
          ActionError err= new ActionError ("error.global");
          errors.add(ActionErrors.GLOBAL_ERROR,err);
          this.saveErrors(request,errors);
          pageForward="error";
        }
        return mapping.findForward(pageForward);
       }
}