安卓內(nèi)容提供者實(shí)現(xiàn)對數(shù)據(jù)的增刪改查

2019-11-11 03:53:43

字體：大中小

來源：轉(zhuǎn)載

供稿：網(wǎng)友

安卓內(nèi)容提供者簡介

簡介主要用于在不同的應(yīng)用程序之間實(shí)現(xiàn)數(shù)據(jù)共享的功能，它提供了一套完整的機(jī)制，允許一個程序訪問另一個程序中的數(shù)據(jù)，同時還能保證被訪數(shù)據(jù)的安全性。

備注：以下demo實(shí)現(xiàn)了一套簡單快捷的內(nèi)容者實(shí)現(xiàn)對數(shù)據(jù)的增刪改查，截取部分代碼，加解析。

—–》第一個應(yīng)用程序“內(nèi)容提供者“”demo創(chuàng)建工程截圖：這里寫圖片描述

—–》Activity代碼 package com.example.android_sqlite;

import android.app.ListActivity; import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AlertDialog; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.text.TextUtils; import android.view.View; import android.widget.AdapterView; import android.widget.Button; import android.widget.EditText; import android.widget.LinearLayout; import android.widget.ListView; import android.widget.SimpleCursorAdapter; import android.widget.TextView; import android.widget.Toast;

import com.zking.db.DbHelper;

public class MainActivity extends ListActivity {

PRivate ListView listView;private SQLiteDatabase sdb;private SimpleCursorAdapter simpleCursorAdapter;private Cursor cursor;@Overrideprotected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); //實(shí)例化DbHelper DbHelper db = new DbHelper(this, "person.db", null, 1); //加數(shù)據(jù) sdb = db.getWritableDatabase(); for (int i = 0; i < 10; i++) { ContentValues contentvalues = new ContentValues(); contentvalues.put("name", "張三" + i); contentvalues.put("age", i); contentvalues.putNull("_id"); sdb.insert("person","name",contentvalues); } Toast.makeText(MainActivity.this, "數(shù)據(jù)加載完畢！", Toast.LENGTH_SHORT).show(); //獲取SQLiteDatabase //獲取ListView listView = getListView(); sdb = db.getReadableDatabase(); //查詢所有 cursor = sdb.query(false, "person", null, null, null, null, null, null, null); //循環(huán)游標(biāo)，放值，設(shè)置適配器 simpleCursorAdapter = new SimpleCursorAdapter(this, R.layout.item_listview, cursor, new String[]{"_id", "name", "age"}, new int[]{R.id.tv_item_list_id, R.id.tv_item_list_name, R.id.tv_item_list_age}); //給listView設(shè)置適配器 listView.setAdapter(simpleCursorAdapter);}public Cursor queryAllPerson(){ Cursor cursor = sdb.rawQuery("select * from person",null); return cursor;}public void query(View view){ cursor=queryAllPerson(); //通知適配器發(fā)生改變 simpleCursorAdapter.changeCursor(cursor);}

}

—–>MyContentProvider代碼 package com.example.android_sqlite;

import android.content.ContentProvider; import android.content.ContentUris; import android.content.ContentValues; import android.content.UriMatcher; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.annotation.Nullable;

import com.zking.db.DbHelper;

