fzkjaction.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 103 行

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 FzkjAction 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("KJDT"))
		{
			kind="科技动态";
		}
		else if(type.equals("XPJS"))
		{
			kind="新品介绍";
		}	
		else if(type.equals("GYJS"))
		{
			kind="工艺技术";
		}
		else if(type.equals("FJFQ"))
		{
			kind="纺机纺器";
		}	
		else if(type.equals("CGZL"))
		{
			kind="成果专利";
		}	
		else if(type.equals("FZBZ"))
		{
			kind="纺织标准";
		}		
		else if(type.equals("ZXFW"))
		{
			kind="咨询服务";
		}
		
		int currentPage = 1;
		currentPage=(pages==null)?(1):(Integer.parseInt(pages));//当前页
		
		String sql = "select count(*) from FZKJB 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 FZKJB 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");
	}

}