sctjaction.java

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

// 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.Sctj;
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.SctjForm;

/** 
 * SctjAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-03-2004
 * 
 * XDoclet definition:
 * @struts:action path="/sctj" name="sctjForm" input="/sctj.jsp" validate="true"
 */
public class SctjAction 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 {
		SctjForm sctjForm = (SctjForm) form;
		
		ResultSet rs;
		dbconnect db=new dbconnect();
		String sql;
		String table=sctjForm.gettable();
		String tables="";
		int id=sctjForm.getid();
		Vector show1=new Vector();
		
		sql="select title,contents from "+table+" where id='"+id+"' order by id";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Sctj sctj=new Sctj();
			sctj.settitles(rs.getString("title"));
			sctj.setcontents(rs.getString("contents"));
			show1.add(sctj);
		}
		if(table.equalsIgnoreCase("SCTJ"))
		{
			tables="生产统计";
		}
		else if(table.equalsIgnoreCase("JJXY"))
		{
			tables="经济效益";
		}
		else if(table.equalsIgnoreCase("JCKTJ"))
		{
			tables="进出口统计";
		}
		else if(table.equalsIgnoreCase("ZHTJ"))
		{
			tables="综合统计";
		}
		request.setAttribute("kind",table);
		request.setAttribute("id",String.valueOf(id));
		request.setAttribute("tables",tables);
		request.setAttribute("show1",show1);
		
		return mapping.findForward("Success"); 
	}

}