showtitle_suggestaction.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (系统找不到指定的路径。))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.*;

import java.util.*;

import javabean.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

/** 
 * ShowTitleAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 09-25-2004
 * 
 * XDoclet definition:
 * @struts:action validate="true"
 * @struts:action-forward name="/showtitle.jsp" path="/showtitle.jsp"
 */
public class ShowTitle_suggestAction 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 {
		HttpSession session=request.getSession();
		if(!(session.getAttribute("backflag").equals("7") || session.getAttribute("backflag").equals("1")))
		{
			return mapping.findForward("hong");
		}
		int pagesize=10;
		Vector vec=new Vector();
		ConnectionPool pool=null;
		pool=ConnectionPool.getInstance();
		Connection con=null;
		try
		{
			con=pool.getConnection();
						
				
							
		}catch(SQLException e){}
		Database_suggest DBase=new Database_suggest(con);
		PageNumber_suggest pagenumber=new PageNumber_suggest(con);
		String delete;
		delete=request.getParameter("delete");
		if(delete!=null)
		{	int id=Integer.parseInt(delete);
			String del="delete from HYJY where id="+id;
			DBase.Delete(del);
		}
		String code;
		code=request.getParameter("code");
		if(code==null)
			code=(String)request.getAttribute("code");
		if(code==null)
			code="1";	
		String show;
		String str1;
		String str;
		show=request.getParameter("show");
		if(show==null)
			show=(String)request.getAttribute("show");
		if(show==null)
			show="true";
		if(show.equals("false"))
		{	
			str1="select * from HYJY where flag='false'";
			str="select * from HYJY where flag='false' order by id";
		}
		else
		{
			str1="select * from HYJY";
			str="select id,uuid,pubdate,title,flag from HYJY order by id";
		}
		pagenumber.setPagesize(pagesize);
		
		pagenumber.setRowcount(str1);
		pagenumber.setPagecount();
		
		vec=DBase.getData(Integer.parseInt(code),pagesize,str);
		request.setAttribute("vec",vec);
		request.setAttribute("code",code);
		request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
		request.setAttribute("show",show);
		try
		{
			if(con!=null) 
			con.close();
		}catch(SQLException e){}
		return(mapping.findForward("success"));
	}

}