对数据库进行共享,首先对数据库的创建:
public class DBHelper extends SQLiteOpenHelper {
public DBHelper(Context context, int version) {
super(context, "wz.db", null, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table student (_id int, name varchar(200) ,age int)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("drop table student");
db.execSQL("create table student (_id int primary key, name varchar(200) ,age int)");
}
}
接着对该数据库进行数据共享操作,实现数据的CRUD操作:
public class StudentProvider extends ContentProvider {
private DBHelper helper;
private static int STUDENTS =1;
private static int STUDENT =2;
private SQLiteDatabase db;
private static UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);
static{
matcher.addURI("com.wpf.student.provider", "students", STUDENTS);
matcher.addURI("com.wpf.student.provider", "student/#", STUDENT);
}
@Override
public int delete(Uri uri, String selection, String[] selectionArgs) {
int num = 0;
switch (matcher.match(uri)) {
case 1:
num = db.delete("student", selection, select