android--四大组件之ContentProvider与SQLite数据库的联用

使用方法:

1.创建一个数据库,继承SQLiteOpenHelper

2.新建一个MyProvider继承ContentProvider,并重写方法

3.实现MyProvider里面的增删改查方法

4.在主activity里面调用数据库的增删改查方法

 

一.创建一个数据库,继承SQLiteOpenHelper

 

public class MyDatebaseopenHelper extends SQLiteOpenHelper{
    /*
    * name :数据库名称
    * factory :游标工厂
    * version :版本号
    * */

    public MyDatebaseopenHelper(Context context) {
        super(context, "infoss", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //创建数据库
        String sql ="create table infoss(_id integer primary key autoincrement,name varchar(20),phone varchar(20));";
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        //更新数据库
    }
}

 

二:新建一个MyProvider继承ContentProvider,并重写方法

三.实现MyProvider里面的增删改查方法

 

public class contentProviders extends ContentProvider{
    MyDatebaseopenHelper helper;
    private static final UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);
    private static final int INSERTSCUESS = 0;
    private static final int DELETESCUESS = 1;
    private static final int QUERYSCUESS = 2;
    private static final int UPDATESCUESS = 3;

    static{
        matcher.addURI("COM,CCN","insert",INSERTSCUESS);
        matcher.addURI("COM,CCN","delete&