?? searchaction.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 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");
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -