android数据库的简单使用

public class MyHelper extends SQLiteOpenHelper {
    public MyHelper(Context context) {
        super(context, "sun", null, 1);//数据库名
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
            db.execSQL("create table lr(id Integer primary key autoincrement,title text,url text)");//创建表
    }

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

    }
}

public class MyManager {
    private Context context;
    private final SQLiteDatabase db;

    public MyManager(Context context) {
        this.context = context;
        MyHelper helper=new MyHelper(context);
         db = helper.getWritableDatabase();
    }
    //添加方法
    public void insertData(List<Bean.ResultBean.DataBean> data){
        for (int i=0;i<data.size();i++){
            Bean.ResultBean.DataBean dataBean = data.get(i);
            ContentValues values=new ContentValues();
            values.put("title",dataBean.getTitle());
            values.put("url",dataBean.getThumbnail_pic_s());
            db.insert("lr",null,values);
        }
    }
    //查询方法
    public List<Bean.ResultBean.DataBean> selectData(){
        List<Bean.ResultBean.DataBean> list=new ArrayList<>();
        Cursor cursor = db.query("lr", null, null, null, null, null, null);

        while(cursor.moveToNext()){
            String title = cursor.getString(cursor.getColumnIndex("title"));
            String url = cursor.getString(cursor.getColumnIndex("url"));
            Bean.ResultBean.DataBean bean=new Bean.ResultBean.DataBean();
            bean.setTitle(title);
            bean.setUrl(url);
            list.add(bean);
        }
        return list;
    }
MyManager manager = new MyManager(getActivity());
manager.insertData(data);
List<Bean.ResultBean.DataBean> dataBeen = manager.selectData();