如何使用SQL-lite数据库检索到android studio中的单选按钮组

// 步骤1：创建SQLiteOpenHelper类
public class DBHelper extends SQLiteOpenHelper {
    // 定义数据库名称和版本号
    private static final String DATABASE_NAME = "OptionsDB";
    private static final int DATABASE_VERSION = 1;

    public DBHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // 步骤2：创建数据库表
        String CREATE_TABLE_OPTIONS = "CREATE TABLE Options (id INTEGER PRIMARY KEY, optionText TEXT, isSelected INTEGER)";
        db.execSQL(CREATE_TABLE_OPTIONS);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库版本时的操作，可根据需求进行处理
    }
}

// 步骤3和4：在活动中使用SQLiteOpenHelper和SQLiteDatabase执行检索操作
public class MainActivity extends AppCompatActivity {
    private DBHelper dbHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        dbHelper = new DBHelper(this);

        SQLiteDatabase db = dbHelper.getReadableDatabase();

        // 步骤4：使用SQL语句检索数据
        String selectQuery = "SELECT * FROM Options";
        Cursor cursor = db.rawQuery(selectQuery, null);

        // 步骤5：将检索到的数据加载到单选按钮组中
        RadioGroup radioGroup = findViewById(R.id.radioGroup);

        if (cursor.moveToFirst()) {
            do {
                String optionText = cursor.getString(cursor.getColumnIndex("optionText"));
                int isSelected = cursor.getInt(cursor.getColumnIndex("isSelected"));

                RadioButton radioButton = new RadioButton(this);
                radioButton.setText(optionText);

                if (isSelected == 1) {
                    radioButton.setChecked(true);
                }

                radioGroup.addView(radioButton);
            } while (cursor.moveToNext());
        }

        cursor.close();
        db.close();
    }
}