grjlbo.java

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

package javabean;

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

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

public class GrjlBO {
	
	private static ConnectionPool pool;
	
	public GrjlBO() 
	{
		pool=ConnectionPool.getInstance();
	}
	
	public void AddGrjl(Grjl grjl,String photo)
	throws GrjlException
	{
		validateGrjl(grjl);		
		Connection con=null;		
		try
		{			
			con=pool.getConnection();			
			GrjlDAO grjlDAO=new GrjlDAO(con);
			grjlDAO.create(grjl,photo);			
			con.commit();
		}
		catch(Exception e) 
		{
			try
			{
				if(con!=null)
				{
					con.rollback();
					throw new GrjlException(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 GrjlException{				
		
		Connection con=null;				
		try
		{			
			con=pool.getConnection();			
			GrjlDAO grjlDAO=new GrjlDAO(con);
			grjlDAO.update(sql);			
			con.commit();
		}
		catch(Exception e) 
		{
			try
			{
				if(con!=null)
				{
					con.rollback();
					throw new GrjlException(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 updateGrjl(String sql,Grjl grjl)
	throws GrjlException{
		
		validateGrjl(grjl);				
		Connection con=null;
				
		try
		{			
			con=pool.getConnection();			
			GrjlDAO grjlDAO=new GrjlDAO(con);
			grjlDAO.update(sql);			
			con.commit();
		}
		catch(Exception e) 
		{
			try
			{
				if(con!=null)
				{
					con.rollback();
					throw new GrjlException(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 validateGrjl(Grjl grjl)
	throws GrjlException
	{
		Check check=new Check();
		if(grjl.getREALNAME().trim().equals(""))
		{
			throw new GrjlException("error.missing.realname");
		}
		if(grjl.getSCHOOLNAME().trim().equals(""))
		{
			throw new GrjlException("error.missing.schoolname");
		}
		if(grjl.getEMAIL().trim().equals(""))
		{
			throw new GrjlException("error.missing.email");
		}
		if(check.fenxiEmail(grjl.getEMAIL())!=3)
		{
			throw new GrjlException("error.err.email");
		}
		if(grjl.getPHONE().trim().equals(""))
		{
			throw new GrjlException("error.missing.phone");
		}
		/*if(check.numberchecked(grjl.getPHONE()).equals("false")){
			throw new GrjlException("error.err.phone");
		}*/
		if(grjl.getBORNDATEYEAR().trim().equals(""))
		{
			throw new GrjlException("error.missing.borndateyear");
		}
		if(grjl.getBORNDATEYEAR().trim().length()!=4||grjl.getBORNDATEYEAR().trim().compareTo("1930")<0||grjl.getBORNDATEYEAR().trim().compareTo("2000")>0)
		{
			throw new GrjlException("error.err.borndateyear");
		}
		if(grjl.getCARDNO().trim().equals(""))
		{
			throw new GrjlException("error.missing.cardno");
		}
		/*if(check.numberchecked(grjl.getCARDNO()).equals("false")){
			throw new GrjlException("error.err.cardno");
		}*/
		if(grjl.getZIP().trim().equals(""))
		{
			throw new GrjlException("error.missing.zip");
		}
		if(check.numberchecked(grjl.getZIP()).equals("false"))
		{
			throw new GrjlException("error.err.zip");
		}
		if(grjl.getSTUDYLIST().trim().equals(""))
		{
			throw new GrjlException("error.missing.studylist");
		}
		if(grjl.getWORKLIST().trim().equals(""))
		{
			throw new GrjlException("error.missing.worklist");
		}
		if(grjl.getSPEC().trim().equals(""))
		{
			throw new GrjlException("error.missing.spec");
		}
		if(grjl.getJOBNAME().trim().equals(""))
		{
			throw new GrjlException("error.missing.jobname");
		}
	}
}