java - 如何使用 rawquery 方法在 Android 中使用 SQLite 对行进行排序？

Question

我正在使用以下方法从表中获取数据:

Cursor c = ourDatabase.rawQuery("SELECT " + KEY_SWIMMERLAPS + " * "
  + KEY_SPONSOR + " AS result FROM " + DATABASE_TABLE, null);

我想知道是否可以对其进行编辑以按 KEY_SWIMMERLAPS 对结果进行排序。我认为以下方法可行:

Cursor c = ourDatabase.rawQuery("SELECT " + KEY_SWIMMERLAPS + " * "
  + KEY_SPONSOR + " AS result FROM " + DATABASE_TABLE, KEY_SWIMMERLAPS + " DESC");

但是，我得到一个错误，因为 KEY_SWIMMERLAPS 不是一个字符串:

SQLiteDatabase 类型中的方法 rawQuery(String, String[]) 不适用于参数 (String, String)

Answer 1

您在 rawQuery 方法中使用了第二个参数，并希望用作顺序子句。事实并非如此。第二个参数用于为 SQL 查询字符串中的 ? 占位符提供值。使用以下应该可以解决问题:

Cursor c = ourDatabase.rawQuery("SELECT " + KEY_SWIMMERLAPS + " * "
            + KEY_SPONSOR + " AS result FROM " + DATABASE_TABLE + " ORDER BY "+ KEY_SWIMMERLAPS+" DESC", null);