fragmentlayout+radiogroup+数据库

1数据库  建表

//创建表结构
public class SqliteHelper extends SQLiteOpenHelper {

    public static final int VERSION = 1;
    public static final String STRING="news.db";

    public SqliteHelper(@Nullable Context context ) {
        super(context, STRING, null, VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
     db.execSQL("create table news(_id INTEGER PRIMARY KEY, url TEXT,json TEXT)");
    }

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

    }
}

2  数据库的dao包  添加数据  和查询数据

//做数据库的添加和查询
public class NewsDao {

    private SqliteHelper helper;
    private SQLiteDatabase db;

    public  NewsDao(Context  context){
        helper = new SqliteHelper(context);
        db = helper.getWritableDatabase();
    }

    //添加
    public void addnews(NewsBean bean){
        ContentValues  values=new ContentValues();
        values.put("url",bean.url);
        values.put("json",bean.json);
        db.replace("news",null,values);

    }

    //查询

    public NewsBean selectnews(String  url){
        NewsBean newsBean = null;
        Cursor cursor = db.rawQuery("select *  from news  where url=?", new String[]{url});
        if (cursor.moveToNext()){
            newsBean = new NewsBean();
            newsBean.url=cursor.getString(cursor.getColumnIndex("url"));
            newsBean.json=cursor.getString(cursor.getColumnIndex("json"));
        }
        return newsBean;
    }


}

3.bean方法 定义有参无参

public class NewsBean {

    private  int  _id;
    public String json;
    public String url;

    public NewsBean() {
    }

    public NewsBean(String url, String json) {
        this.url = url;
        this.json = json;
    }


}