rczx_grjl_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_grjl_desc_action extends Action{
//	初始化连接池
	private ConnectionPool pool;
	
	public rczx_grjl_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
			{
//				!--修改点击数-->
				int Id=Integer.parseInt(request.getParameter("Id"));
				GrjlBO grjlBO=new GrjlBO();
				String sql="UPDATE GRJL SET CLICKNUM=CLICKNUM+1 where ID="+"'"+Id+"'";
				grjlBO.update(sql);
					
//				从连接池中获得一个连接
				con=pool.getConnection();
//				!--查询个人简历-->				
				GrjlDAO grjlDAO=new GrjlDAO(con);
				Grjl grjl=GrjlDAO.findByPrimaryKey(Id);
				
				request.setAttribute(BeanNames.GRJL_FORM,grjl);
//				释放连接
				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());
		}
}