Android SQLite OrderBy的使用

最新推荐文章于 2024-03-29 11:25:26 发布

原创最新推荐文章于 2024-03-29 11:25:26 发布 · 8.6k 阅读

3 ·

CC 4.0 BY-SA版权

Android 同时被 2 个专栏收录

45 篇文章

订阅专栏

数据库

5 篇文章

订阅专栏

本文介绍了如何在Android SQLite数据库查询中实现多列排序的方法。通过使用db.query方法，可以指定多个排序字段，并且可以设置升序或降序排列。文章提供了具体的代码示例来展示如何实现这一功能。

Query has two syntax, the syntax you are using, last column represents order by, you just need to specify on what column you want to do orderby +"ASC" (or) orderby +"DESC"

Cursor c = scoreDb.query(DATABASE_TABLE, rank, null, null, null, null, yourColumn+" DESC");

The last parameter in db.query() method is the order by clause (without the "order by"). All you need to do is separate both columns by a ",". So it would look like:

Cursor cursor = db.query(TABLE_SESSION, new String[] {KEY_ID, KEY_MODULE_CODE, 
        KEY_DAY_OF_WEEK, KEY_START_TIME, KEY_DURATION, KEY_SESSION_TYPE, KEY_ROOM},
        null, null, null, null, KEY_DAY_ID + " ASC, " + KEY_START_TIME  + " ASC");

参考：

http://stackoverflow.com/questions/10254163/android-sql-how-do-you-order-your-sql-query-by-multiple-columns

http://stackoverflow.com/questions/8948435/how-do-i-order-my-sqlite-database-in-descending-order-for-an-android-app

http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#query%28boolean,%20java.lang.String,%20java.lang.String%5B%5D,%20java.lang.String,%20java.lang.String%5B%5D,%20java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String%29