package com.ljq.db;
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.net.Uri;
import android.text.TextUtils;
/**
 * 內(nèi)容提供者
 * 
 * 作用：統(tǒng)一數(shù)據(jù)訪問方式，方便外部調(diào)用
 * 
 * @author jiqinlin
 * 
 */
public class PersonContentProvider extends ContentProvider {
  // 數(shù)據(jù)集的MIME類型字符串則應(yīng)該以vnd.android.cursor.dir/開頭
  public static final String PERSONS_TYPE = "vnd.android.cursor.dir/person";
  // 單一數(shù)據(jù)的MIME類型字符串應(yīng)該以vnd.android.cursor.item/開頭
  public static final String PERSONS_ITEM_TYPE = "vnd.android.cursor.item/person";
  public static final String AUTHORITY = "com.ljq.provider.personprovider";// 主機(jī)名
  /* 自定義匹配碼 */
  public static final int PERSONS = 1;
  /* 自定義匹配碼 */
  public static final int PERSON = 2;
  public static final Uri PERSONS_URI = Uri.parse("content://" + AUTHORITY + "/person");
  private DBOpenHelper dbOpenHelper = null;
  // UriMatcher類用來匹配Uri，使用match()方法匹配路徑時(shí)返回匹配碼
  private static final UriMatcher uriMatcher;
  static {
    // 常量UriMatcher.NO_MATCH表示不匹配任何路徑的返回碼
    uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
    // 如果match()方法匹配content://com.ljq.provider.personprovider/person路徑，返回匹配碼為PERSONS
    uriMatcher.addURI(AUTHORITY, "person", PERSONS);
    // 如果match()方法匹配content://com.ljq.provider.personprovider/person/230路徑，返回匹配碼為PERSON
    uriMatcher.addURI(AUTHORITY, "person/#", PERSON);
  }
  @Override
  public boolean onCreate() {
    dbOpenHelper = new DBOpenHelper(this.getContext());
    return true;
  }
  @Override
  public Uri insert(Uri uri, ContentValues values){
    SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
    long id = 0;
    switch (uriMatcher.match(uri)) {
    case PERSONS:
      id = db.insert("person", "name", values);// 返回的是記錄的行號(hào)，主鍵為int，實(shí)際上就是主鍵值
      return ContentUris.withAppendedId(uri, id);
    case PERSON:
      id = db.insert("person", "name", values);
      String path = uri.toString();
      return Uri.parse(path.substring(0, path.lastIndexOf("/"))+id); // 替換掉id
    default:
      throw new IllegalArgumentException("Unknown URI " + uri);
    }
  }
  @Override
  public int delete(Uri uri, String selection, String[] selectionArgs) {
    SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
    int count = 0;
    switch (uriMatcher.match(uri)) {
    case PERSONS:
      count = db.delete("person", selection, selectionArgs);
      break;
    case PERSON:
      // 下面的方法用于從URI中解析出id，對(duì)這樣的路徑content://com.ljq.provider.personprovider/person/10
      // 進(jìn)行解析，返回值為10
      long personid = ContentUris.parseId(uri);
      String where = "id=" + personid;// 刪除指定id的記錄
      where += !TextUtils.isEmpty(selection) ? " and (" + selection + ")" : "";// 把其它條件附加上
      count = db.delete("person", where, selectionArgs);
      break;
    default:
      throw new IllegalArgumentException("Unknown URI " + uri);
    }
    db.close();
    return count;
  }
  @Override
  public int update(Uri uri, ContentValues values, String selection,
      String[] selectionArgs) {
    SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
    int count = 0;
    switch (uriMatcher.match(uri)) {
    case PERSONS:
      count = db.update("person", values, selection, selectionArgs);
      break;
    case PERSON:
      // 下面的方法用于從URI中解析出id，對(duì)這樣的路徑content://com.ljq.provider.personprovider/person/10
      // 進(jìn)行解析，返回值為10
      long personid = ContentUris.parseId(uri);
      String where = "id=" + personid;// 獲取指定id的記錄
      where += !TextUtils.isEmpty(selection) ? " and (" + selection + ")" : "";// 把其它條件附加上
      count = db.update("person", values, where, selectionArgs);
      break;
    default:
      throw new IllegalArgumentException("Unknown URI " + uri);
    }
    db.close();
    return count;
  }
  @Override
  public String getType(Uri uri) {
    switch (uriMatcher.match(uri)) {
    case PERSONS:
      return PERSONS_TYPE;
    case PERSON:
      return PERSONS_ITEM_TYPE;
    default:
      throw new IllegalArgumentException("Unknown URI " + uri);
    }
  }
  @Override
  public Cursor query(Uri uri, String[] projection, String selection,
      String[] selectionArgs, String sortOrder) {
    SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
    switch (uriMatcher.match(uri)) {
    case PERSONS:
      return db.query("person", projection, selection, selectionArgs, null, null, sortOrder);
    case PERSON:
      // 下面的方法用于從URI中解析出id，對(duì)這樣的路徑content://com.ljq.provider.personprovider/person/10
      // 進(jìn)行解析，返回值為10
      long personid = ContentUris.parseId(uri);
      String where = "id=" + personid;// 獲取指定id的記錄
      where += !TextUtils.isEmpty(selection) ? " and (" + selection + ")" : "";// 把其它條件附加上
      return db.query("person", projection, where, selectionArgs, null, null, sortOrder);
    default:
      throw new IllegalArgumentException("Unknown URI " + uri);
    }
  }
}

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
  package="com.ljq.sql" android:versionCode="1"
  android:versionName="1.0">
  <application android:icon="@drawable/icon"
    android:label="@string/app_name">
    <uses-library android:name="android.test.runner" />
    <activity android:name=".SqlActivity"
      android:label="@string/app_name">
      <intent-filter>
        <action android:name="android.intent.action.MAIN" />
        <category
          android:name="android.intent.category.LAUNCHER" />
      </intent-filter>
    </activity>
    <provider android:name="com.ljq.db.PersonContentProvider" 
       android:authorities="com.ljq.provider.personprovider" />
  </application>
  <uses-sdk android:minSdkVersion="7" />
  <instrumentation
    android:name="android.test.InstrumentationTestRunner"
    android:targetPackage="com.ljq.sql" android:label="Tests for My App" />
