????????????????????????

 
loadAccountStatus()??????????洢?豸????accountStatus??????????????

public void loadAccountStatus()

                  throws CustomerAccountsSystemOutageException {

 Connection c = null;

 try {

    c = DriverManager.getConnection("databaseUrl"?? "databaseUser"??

                                    "databasePassword");

    PreparedStatement ps = c.prepareStatement(

              "SELECT status FROM customer_account "

            + "WHERE username = ? AND password = ? ");

    ps.setString(1?? this.username);

    ps.setString(2?? this.password);

    ResultSet rs = ps.executeQuery();

    if (rs.next()) {

      this.accountStatus=rs.getString("status");

    }

    rs.close();

    ps.close();

    c.close();

  } catch (SQLException e) {

    throw new CustomerAccountsSystemOutageException(e);

 } finally {

    if (c != null) {

      try {

        c.close();

       } catch (SQLException e) {}

    }

 }

}