searchaction.java

这个程序是花了好几十万请人开发的

package struts.action;

import java.sql.ResultSet;
import java.util.Vector;

import javabean.Fkind;
import javabean.dbconnect;

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

import struts.form.SearchForm;
	
public class SearchAction extends Action 
{
	
	dbconnect db=new dbconnect();
		
	public ActionForward execute(
	ActionMapping mapping,
	ActionForm form,
	HttpServletRequest request,
	HttpServletResponse response)
	throws Exception {
	
	int i=1;
	int numPages=15;              //第页显示条数
	int nextPage ;
	int upPage;
	
	SearchForm searchform=(SearchForm) form;
	HttpSession session=request.getSession();
	
	String keyword=(String)request.getAttribute("keyword");
	if(keyword==null||keyword.equals(""))
	{
		keyword=searchform.getKeyword();
	}		
  		keyword=new String(keyword.getBytes("ISO-8859-1"));
  		
	String searchfile=(String)request.getAttribute("searchfile");
	if(searchfile==null||searchfile.equals(""))
	{
		searchfile=searchform.getSearchfile();
	}
  		searchfile=new String(searchfile.getBytes("ISO-8859-1"));
	String type=request.getParameter("type");
	
	String sql="";
	if(type==null||type.equals(""))
	{
		if(searchfile.equals("纺织资讯"))
		  sql= "select count(*) from FZDTB where KEYWORD like '%"+keyword+"%' order by ID DESC";
		else if(searchfile.equals("纺织科技"))
		  sql= "select count(*) from FZKJB where KEYWORD like '%"+keyword+"%' order by ID DESC";
		else if(searchfile.equals("原料行情"))
		   sql= "select count(*) from YLHQ1_PS where TITLE like '%"+keyword+"%' order by ID DESC";
		else if(searchfile.equals("市场行情"))
		   sql= "select count(*) from HQDTB where KEYWORD like '%"+keyword+"%' order by ID DESC";
		else if(searchfile.equals("商务中心"))
		   sql= "select count(*) from CPGQB where KIND like '%"+keyword+"%' order by ID DESC";

	}
		
	String pages = request.getParameter("page") ;				
	int currentPage = 1;
	currentPage=(pages==null)?(1):(Integer.parseInt(pages));//当前页
		
	
	ResultSet rs = db.executeQuery(sql) ;
	while(rs.next()) i = rs.getInt(1) ;
		
	int intPageCount=(i%numPages==0)?(i/numPages):(i/numPages+1);//总页数

	if(currentPage>intPageCount) currentPage=intPageCount;
	nextPage = currentPage+1;
	if (nextPage>=intPageCount) nextPage=intPageCount;
	upPage = currentPage-1;
	if (upPage<=1) upPage=1;
		
	Fkind fkind=new Fkind();		
	Vector vec=new Vector();		    
	sql="select * from "+type+" where KEYWORD like '%"+keyword+"%' order by ID DESC";	
	vec=fkind.getTitleId(sql,numPages,currentPage);	  
	 
	request.setAttribute("vec",vec);
	request.setAttribute("searchfile",searchfile);	
	request.setAttribute("type",type);
	request.setAttribute("keyword",keyword);
	
	request.setAttribute("currentPage",String.valueOf(currentPage));
	request.setAttribute("intPageCount",String.valueOf(intPageCount));
	request.setAttribute("nextpage",String.valueOf(nextPage));
	request.setAttribute("upPage",String.valueOf(upPage));

    searchform.reset(mapping,request);
    
	return (mapping.findForward("success"));
   }	

}