</manifest>

package com.ljq.test;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.test.AndroidTestCase;
import android.util.Log;
/**
 * 外部訪問內(nèi)容提供者
 * 
 * @author jiqinlin
 *
 */
public class PersonContentProviderTest extends AndroidTestCase{
  private static final String TAG = "PersonContentProviderTest";
  public void testSave() throws Throwable{
    ContentResolver contentResolver = this.getContext().getContentResolver();
    Uri insertUri = Uri.parse("content://com.ljq.provider.personprovider/person");
    ContentValues values = new ContentValues();
    values.put("name", "ljq");
    values.put("phone", "1350000009");
    Uri uri = contentResolver.insert(insertUri, values);
    Log.i(TAG, uri.toString());
  }
  public void testUpdate() throws Throwable{
    ContentResolver contentResolver = this.getContext().getContentResolver();
    Uri updateUri = Uri.parse("content://com.ljq.provider.personprovider/person/1");
    ContentValues values = new ContentValues();
    values.put("name", "linjiqin");
    contentResolver.update(updateUri, values, null, null);
  }
  public void testFind() throws Throwable{
    ContentResolver contentResolver = this.getContext().getContentResolver();
    //Uri uri = Uri.parse("content://com.ljq.provider.personprovider/person");
    Uri uri = Uri.parse("content://com.ljq.provider.personprovider/person");
    Cursor cursor = contentResolver.query(uri, null, null, null, "id asc");
    while(cursor.moveToNext()){
      int personid = cursor.getInt(cursor.getColumnIndex("id"));
      String name = cursor.getString(cursor.getColumnIndex("name"));
      String phone = cursor.getString(cursor.getColumnIndex("phone"));
      Log.i(TAG, "personid="+ personid + ",name="+ name+ ",phone="+ phone);
    }
    cursor.close();
  }
  public void testDelete() throws Throwable{
    ContentResolver contentResolver = this.getContext().getContentResolver();
    Uri uri = Uri.parse("content://com.ljq.provider.personprovider/person/1");
    contentResolver.delete(uri, null, null);
  }
}