/** * Created by Administrator on 2017/2/6. */ public class MyContentProvider extends ContentProvider {

private DbHelper dbHelper;private SQLiteDatabase sqLiteDatabase;// uri匹配相關(guān)private static UriMatcher uriMatcher;// 主機(jī)名稱(這一部分是可以隨便取得)private static final String authority = "com.example.android_sqlite.PERSON";// 注冊該內(nèi)容提供者匹配的uristatic { uriMatcher = new UriMatcher(UriMatcher.NO_MATCH); uriMatcher.addURI(authority, "person", 1);// 代表當(dāng)前表中的所有的記錄 uriMatcher.addURI(authority, "person/#", 2);// 代表當(dāng)前表中的某條特定的記錄，記錄id便是#處得數(shù)字}@Overridepublic boolean onCreate() { dbHelper = new DbHelper(getContext(), "person.db", null, 1); sqLiteDatabase = dbHelper.getReadableDatabase(); return true;}@Nullable@Overridepublic Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) { int code = uriMatcher.match(uri); switch (code) { case 1: Cursor cursor = sqLiteDatabase.query("person", projection, selection, selectionArgs, null, null, sortOrder); return cursor; case 2: // 從uri中解析出ID long id = ContentUris.parseId(uri); Cursor cursor2 = sqLiteDatabase.query("person", projection, "_id=?", new String[]{id + ""}, null, null, sortOrder); return cursor2; } return null;}@Nullable@Overridepublic String getType(Uri uri) { return null;}@Nullable@Overridepublic Uri insert(Uri uri, ContentValues values) { sqLiteDatabase.insert("person", null, values); return uri;}@Overridepublic int delete(Uri uri, String selection, String[] selectionArgs) { return sqLiteDatabase.delete("person",selection,selectionArgs);}@Overridepublic int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { return sqLiteDatabase.update("person",values,selection,selectionArgs);}

}

——》main.xml為默認(rèn)。

—–》第二個應(yīng)用程序“內(nèi)容監(jiān)聽者”創(chuàng)建工程截圖：這里寫圖片描述

——>MainActivity代碼 package com.example.android_contentprovider_sqlite;

import android.content.ContentResolver; import android.content.ContentValues; import android.database.Cursor; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.text.TextUtils; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

private ContentResolver contentResolver;private Button bt_main_add;private Button bt_main_query;private Button bt_main_delete;private Button bt_main_update;private EditText et_main_query;@Overrideprotected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); contentResolver = this.getContentResolver(); //查詢 bt_main_query = (Button) findViewById(R.id.bt_main_query); et_main_query = (EditText) findViewById(R.id.et_main_query); bt_main_query.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { query(v); } }); //添加 bt_main_add = (Button) findViewById(R.id.bt_main_add); bt_main_add.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { add(v); } }); //刪除 bt_main_delete = (Button) findViewById(R.id.bt_main_delete); bt_main_delete.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { delete(v); } }); //修改 bt_main_update = (Button) findViewById(R.id.bt_main_update); bt_main_update.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { update(v); } });}//*********************************************************************************//查詢public void query(View view) { Uri uri; //判斷輸入框是否為空 if (TextUtils.isEmpty(et_main_query.getText().toString())) { uri = Uri.parse("content://com.example.android_sqlite.PERSON/person"); } else { //查詢單個 String id = et_main_query.getText().toString(); uri = Uri.parse("content://com.example.android_sqlite.PERSON/person/" + id); } //訪問數(shù)據(jù) Cursor cursor = contentResolver.query(uri, null, null, null, null); while (cursor.moveToNext()) { int pid = cursor.getInt(cursor.getColumnIndex("_id")); String name = cursor.getString(cursor.getColumnIndex("name")); int age = cursor.getInt(cursor.getColumnIndex("age")); Log.i("test", pid + " " + name + " " + age); }}//添加public void add(View view) { ContentValues contentValues = new ContentValues(); contentValues.put("name", "大七"); contentValues.put("age", 13); Uri uri = Uri.parse("content://com.example.android_sqlite.PERSON"); contentResolver.insert(uri, contentValues); Toast.makeText(MainActivity.this, "添加成功", Toast.LENGTH_SHORT).show();}//刪除public void delete(View view) { Uri uri = Uri.parse("content://com.example.android_sqlite.PERSON"); contentResolver.delete(uri, "_id=?", new String[]{6 + ""}); Toast.makeText(MainActivity.this, "刪除成功", Toast.LENGTH_SHORT).show();}//修改public void update(View view) { Uri uri = Uri.parse("content://com.example.android_sqlite.PERSON"); ContentValues values = new ContentValues(); values.put("name", "大大"); values.put("age", 2); contentResolver.update(uri, values, "_id=?", new String[]{9 + ""}); Toast.makeText(MainActivity.this, "修改成功", Toast.LENGTH_SHORT).show();}

}

上一篇：scala操作符和關(guān)鍵字

下一篇：C#學(xué)習(xí)日記2017-02-07 Combox下拉控件問題