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 SearchAction extends Action {
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
  HttpSession session=request.getSession();
  ActionErrors errors=new ActionErrors ();
  DynaActionForm tform=(DynaActionForm)form;
 // String sorts=(String)tform.get("sort");
  String pname=(String)tform.get("pname");
  pname=new String(pname.getBytes("ISO-8859-1"),"GBK");
  String provider=(String)tform.get("provider");
  provider=new String(provider.getBytes("ISO-8859-1"),"GBK");

  if(tform.get("pname")==null||pname.equals("")){
             pname="_*";}
 if(tform.get("provider")==null||provider.equals("")){
             provider="_*";}
  Vector vc=new Vector();
  
  try{
    String sql="SELECT * FROM product WHERE pname REGEXP '"+pname+
              "' AND provider REGEXP '"+provider+"'";
    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;
    }  
    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");
 }
}