office_myfavoriteaction.java

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

/*
 * 
 * @author 郑文金
 *
 * 这个action用于在"网上办公室"中显示个人的收藏夹中的信息
 *
 */
package struts.action;

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.Office_myfavoriteForm;
import javabean.*;
import java.util.Vector;
import java.sql.*;
import javax.servlet.http.HttpSession;

public class Office_myfavoriteAction extends Action {


	private ConnectionPool pool;
	private Connection con;
	public Office_myfavoriteAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
		
	}
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		HttpSession session=request.getSession();
		Vector vec=new Vector();
		CodeString getstring=new CodeString();
		Office_myfavoriteForm myfavoriteForm =(Office_myfavoriteForm) form;
		con=pool.getConnection();  //从池中获得一个连接	
		Favoritedao favoritedao=new Favoritedao(con);
		String kind=myfavoriteForm.getKIND();	
		kind=getstring.getString(kind);	
		
		PageNumber pagenumber=new PageNumber(con);
		int pagesize=5;
		String code=request.getParameter("code");
		if(code==null)
			code="1";
		pagenumber.setPagesize(pagesize);
		String uid=(String)session.getAttribute("uid");
		if(kind.equals(""))
		{
			String s="select * from FAVORITE where UUID= "+"'"+uid+"'"+"order by ID desc";
			pagenumber.setRowcount(s);
			pagenumber.setPagecount();
			vec=favoritedao.query(Integer.parseInt(code),pagesize,s);
			request.setAttribute("vec",vec);
			request.setAttribute("code",code);
			request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
		}
		else
		{
			String s="select * from FAVORITE where KIND= "+"'"+kind+"'"+" and UUID= "+"'"+uid+"'"+"order by ID desc";
			pagenumber.setRowcount(s);
			pagenumber.setPagecount();
			vec=favoritedao.query(Integer.parseInt(code),pagesize,s);
			request.setAttribute("vec",vec);
			request.setAttribute("code",code);
			request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
		}
		con.commit();
		if(con!=null)
		{
			con.close();
		}
		return (mapping.findForward("office_myfavorite"));			
		

	}

}