Android之自定义contentprovider

1、ContentProviderTestActivity 类中有2个按钮，分别插入数据为查询数据

2、DataBaseConfiguation 为程序所用到的配置信息 注：TableConfiguation内部类实现BaseColumns，即声明了_ID 和 _COUNT

3、MyContentProvider 自定义ContentProvider，继承与ContentProvider

其中 uriMatcher 为Uri的匹配器，在静态块中初始化URI。 columnMap为表结构的映射mapping

在getType方法中要根据访问的Uri确定访问资源的类型，以字符串形式返回。
格式为："vnd.android.cursor.dir/vnd.catking.userList"、"vnd.android.cursor.item/vnd.catking.userItem";

注释掉，对程序运行无影响。

注意：

static{

  //初始化URI
  uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
  uriMatcher.addURI(DataBaseConfiguation.AUTHORITY, "user", USER_LIST_CODE);
  uriMatcher.addURI(DataBaseConfiguation.AUTHORITY, "user/#", USER_RECORD_CODE);
   红色字体中，的格式为xxx/xx，并不是/xxx/xx，其中*号匹配所有字符，#匹配所有数字
  //表结构的映射
  columnMap.put(DataBaseConfiguation.TableConfiguation._ID, DataBaseConfiguation.TableConfiguation._ID);
  columnMap.put(DataBaseConfiguation.TableConfiguation.USER_NAME, DataBaseConfiguation.TableConfiguation.USER_NAME);
 }

 

最后在AndroidManifest.xml里配上

<provider android:authorities="com.catking.contentprovider.MyContentProvider" android:name="com.catking.contentprovider.MyContentProvider" />

authorities的值必须与DataBaseConfiguation.AUTHORITY一致 

 

ContentProviderTestActivity：

import android.app.Activity;

import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

import com.catking.cfg.DataBaseConfiguation;

public  class ContentProviderTestActivity  extends Activity {
     private Button insertBtn;
     private Button queryBtn;
    @Override
     public  void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
        insertBtn = (Button) findViewById(R.id.insert);
        queryBtn = (Button) findViewById(R.id.query);
        
        insertBtn.setOnClickListener( new InsertOnClickListener());
        queryBtn.setOnClickListener( new QueryOnClickListener());
    }
    
     class InsertOnClickListener  implements OnClickListener{
        @Override
         public  void onClick(View v) {
            ContentValues values =  new ContentValues();
            values.put(DataBaseConfiguation.TableConfiguation.USER_NAME, "张三");
            Uri uri = getContentResolver().insert(DataBaseConfiguation.TableConfiguation.CONTENT_URI, values);
            System.out.println("uri------------------->" + uri);
        }
    }
    
     class QueryOnClickListener  implements OnClickListener{
        @Override
         public  void onClick(View v) {
            Cursor cursor = getContentResolver().query(DataBaseConfiguation.TableConfiguation.CONTENT_URI,
                     null,  null,  null,  null);
             while (cursor.moveToNext()) {
                System.out.println(cursor.getString(cursor.getColumnIndex(DataBaseConfiguation.TableConfiguation.USER_NAME)));
            }
        }
        
    }
}

DataBaseConfiguation：

package com.catking.cfg;

import android.net.Uri;
import android.provider.BaseColumns;

public  class DataBaseConfiguation {
     public  static  final String AUTHORITY = "com.catking.contentprovider.MyContentProvider";
     public  static  final String DATABASE_NAME = "cp_db";
     public  static  final  int DATABASE_VERSION = 1;
    
     public  static  class TableConfiguation  implements BaseColumns{
         public  static  final String TABLE_NAME = "user";
         public  static  final Uri CONTENT_URI = Uri.parse("content://" + DataBaseConfiguation.AUTHORITY + "/" + TABLE_NAME);
         public  static  final String CONTENT_TYPE_DIR = "vnd.android.cursor.dir/vnd.catking.userList";
         public  static  final String CONTENT_TYPE_RECORD = "vnd.android.cursor.item/vnd.catking.userItem";
         public  static  final String USER_NAME = "name";
         public  static  final String DEFAULT_SORT_ORDER = "_id desc";
    }

} 

MyContentProvider：

public  class MyContentProvider  extends ContentProvider {
    
     private  static  final UriMatcher uriMatcher;
     private  static  final  int USER_LIST_CODE = 1;
     private  static  final  int USER_RECORD_CODE = 2;
     private SQLiteOpenHelper dbh;
     private  static Map<String, String> columnMap =  new HashMap<String, String>();
    
