listproaction.java

一个用java开发的网上购物系统。基本功能都是可以实现的

package store;
import java.sql.*;
import java.util.*;
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.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 ListProAction extends Action {
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
  HttpSession session=request.getSession();
 DynaActionForm tform=(DynaActionForm)form;
 ActionErrors errors=new ActionErrors ();
  String sorts=(String)tform.get("sort");
  Vector vc=new Vector();
  try{
    String sql="SELECT * FROM product WHERE sort="+sorts;
    DBConn conn = new DBConn();
    ResultSet rs = conn.query(sql);
    while (rs.next()) {
      ProInfo PI=new ProInfo();
      PI.setId(rs.getInt("id"));
      PI.setSort(rs.getInt("sort"));
      PI.setPname(rs.getString("pname"));
      PI.setProvider(rs.getString("provider"));
      PI.setStock(rs.getInt("stock"));
      PI.setPrice(rs.getFloat("price"));
      PI.setSold(rs.getInt("sold"));
      PI.setSinfo(rs.getString("sinfo"));
      PI.setInfo(rs.getString("info"));
      PI.setImage(rs.getString("image"));
      vc.add(PI);
     // PI = null;
    }
    System.out.print(sql);
    rs.close();
    conn.DBclose();
  }
  catch(Exception e){
    ActionError err= new ActionError ("error.global");
    errors.add(ActionErrors.GLOBAL_ERROR,err);
    this.saveErrors(request,errors);
    return mapping.findForward("error");
  }
  session.setAttribute("Search_pro",vc);
  return mapping.findForward("ListPro");
 }
}