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