CotentProvider

CotentProvider

1.提供方:ContentProvider
(1)创建数据库,自定义类继承SQLiteOpenHelper
(2)自定义内容提供者类,继承ContentProvider,重写insert/delete/update/query方法,向外界提供方法
(3)清单文件中注册内容提供者

2.索要方:ContentResolver
(1)通过Context的getContentResolver方法获得ContentResolver对象
(2)确定uri
(3)调用insert/delete/update/query方法访问数据库




public class MyHelper extends SQLiteOpenHelper {
    //自定义类继承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) {

    }
}



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;
        }
    }

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

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

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

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

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



<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.example.gao_1_0302_content">
    <!-- 1.自定义权限  (注意位置,没有在application里面) -->
    <permission
        android:name="com.bawei.permission.READ"
        android:protectionLevel="normal"></permission>
    <permission
        android:name="com.bawei.permission.WRITE"
        android:protectionLevel="normal"></permission>

    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".Main2Activity"></activity>
        <activity android:name=".MainActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>


 <!-- 1.自定义权限  (注意位置,没有在application里面) -->
    <permission
        android:name="com.bawei.permission.READ"
        android:protectionLevel="normal"></permission>
    <permission
        android:name="com.bawei.permission.WRITE"
        android:protectionLevel="normal"></permission>




public class Main2Activity extends AppCompatActivity {
    private static final String TAG = "Main2Activity";
    private ContentResolver contentResolver;
    private Uri uri;
    private Button buttonId;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main2);

        uri=Uri.parse("content://com.bawei");
        contentResolver=getContentResolver();
        //初始化控件
        buttonId=buttonId = findViewById(R.id.btn);
        //设置点击事件
        buttonId.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                query();
            }
        });
    }
    public void query(){
        //参数一:uri 参数二:查询的字段 参数三:条件  参数四:为?赋值 参数五:排序
        Toast.makeText(this, "cha", Toast.LENGTH_SHORT).show();
        Cursor cursor = contentResolver.query(uri, new String[]{"_id", "name"}, null, null, null);
        while(cursor.moveToNext()){
            String name = cursor.getString(cursor.getColumnIndex("name"));
            Log.i(TAG, "query: "+name);
            Toast.makeText(this, name, Toast.LENGTH_SHORT).show();
        }
//          遍历
    }
    public  void delete(){
        //参数一:uri  参数二:条件 参数三:为?赋值
        int raw=contentResolver.delete(uri,"name=?",new String[]{"非常的帅1"});
    }
    public void insert(){
        //添加数据
        ContentValues contentValues=new ContentValues();
        contentValues.put("name","要甜雪");
        contentValues.put("age",18);
        contentResolver.insert(uri,contentValues);
        
    }


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值