ylhq1_1action.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 450 行 · 第 1/2 页

				CpgqDAO cpgqDAO=new CpgqDAO(con);
				Collection col=cpgqDAO.findAll(sql);	
				request.setAttribute(BeanNames.CPGQB_LIST,col);
				
				return mapping.findForward("GNJZ");
			}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("DLDQ");
			}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("NJDQ");
			}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("JLDQ");
			}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("涤纶FDY"))
		{
			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("DLFDY");
			}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("涤纶DTY"))
		{
			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("DLDTY");
			}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("涤纶POY"))
		{
			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("DLPOY");
			}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("JLCS");
			}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("ALCS");
			}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("GJMJ");
			}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
		{
			return mapping.findForward("Success");
		}
		
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}