在AsyncTask中使用SQLite

public class MyAsyncTask extends AsyncTask<Void, Void, Void> {

    private Context context;
    private SQLiteDatabase database;

    public MyAsyncTask(Context context) {
        this.context = context;
    }

    @Override
    protected Void doInBackground(Void... voids) {
        // 执行数据库操作
        MyDatabaseHelper dbHelper = new MyDatabaseHelper(context);
        database = dbHelper.getWritableDatabase();

        // 插入数据
        ContentValues values = new ContentValues();
        values.put("name", "John");
        values.put("age", 25);
        database.insert("users", null, values);

        // 查询数据
        Cursor cursor = database.query("users", null, null, null, null, null, null);
        while (cursor.moveToNext()) {
            String name = cursor.getString(cursor.getColumnIndex("name"));
            int age = cursor.getInt(cursor.getColumnIndex("age"));
            Log.d("MyAsyncTask", "Name: " + name + ", Age: " + age);
        }
        cursor.close();

        return null;
    }

    @Override
    protected void onPostExecute(Void aVoid) {
        // 处理数据库操作结果
        // 更新UI或执行其他操作
    }
}