Ninth

自定义ContentProvider

提供方：ContentProvider

创建数据库，自定义类继承SQLiteOpenHelper

自定义内容提供者类，继承ContentProvider，重写insert/delete/update/query方法，向外界提供方法

清单文件中注册内容提供者

代码:

自定义类继承SQLiteOpenHelper

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table user (_id integer primary key autoincrement ,name varchar(30),age integer)");
        for(int i=1;i<10;i++){
            db.execSQL("insert into user values(null,?,?)",new String[]{i+"",i+""});
        }
    }

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

    }
}

自定义内容提供者类，继承ContentProvider**

public class MyProvider extends ContentProvider {
    private MyHelper myHelper;
    private SQLiteDatabase db;
    //获取数据库
    @Override
    public boolean onCreate() {
        myHelper=new MyHelper(getContext());
        db=myHelper.getWritableDatabase();
        if(db==null){
            return false;
        }else{
            return true;
        }
    }

    @Nullable
    @Override
    public Cursor query(@NonNull Uri uri, @Nullable String[] projection, @Nullable String selection, @Nullable String[] selectionArgs, @Nullable String sortOrder) {
        return  db.query("user",projection,selection,selectionArgs,null,null,sortOrder);
    }

    @Nullable
    @Override
    public String getType(@NonNull Uri uri) {
        return null;
    }

    @Nullable
    @Override
    public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {
        db.insert("user",null,values);
        return uri;
    }

    @Override
    public int delete(@NonNull Uri uri, @Nullable String selection, @Nullable String[] selectionArgs) {
        return db.delete("user",selection,selectionArgs);
    }

    @Override
    public int update(@NonNull Uri uri, @Nullable ContentValues values, @Nullable String selection, @Nullable String[] selectionArgs) {
        return db.update("user",values,selection,selectionArgs);
    }
}

清单文件中注册内容提供者

<!--注册内容提供者 exported能否被其他应用程序访问   authorities：uri  name：类的全路径-->
        <provider
            android:exported="true"
            android:authorities="com.bawei"
            android:name=".MyProvider"></provider>

索要方：ContentResolver

通过Context的getContentResolver方法获得ContentResolver对象

确定uri

调用insert/delete/update/query方法访问数据库

代码:

获取ContentResolver直接获取

public class MainActivity extends AppCompatActivity {
    private ContentResolver contentResolver;
    private Uri uri;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        uri=Uri.parse("content://com.bawei");
        contentResolver=getContentResolver();
    }
    //user (_id integer primary key autoincrement ,name varchar(30),age integer)
    public void query(){
        //参数一：uri 参数二：查询的字段 参数三：条件  参数四：为?赋值 参数五：排序
        Cursor cursor=contentResolver.query(uri,new String[]{"_id","name"},null,null,null);
        //遍历
    }
    public  void delete(){
        //参数一：uri  参数二：条件 参数三：为?赋值
        int raw=contentResolver.delete(uri,"name=?",new String[]{"123"});
    }
    public void insert(){
        //添加数据
        ContentValues contentValues=new ContentValues();
        contentValues.put("name","231");
        contentValues.put("age",18);
        contentResolver.insert(uri,contentValues);
        //遍历
    }
}