创建数据库 增删改查

public class MyHelper extends SQLiteOpenHelper {
    public MyHelper(Context context) {
        super(context, "dbcache", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        //创建数据表
        sqLiteDatabase.execSQL("create table jsontable (id integer primary key autoincrement,url text not null,json text not null)");

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}

--------以上是创建数据库  当然值自己设定  在设置dao层做增删该查

public class JsonDao {
    private MyHelper helper;

    public JsonDao(Context context) {
        helper=new MyHelper(context);
    }

    //插入数据
    public void insertData(String url,String jsonstr){
        SQLiteDatabase db=helper.getWritableDatabase();
        //先删除，再插入
        db.delete("jsontable","url=?",new String[]{jsonstr});

        ContentValues values=new ContentValues();
        values.put("url",url);
        values.put("json",jsonstr);

        long rowid = db.insert("jsontable", null, values);
        Log.d("zzz","insert-----rowid:"+rowid);
    }

    /**
     * 查询数据
     * @param url
     * @return
     */
    public String queryData(String url){
        String json="";
        SQLiteDatabase db = helper.getWritableDatabase();
        Cursor cursor = db.query("jsontable", null, "url=?", new String[]{url}, null, null, null);
        while (cursor.moveToNext()){
             json = cursor.getString(cursor.getColumnIndex("json"));
        }

        return json;

    }

}