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

import javabean.*;

public class rczx_index_action extends Action{
//	初始化连接池	
	private ConnectionPool pool;
	
		public rczx_index_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
				{
					Date_before_n date_n=new Date_before_n();
					String time=date_n.nDate(7);
				
//                  !--查询职位信息--> 
					con=pool.getConnection();
					String zsql="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=ZWXX.UUID";
					ZwxxDAO zwxxDAO=new ZwxxDAO(con);
					Collection zcol=zwxxDAO.findAll(zsql);		
					request.setAttribute(BeanNames.ZWXX_LIST,zcol);
				
//	                !--查询简历信息--> 
					String csql="SELECT * FROM GRJL ";
					GrjlDAO grjlDAO=new GrjlDAO(con);
					Collection ccol=grjlDAO.findAll(csql);
					request.setAttribute(BeanNames.GRJL_LIST,ccol);
					
//                  !--查询职位数信息--> 
					String nzwsql="SELECT COUNT(ID) as N FROM ZWXX";
					String nzw=String.valueOf(zwxxDAO.findNum(nzwsql));
					request.setAttribute("NZW",nzw);
					
//                  !--查询新增职位数信息--> 
					String new_nzwsql="SELECT COUNT(ID) as N FROM ZWXX WHERE FBTIME>"+"'"+time+"'";
					String new_nzw=String.valueOf(zwxxDAO.findNum(new_nzwsql));
					request.setAttribute("NEW_NZW",new_nzw);

//                  !--查询简历数信息--> 
					String njlsql="SELECT COUNT(ID) as N FROM GRJL";
					String njl=String.valueOf(grjlDAO.findNum(njlsql));
					request.setAttribute("NJL",njl);
					
//                  !--查询新增简历数信息--> 
					String new_njlsql="SELECT COUNT(ID) as N FROM GRJL WHERE FBTIME>"+"'"+time+"'";
					String new_njl=String.valueOf(grjlDAO.findNum(new_njlsql));
					request.setAttribute("NEW_NJL",new_njl);
					
//                  !--查询公司数信息--> 
					String ncorpsql="SELECT COUNT(ID) as N FROM CORPORATION";
					CorporationDAO corpDAO=new CorporationDAO(con);
					String ncorp=String.valueOf(corpDAO.findNum(ncorpsql));
					request.setAttribute("NCORP",ncorp);
					
//                  !--查询新增公司数信息--> 
					String new_ncorpsql="SELECT COUNT(ID) as N FROM CORPORATION WHERE FBTIME>"+"'"+time+"'";
					String new_ncorp=String.valueOf(corpDAO.findNum(new_ncorpsql));
					request.setAttribute("NEW_NCORP",new_ncorp);					

//	                !--查询人才点击数排名--> 
					String toprcsql="SELECT * FROM GRJL ORDER BY CLICKNUM DESC ";
					Collection toprccol=grjlDAO.findAll(toprcsql);
					request.setAttribute("toprc",toprccol);
					
//	                !--查询职位点击数排名-->
					String topzwsql="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=ZWXX.UUID ORDER BY ZWXX.CLICKNUM DESC ";
					Collection topzwcol=zwxxDAO.findAll(topzwsql);
					request.setAttribute("topzw",topzwcol);
//					释放连接
					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());
			}
}