public Collection<LineUp> getLineUps(Groop grp) throws SQLException
   {
      Collection<LineUp> lineups = new LinkedList<LineUp>();

      // Get a statement and run the query
      String sql = "SELECT LineUp.LineUpNumber, ArtistNumber FROM LineUp,LineUpDetails WHERE LineUp.GroopNumber = ? AND LineUp.LineUpNumber = LineUpDetails.LineUpNumber ORDER BY LineUp.LineUpNumber ASC";
      PreparedStatement ps = Connect.getConnection().getPreparedStatement(sql);
      ps.setInt(1, grp.getNumber());
      ps.execute();
      ResultSet rs = ps.getResultSet();

      LineUp currLineUp = null;
      while (rs.next())
      {
         // Read the info
         int lineUpNumber = rs.getInt(1);
         int artistNumber = rs.getInt(2);

         if (currLineUp == null)
         {
            currLineUp = new LineUp(lineUpNumber, new TreeSet<Artist>(), grp);
            currLineUp.addArtist(GetArtists.create().getArtist(artistNumber));
         }
         else if (currLineUp.getLineUpNumber() != lineUpNumber)
         {
            // Add the line up
            lineups.add(currLineUp);

            // Construct the new line up
            currLineUp = new LineUp(lineUpNumber, new TreeSet<Artist>(), grp);
            currLineUp.addArtist(GetArtists.create().getArtist(artistNumber));
         }
         else
            currLineUp.addArtist(GetArtists.create().getArtist(artistNumber));
      }
      if (currLineUp != null && currLineUp.getArtists().size() > 0)
         lineups.add(currLineUp);

      return lineups;
   }