org/sonews/storage/impl/JDBCDatabase.java
changeset 12 bb6990c0dd1a
parent 3 2fdc9cc89502
child 14 efce4ec25564
     1.1 --- a/org/sonews/storage/impl/JDBCDatabase.java	Wed Jul 22 14:04:05 2009 +0200
     1.2 +++ b/org/sonews/storage/impl/JDBCDatabase.java	Thu Aug 20 14:31:19 2009 +0200
     1.3 @@ -1142,28 +1142,27 @@
     1.4    }
     1.5  
     1.6    @Override
     1.7 -  public String getListForGroup(String group)
     1.8 +  public List<String> getListsForGroup(String group)
     1.9      throws StorageBackendException
    1.10    {
    1.11 -    ResultSet rs = null;
    1.12 +    ResultSet     rs    = null;
    1.13 +    List<String>  lists = new ArrayList<String>();
    1.14  
    1.15      try
    1.16      {
    1.17        this.pstmtGetListForGroup.setString(1, group);
    1.18        rs = this.pstmtGetListForGroup.executeQuery();
    1.19 -      if (rs.next())
    1.20 +
    1.21 +      while(rs.next())
    1.22        {
    1.23 -        return rs.getString(1);
    1.24 +        lists.add(rs.getString(1));
    1.25        }
    1.26 -      else
    1.27 -      {
    1.28 -        return null;
    1.29 -      }
    1.30 +      return lists;
    1.31      }
    1.32      catch(SQLException ex)
    1.33      {
    1.34        restartConnection(ex);
    1.35 -      return getListForGroup(group);
    1.36 +      return getListsForGroup(group);
    1.37      }
    1.38      finally
    1.39      {