     static{
        uriMatcher =  new UriMatcher(UriMatcher.NO_MATCH);
        uriMatcher.addURI(DataBaseConfiguation.AUTHORITY, "user", USER_LIST_CODE);
        uriMatcher.addURI(DataBaseConfiguation.AUTHORITY, "user/#", USER_RECORD_CODE);
        
        
        columnMap.put(DataBaseConfiguation.TableConfiguation._ID, DataBaseConfiguation.TableConfiguation._ID);
        columnMap.put(DataBaseConfiguation.TableConfiguation.USER_NAME, DataBaseConfiguation.TableConfiguation.USER_NAME);
    }
    
    @Override
     public  boolean onCreate() {
        dbh =  new MySQLiteOpenHelper(getContext(), DataBaseConfiguation.DATABASE_NAME,  null, DataBaseConfiguation.DATABASE_VERSION);
        System.out.println("dbh ������");
         return  true;
    }

    @Override
     public String getType(Uri uri) {
        System.out.println("getTypeִ��");
         switch (uriMatcher.match(uri)) {
         case USER_LIST_CODE:
             return DataBaseConfiguation.TableConfiguation.CONTENT_TYPE_DIR;
         case USER_RECORD_CODE:
             return DataBaseConfiguation.TableConfiguation.CONTENT_TYPE_RECORD;
         default:
             throw  new RuntimeException("unknown uri " + uri.toString());
        }
    }

    @Override
     public Uri insert(Uri uri, ContentValues values) {
        System.out.println("insert ִ��");
        SQLiteDatabase db = dbh.getWritableDatabase();
         long rowId = db.insert(DataBaseConfiguation.TableConfiguation.TABLE_NAME,  null, values);
         if (rowId > 0) {
            Uri insertedUri = ContentUris.withAppendedId(DataBaseConfiguation.TableConfiguation.CONTENT_URI, rowId);
            getContext().getContentResolver().notifyChange(insertedUri,  null);
             return insertedUri;
        }
         throw  new SQLException("fail to insert row into " + uri.toString());
    }

    @Override
     public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
        System.out.println(DataBaseConfiguation.TableConfiguation.CONTENT_URI);
        SQLiteDatabase db = dbh.getReadableDatabase();
        SQLiteQueryBuilder qb =  new SQLiteQueryBuilder();
        qb.setTables(DataBaseConfiguation.TableConfiguation.TABLE_NAME);
        qb.setProjectionMap(columnMap);
         switch (uriMatcher.match(uri)) {
         case USER_LIST_CODE:
             break;
         case USER_RECORD_CODE:
            System.out.println("��ʼ��ѯuri.getPathSegments()����");
             for (String s : uri.getPathSegments()) {
                System.out.println(s);
            }
            System.out.println("�����ѯuri.getPathSegments()����");
            qb.appendWhere(DataBaseConfiguation.TableConfiguation.USER_NAME + "=" + uri.getPathSegments().get(1));
             break;
         default:
             throw  new RuntimeException("unknown uri " + uri.toString());
        }
        Cursor c = db.query(DataBaseConfiguation.TableConfiguation.TABLE_NAME, projection, selection, selectionArgs,  null,  null,
                DataBaseConfiguation.TableConfiguation.DEFAULT_SORT_ORDER);
        c.setNotificationUri(getContext().getContentResolver(), uri);
         return c;
    }

    @Override
     public  int delete(Uri uri, String selection, String[] selectionArgs) {
         //  TODO Auto-generated method stub
         return 0;
    }

    @Override
     public  int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
         //  TODO Auto-generated method stub
         return 0;
    }

}  

 

MySQLiteOpenHelper：

public  class MySQLiteOpenHelper  extends SQLiteOpenHelper {

     public MySQLiteOpenHelper(Context context, String name, CursorFactory factory,  int version) {
         super(context, name, factory, version);
    }

    @Override
     public  void onCreate(SQLiteDatabase db) {
        System.out.println("createDB excuted");
        String createSQL = "create table " + DataBaseConfiguation.TableConfiguation.TABLE_NAME + "("
                + DataBaseConfiguation.TableConfiguation._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + DataBaseConfiguation.TableConfiguation.USER_NAME + " VARCHAR(20)" + ")";
        System.out.println(createSQL);
        db.execSQL(createSQL);
    }

    @Override
     public  void onUpgrade(SQLiteDatabase db,  int oldVersion,  int newVersion) {
        System.out.println("onUpgrade excuted");
    }

}  

AndroidManifest：

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
     package="com.catking.activity"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk android:minSdkVersion="8" />

    <application
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name" >
        <activity
            android:name=".ContentProviderTestActivity"
            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:authorities="com.catking.contentprovider.MyContentProvider" android:name="com.catking.contentprovider.MyContentProvider" />
    </application>

</manifest>  

参考自：http://catkingwong.iteye.com/blog/1313740 

转载于:https://www.cnblogs.com/lee0oo0/archive/2012/08/28/2659794.html