本人原创作品,谢绝转载!
前一篇android 玩转ContentProvider之二--实现多个ContentProvider对多张表进行操作中提到的是多个ContentProvider处理,一个ContentProvider对应一张表,下面说一下一个ContentProvider操作多张表的用法。
因为只有一个ContentProvider,所以在ContentProvider中就要区别多张表,很明确一下子就找到解决问题的切入点。下面的方法就是这样做的。也就是说authority只有一个,但Content_uri还是要有多个,因为要对应多张表。下面看代码:
直接操作数据类DatabaseHelper跟前面是一样的
DatabaseHelper.java
package com.jacp.database;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.jacp.demo.provider.Provider;
/**
* 直接操作数据库类
* @author jacp
*
*/
public class DatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "jacp_demo.db";
private static final int DATABASE_VERSION = 1;
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + Provider.ProgrammerColumns.TABLE_NAME + " ("
+ Provider.ProgrammerColumns._ID + " INTEGER PRIMARY KEY,"
+ Provider.ProgrammerColumns.NAME + " TEXT,"
+ Provider.ProgrammerColumns.AGE + " INTEGER"
+ ");");
db.execSQL("CREATE TABLE " + Provider.LeaderColumns.TABLE_NAME + " ("
+ Provider.LeaderColumns._ID + " INTEGER PRIMARY KEY,"
+ Provider.LeaderColumns.NAME + " TEXT,"
+ Provider.LeaderColumns.TITLE + " TEXT,"
+ Provider.LeaderColumns.LEVEL + " INTEGER"
+ ");");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + Provider.ProgrammerColumns.TABLE_NAME);
db.execSQL("DROP TABLE IF EXISTS " + Provider.LeaderColumns.TABLE_NAME);
onCreate(db);
}
}
保存跟数据库及表有关的常量,里面只有一个authority:
Provider.java
package com.jacp.demo.provider;
import android.net.Uri;
import android.provider.BaseColumns;
/**
* 保存数据库中的常量
* @author jacp
*
*/
public class Provider {
// 这里只有一个authority
public static final String AUTHORITY = "com.jacp.provider.demo.common";
public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.jacp.demo";
public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.jacp.demo";
/**
* 保存programmer表中用到的常量
* @author jacp
*
*/
public static final class ProgrammerColumns implements BaseColumns {
// 注意这个地方和下面LeaderColumns类中CONTENT_URI一样,用的是同一个AUTHORITY
public static final Uri CONTENT_URI = Uri.parse("content://"+ AUTHORITY +"/programmers");
public static final String TABLE_NAME = "programmer";
public static final String DEFAULT_SORT_ORDER = "age desc";
public static final String NAME = "name";
public static final String AGE = "age";
}
/**
* 保存leader表中用到的常量
* @author mayliang
*
*/
public static final class LeaderColumns implements BaseColumns {
public static final Uri CONTENT_URI = Uri.parse("content://"+ AUTHORITY +"/leaders");
public static final String TABLE_NAME = "leader";
public static final String DEFAULT_SORT_ORDER = "level desc";
public static final String NAME = "name";
public static final String TITLE = "title&