fzdtaction.java

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

package struts.action;

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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 javabean.dbconnect;
import javabean.Shown;
import javabean.Fkind;

public class FzdtAction extends Action {
	
	dbconnect db=new dbconnect();
	Shown show=new Shown();
	Vector vec=new Vector();

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
			
		int i=1;
		int numPages=20;              //第页显示条数
		int nextPage ;
		int upPage;
		
		String type=request.getParameter("type");				
		String pages = request.getParameter("page") ;
		String kind="";
		if(type.equals("HYDT"))
		{
			kind="行业动态";
		}
		else if(type.equals("ZCFG"))
		{
			kind="政策法规";
		}	
		else if(type.equals("ZTDY"))
		{
			kind="专题调研";
		}
		else if(type.equals("WMXX"))
		{
			kind="外贸信息";
		}	
		else if(type.equals("ZHXX"))
		{
			kind="综合信息";
		}	
		else if(type.equals("FZZX"))
		{
			kind="纺织展讯";
		}

		
		int currentPage = 1;
		currentPage=(pages==null)?(1):(Integer.parseInt(pages));//当前页
		
		String sql = "select count(*) from FZDTB where KIND='"+kind+"'";
		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 FZDTB where KIND='"+kind+"' order by ID DESC";	
		vec=fkind.getTitleId(sql,numPages,currentPage);	   
		request.setAttribute("vec",vec);
	    
	    request.setAttribute("currentPage",String.valueOf(currentPage));
		request.setAttribute("intPageCount",String.valueOf(intPageCount));
		request.setAttribute("nextpage",String.valueOf(nextPage));
		request.setAttribute("upPage",String.valueOf(upPage));
		request.setAttribute("kind",kind);
		request.setAttribute("type",type);
		
		return mapping.findForward("success");
	}

}