解析JSON存到数据库

最新推荐文章于 2025-07-03 08:21:34 发布

原创最新推荐文章于 2025-07-03 08:21:34 发布 · 1w 阅读

CC 4.0 BY-SA版权

这篇博客介绍了如何在Android应用中将JSON数据存入SQLite数据库。首先展示了一个`MainActivity`，接着创建了一个继承自`SQLiteOpenHelper`的`Demo`类用于初始化数据库。在`onCreate`方法中创建了名为`Rikao`的表，包含`id`和`title`两个字段。然后定义了一个`Dao`类，包含`add`方法，用于向数据库插入数据。该方法通过`ContentValues`设置字段并调用`db.insert`来完成添加操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//主页面

public class MainActivity extends AppCompatActivity {

    private Dao dao;
    Bean bean;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        dao = new Dao(this);
    }
public void Button(View view){
    jiexi("http://japi.juhe.cn/health_knowledge/infoList?key=d2e173f79187d521231467d23c7dfb81");
}
public void jiexi(String path){
    new AsyncTask<String,Void,String>(){
        @Override
        protected void onPostExecute(String s) {
            super.onPostExecute(s);
            if(s != null){
                Gson gson = new Gson();
                bean = gson.fromJson(s, Bean.class);
                List<Bean.ResultBean.DataBean> list = bean.getResult().getData();
                for (Bean.ResultBean.DataBean bean: list) {
                    String title = bean.getTitle();
                    dao.add(title);
                }
            }
        }
        @Override
        protected String doInBackground(String... params) {
            try {
                String path = params[0];
                URL url = new URL(path);
                HttpURLConnection connection = (HttpURLConnection) url.openConnection();
                connection.setRequestMethod("GET");
                connection.setReadTimeout(5000);
                connection.setConnectTimeout(5000);
                int code = connection.getResponseCode();
                if(code == HttpURLConnection.HTTP_OK){
                    InputStream is = connection.getInputStream();
                    String json = Utils.read(is);
                    System.out.println("----------------"+json);
                    return json;
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
            return null;
        }
    }.execute(path);

}

//创建数据库（继承SQLiteOpenHelper）

public class Demo extends SQLiteOpenHelper {
    public Demo(Context context){
        super(context,"day_14",null,1);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table Rikao(id Integer primary key autoincrement,title varchar(20))");
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

//添加的方法

public class Dao {
    private final SQLiteDatabase db;
    public Dao(Context context){
        Demo demo = new Demo(context);
        db = demo.getWritableDatabase();
    }
    public boolean add(String title){
        ContentValues values = new ContentValues();
        values.put("name",title);
        long l = db.insert("Rikao", null, values);
        if(l != -1){
            return true;
        }else{
            return false;
        }
    }
}