previous | start | next

Case Study: A Bank Database

public Customer find(int customerNumber, int pin)
    throws SQLException
{
   Customer c = null;
   Connection conn = SimpleDataSource.getConnection();
   Statement stat = conn.createStatement();
   ResultSet result = stat.executeQuery("SELECT *"
      + " FROM Customer WHERE Customer_Number = "
      + customerNumber);

   if (result.next() && pin == result.getInt("PIN"))
      c = new Customer(customerNumber,
         result.getInt("Checking_Account_Number"),
         result.getInt("Savings_Account_Number"));
   result.close();
   stat.close();
   conn.close();
   return c;
}


previous | start | next