rczx_grjl_mulidesc_action.java

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

package struts.action;

import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionErrors;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Vector;

import javabean.*;
import struts.form.*;

public class rczx_grjl_mulidesc_action extends Action{
//	初始化连接池	
	private ConnectionPool pool;
	
	public rczx_grjl_mulidesc_action()
	{
//		从连接池中获得一个连接池实例			
		pool=ConnectionPool.getInstance();
	}

	public ActionForward  execute (
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws IOException,ServletException,SQLException 
		{
			Connection con=null;
			ActionErrors errors=new ActionErrors();
			
			try
			{
				Vector vec=new Vector();
				String[] recruit_no=request.getParameterValues("recruit_no");					
//              !--修改点击数-->
				GrjlBO grjlBO=new GrjlBO();
				for(int i=0;i<recruit_no.length;i++)
				{
					int Id=Integer.parseInt(recruit_no[i]);						
					String sql="UPDATE GRJL SET CLICKNUM=CLICKNUM+1 where ID="+"'"+Id+"'";
					grjlBO.update(sql);		 	
				}										
//				从连接池中获得一个连接
				con=pool.getConnection();
//				!--查询个人简历-->								
				GrjlDAO grjlDAO=new GrjlDAO(con);
				for(int i=0;i<recruit_no.length;i++)
				{
					int Id=Integer.parseInt(recruit_no[i]);
					Grjl grjl=GrjlDAO.findByPrimaryKey(Id);
					vec.add(grjl);  		 	
				}									
					request.setAttribute("vec",vec);
//				释放连接
				if(con!=null) con.close();				
				return mapping.findForward("success");
			}
//			捕获一些可能的错误            			
			catch(Throwable e)
			{
				e.printStackTrace();
				ActionError error=new ActionError(e.getMessage());
				errors.add(ActionErrors.GLOBAL_ERROR,error);
			}
//			如果连接未释放，释放连接
			if(con!=null) con.close();
			saveErrors(request,errors);
			return new ActionForward(mapping.getInput());
		}
}