解析并且存入数据库

最新推荐文章于 2022-06-20 16:21:18 发布

情不知所起i

最新推荐文章于 2022-06-20 16:21:18 发布

阅读量375

点赞数

本文链接：https://blog.csdn.net/Fairy_1001/article/details/75670553

版权

主界面

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) {

    }
}