zwxxbo.java

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

package javabean;

import java.sql.SQLException;
import java.sql.Connection;

import struts.form.*;
import javabean.ZwxxDAO;
import javabean.ConnectionPool;

public class ZwxxBO {
	
	private static ConnectionPool pool;
	
	public ZwxxBO() {
		pool=ConnectionPool.getInstance();
	}
	
	public static void AddZwxx(Zwxx zwxx)
	throws ZwxxException{
		
		validateZwxx(zwxx);		
		Connection con=null;		
		try
		{			
			con=pool.getConnection();			
			ZwxxDAO zwxxDAO=new ZwxxDAO(con);
			zwxxDAO.create(zwxx);			
			con.commit();
		}
		catch(Exception e) 
		{
			try
			{
				if(con!=null)
				{
					con.rollback();
					throw new ZwxxException(e.getMessage());
				}
			}
			catch(SQLException sqle)
			{
				e.printStackTrace();
				throw new RuntimeException("error.unexpected");
			}
		}
		finally
		{
		    try
		    {
			    if(con!=null)  con.close();
		    }
		    catch(SQLException sqle)
		    {
			    sqle.printStackTrace();
			    throw new RuntimeException("error.unexpected");
		    }
	    }		
	}
		
	public void update(String sql)
	throws ZwxxException{
						
		Connection con=null;				
		try
		{			
			con=pool.getConnection();			
			ZwxxDAO zwxxDAO=new ZwxxDAO(con);
			zwxxDAO.update(sql);			
			con.commit();
		}
		catch(Exception e) 
		{
			try
			{
				if(con!=null)
				{
					con.rollback();
					throw new ZwxxException(e.getMessage());
				}
			}
			catch(SQLException sqle)
			{
				e.printStackTrace();
				throw new RuntimeException("error.unexpected");
			}
		}
		finally
		{
		    try
		    {
			    if(con!=null)  con.close();
		    }
		    catch(SQLException sqle)
		    {
			    sqle.printStackTrace();
			    throw new RuntimeException("error.unexpected");
		    }
	    }		
	}
		
	public void updateZwxx(String sql,Zwxx zwxx)
	throws ZwxxException{
		
		validateZwxx(zwxx);				
		Connection con=null;				
		try{			
			con=pool.getConnection();			
			ZwxxDAO zwxxDAO=new ZwxxDAO(con);
			zwxxDAO.update(sql);			
			con.commit();
		}
		catch(Exception e) 
		{
			try
			{
				if(con!=null)
				{
					con.rollback();
					throw new ZwxxException(e.getMessage());
				}
			}
			catch(SQLException sqle)
			{
				e.printStackTrace();
				throw new RuntimeException("error.unexpected");
			}
		}
		finally
		{
		    try
		    {
			    if(con!=null)  con.close();
		    }
		    catch(SQLException sqle)
		    {
			    sqle.printStackTrace();
			    throw new RuntimeException("error.unexpected");
		    }
	    }		
	}
		
	private static void validateZwxx(Zwxx zwxx)
	throws ZwxxException{
		
		Check check=new Check();
		if(zwxx.getJOBCATE().trim().equals(""))
		{
			throw new ZwxxException("error.missing.jobcate");
		}		
		if(zwxx.getJOBNAME().trim().equals(""))
		{
			throw new ZwxxException("error.missing.jobname");
		}
		if(!(zwxx.getJOBNUM()>0))
		{
			throw new ZwxxException("error.err.jobnum");
		}
		if(zwxx.getWORKMODE().trim().equals(""))
		{
			throw new ZwxxException("error.missing.workmode");
		}
		if(zwxx.getSEX().trim().equals(""))
		{
			throw new ZwxxException("error.missing.sex");
		}
		if(zwxx.getGRADE().trim().equals(""))
		{
			throw new ZwxxException("error.missing.grade");
		}
		if(zwxx.getWORKTIME().trim().equals(""))
		{
			throw new ZwxxException("error.missing.worktime");
		}
		if(zwxx.getVALIDTIME().trim().equals(""))
		{
			throw new ZwxxException("error.missing.validtime");
		}		
	}
}