从片段调用SQLiteOpenHelper方法

// 自定义帮助类
public class DBHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "mydatabase.db";
    private static final int DATABASE_VERSION = 1;

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建数据库表的操作
        String createTableQuery = "CREATE TABLE mytable (id INTEGER PRIMARY KEY, name TEXT)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库的操作
        String dropTableQuery = "DROP TABLE IF EXISTS mytable";
        db.execSQL(dropTableQuery);
        onCreate(db);
    }

    @Override
    public void onOpen(SQLiteDatabase db) {
        super.onOpen(db);
        // 打开数据库的操作
    }
}

// 在片段中调用SQLiteOpenHelper方法
public class MyFragment extends Fragment {
    private DBHelper dbHelper;
    private SQLiteDatabase database;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        dbHelper = new DBHelper(getActivity());
        database = dbHelper.getWritableDatabase(); // 获取可写数据库对象
        // 或者使用以下代码获取只读数据库对象
        // database = dbHelper.getReadableDatabase();
    }

    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
        // 在片段中进行其他操作，如插入、查询、更新和删除等
        return inflater.inflate(R.layout.fragment_layout, container, false);
    }

    @Override
    public void onDestroy() {
        super.onDestroy();
        database.close(); // 关闭数据库连接
    }
}