public static ArrayList<Book> queryFilterBooks(ContentResolver resolver, String tag, String key) {
ArrayList<Book> bookList = new ArrayList<Book>();
Book book;
Cursor cursor =
resolver.query(
Uri.parse(DbTags.URI_TABLE_BOOK_INFO), null, tag + "=?", new String[] {key + ""}, null);
while (cursor.moveToNext()) {
book = new Book();
book.setBookId(Integer.parseInt(getFieldContent(cursor, DbTags.FIELD_BOOK_ID)));
book.setBookName(getFieldContent(cursor, DbTags.FIELD_BOOK_NAME));
book.setBookAuthor(getFieldContent(cursor, DbTags.FIELD_BOOK_AUTHOR));
book.setBookPath(getFieldContent(cursor, DbTags.FIELD_BOOK_PATH));
book.setBookAddTime(getFieldContent(cursor, DbTags.FIELD_BOOK_ADD_TIME));
book.setBookOpenTime(getFieldContent(cursor, DbTags.FIELD_BOOK_OPEN_TIME));
book.setBookCategoryId(
Integer.parseInt(getFieldContent(cursor, DbTags.FIELD_BOOK_CATEGORY_ID)));
book.setBookCategroyName(getFieldContent(cursor, DbTags.FIELD_BOOK_CATEGORY_NAME));
book.setBookSize(getFieldContent(cursor, DbTags.FIELD_BOOK_SIZE));
book.setBookProgress(getFieldContent(cursor, DbTags.FIELD_BOOK_PROGRESS));
bookList.add(book);
}
cursor.close();
return bookList;
}
public static Book queryBookFav(ContentResolver resolver, String tag, String key) {
Book book = null;
Cursor cursor =
resolver.query(
Uri.parse(DbTags.URI_TABLE_BOOK_FAV), null, tag + "=?", new String[] {key + ""}, null);
if (cursor.moveToNext()) {
book = new Book();
book.setBookName(getFieldContent(cursor, DbTags.FIELD_BOOK_NAME));
book.setBookPath(getFieldContent(cursor, DbTags.FIELD_BOOK_PATH));
book.setBookAddTime(getFieldContent(cursor, DbTags.FIELD_BOOK_ADD_TIME));
book.setBookSize(getFieldContent(cursor, DbTags.FIELD_BOOK_SIZE));
}
cursor.close();
return book;
}
public static ArrayList<Book> queryBooksFav(ContentResolver resolver) {
ArrayList<Book> bookList = new ArrayList<Book>();
Book book;
Cursor cursor = resolver.query(Uri.parse(DbTags.URI_TABLE_BOOK_FAV), null, null, null, null);
while (cursor.moveToNext()) {
book = new Book();
book.setBookName(getFieldContent(cursor, DbTags.FIELD_BOOK_NAME));
book.setBookPath(getFieldContent(cursor, DbTags.FIELD_BOOK_PATH));
book.setBookAddTime(getFieldContent(cursor, DbTags.FIELD_BOOK_ADD_TIME));
book.setBookSize(getFieldContent(cursor, DbTags.FIELD_BOOK_SIZE));
bookList.add(book);
}
cursor.close();
return bookList;
}