如何从SQLite读取选择性数据

Question

我想从SQLite DB中读取存储在id 10到20中的数据。我需要在以下代码中添加/更改什么？

    mNumOneTest = new Vector<Test>();
    DiagnoseTestOpenHelper helper = new DiagnoseTestOpenHelper(
            TestOneTimeTable.this);
    mDb = helper.getReadableDatabase();
    Cursor cursor = mDb.rawQuery("SELECT * FROM TEST;", null);
    if (cursor.getCount() > 0) {
        cursor.moveToFirst();
        do {
            Test test = new Test();
            test.setId(cursor.getInt(0));
            test.setNumber_one(cursor.getInt(1));
            test.setNumber_two(cursor.getInt(2));
            mNumOneTest.add(test);
        } while (cursor.moveToNext());
    }

Answer 1

将SQL更改为SELECT * FROM TEST WHERE id >= 10 AND id <= 20

Answer 2

"SELECT * FROM TEST WHERE id >= 10 AND id <= 20"

Answer 3

SELECT * FROM TEST WHERE id BETWEEN 10 AND 20

Answer 4

我想从SQLite DB中读取存储在id 10中的数据至20。我需要在下面的代码中添加/更改什么？

你需要学习SQL basics，因为这是一个非常"原始"的问题，当你想使用任何数据库、WHERE、LIKE等子句时，你应该知道。

您可以使用between和子句、in子句或仅使用<>=操作数

where id between 10 and 20
where id >= 10 and id <=20