fbplaction.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.FbplRs;
import javabean.dbconnect;
import javabean.Shown;

public class FbplAction extends Action {
	
	dbconnect db=new dbconnect();
	Shown show=new Shown();
	Vector vec=new Vector();

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
		{				
			
			int i=1;
			int numPages=5;              //第页显示条数
			int nextPage ;
			int upPage;
			
			String pages = request.getParameter("page") ;
			
			String type=request.getParameter("type");
			String id=request.getParameter("id");
			
			if(type==null||type.equals(""))
			{
				type=(String)request.getAttribute("type");
				id=(String)request.getAttribute("id");			
			}
			
			String sql="select TITLE from "+type+" where ID='"+id+"'";
			ResultSet rs1=db.executeQuery(sql);
			if(rs1.next());
			String title=rs1.getString("TITLE");
			
			int currentPage =(pages==null)?(1):(Integer.parseInt(pages));//当前页
		
			sql = "select count(*) from NEWSTALK where KIND='"+type+"' and TALKID='"+id+"' order by ID DESC";
			ResultSet rs = db.executeQuery(sql) ;
			while(rs.next()) i = rs.getInt(1) ;
		
			int intPageCount=(i%numPages==0)?(i/numPages):(i/numPages+1);//总页数

			if(currentPage>intPageCount) currentPage=intPageCount;
			nextPage = currentPage+1;
			if (nextPage>=intPageCount) nextPage=intPageCount;
			upPage = currentPage-1;
			if (upPage<=1) upPage=1;
			
			
			Vector vec=new Vector();
			FbplRs fbrs=new FbplRs();
						
			sql="select * from NEWSTALK where KIND='"+type+"' and TALKID='"+id+"' order by ID DESC";			
			vec=fbrs.getTitleId(sql,numPages,currentPage);						
			request.setAttribute("vec",vec);
			
			request.setAttribute("currentPage",String.valueOf(currentPage));
			request.setAttribute("intPageCount",String.valueOf(intPageCount));
			request.setAttribute("nextpage",String.valueOf(nextPage));
			request.setAttribute("upPage",String.valueOf(upPage));

			request.setAttribute("type",type);
			request.setAttribute("id",id);
			request.setAttribute("title",title);

			return mapping.findForward("success");
			
		}

}