网络加载数据放入数据库中

来源：互联网发布：淘宝联盟为何提不了现编辑：程序博客网时间：2024/06/14 03:44

insertDatabase

package com.example.rikao080902.util;import android.content.ContentValues;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import com.example.rikao080902.MyDatabaseHelper;/** *  */public class InsertDatabase {    private final SQLiteDatabase sd;    public  InsertDatabase(Context context){        MyDatabaseHelper helper=new MyDatabaseHelper(context);        sd = helper.getWritableDatabase();    }    public boolean insert(String step){        ContentValues values=new ContentValues();        values.put("step",step);        long user = sd.insert("users", null, values);        if(user!=-1){            return true;        }else{            return false;        }    }}

MainActivity

package com.example.rikao080902;import android.content.ContentValues;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.os.AsyncTask;import android.support.v7.app.AppCompatActivity;import android.os.Bundle;import android.view.View;import android.widget.Button;import android.widget.Toast;import com.example.rikao080902.bean.MenuInfo;import com.example.rikao080902.util.InsertDatabase;import com.example.rikao080902.util.StreamTools;import com.google.gson.Gson;import java.io.InputStream;import java.io.OutputStream;import java.net.HttpURLConnection;import java.net.MalformedURLException;import java.net.URL;import java.util.List;public class MainActivity extends AppCompatActivity {    private SQLiteDatabase db;    private MyDatabaseHelper dbhelper;    private Button button,button02;    private List<MenuInfo.ResultBean.DataBean.StepsBean> list;    private  InsertDatabase insertDatabase;   // private Context context;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);          button= (Button) findViewById(R.id.button);          button02= (Button) findViewById(R.id.button02);         dbhelper=new MyDatabaseHelper(this);        button.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                dbhelper.getWritableDatabase();                Toast.makeText(MainActivity.this,"数据库创建完毕",Toast.LENGTH_SHORT).show();            }        });        button02.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                new AsyncTask<String, Void, String>() {                    @Override                    protected void onPostExecute(String s) {                        super.onPostExecute(s);                        Gson gson=new Gson();                        MenuInfo menuInfo=gson.fromJson(s,MenuInfo.class);                        list=menuInfo.getResult().getData().get(0).getSteps();                        insertDatabase=new InsertDatabase(MainActivity.this);                      for (int i=0;i<list.size();i++){                          Boolean insert = insertDatabase.insert(list.get(i).getStep());                     if(insert)                     {                         System.out.println("添加成功");                     }                      }                    }                    @Override                    protected String doInBackground(String... params) {                        try {                            String path=params[0];                            URL url=new URL(path);                            HttpURLConnection connection= (HttpURLConnection) url.openConnection();                            connection.setRequestMethod("POST");                            OutputStream os=connection.getOutputStream();                            os.write("key=4866477692b8491f120e3608db277cb0&menu=红烧肉".getBytes());                            os.flush();                            connection.setConnectTimeout(5000);                            connection.setReadTimeout(5000);                            int code=connection.getResponseCode();                            if(code==HttpURLConnection.HTTP_OK){                                InputStream is=connection.getInputStream();                                String json= StreamTools.readNetWorks(is);                                return json;                            }                        } catch (Exception e) {                            e.printStackTrace();                        }                        return null;                    }                }.execute("http://apis.juhe.cn/cook/query.php");            }        });     }}

MyDatabaseHelper

package com.example.rikao080902;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;/** *  */public class MyDatabaseHelper  extends SQLiteOpenHelper{    public MyDatabaseHelper(Context context) {        super(context, "user.db", null, 1);    }    @Override    public void onCreate(SQLiteDatabase db) {        db.execSQL("create table users(id integer primary key autoincrement,step varchar(20))");    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {    }}

阅读全文

0 0