예제 #1
0
  /**
   * Return a Cursor over the list of all todo in the database
   *
   * @return Cursor over all notes
   */
  public List<BookInfo> fetchAllBooks() {

    // createBook(new BookInfo("Agile Estimating and Planning", "Mike Cohn", "Paperback", "Book
    // Description", 324, "2005-08-21", "Prentice Hall", "123455432"));

    List<BookInfo> bookList = new ArrayList<BookInfo>();

    Cursor results = database.query(DATABASE_TABLE, null, null, null, null, null, null);

    results.moveToFirst();
    while (!results.isAfterLast()) {
      BookInfo thisBook = new BookInfo();

      thisBook.setId(results.getInt(0));
      thisBook.setTitle(results.getString(1));
      thisBook.setAuthor(results.getString(2));
      thisBook.setEdition(results.getString(3));
      thisBook.setDescription(results.getString(4));
      thisBook.setPages(new Integer(results.getString(5)));
      thisBook.setReleaseDate(results.getString(6));
      thisBook.setPublisher(results.getString(7));
      thisBook.setIsbn(results.getString(8));

      bookList.add(thisBook);

      results.moveToNext();
    }

    results.close();

    return bookList;
  }
예제 #2
0
  /** Return a Cursor positioned at the defined todo */
  public BookInfo fetchBook(long rowId) throws SQLException {

    Log.d("LOOKUPBOOK", ":::::" + rowId);

    BookInfo thisBook = null;

    Cursor result =
        database.query(
            true,
            DATABASE_TABLE,
            new String[] {
              BookInfo.KEY_ROWID,
              BookInfo.KEY_TITLE,
              BookInfo.KEY_AUTHOR,
              BookInfo.KEY_EDITION,
              BookInfo.KEY_DESCRIPTION,
              BookInfo.KEY_PAGES,
              BookInfo.KEY_RELEASEDATE,
              BookInfo.KEY_PUBLISHER,
              BookInfo.KEY_ISBN
            },
            BookInfo.KEY_ROWID + "=" + rowId,
            null,
            null,
            null,
            null,
            null);

    if (result != null) {
      result.moveToFirst();

      thisBook = new BookInfo();

      thisBook.setId(result.getInt(0));
      thisBook.setTitle(result.getString(1));
      thisBook.setAuthor(result.getString(2));
      thisBook.setEdition(result.getString(3));
      thisBook.setDescription(result.getString(4));
      thisBook.setPages(new Integer(result.getString(5)));
      thisBook.setReleaseDate(result.getString(6));
      thisBook.setPublisher(result.getString(7));
      thisBook.setIsbn(result.getString(8));

      result.close();
    }
    return thisBook;
  }