tjfxaction.java

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

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


public class TjfxAction extends Action {


	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		TjfxForm tjfxForm = (TjfxForm) form;
		
		ResultSet rs;
		dbconnect db=new dbconnect();
		String sql;
		String table=tjfxForm.gettable();
		String contents="";
		String tables="";
		int id=tjfxForm.getid();
		Vector show1=new Vector();
		Vector show2=new Vector();
		
		sql="select title,contents from "+table+" where id='"+id+"'";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Sctj sctj=new Sctj();
			sctj.settitles(rs.getString("title"));
			contents=rs.getString("contents");
			sctj.setcontents(contents);
			show1.add(sctj);
		}
		rs.close();
		
		sql="select content from TJFXTP where id='"+id+"'";
		rs=db.executeQuery(sql);
		while(rs.next())
		{
			Sctj sctj=new Sctj();
			sctj.setcontents(rs.getString("content"));
			show2.add(sctj);
		}
		rs.close();
		
		if(table.equalsIgnoreCase("TJFX"))
		{
			tables="统计分析";
		}
		request.setAttribute("tables",tables);
		request.setAttribute("show2",show2);
		request.setAttribute("show1",show1);
		request.setAttribute("kind",table);
		request.setAttribute("id",String.valueOf(id));
		
		return mapping.findForward("Success"); 
		
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}