/**
* Created by Administrator on 2018/1/15.
*/
//创建一个类 继承 SQLiteOpenHelper
public class MyOpenHp extends SQLiteOpenHelper
{
public MyOpenHp(Context context) {
super(context, "User", null, 1);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
//创建表
sqLiteDatabase.execSQL("create table user(id integer primary key autoincrement,url text not null,json text not null)");
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
}
}
//创建一个类
public class MyUserBean {
private final SQLiteDatabase db;
//调取数据库
public MyUserBean(Context context){
MyOpenHp myOpenHp = new MyOpenHp(context);
db = myOpenHp.getWritableDatabase();
}
//添加的方法
public void insertData(String url,String json){
ContentValues values = new ContentValues();
values.put("url",url);
values.put("json",json);
db.insert("user",null,values);
}
//查询的方法
public String queryData(String url){
String s = "";
Cursor user = db.query("user", null, "url=?", new String[]{url}, null, null, null);
while (user.moveToNext()){
s = user.getString(user.getColumnIndex("json"));
}
return s;
}
}
//调取数据库 如果有网络就执行网络
if (NetStateUtil.isConn(getActivity())){
MyTask myTask = new MyTask(new MyTask.ICallBacks() {
@Override
public void getJson(String json) {
db.insertData(urls,json);
Gson gson = new Gson();
MyJson myJson = gson.fromJson(json, MyJson.class);
list = myJson.getResult().getData();
setadapter();
}
});
myTask.execute(urls);
}else {
//没有网络就执行数据库数据
Toast.makeText(getActivity(),”当前无网络”,Toast.LENGTH_SHORT).show();
String s = db.queryData(urls);
Gson gson = new Gson();
MyJson myJson = gson.fromJson(s, MyJson.class);
list = myJson.getResult().getData();
setadapter();
}