list_cpgq_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 org.apache.struts.action.ActionServlet;


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

public class List_Cpgq_Action extends Action{
	private ConnectionPool pool;
	
		public List_Cpgq_Action(){
			pool=ConnectionPool.getInstance();
		}

		public ActionForward  execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response)
			throws IOException,ServletException {
			
				Connection con=null;
			
				try{
					con=pool.getConnection();
					String sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND CPGQB.FLAG='true'";
					CpgqDAO cpgqDAO=new CpgqDAO(con);
					Collection col=cpgqDAO.findAll(sql);	
					request.setAttribute(BeanNames.CPGQB_LIST,col);
				
					return mapping.findForward("success");
				}catch(SQLException e){
				e.printStackTrace();
				throw new RuntimeException("error.unexpected");
				} finally{
				   try{
				   if(con!=null) con.close();
				   }catch(SQLException e){
				  throw new RuntimeException(e.getMessage());
				   }
				}
		
		}

	}