可以使用以下代码将查询结果存储到变量中:
SQLiteDatabase db = dbHelper.getReadableDatabase(); Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_NAME, null); if (cursor.moveToFirst()) { do { int id = cursor.getInt(cursor.getColumnIndexOrThrow("_id")); String name = cursor.getString(cursor.getColumnIndexOrThrow("name")); int age = cursor.getInt(cursor.getColumnIndexOrThrow("age")); //将查询结果存储到变量中 //... } while (cursor.moveToNext()); } cursor.close();
其中,dbHelper是一个SqliteOpenHelper的实例,TABLE_NAME是表名,"_id"、"name"、"age"等为表中的列名。通过Cursor对象遍历查询结果,并将需要的列存储到变量中即可。