GSON解析JSON儲存到資料庫

今天給大家帶來的文章為通過Gson解析json資料并快速儲存至資料庫的文章。我們要儲存是json對象數組，本文中的json數組并非從背景擷取，為了示範，直接手動構造。

需要儲存到資料庫的是手機的品牌和型号。是以，我們需要建立一個bean實體類去儲存我們的型号和品牌。在這，我先介紹2個工具，一個是Google官方的Gson解析jar包。

名為Gson.jar，這個百度下載下傳就可以了。另外一個是序列化插件Parcelable。在setting---->>>>plugin----->搜尋Parcelable。

GSON解析JSON儲存到資料庫

。

好了，下面建立我們的bean，取名DeviceModelBean.Java。添加屬性後，右鍵選擇Generate--->>>Parcelable，然後快速直接序列化，對bean我們最好養成習慣，先序列化。

[java] view plain copy

GSON解析JSON儲存到資料庫

package com.mero.wyt_register.bean;
import android.os.Parcel;
import android.os.Parcelable;
public class DeviceModelBean implements Parcelable {
public String getBrand() {
return brand;
}
public void setBrand(String brand) {
this.brand = brand;
}
public String getModel() {
return model;
}
public void setModel(String model) {
this.model = model;
}
public String model;//型号
public String brand;//品牌
@Override
public int describeContents() {
return 0;
}
@Override
public void writeToParcel(Parcel dest, int flags) {
dest.writeString(this.model);
dest.writeString(this.brand);
}
protected DeviceModelBean(Parcel in) {
this.model = in.readString();
this.brand = in.readString();
}
public static final Parcelable.Creator<DeviceModelBean> CREATOR = new Parcelable.Creator<DeviceModelBean>() {
@Override
public DeviceModelBean createFromParcel(Parcel source) {
return new DeviceModelBean(source);
}
@Override
public DeviceModelBean[] newArray(int size) {
return new DeviceModelBean[size];
}
};
}

接下來，再看看我們的json字元串的内容。這個字元串是我按照預期目的而構造的。

json字元串内容如下：

[java] view plain copy

GSON解析JSON儲存到資料庫

String jsonString = "[{\"brand\":\"華為\",\"model\":\"c8818\"},{\"brand\":\"華為\",\"model\":\"Y635\"}," +
"{\"brand\":\"華為\",\"model\":\"Y635-CL00\"},{\"brand\":\"華為\",\"model\":\"P8 Lite\"},{\"brand\":\"華為\",\"model\":\"榮耀X2\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀Hol-T00\"},{\"brand\":\"華為\",\"model\":\"榮耀3X暢玩版\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀6\"},{\"brand\":\"華為\",\"model\":\"榮耀4C\"},{\"brand\":\"華為\",\"model\":\"榮耀X3更新版\"}," +
"{\"brand\":\"華為\",\"model\":\"C8816\"},{\"brand\":\"華為\",\"model\":\"C8816D\"},{\"brand\":\"華為\",\"model\":\"Mate 7\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4C\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀7\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4C\"},{\"brand\":\"華為\",\"model\":\"榮耀7\"},{\"brand\":\"華為\",\"model\":\"榮耀4A\"}," +
"{\"brand\":\"華為\",\"model\":\"P8\"},{\"brand\":\"華為\",\"model\":\"C2900\"},{\"brand\":\"華為\",\"model\":\"Y320\"}," +
"{\"brand\":\"華為\",\"model\":\"C8815\"},{\"brand\":\"華為\",\"model\":\"Mate\"},{\"brand\":\"華為\",\"model\":\"Y600\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀6 Plus\"},{\"brand\":\"華為\",\"model\":\"C8817L\"},{\"brand\":\"華為\",\"model\":\"G5000\"}," +
"{\"brand\":\"華為\",\"model\":\"C8817E\"},{\"brand:\":\"華為\",\"model\":\"榮耀6X\"},{\"brand\":\"華為\",\"model\":\"P8 Lite\"}," +
"{\"brand\":\"華為\",\"model\":\"Ascend P8\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4X\"},{\"brand\":\"華為\",\"model\":\"G629\"},{\"brand\":\"華為\",\"model\":\"G620\"},{\"brand\":\"華為\",\"model\":\"榮耀X2\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀3C\"},{\"brand\":\"華為\",\"model\":\"榮耀6 Plus\"},{\"brand\":\"華為\",\"model\":\"C2800\"},{\"brand\":\"華為\",\"model\":\"2601\"},{\"brand\":\"華為\",\"model\":\"G610S\"}," +
"{\"brand\":\"華為\",\"model\":\"Ascend G302D\"},{\"brand\":\"華為\",\"model\":\"Ascend G6\"},{\"brand\":\"華為\",\"model\":\"Ascend G6\"},{\"brand\":\"華為\",\"model\":\"T8950N\"}," +
"{\"brand\":\"華為\",\"model\":\"G610\"},{\"brand\":\"華為\",\"model\":\"C8813DQ\"},{\"brand\":\"華為\",\"model\":\"Y618\"},{\"brand\":\"華為\",\"model\":\"G630\"}," +
"{\"brand\":\"華為\",\"model\":\"G521\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4\"}]";

