rczx_zwxx_wh_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 java.util.Collection;

public class rczx_zwxx_wh_action extends Action{
//	初始化连接池	
	private ConnectionPool pool;
		
	public rczx_zwxx_wh_action()
	{
//		从连接池中获得一个连接池实例
		pool=ConnectionPool.getInstance();
	}
	
    public ActionForward  execute (
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response)
			throws IOException,ServletException, ZwxxException, SQLException 
			{
			    Connection con=null;
				ActionErrors errors=new ActionErrors();
				try
				{
					String UUID=request.getParameter("UUID");
//					从连接池中获得一个连接					
					con=pool.getConnection();
					String sql="SELECT ZWXX.ID,ZWXX.UUID,ZWXX.JOBCATE,ZWXX.JOBNAME,ZWXX.JOBNUM,ZWXX.PROVINCE,ZWXX.WORKMODE,ZWXX.WORKMONEY,ZWXX.SEX,ZWXX.GRADE,ZWXX.WORKTIME,ZWXX.AGE,ZWXX.BORNADDR,ZWXX.MEMO,ZWXX.FBTIME,ZWXX.VALIDTIME,ZWXX.CLICKNUM,ZWXX.CLASS,ZWXX.LANG,CORPORATION.CORPNAME FROM ZWXX,CORPORATION WHERE CORPORATION.UUID="+"'"+UUID+"'"+"AND CORPORATION.UUID=ZWXX.UUID";				
					ZwxxDAO zwxxDAO=new ZwxxDAO(con);
					Collection vec=zwxxDAO.findAll(sql);
					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());
			}
}