mrgxaction.java

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

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

public class MrgxAction extends Action 
{
	Vector vec=new Vector();

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
				
		ShowAtt show=new ShowAtt();
		
		Vector vec1=new Vector();			    
		String sql1="select * from FZDTB where PUBDATE=(select max( PUBDATE) from  FZDTB) order by ID DESC";	
		vec1=show.getTitleId(sql1);   
		request.setAttribute("vec1",vec1);
		
		Vector vec2=new Vector();			    
		String sql2="select * from FZKJB where PUBDATE=(select max( PUBDATE) from  FZKJB) order by ID DESC";	
		vec2=show.getTitleId(sql2);   
		request.setAttribute("vec2",vec2);
		
		Vector vec3=new Vector();			    
		String sql3="select * from HQDTB where PUBDATE=(select max( PUBDATE) from  HQDTB) order by ID DESC";	
		vec3=show.getTitleId(sql3);   
		request.setAttribute("vec3",vec3);
		
		Vector vec4=new Vector();			    
		String sql4="select * from TJFX where PUBDATE=(select max( PUBDATE) from  TJFX) order by ID DESC";	
		vec4=show.getTitleId(sql4);   
		request.setAttribute("vec4",vec4);
		
		return mapping.findForward("success");
	}

}