仔細一看，其實就是一些對象數組，每個對象裡面有2個元素，一個品牌，一個型号。

接下來，咱們就需要把這些屬性全部設定到對象數組裡去。

[java] view plain copy

GSON解析JSON儲存到資料庫

java.lang.reflect.Type type = new TypeToken<List<DeviceModelBean>>(){}.getType();
Gson gson = new Gson();
listDeviceModel = gson.fromJson(jsonString,type);

上面三行就可以将我們的json數組設定到List<DeviceModelBean>數組裡去。在這裡說明一下上面的用法，Gson可以通過toJson和fromJson方法分别把對象拆分成json數組和把json數組設定到對象集合中。Type是個接口，位于java.lang.reflect包下。formJson通過傳入json字元串數組和type的接口對象進而設定到對象中去。

接下來，我們應該編寫資料庫幫助類和dao來完成資料庫的操作。首先，我們先建立一個資料庫幫助類DbHelper.java。

[java] view plain copy

GSON解析JSON儲存到資料庫

public class DbHelper extends SQLiteOpenHelper {
private Context context;
private static final String dbName = "bbzs.db";
public DbHelper(Context context){
super(context,dbName,null,1);
this.context = context;
}
//建立表
@Override
public void onCreate(SQLiteDatabase db) {
String sql1 = "create table if not exists device_model_info(id integer primary key AUTOINCREMENT,model varchar(20),brand varchar(20))";
db.execSQL(sql1);
}
//删除資料庫
public void deleteDb(){
context.deleteDatabase(dbName);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}

我們可以通過建立DbHelper對象來建立一個資料庫的執行個體和建立表。

然後我們可以寫我們的Dao。

dao的完整代碼如下：

[java] view plain copy

GSON解析JSON儲存到資料庫

public class DeviceModelDao {
public static final String TAG = "DeviceModelDao";
Context context;
SQLiteDatabase db;
List<DeviceModelBean> listDeviceModel = null;
public DeviceModelDao(Context context){
this.context = context;
}
//Gson解析數組到對象中去
public List<DeviceModelBean> addObjectToList(){
String jsonString = "[{\"brand\":\"華為\",\"model\":\"c8818\"},{\"brand\":\"華為\",\"model\":\"Y635\"}," +
"{\"brand\":\"華為\",\"model\":\"Y635-CL00\"},{\"brand\":\"華為\",\"model\":\"P8 Lite\"},{\"brand\":\"華為\",\"model\":\"榮耀X2\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀Hol-T00\"},{\"brand\":\"華為\",\"model\":\"榮耀3X暢玩版\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀6\"},{\"brand\":\"華為\",\"model\":\"榮耀4C\"},{\"brand\":\"華為\",\"model\":\"榮耀X3更新版\"}," +
"{\"brand\":\"華為\",\"model\":\"C8816\"},{\"brand\":\"華為\",\"model\":\"C8816D\"},{\"brand\":\"華為\",\"model\":\"Mate 7\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4C\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀7\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4C\"},{\"brand\":\"華為\",\"model\":\"榮耀7\"},{\"brand\":\"華為\",\"model\":\"榮耀4A\"}," +
"{\"brand\":\"華為\",\"model\":\"P8\"},{\"brand\":\"華為\",\"model\":\"C2900\"},{\"brand\":\"華為\",\"model\":\"Y320\"}," +
"{\"brand\":\"華為\",\"model\":\"C8815\"},{\"brand\":\"華為\",\"model\":\"Mate\"},{\"brand\":\"華為\",\"model\":\"Y600\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀6 Plus\"},{\"brand\":\"華為\",\"model\":\"C8817L\"},{\"brand\":\"華為\",\"model\":\"G5000\"}," +
"{\"brand\":\"華為\",\"model\":\"C8817E\"},{\"brand:\":\"華為\",\"model\":\"榮耀6X\"},{\"brand\":\"華為\",\"model\":\"P8 Lite\"}," +
"{\"brand\":\"華為\",\"model\":\"Ascend P8\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4X\"},{\"brand\":\"華為\",\"model\":\"G629\"},{\"brand\":\"華為\",\"model\":\"G620\"},{\"brand\":\"華為\",\"model\":\"榮耀X2\"}," +
"{\"brand\":\"華為\",\"model\":\"榮耀3C\"},{\"brand\":\"華為\",\"model\":\"榮耀6 Plus\"},{\"brand\":\"華為\",\"model\":\"C2800\"},{\"brand\":\"華為\",\"model\":\"2601\"},{\"brand\":\"華為\",\"model\":\"G610S\"}," +
"{\"brand\":\"華為\",\"model\":\"Ascend G302D\"},{\"brand\":\"華為\",\"model\":\"Ascend G6\"},{\"brand\":\"華為\",\"model\":\"Ascend G6\"},{\"brand\":\"華為\",\"model\":\"T8950N\"}," +
"{\"brand\":\"華為\",\"model\":\"G610\"},{\"brand\":\"華為\",\"model\":\"C8813DQ\"},{\"brand\":\"華為\",\"model\":\"Y618\"},{\"brand\":\"華為\",\"model\":\"G630\"}," +
"{\"brand\":\"華為\",\"model\":\"G521\"},{\"brand\":\"華為\",\"model\":\"榮耀暢玩4\"}]";
try{
java.lang.reflect.Type type = new TypeToken<List<DeviceModelBean>>(){}.getType();
Gson gson = new Gson();
listDeviceModel = gson.fromJson(jsonString,type);
Log.e("TAG",type+"");
for(Iterator iterator = listDeviceModel.iterator();iterator.hasNext();){
DeviceModelBean bean = (DeviceModelBean) iterator.next();
Log.e(TAG,bean.getModel()+bean.getBrand());
}
}catch (Exception e){
Log.e(TAG,"錯誤："+e.getMessage());
}
return listDeviceModel;
}
//插入資料到資料庫
public void insertModelToDb(List<DeviceModelBean> listDeviceModel){
try{
DbHelper dbHelper = new DbHelper(context);
db = dbHelper.getWritableDatabase();
//開始事務
db.beginTransaction();
Log.e(TAG,listDeviceModel.size()+"");
String sql1 = "insert into device_model_info(id,model,brand) values (?,?,?)";
for(DeviceModelBean f :listDeviceModel){
db.execSQL(sql1,new Object[]{null,f.model,f.brand});
}
}catch (Exception e){
e.printStackTrace();
}finally {
//送出
db.setTransactionSuccessful();
db.endTransaction();
db.close();
}
}
}

建立資料庫的腳本為：

[java] view plain copy

GSON解析JSON儲存到資料庫

create table if not exists device_model_info(id integer primary key AUTOINCREMENT,model varchar(20),brand varchar(20))

執行插入的腳本為：

[java] view plain copy

GSON解析JSON儲存到資料庫

insert into device_model_info(id,model,brand) values (?,?,?)

這裡注意的是第一個為主鍵id，這個必須得加上integer primary key 才會自動生成。另外，主鍵必須為null才可以，否則一直

在代碼中的用法為：

[java] view plain copy

GSON解析JSON儲存到資料庫

//建立資料庫和表
DbHelper dbHelper = new DbHelper(MyApplication.getMyApplication());
//插入資料到資料庫
DeviceModelDao dao = new DeviceModelDao(MyApplication.getMyApplication());
dao.insertModelToDb(dao.addObjectToList());

GSON解析JSON儲存到資料庫

GSON解析JSON儲存到資料庫

繼續閱讀

專訪鄧凡平：深入了解Android

與專家面對面：Android開發入門問與答

Android MVP架構MVCMVP

mvp初探

Android常用工具類簡介目錄

android常用工具類轉載自：http://www.trinea.cn/android/android-common-utils/Android常用工具類

Android常用工具類ToastUtilsSizeUtilsLogUtilsRetrofitManagerAnimUtil

Android Studio 0.8.0解決 Failure [INSTALL_FAILED_OLDER_SDK] 問題

Android – ListView 中添加按鈕，動态删除添加ItemView的操作

Kotlin的ListView與RecyclerView的簡單應用

關于公司的那些坑：Android Studio篇

android SQLite事務和kotlin協程

無法正常編譯錯誤Compilation failed to complete

關于Gradle配置的小結

AOP程式設計_Android優雅權限架構(1)概念基礎，2021金三銀四前言正文大綱正文

Android APK檔案反編譯Android APK檔案反編譯