rczx_zwxx_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 struts.form.*;
import javabean.*;

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

		public ActionForward  execute (
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response)
			throws IOException,ServletException, ZwxxException, FinderException, SQLException 
			{			
				Connection con=null;
				ActionErrors errors=new ActionErrors();
				
				try
				{
					Vector vec_zw=new Vector();
					Vector vec_corp=new Vector();					
					String[] recruit_id=request.getParameterValues("recruit_no");
					String[] recruit_uid=request.getParameterValues("recruit_no");					
//                  !--修改点击数-->
					ZwxxBO zwxxBO=new ZwxxBO();
					for(int i=0;i<recruit_id.length;i++)
					{
						int Id=Integer.parseInt(recruit_id[i]);
						String sql="UPDATE ZWXX SET CLICKNUM=CLICKNUM+1 where ID="+"'"+Id+"'";
						zwxxBO.update(sql);		 	
					}															
//					从连接池中获得一个连接
					con=pool.getConnection();
//					!--查询职位信息:分为职位和公司查询两部分-->								
					ZwxxDAO zwxxDAO=new ZwxxDAO(con);
					CorporationDAO corporationDAO=new CorporationDAO(con);
					for(int i=0;i<recruit_id.length;i++)
					{
//						!--查询职位部分-->
						int Id=Integer.parseInt(recruit_id[i]);
						Zwxx zwxx=ZwxxDAO.findByPrimaryKey(Id);
						recruit_uid[i]=zwxx.getUUID();
						vec_zw.add(zwxx);
//						!--查询公司部分-->								
						Corporation corporation=CorporationDAO.findByPrimaryKey(recruit_uid[i]);
						vec_corp.add(corporation);				  		 	
					}
										
					request.setAttribute("vec_zw",vec_zw);	
					request.setAttribute("vec_corp",vec_corp);					
//					释放连接
					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());
			}
}