本文整理匯總了Java中android.arch.persistence.room.Query類的典型用法代碼示例。如果您正苦於以下問題：Java Query類的具體用法？Java Query怎麽用？Java Query使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。
Query類屬於android.arch.persistence.room包，在下文中一共展示了Query類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: findLoansByNameAfter
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT Loan.id, Book.title as title, User.name as name, Loan.startTime, Loan.endTime " +
"FROM Book " +
"INNER JOIN Loan ON Loan.book_id = Book.id " +
"INNER JOIN User on User.id = Loan.user_id " +
"WHERE User.name LIKE :userName " +
"AND Loan.endTime > :after "
)
LiveData<List<LoanWithUserAndBook>> findLoansByNameAfter(String userName, Date after);
示例2: join
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("select PhysicalCategory.id, PhysicalCategory.categoryName, PhysicalCategory.intensity, PhysicalCategory.isFavorite, CategoryData.duration " +
"from PhysicalCategory " +
"left join (select PhysicalEntry.duration, PhysicalEntry.categoryId " +
"from PhysicalEntry where PhysicalEntry.date = " +
"(select currentViewDate from ParamRecord limit 1)) " +
"as CategoryData " +
"on PhysicalCategory.id = CategoryData.categoryId ")
LiveData<List<PhysicalData>> getToday();
示例3: getAll
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM station")
List<Station> getAll();
示例4: getAllByNameFancy
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM station WHERE name_fancy LIKE :nameFancy OR name_fancy LIKE :nameFancy2")
List<Station> getAllByNameFancy(String nameFancy, String nameFancy2);
示例5: selectAll
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM user")
List<User> selectAll();
示例6: delete
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("DELETE FROM User")
void delete();
示例7: getAllArticlesByOldToNew
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("select * from Article ORDER BY TIMESTAMP ASC")
public Flowable<List<Article>> getAllArticlesByOldToNew();
示例8: getDocumentMetadata
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT " + COLUMN_ID + ", " +COLUMN_NAME + ", " + COLUMN_WORKING_TIME +
", " + COLUMN_LAST_EDITION_TIME + ", " + COLUMN_WORDS + ", " + COLUMN_FAVORITE +
", " + COLUMN_COVER_COLOR + ", " + COLUMN_COVER_IMAGE + " FROM " + TABLE_NAME +
" WHERE " + COLUMN_ID + " = :docId")
DocumentMetadata getDocumentMetadata(long docId);
示例9: getAll
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT account_name FROM eos_account WHERE account_name like :nameStarts ORDER BY account_name")
List<String> getAll(String nameStarts);
示例10: loadAllPastFloors
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM " + VisitedFloor.TABLE)
List<VisitedFloor> loadAllPastFloors();
示例11: deleteAll
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("DELETE FROM word_table")
void deleteAll();
示例12: getAll
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM feedEntrys")
LiveData<List<FeedEntry>> getAll();
示例13: findByUid
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM feedEntrys WHERE uid = :uid LIMIT 1")
LiveData<FeedEntry> findByUid(int uid);
示例14: findByText
import android.arch.persistence.room.Query; //導入依賴的package包/類
@Query("SELECT * FROM TimeEntry WHERE description LIKE'%'||:text||'%'")
List<TimeEntry> findByText(String text);
示例15: loadContributors
import android.arch.persistence.room.Query; //導入依賴的package包/類
@SuppressWarnings(RoomWarnings.CURSOR_MISMATCH)
@Query("SELECT login, avatarUrl,repoName, repoOwner, contributions FROM contributor "
+ "WHERE repoName = :name AND repoOwner = :owner "
+ "ORDER BY contributions DESC")
public abstract LiveData<List<Contributor>> loadContributors(String owner, String name);