高质量软件开发人员的五大习惯

 
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) {}

    }

 }

}