如何在Android中将JSON数组添加到Sqlite数据库中

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.google.gson.Gson;

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_NAME = "data";

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + " (" +
                COLUMN_NAME + " TEXT)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 简化示例，不处理数据库升级
    }

    public void insertJsonArray(JSONArray jsonArray) {
        SQLiteDatabase db = getWritableDatabase();
        Gson gson = new Gson();

        for (int i = 0; i < jsonArray.length(); i++) {
            try {
                JSONObject jsonObject = jsonArray.getJSONObject(i);
                String jsonData = gson.toJson(jsonObject);

                ContentValues values = new ContentValues();
                values.put(COLUMN_NAME, jsonData);

                db.insert(TABLE_NAME, null, values);
            } catch (JSONException e) {
                e.printStackTrace();
            }
        }

        db.close();
    }
}