1  import java.sql.Connection;

  2  import java.sql.ResultSet;

  3  import java.sql.PreparedStatement;

  4  import java.sql.SQLException;

  5  

  6  /**

  7     A bank consisting of multiple bank accounts.

  8  */

  9  public class Bank

 10  {

 11     /**

 12        Finds a customer with a given number and PIN.

 13        @param customerNumber the customer number

 14        @param pin the personal identification number

 15        @return the matching customer, or null if none found

 16     */

 17     public Customer findCustomer(int customerNumber, int pin)

 18           throws SQLException

 19     {  

 20        Connection conn = SimpleDataSource.getConnection();

 21        try

 22        {

 23           Customer c = null;

 24           PreparedStatement stat = conn.prepareStatement(

 25                 "SELECT * FROM BankCustomer WHERE Customer_Number = ?");

 26           stat.setInt(1, customerNumber);

 27           

 28           ResultSet result = stat.executeQuery();

 29           if (result.next() && pin == result.getInt("PIN")) 

 30              c = new Customer(customerNumber,

 31                    result.getInt("Checking_Account_Number"),

 32                    result.getInt("Savings_Account_Number"));

 33           return c;

 34        }

 35        finally

 36        {

 37           conn.close();

 38        }

 39     }      

 40  }

 41  

 42