memberdao.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 struts.form.Member;

public class MemberDAO {
	
	private static Connection con;
	
	public MemberDAO(Connection con)
	{
		this.con=con;
	}
	
	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 Member findByPrimaryKey(String UUID)
	throws FinderException{
    	
		PreparedStatement ps=null;
		ResultSet rs=null;
		Member member=null;
		String uid=UUID;		
		String sql="SELECT * from MEMBER WHERE UUID= '"+uid+"'";		
		try
		{
			if(con.isClosed())
			{
				throw new IllegalStateException("error.unexpected");    
			}			
		    ps=con.prepareStatement(sql);
		    rs=ps.executeQuery();			
		    if(rs.next())
		    {				
			    member=new Member();
			    member.setID(rs.getInt(1));		
			    member.setUUID(rs.getString(2));	
			    member.setPWD(rs.getString(3));	
			    member.setEMAIL(rs.getString(4));	
			    member.setTIMES(rs.getLong(5));	
			    member.setRNAME(rs.getString(6));
			    member.setSEX(rs.getString(7));
			    member.setDATE1(rs.getString(8));
			    member.setUSER_PROVINCE(rs.getString(9));
				member.setUSER_POST_CODE(rs.getString(10));
				member.setUSER_CITY(rs.getString(11));
				member.setUSER_HOMEPH(rs.getString(12));
				member.setUSER_OFFICEPH(rs.getString(13));
				member.setUSER_MOBILEPH(rs.getString(14));
				member.setUSER_ADDRESS(rs.getString(15));
				member.setQUESTION(rs.getString(16));
				member.setANSWER(rs.getString(17));
				member.setHOMEPAGE(rs.getString(18));
				member.setFABU(rs.getLong(19));	
				member.setCOMPANY(rs.getString(20));
				//cpgq.setPHOTO(rs.getString(14));
				return member;
			}
			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())
			{
				Member member=new Member();
				member.setID(rs.getInt(1));		
				member.setUUID(rs.getString(2));	
				member.setPWD(rs.getString(3));	
				member.setEMAIL(rs.getString(4));	
				member.setTIMES(rs.getLong(5));	
				member.setRNAME(rs.getString(6));
				member.setSEX(rs.getString(7));
				member.setDATE1(rs.getString(8));
				member.setUSER_PROVINCE(rs.getString(9));
				member.setUSER_POST_CODE(rs.getString(10));
				member.setUSER_CITY(rs.getString(11));
				member.setUSER_HOMEPH(rs.getString(12));
				member.setUSER_OFFICEPH(rs.getString(13));
				member.setUSER_MOBILEPH(rs.getString(14));
				member.setUSER_ADDRESS(rs.getString(15));
				member.setQUESTION(rs.getString(16));
				member.setANSWER(rs.getString(17));
				member.setCOMPANY(rs.getString(18));
				member.setHOMEPAGE(rs.getString(19));
				member.setFABU(rs.getLong(20));	
				
				list.add(member);
			}    		
			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");
		   }
		}	
	}
}