如何从viewpager片段中的sqlite中检索行？

// 步骤1：创建SQLiteOpenHelper子类
public class MyDatabaseHelper extends SQLiteOpenHelper {
    // 定义数据库和表的相关信息
    private static final String DATABASE_NAME = "my_database";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "my_table";
    private static final String COLUMN_ID = "id";
    private static final String COLUMN_NAME = "name";

    // 构造方法
    public MyDatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    // 步骤2：实现onCreate()方法
    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + "(" +
                COLUMN_ID + " INTEGER PRIMARY KEY, " +
                COLUMN_NAME + " TEXT)";
        db.execSQL(createTableQuery);
    }

    // 步骤2：实现onUpgrade()方法
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 处理数据库升级的逻辑
    }
}

// 步骤3：在片段中实例化SQLiteOpenHelper类
MyDatabaseHelper dbHelper = new MyDatabaseHelper(getActivity());
SQLiteDatabase db = dbHelper.getReadableDatabase();

// 步骤4：执行查询操作
String[] columns = {COLUMN_ID, COLUMN_NAME};
String selection = COLUMN_ID + "=?";
String[] selectionArgs = {"1"};
String sortOrder = COLUMN_NAME + " ASC";
Cursor cursor = db.query(TABLE_NAME, columns, selection, selectionArgs, null, null, sortOrder);

// 步骤5：遍历结果集并提取数据
if (cursor != null && cursor.moveToFirst()) {
    do {
        int id = cursor.getInt(cursor.getColumnIndex(COLUMN_ID));
        String name = cursor.getString(cursor.getColumnIndex(COLUMN_NAME));
        // 处理提取到的数据
    } while (cursor.moveToNext());
}

// 步骤6：关闭数据库
if (cursor != null) {
    cursor.close();
}
db.close();