tjindexaction.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.Tjindex;
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;

/** 
 * TjindexAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-02-2004
 * 
 * XDoclet definition:
 * @struts:action validate="true"
 */
public class TjindexAction 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 {
		
		Vector vector1=new Vector();
		Vector vector2=new Vector();
		Vector vector3=new Vector();
		Vector vector4=new Vector();
		Vector vector5=new Vector();
		ResultSet rs;
		dbconnect db=new dbconnect();
		String sql="";
		
		sql="select TITLE,ID,PUBDATE from SCTJ order by id desc ";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Tjindex tj1=new Tjindex();
			tj1.settitles(rs.getString("TITLE"));
			tj1.setid(rs.getInt("ID"));
			tj1.settimes(rs.getString("PUBDATE"));
			vector1.add(tj1);
		}
		rs.close();
		request.setAttribute("vector1",vector1);
		
		sql="select TITLE,ID,PUBDATE from TJFX order by id desc";//统计分析没有做完！！
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Tjindex tj2=new Tjindex();
			tj2.settitles(rs.getString("TITLE"));
			tj2.setid(rs.getInt("ID"));
			tj2.settimes(rs.getString("PUBDATE"));
			vector5.add(tj2);
		}
		rs.close();
		request.setAttribute("vector5",vector5);
		
		sql="select TITLE,ID,PUBDATE from ZHTJ order by id desc";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Tjindex tj3=new Tjindex();
			tj3.settitles(rs.getString("TITLE"));
			tj3.setid(rs.getInt("ID"));
			tj3.settimes(rs.getString("PUBDATE"));
			vector2.add(tj3);
		}
		rs.close();
		request.setAttribute("vector2",vector2);
		
		sql="select TITLE,ID,PUBDATE from JJXY order by id desc";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Tjindex tj=new Tjindex();
			tj.settitles(rs.getString("TITLE"));
			tj.setid(rs.getInt("ID"));
			tj.settimes(rs.getString("PUBDATE"));
			vector3.add(tj);
		}
		rs.close();
		request.setAttribute("vector3",vector3);
		
		sql="select TITLE,ID,PUBDATE from JCKTJ order by id desc";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Tjindex tj=new Tjindex();
			tj.settitles(rs.getString("TITLE"));
			tj.setid(rs.getInt("ID"));
			tj.settimes(rs.getString("PUBDATE"));
			vector4.add(tj);
		}
		rs.close();
		request.setAttribute("vector4",vector4);
		
		return mapping.findForward("Success");
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}