Android SQLite rawquery仅返回第一条记录

// 创建SQLiteOpenHelper对象
SQLiteOpenHelper dbHelper = new SQLiteOpenHelper(context, "database_name", null, 1) {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建数据库表
        db.execSQL("CREATE TABLE IF NOT EXISTS table_name (id INTEGER PRIMARY KEY, name TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库表
        db.execSQL("DROP TABLE IF EXISTS table_name");
        onCreate(db);
    }
};

// 获取可读的数据库对象
SQLiteDatabase db = dbHelper.getReadableDatabase();

// 执行查询语句
String query = "SELECT * FROM table_name";
Cursor cursor = db.rawQuery(query, null);

// 遍历查询结果
if (cursor.moveToFirst()) {
    do {
        // 处理每一条记录
        int id = cursor.getInt(cursor.getColumnIndex("id"));
        String name = cursor.getString(cursor.getColumnIndex("name"));
        // 其他操作...
    } while (cursor.moveToNext());
}

// 关闭Cursor和数据库连接
cursor.close();
db.close();