16m.txt

来自「一本关于JBuilder 应用开发的书籍,希望大家喜欢,其实我没看过的,」· 文本 代码 · 共 43 行

  public Enumeration ejbFindAccountsLargerThan(float balance) throws RemoteException, FinderException
  {
    Connection connection = null;
    PreparedStatement statement = null;
    try
    {
      connection = getConnection();
      statement = connection.prepareStatement("SELECT name FROM Savings_Accounts WHERE balance > ?");
      statement.setFloat(1, balance);
      ResultSet resultSet = statement.executeQuery();
      Vector keys = new Vector();
      while(resultSet.next())
      {
        String name = resultSet.getString(1);
        keys.addElement(new AccountPK(name));
      }
      return keys.elements();
    }
    catch(SQLException e)
    {
      throw new RemoteException("Could not findAccountsLargerThan: " + balance, e);
    }
    finally
    {
      try
      {
        if (statement != null)
        {
          statement.close();
        }
        if (connection != null)
        {
          connection.close();
        }
      }
      catch (SQLException sqe)
      {
        throw new RemoteException("Could not findAccountsLargerThan: " + balance, sqe);
      }
    }
  }