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();