16g.txt

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

public AccountPK ejbFindByPrimaryKey(AccountPK key)  throws RemoteException, ObjectNotFoundException 
  {
    Connection connection = null;
    PreparedStatement statement = null;
    try 
    {
      connection = getConnection();
      statement = connection.prepareStatement
        ("SELECT name FROM Savings_Accounts WHERE name = ?");
      statement.setString(1, key.name);
      ResultSet resultSet = statement.executeQuery();
      if(!resultSet.next()) 
      {
        throw new ObjectNotFoundException("Could not find: " + key);
      }
      return key;
    }
    catch(SQLException e) 
    {
      throw new RemoteException("Could not find: " + key, e);
    } 
    finally 
    {
      try 
      {
        if (statement != null) 
        {
          statement.close();
        }
        if (connection != null) 
        {
          connection.close();
        }
      } 
      catch (SQLException sqe)
      {
        throw new RemoteException("Could not find: " + key, sqe);
      }
    }
  }