rczx_zwxx_desc_action.java

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

package struts.action;

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 org.apache.struts.action.ActionError;
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 javabean.*;
import struts.form.*;

public class rczx_zwxx_desc_action extends Action{
//	初始化连接池
	private ConnectionPool pool;
	
		public rczx_zwxx_desc_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{
//					获得要查询的职位ID和UUID										
					int Id=Integer.parseInt(request.getParameter("Id"));
					String user=request.getParameter("UUID");
										
//                  !--修改职位点击数-->					
					ZwxxBO zwxxBO=new ZwxxBO();
					String sql="UPDATE ZWXX SET CLICKNUM=CLICKNUM+1 where ID="+"'"+Id+"'";
					zwxxBO.update(sql);
					
//                  从连接池中获得一个连接
					con=pool.getConnection();
//					!--查询职位：分别查询公司和职位-->									
					ZwxxDAO zwxxDAO=new ZwxxDAO(con);
					Zwxx zwxx=ZwxxDAO.findByPrimaryKey(Id);
					CorporationDAO corporationDAO=new CorporationDAO(con);
					Corporation corporation=CorporationDAO.findByPrimaryKey(user);
					request.setAttribute(BeanNames.ZWXX_FORM,zwxx);
					request.setAttribute(BeanNames.CORPORATION_FORM,corporation);
//					释放连接					
					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());
			}
}