Struts框架 loginAction

 package com.yourcompany.struts.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

import com.yourcompany.struts.model.ShoppingCart;
import com.yourcompany.struts.form.LoginForm;
import com.yourcompany.struts.model.UserBean;

/**
 * MyEclipse Struts
 * Creation date: 03-19-2007
 *
 * XDoclet definition:
 * @struts.action path="/login" name="loginForm" input="/form/login.jsp" scope="request" validate="true"
 */
public class LoginAction extends Action {

 // --------------------------------------------------------- Instance Variables

 // --------------------------------------------------------- Methods

 public ActionForward execute(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response) throws ClassNotFoundException, SQLException
 {
  LoginForm loginForm = (LoginForm) form;
  String username = loginForm.getUsername();
  String password = loginForm.getPassword();
  
  UserBean userinfo = new UserBean();
  Statement stmt ; 
  stmt = userinfo.process();
  ResultSet rs=stmt.executeQuery("select * from userinfo where username='"+username+"' and password='"+password+"'");

  if(rs.next())
  { 
   HttpSession session = request.getSession(true);
   ShoppingCart scart = new ShoppingCart();
   System.out.println("ShoppingCart:"+scart);
   
   session.setAttribute("hash", scart); 
   session.setMaxInactiveInterval(365*60);   
   session.setAttribute("user",loginForm);
   return (mapping.findForward("success"));
  }
  else
  { 
      ActionErrors errors = new ActionErrors();
   errors.add("usernamepassword",new ActionError("error.usernamepassword"));
   saveErrors( request, errors );
   return (mapping.findForward("failure"));
  } 
 } 
}