Android provider sample (2015.12.7)

http://www.tutorialspoint.com/android/android_content_providers.htm

1. 修改布局文件:main_activity.xml, 布置好界面；

    在属性栏：修改，名字，大小，回调函数

    <EditText
        android:id="@+id/editText_name"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/textView1"
        android:layout_below="@+id/textView1"
        android:layout_marginTop="19dp"
        android:ems="10"
        android:hint="Name"
        android:inputType="textPersonName" />

    <EditText
        android:id="@+id/editText_grade"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/editText_name"
        android:layout_below="@+id/editText_name"
        android:ems="10"
        android:hint="Grade" >

        <requestFocus />
    </EditText>

    <Button
        android:id="@+id/button_add_name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/editText_grade"
        android:layout_alignRight="@+id/editText_grade"
        android:layout_below="@+id/editText_grade"
        android:layout_marginTop="34dp"
        android:gravity="center_vertical|center_horizontal|fill_vertical"
        android:onClick="onClickAddName"
        android:text="Add Name" />

    <Button
        android:id="@+id/button_retrieve_student"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/button_add_name"
        android:layout_alignRight="@+id/editText_grade"
        android:layout_below="@+id/button_add_name"
        android:layout_marginTop="16dp"
        android:onClick="onClickRetrieveStudents"
        android:text="Retreive Student" />

2. 在Main_Activity.java中，对2个button 加2个回调函数：

   public void onClickAddName(View view) {
    	// add a new student record.
    	Log.d(msg, "onClickName()");
    	
    	ContentValues values = new ContentValues();
    	
    	values.put(StudentProvider.NAME, 
    			((EditText)findViewById(R.id.editText_name)).getText().toString());
    	
    	values.put(StudentProvider.GRADE, 
    			((EditText)findViewById(R.id.editText_grade)).getText().toString());
    	
    	Uri uri = getContentResolver().insert(StudentProvider.CONTENT_URI, values);
    	
    	Toast.makeText(getBaseContext(), uri.toString(), Toast.LENGTH_LONG).show();
    	
    }

    public void onClickRetrieveStudents(View view) {
    	// Retrieve student records
    	Log.d(msg, "onClickRetrieveStudents()");
    	

    	// Retrieve students records
    	String URL = "content://com.example.providerDemo.Colloge/students";
    	
    	Uri students = Uri.parse(URL);
    	Cursor c = managedQuary(students, null, null, null, "name");

    		
        if (c != null )
	        if ( c.moveToFirst()) {
	            do{
	               Toast.makeText(this, 
	               c.getString(c.getColumnIndex(StudentProvider._ID)) + 
	               ", " +  c.getString(c.getColumnIndex( StudentProvider.NAME)) + 
	               ", " + c.getString(c.getColumnIndex( StudentProvider.GRADE)), 
	               Toast.LENGTH_SHORT).show();
	            } while (c.moveToNext());
	         }    	

    }

3. 新生成一个provider文件： StudentProvider.java

package com.example.providerdemo;

import java.util.HashMap;

import android.content.ContentProvider;
import android.content.ContentUris;
import android.content.ContentValues;
import android.content.Context;
import android.content.UriMatcher;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteQueryBuilder;
import android.net.Uri;
import android.text.TextUtils;
import android.util.Log;

public class StudentProvider extends ContentProvider {
	
	static String msg = "Android:StudentProvider ";
	
	static final String PROVIDE_NAME = "com.example.providerDemo.College";
	static final String URL = "content://" + PROVIDE_NAME + "/students";
	static final Uri CONTENT_URI = Uri.parse(URL);
	
	static final String _ID = "_id";
	static final String NAME = "name";
	static final String GRADE = "grade";
	
	private static HashMap<String, String> STUDENTS_PROJECTION_MAP;
	
	static final int STUDENTS = 1;
	static final int STUDENT_ID = 2;
	
	static final UriMatcher uriMatcher;
	static {
		uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
		uriMatcher.addURI(PROVIDE_NAME, "students", STUDENTS);
		uriMatcher.addURI(PROVIDE_NAME, "students/#", STUDENT_ID);
	}
	
	/**
	 * Database specific constant declarations
	 */
	private SQLiteDatabase db;
	static final String DATABASE_NAME = "College";
	static final String STUDENTS_TABLE_NAME = "students";
	static final int DATABASE_VERSION = 1;

	static final String CREATE_DB_TABLE =
			" CREATE TABLE " + STUDENTS_TABLE_NAME +
			" (_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
			" name TEXT NOT NULL, " + 
			" grade TEXT NOT NULL);";
	/*
   static final String CREATE_DB_TABLE = 
		   " CREATE TABLE " + STUDENTS_TABLE_NAME +
		   " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + 
		   " name TEXT NOT NULL, " +
		   " grade TEXT NOT NULL);";	
				*/
	/**
	 * Helper class that actually creates and manages
	 * the provider's underlying data repository.
	 */
	private static class DatabaseHelper extends SQLiteOpenHelper {
		
		DatabaseHelper(Context context) {
			super(context, DATABASE_NAME, null, DATABASE_VERSION);
		}

