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