解析并且存入数据库

来源：互联网发布：教课程财务会计软件编辑：程序博客网时间：2024/06/05 09:27

主界面

import android.os.AsyncTask;import android.support.v7.app.AppCompatActivity;import android.os.Bundle;import android.util.Log;import android.view.View;import android.widget.Toast;import com.bwie.day_14.Bean.Bean;import com.bwie.day_14.Utils.Utils;import com.google.gson.Gson;import java.io.InputStream;import java.net.HttpURLConnection;import java.net.MalformedURLException;import java.net.URL;import java.util.List;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");}//导出数据库要用4.4的模拟器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);}}

Dao包

import android.content.ContentValues;import android.content.Context;import android.database.sqlite.SQLiteDatabase;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;        }    }}

创建数据库（表）

import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.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) {    }}

阅读全文

0 0