ylhq1_1action.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (Bad file descriptor))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;

import javabean.BeanNames;
import javabean.ConnectionPool;
import javabean.CpgqDAO;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import struts.form.Ylhq1_1Form;

/** 
 * Ylhq1_1Action.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-17-2004
 * 
 * XDoclet definition:
 * @struts:action path="/ylhq1_1" name="ylhq1_1Form" input="/ylhq1_1.jsp" validate="true"
 * @struts:action-forward name="/YLHQ1_1" path="/YLHQ1_1"
 */
public class Ylhq1_1Action extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods
	private ConnectionPool pool;
	private Connection con;
	public Ylhq1_1Action() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池  
	}
	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
		{
		Ylhq1_1Form ylhq1_1Form = (Ylhq1_1Form) form;
		String names=ylhq1_1Form.getNames();
			names=new String(names.getBytes("ISO-8859-1"));
		
		request.setAttribute("names",names);
		
		if(names.equalsIgnoreCase("电子撮合"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("DZCH");
			}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());
			   }
			}
			
								
		}
		else if(names.equalsIgnoreCase("郑棉期货"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("ZMQH");
			}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());
			   }
			}
		}
		else if(names.equalsIgnoreCase("纽棉期货"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("NMQH");
			}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());
			   }
			}
			
		}
		else if(names.equalsIgnoreCase("中棉指数"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("ZMZS");
			}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());
			   }
			}
			
		}
		else if(names.equalsIgnoreCase("化纤指数"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("HQZS");
			}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());
			   }
			}
			
		}
		else if(names.equalsIgnoreCase("美棉现货"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("MMXH");
			}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());
			   }
			}
			
		}
		else if(names.equalsIgnoreCase("棉交市场"))
		{
			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' order by cpgqb.id desc" ;
				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("MJSC");
			}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());
			   }
			}
			
		}
		else if(names.equalsIgnoreCase("聚酯切片"))
		{
			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' order by cpgqb.id desc" ;