grjldao.java

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

package javabean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import java.util.ArrayList;
import java.util.Vector;

import struts.form.*;
import javabean.CodeString;

public class GrjlDAO {
	
	private static Connection con;
	
	public GrjlDAO(Connection con)
	{
		this.con=con;
	}

    public void create(Grjl grjl,String photo) throws CreateException{
    	
    	PreparedStatement ps=null;
		ResultSet rs=null;
    	String sqlmax="select max(ID) as n from GRJL";
    	String sql="INSERT INTO GRJL VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
      
        try
        {
        	if(con.isClosed())
        	{
        		throw new IllegalStateException("error.unexpected");    
        	}
			ps=con.prepareStatement(sqlmax);
			rs=ps.executeQuery();
			int Id=0;			
			
			while(rs.next())
			{
				Id=rs.getInt("n");
				Id=Id+1;
			}
			//出生日期处理
			CodeString getstring=new CodeString();
			String bothday=getstring.getString(grjl.getBORNDATEYEAR())+'年'+getstring.getString(grjl.getBORNDATEMON())+'月';
			//发布日期处理
			PubDate pubDate=new PubDate();
			String pbdate=pubDate.getshortPubdate();			
        	//换行处理
        	TextareaChange change=new TextareaChange();
        	String studylist=getstring.getString(change.changeArea(grjl.getSTUDYLIST()));
            String worklist=getstring.getString(change.changeArea(grjl.getWORKLIST()));
            String spec=getstring.getString(change.changeArea(grjl.getSPEC()));
            String memo=getstring.getString(change.changeArea(grjl.getMEMO()));
            //图片处理
                        
			ps=con.prepareStatement(sql);
			ps.setInt(1,Id);
			ps.setString(2,getstring.getString(grjl.getUUID()));
			ps.setString(3,grjl.getREALNAME());
			ps.setString(4,getstring.getString(grjl.getSEX()));
			ps.setString(5,getstring.getString(grjl.getSCHOOLNAME()));
			ps.setString(6,getstring.getString(grjl.getCLASS()));
			ps.setString(7,getstring.getString(grjl.getGRADE()));
			ps.setString(8,getstring.getString(grjl.getLANG()));
			ps.setString(9,getstring.getString(grjl.getWORKTIME()));
			ps.setString(10,getstring.getString(grjl.getEMAIL()));
			ps.setString(11,getstring.getString(grjl.getPHONE()));
			ps.setString(12,getstring.getString(grjl.getMOB()));
			ps.setString(13,bothday);
			ps.setString(14,getstring.getString(grjl.getCARDNO()));
			ps.setString(15,getstring.getString(grjl.getPROVINCE()));
			ps.setString(16,getstring.getString(grjl.getCITY()));
			ps.setString(17,getstring.getString(grjl.getADDR()));
			ps.setString(18,getstring.getString(grjl.getZIP()));
			ps.setString(19,studylist);
			ps.setString(20,worklist);
			ps.setString(21,spec);
			ps.setString(22,getstring.getString(grjl.getJOBTYPE()));
			ps.setString(23,getstring.getString(grjl.getJOBNAME()));
			ps.setString(24,getstring.getString(grjl.getJOBAREA()));
			ps.setString(25,getstring.getString(grjl.getJOBMONEY()));
			ps.setString(26,memo);
			ps.setString(27,pbdate);
			ps.setInt(28,0);
			ps.setString(29,photo);
						
			if(ps.executeUpdate()!=1)
			{
				throw new CreateException("error.create.attraction");
			}
        }
        catch(SQLException e)
        {
        	/*try{
        		findByPrimaryKey(attraction.getUserId());
        	}catch(FinderException fe){
        		fe.printStackTrace();
        		throw new RuntimeException("error.unexpected");
        	}*/
        	throw new DuplicateKeyException("error.duplicate.attraction");
        }
        finally
        {
        	try
        	{
        		if(ps!=null)  ps.close();
        	}
        	catch(SQLException e)
        	{
        		e.printStackTrace();
				throw new RuntimeException("error.unexpected");
        	}
        }       
    }
   
   
	public void update(String sql) throws CreateException{
    	
		PreparedStatement ps=null;
   
		try
		{
			if(con.isClosed())
			{
				throw new IllegalStateException("error.unexpected");    
			}        	
			ps=con.prepareStatement(sql);        				
			if(ps.executeUpdate()!=1)
			{
				throw new CreateException("error.create.attraction");
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
			throw new RuntimeException("error.unexpected");
		}
		finally
		{
			try
			{
				if(ps!=null)  ps.close();
			}
			catch(SQLException e)
			{
				e.printStackTrace();
				throw new RuntimeException("error.unexpected");
			}
		}       
	}  
   
	public static Grjl findByPrimaryKey(int Id)
		throws FinderException{
    	
		PreparedStatement ps=null;
		ResultSet rs=null;
		Grjl grjl=null;		
		String sql="SELECT * from GRJL WHERE ID=?";		
		try
		{
			if(con.isClosed())
			{
				throw new IllegalStateException("error.unexpected");    
			}			
			ps=con.prepareStatement(sql);
			ps.setInt(1,Id);
			rs=ps.executeQuery();			
			if(rs.next())
			{				
				grjl=new Grjl();
				grjl.setID(rs.getInt(1));		
				grjl.setUUID(rs.getString(2));	
				grjl.setREALNAME(rs.getString(3));	
				grjl.setSEX(rs.getString(4));	
				grjl.setSCHOOLNAME(rs.getString(5));	
				grjl.setCLASS(rs.getString(6));
				grjl.setGRADE(rs.getString(7));
				grjl.setLANG(rs.getString(8));
				grjl.setWORKTIME(rs.getString(9));
				grjl.setEMAIL(rs.getString(10));
				grjl.setPHONE(rs.getString(11));
				grjl.setMOB(rs.getString(12));
				grjl.setBORNDATE(rs.getString(13));		
				grjl.setCARDNO(rs.getString(14));	
				grjl.setPROVINCE(rs.getString(15));	
				grjl.setCITY(rs.getString(16));	
				grjl.setADDR(rs.getString(17));	
				grjl.setZIP(rs.getString(18));
				grjl.setSTUDYLIST(rs.getString(19));
				grjl.setWORKLIST(rs.getString(20));
				grjl.setSPEC(rs.getString(21));
				grjl.setJOBTYPE(rs.getString(22));
				grjl.setJOBNAME(rs.getString(23));
				grjl.setJOBAREA(rs.getString(24));										
				grjl.setJOBMONEY(rs.getString(25));
				grjl.setMEMO(rs.getString(26));
				grjl.setFBTIME(rs.getString(27));
				grjl.setCLICKNUM(rs.getInt(28));
				grjl.setPHOTOPATH(rs.getString(29).trim());
				return grjl;
			}
			else
			{
				throw new ObjectNotFoundException("error.removed.attraction");
			}
      
		}
		catch(SQLException e)
		{
		    e.printStackTrace();
		    throw new RuntimeException("error.unexpected");
		} 
		finally
		{
			try
			{
			    if(ps!=null)  ps.close();
			    if(rs!=null)  rs.close();
			}
			catch(SQLException e)
			{
			    e.printStackTrace();
			    throw new RuntimeException("error.unexpected");
		    }
		}
	}
   
	public Collection findAll(String sql){
    	
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList list=new ArrayList();    	   	
		try
		{
			if(con.isClosed())
			{
				throw new IllegalStateException("error.unexpected");
			}
    		
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();   		
			while(rs.next())
			{
				Grjl grjl=new Grjl();
				grjl.setID(rs.getInt(1));		
				grjl.setUUID(rs.getString(2));	
				grjl.setREALNAME(rs.getString(3));	
				grjl.setSEX(rs.getString(4));	
				grjl.setSCHOOLNAME(rs.getString(5));	
				grjl.setCLASS(rs.getString(6));
				grjl.setGRADE(rs.getString(7));
				grjl.setLANG(rs.getString(8));
				grjl.setWORKTIME(rs.getString(9));
				grjl.setEMAIL(rs.getString(10));
				grjl.setPHONE(rs.getString(11));
				grjl.setMOB(rs.getString(12));
				grjl.setBORNDATE(rs.getString(13));		
				grjl.setCARDNO(rs.getString(14));	
				grjl.setPROVINCE(rs.getString(15));	
				grjl.setCITY(rs.getString(16));	
				grjl.setADDR(rs.getString(17));	
				grjl.setZIP(rs.getString(18));
				grjl.setSTUDYLIST(rs.getString(19));
				grjl.setWORKLIST(rs.getString(20));
				grjl.setSPEC(rs.getString(21));
				grjl.setJOBTYPE(rs.getString(22));
				grjl.setJOBNAME(rs.getString(23));
				grjl.setJOBAREA(rs.getString(24));										
				grjl.setJOBMONEY(rs.getString(25));
				grjl.setMEMO(rs.getString(26));
				grjl.setFBTIME(rs.getString(27));
				grjl.setCLICKNUM(rs.getInt(28));
				grjl.setPHOTOPATH(rs.getString(29));
					
				list.add(grjl);					
			}    		
			return list;    		
		}
		catch(SQLException e)
		{
			e.printStackTrace();
			throw new RuntimeException("error.unexpected");
		} 
		finally
		{
			try
			{
			    if(ps!=null)  ps.close();
			    if(rs!=null)  rs.close();
			}
			catch(SQLException e)
			{
			    e.printStackTrace();
			    throw new RuntimeException("error.unexpected");
		    }
		}	
	}
				
	public Vector find_fenye(int code,int pagesize,String str){
    	
		PreparedStatement ps=null;
		ResultSet rs=null;
		Vector vec=new Vector();

		try
		{
			if(con.isClosed())
			{
				throw new IllegalStateException("error.unexpected");
			}
			int count=pagesize;				
			rs=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY).executeQuery(str);
			rs.absolute((code-1)*pagesize+1);
			while(count>0)
			{				 
				Grjl grjl=new Grjl();
				grjl.setID(rs.getInt(1));		
				grjl.setUUID(rs.getString(2));	
				grjl.setREALNAME(rs.getString(3));	
				grjl.setSEX(rs.getString(4));	
				grjl.setSCHOOLNAME(rs.getString(5));	
				grjl.setCLASS(rs.getString(6));
				grjl.setGRADE(rs.getString(7));
				grjl.setLANG(rs.getString(8));
				grjl.setWORKTIME(rs.getString(9));
				grjl.setEMAIL(rs.getString(10));
				grjl.setPHONE(rs.getString(11));
				grjl.setMOB(rs.getString(12));
				grjl.setBORNDATE(rs.getString(13));		
				grjl.setCARDNO(rs.getString(14));	
				grjl.setPROVINCE(rs.getString(15));	
				grjl.setCITY(rs.getString(16));	
				grjl.setADDR(rs.getString(17));	
				grjl.setZIP(rs.getString(18));
				grjl.setSTUDYLIST(rs.getString(19));
				grjl.setWORKLIST(rs.getString(20));
				grjl.setSPEC(rs.getString(21));
				grjl.setJOBTYPE(rs.getString(22));
				grjl.setJOBNAME(rs.getString(23));
				grjl.setJOBAREA(rs.getString(24));										
				grjl.setJOBMONEY(rs.getString(25));
				grjl.setMEMO(rs.getString(26));
				grjl.setFBTIME(rs.getString(27));
				grjl.setCLICKNUM(rs.getInt(28));
				grjl.setPHOTOPATH(rs.getString(29));
					
				vec.add(grjl);
				count--;
				if(!rs.next())
				break;
			}   		
			return vec;    		
		}
		catch(SQLException e)
		{
			e.printStackTrace();
			throw new RuntimeException("error.unexpected");
		} 
		finally
		{
			try
			{
				//if(ps!=null)  ps.close();
				if(rs!=null)  rs.close();
			}
			catch(SQLException e)
			{
				e.printStackTrace();
				throw new RuntimeException("error.unexpected");
			}
		}	
	}  
			
	public int findNum(String str)
		throws FinderException{
    	
		PreparedStatement ps=null;
		ResultSet rs=null;		    
		
		try
		{
			if(con.isClosed())
			{
				throw new IllegalStateException("error.unexpected");    
			}								
			ps=con.prepareStatement(str);
			rs=ps.executeQuery();
			int Id=0;
			
			while(rs.next())
			{
				Id=rs.getInt("N");				
			}				
			return Id;
		}
		catch(SQLException e)
		{
		    e.printStackTrace();
		    throw new RuntimeException("error.unexpected");
		} 
		finally
		{
			try
			{
			    if(ps!=null)  ps.close();
			    if(rs!=null)  rs.close();
			}
			catch(SQLException e)
			{
			    e.printStackTrace();
			    throw new RuntimeException("error.unexpected");
		    }
		}
	}				      
}