数据库的缓存网络数据

public class MySqlite extends SQLiteOpenHelper {
    public MySqlite(Context context) {
        super(context, "user.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table person(id integer primary key autoincrement,url text,jsonData text)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

}

//dao的方法

public class Dao {

    private final SQLiteDatabase db;
    private final MySqlite mySqlite;

    public Dao(Context context) {
        mySqlite = new MySqlite(context);
        db = mySqlite.getWritableDatabase();
    }

    public void add(String url,String json){
        db.delete("person","url=?",new String[]{url});
        ContentValues values=new ContentValues();
        values.put("url",url);
        values.put("jsonData",json);
        db.insert("person",null,values);
    }

    public String  select(String url){
        String jsonData="";

        Cursor query = db.query("person", null, "url=?", new String[]{url}, null, null, null);
        while (query.moveToNext()){

            jsonData = query.getString(query.getColumnIndex("jsonData"));
        }
        return jsonData;
    }


}