Day10ContentProvider读取数据库进行增删改查

注意清单 文件

  <provider
            android:name=".MyContentProvider"
            android:authorities="com.zcb"
            android:enabled="true"
            android:exported="true">
   </provider>

1.Provieder

public class MyContentProvider extends ContentProvider {
    private SQLiteDatabase db;
    public MyContentProvider() {
    }

    @Override
    public int delete(Uri uri, String selection, String[] selectionArgs) {
        // Implement this to handle requests to delete one or more rows.
        int person = db.delete("person", selection, selectionArgs);
        return person;
    }

    @Override
    public String getType(Uri uri) {
        // TODO: Implement this to handle requests for the MIME type of the data
        // at the given URI.
        throw new UnsupportedOperationException("Not yet implemented");
    }

    @Override
    public Uri insert(Uri uri, ContentValues values) {
        long person = db.insert("person", null, values);
        return uri;
    }

    @Override
    public boolean onCreate() {
        // TODO: Implement this to initialize your content provider on startup.
        MySqlHelper mySqlHelper = new MySqlHelper(getContext(), "person.db", null, 2);
        db = mySqlHelper.getWritableDatabase();
        if (db!=null){
            return true;
        }
        return false;
    }

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

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

2.Main页面获取

public class MainActivity extends AppCompatActivity {

   private ContentResolver contentResolver;

   private Uri parse;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
       contentResolver  = getContentResolver();
        parse = Uri.parse("content://com.zcb");
    }

    public void select(View view) {
        Cursor cursor = contentResolver.query(parse, null, null, null, null);
        if (cursor!=null){
            while (cursor.moveToNext()){
                String name = cursor.getString(cursor.getColumnIndex("name"));
                Toast.makeText(this, name, Toast.LENGTH_SHORT).show();
            }
            cursor.close();
        }
    }

    public void insert(View view) {
        ContentValues contentValues = new ContentValues();
        contentValues.put("name","小明");
        contentResolver.insert(parse,contentValues);
    }

    public void delete(View view) {
        ContentValues contentValues = new ContentValues();
        contentValues.put("name","小明");
        contentResolver.delete(parse,"name = ?",new String[]{"小明"});
    }

    public void update(View view) {
        ContentValues contentValues = new ContentValues();
        contentValues.put("name","小明");
        contentResolver.update(parse,contentValues,"name = ?",new String[]{"小王"});
    }

}