Ejemplo n.º 1
0
  public List<Feed> getFeeds() {
    ArrayList<Feed> feeds = new ArrayList<Feed>();
    try {

      Cursor c =
          db.query(
              FEEDS_TABLE,
              new String[] {"feed_id", "title", "shorttitle", "url", "count", "unread"},
              null,
              null,
              null,
              null,
              null);

      int numRows = c.getCount();
      c.moveToFirst();
      for (int i = 0; i < numRows; ++i) {
        Feed feed = new Feed();
        feed.feedId = c.getLong(0);
        feed.title = c.getString(1);
        feed.shortTitle = c.getString(2);
        feed.url = c.getString(3);
        feed.count = c.getInt(4);
        feed.unread = c.getInt(5);
        feeds.add(feed);
        c.moveToNext();
      }
      c.close();

    } catch (Exception e) {
    }
    return feeds;
  }