		@Override
		public void onCreate(SQLiteDatabase db) {
			// TODO Auto-generated method stub
			Log.d(msg, "onCreate(SQLiteDatabase db)");
			db.execSQL(CREATE_DB_TABLE);
			Log.d(msg, "onCreate(SQLiteDatabase db)2");
		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
			// TODO Auto-generated method stub
			db.execSQL("DROP TABLE IF EXISTS " + STUDENTS_TABLE_NAME);
			onCreate(db);
		}
		
	}
	
	@Override
	public boolean onCreate() {
		// TODO Auto-generated method stub
		Log.d(msg, "onCreate()");
		
		Context context = getContext();
		DatabaseHelper dbHelper = new DatabaseHelper(context);
		Log.d(msg, "onCreate()2");
		
		/*
		 * Create a writable database which will trigger its creation
		 * if it doesn't already exist.
		 */
		db = dbHelper.getWritableDatabase();
		return (db == null) ? false:true;
	}
	
	@Override
	public Uri insert(Uri uri, ContentValues values) {
		// TODO Auto-generated method stub
		Log.d(msg, "insert()");
		/**
		 * Add a new student record
		 */
		long rowID = db.insert(STUDENTS_TABLE_NAME, "", values);
		
		/**
		 * If record is added successfully.
		 */
		if (rowID > 0) {
			Uri _uri = ContentUris.withAppendedId(CONTENT_URI, rowID);
			getContext().getContentResolver().notifyChange(_uri, null);
			return _uri;
		}
		throw new SQLException("Failed to add a record into " + uri);
	}

	/*
	@Override
	public Cursor query(Uri arg0, String[] arg1, String arg2, String[] arg3,
			String arg4) {
		// TODO Auto-generated method stub
		return null;
	}
	
	@Override
	public int delete(Uri arg0, String arg1, String[] arg2) {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public String getType(Uri arg0) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public int update(Uri arg0, ContentValues arg1, String arg2, String[] arg3) {
		// TODO Auto-generated method stub
		return 0;
	}
	*/
	
	   @Override
	   public Cursor query(Uri uri, String[] projection, String selection,String[] selectionArgs, String sortOrder) {
		   
		   Log.d(msg, "query()");
		   
	      SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
	      qb.setTables(STUDENTS_TABLE_NAME);
	      
	      switch (uriMatcher.match(uri)) {
	         case STUDENTS:
	         qb.setProjectionMap(STUDENTS_PROJECTION_MAP);
	         break;
	         
	         case STUDENT_ID:
	         qb.appendWhere( _ID + "=" + uri.getPathSegments().get(1));
	         break;
	         
	         default:
	         throw new IllegalArgumentException("Unknown URI " + uri);
	      }
	      
	      if (sortOrder == null || sortOrder == ""){
	         /** 
	         * By default sort on student names
	         */
	         sortOrder = NAME;
	      }
	      Cursor c = qb.query(db,	projection,	selection, selectionArgs,null, null, sortOrder);
	      
	      /**
	      * register to watch a content URI for changes
	      */
	      c.setNotificationUri(getContext().getContentResolver(), uri);
	      return c;
	   }

	   @Override
	   public int delete(Uri uri, String selection, String[] selectionArgs) {
		   
		   Log.d(msg, "delete()");
		   
	      int count = 0;
	      
	      switch (uriMatcher.match(uri)){
	         case STUDENTS:
	         count = db.delete(STUDENTS_TABLE_NAME, selection, selectionArgs);
	         break;
	         
	         case STUDENT_ID:
	         String id = uri.getPathSegments().get(1);
	         count = db.delete( STUDENTS_TABLE_NAME, _ID +  " = " + id + 
	         (!TextUtils.isEmpty(selection) ? " AND (" + selection + ')' : ""), selectionArgs);
	         break;
	         
	         default: 
	         throw new IllegalArgumentException("Unknown URI " + uri);
	      }
	      
	      getContext().getContentResolver().notifyChange(uri, null);
	      return count;
	   }
	   
	   @Override
	   public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
		   
		   Log.d(msg, "update()");
		   
	      int count = 0;
	      
	      switch (uriMatcher.match(uri)){
	         case STUDENTS:
	         count = db.update(STUDENTS_TABLE_NAME, values, selection, selectionArgs);
	         break;
	         
	         case STUDENT_ID:
	         count = db.update(STUDENTS_TABLE_NAME, values, _ID + " = " + uri.getPathSegments().get(1) + 
	         (!TextUtils.isEmpty(selection) ? " AND (" +selection + ')' : ""), selectionArgs);
	         break;
	         
	         default: 
	         throw new IllegalArgumentException("Unknown URI " + uri );
	      }
	      getContext().getContentResolver().notifyChange(uri, null);
	      return count;
	   }

	   @Override
	   public String getType(Uri uri) {
	      switch (uriMatcher.match(uri)){
	         /**
	         * Get all student records 
	         */
	         case STUDENTS:
	         return "vnd.android.cursor.dir/vnd.example.students";
	         
	         /** 
	         * Get a particular student
	         */
	         case STUDENT_ID:
	         return "vnd.android.cursor.item/vnd.example.students";
	         
	         default:
	         throw new IllegalArgumentException("Unsupported URI: " + uri);
	     }
	  }	
}

主要是重载sqlite的几个常用接口：

4. 在Manifest.xml中 声明这个content provider:

		<provider 
		    android:name="StudentProvider"
		    android:authorities="com.example.providerDemo.College" />

编译运行。