android把json存入sqlite,android – 如何将Json数据存储到Sqlite中？

我的朋友只是做了以下事情：

>定义此类,该类将执行与数据库创建和操作相关的所有操作,并根据您的需要在此类中进行更改.

DatabaseHandler.java

public class DatabaseHandler extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 1;

private static final String DATABASE_NAME = "Demo";

private static final String TABLE_Demo = "demo";

private static final String KEY_ID = "id";

private static final String KEY_PATIENT_ID= "patientId";

private static final String KEY_ReadingType= "readingType";

private static final String KEY_DeviceMACId= "deviceMACId";

private static final String KEY_DeviceData = "deviceData ";

private static final String KEY_DeviceType= "deviceType";

String CREATE_DEMO_TABLE = "CREATE TABLE " + TABLE_Demo + "("+

KEY_ID + " INTEGER PRIMARY KEY,"+ KEY_ReadingType+ " INTEGER ,"

+ KEY_DeviceMACId + "TEXT,"+ KEY_DeviceData + " TEXT,"

+ KEY_DeviceType + " TEXT" + ")";

public DatabaseHandler(Context context) {

super(context, DATABASE_NAME, null,

}

public void onCreate(SQLiteDatabase db) {

db.execSQL(CREATE_DEMO_TABLE);

}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

db.execSQL("DROP TABLE IF EXISTS " + TABLE_Demo );

onCreate(db);

}

void addJson(JsonObject json) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();

values.put(KEY_PATIENT_ID, json.getString("patientId"));

values.put(KEY_ReadingType,json.getString("readingType"));

values.put(KEY_DeviceMACId, json.getString("deviceMACId"));

values.put(KEY_DeviceData , json.getString("deviceData"));

values.put(KEY_DeviceType, json.getString("deviceType"));

db.insert(TABLE_Demo , null, values);

db.close();

}

}

>现在创建此类的对象并将您的json对象存储到数据库中,如下所示：

DatabaseHandler db = new DatabaseHandler (context);

// context of your activity or fragment

try

{

db.addJson(JsonObject json);

//这里json是你需要保存在数据库中的json对象.        } catch(例外e)          {          }