zhactionaction.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (Bad file descriptor))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

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 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.ZhactionForm;

/** 
 * ZhactionAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-15-2004
 * 
 * XDoclet definition:
 * @struts:action path="/zhaction" name="zhactionForm" input="/zhaction.jsp" validate="true"
 */
public class ZhactionAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		ZhactionForm zhactionForm = (ZhactionForm) form;
		
				int i=0;
				int shownum=30;
				int allnum=0;
				int currentpage=1;
				int nextpage;
				int uppage;
				String page=zhactionForm.getpage();
				String table=zhactionForm.getable();
				String tables = null;
				dbconnect db=new dbconnect();
				Vector vector=new Vector();
		
				currentpage=(page==null)?(1):(Integer.parseInt(page));
				String sql = "select count(id) from "+table+" ";
				ResultSet rs = db.executeQuery(sql) ;
				while(rs.next()) i = rs.getInt(1) ;
				allnum=i;
				sql="";
				int intPageCount=(i%shownum==0)?(i/shownum):(i/shownum+1);//总页数

				if(currentpage>intPageCount) currentpage=intPageCount;
				nextpage = currentpage+1;
				if (nextpage>=intPageCount) nextpage=intPageCount;
				uppage = currentpage-1;
				if (uppage<=1) uppage=1;
		
				Fkind find=new Fkind();
				sql="select TITLE,ID,PUBDATE from "+table+" order by id desc";
				vector=find.getTitleId(sql,shownum,currentpage);
				request.setAttribute("vector",vector);
				request.setAttribute("table",table);
				request.setAttribute("allnum",String.valueOf(allnum));
				request.setAttribute("currentpage",String.valueOf(currentpage));
				request.setAttribute("intPageCount",String.valueOf(intPageCount));
				request.setAttribute("nextpage",String.valueOf(nextpage));
				request.setAttribute("uppage",String.valueOf(uppage));
				if(table.equalsIgnoreCase("TJFX"))
				{
					tables="统计分析";
				}
				else if(table.equalsIgnoreCase("SCTJ"))
				{ 
					tables="生产统计";
				}
				else if(table.equalsIgnoreCase("JJXY"))
				{
					tables="经济效益";
				}
				else if(table.equalsIgnoreCase("ZHTJ"))
				{
					tables="综合统计";
				}
				else if(table.equalsIgnoreCase("JCKTJ"))
				{
					tables="进出口统计";
				}
				request.setAttribute("tables",tables);
			zhactionForm.reset(mapping,request);		
		
		return mapping.findForward("Success");
		
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}