android – IllegalStateException：尝试使用ContentProvider查询数据库时无效的表

Android 前端之家
前端之家收集整理的这篇文章主要介绍了android – IllegalStateException：尝试使用ContentProvider查询数据库时无效的表，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
尝试使用下面显示的自定义ContentProvider查询我的数据库时,我收到以下错误.

我已经确认该表存在正确的名称,但仍然无效.

我能够使用原始查询,但我希望我们使用ContentProvider模式进行练习.

谢谢,如果您需要更多信息,请与我们联系.

sqliteOpenHelper

  1. public class DatabaseHelper extends sqliteOpenHelper {
  2.  
  3.     private static final String TAG = DatabaseHelper.class.getSimpleName();
  4.  
  5.     private static final String DB_PATH = 
  6.             "/data/data/ashton.android.personal.worktc/databases/";
  7.  
  8.     private static final String DB_NAME = "worktc.db";
  9.  
  10.     private static final int DB_VERSION = 1;
  11.  
  12.     private sqliteDatabase myDatabase;
  13.  
  14.     private final Context context;
  15.  
  16.     public DatabaseHelper(Context context) {
  17.         super(context,DB_NAME,null,DB_VERSION);
  18.         this.context = context;
  19.     }
  20.  
  21.     /**
  22.      * Creates a empty database on the system and rewrites it with your own database.
  23.      * */
  24.     public void createDataBase() throws IOException {
  25.  
  26.         boolean dbExist = this.checkDataBase();
  27.  
  28.         if (dbExist) {
  29.             //do nothing - database already exist
  30.         } else {
  31.  
  32.             Log.e(TAG,"Database does not exist when trying to create it.");
  33.  
  34.             //By calling this method and empty database will be created into the default system path
  35.             //of your application so we are gonna be able to overwrite that database with our database.
  36.             this.getReadableDatabase();
  37.             this.close();
  38.  
  39.             try {
  40.  
  41.                 this.copyDataBase();
  42.  
  43.                 Log.e(TAG,"createDatabase database created");
  44.  
  45.             } catch (IOException e) {
  46.  
  47.                 throw new Error("Error copying database");
  48.  
  49.             }
  50.         }
  51.  
  52.     }
  53.  
  54.     /**
  55.      * Check if the database already exist to avoid re-copying the file each time you open the application.
  56.      * @return true if it exists,false if it doesn't
  57.      */
  58.     private boolean checkDataBase(){
  59.  
  60.         File dbFile = new File(DB_PATH + DB_NAME);
  61.         return dbFile.exists();
  62.  
  63.     }
  64.  
  65.     /**
  66.      * Copies your database from your local assets-folder to the just created empty database in the
  67.      * system folder,from where it can be accessed and handled.
  68.      * This is done by transfering bytestream.
  69.      * */
  70.     private void copyDataBase() throws IOException{
  71.  
  72.         //Open your local db as the input stream
  73.         InputStream myInput = this.context.getAssets().open(DB_NAME);
  74.  
  75.         //Open the empty db as the output stream
  76.         OutputStream myOutput = new FileOutputStream(DB_PATH + DB_NAME);
  77.  
  78.         //transfer bytes from the inputfile to the outputfile
  79.         byte[] buffer = new byte[1024];
  80.         int length;
  81.         while ((length = myInput.read(buffer))>0){
  82.             myOutput.write(buffer,length);
  83.         }
  84.  
  85.         //Close the streams
  86.         myOutput.flush();
  87.         myOutput.close();
  88.         myInput.close();
  89.  
  90.     }
  91.  
  92.     public boolean openDataBase() throws sqlException {
  93.  
  94.         //Open the database
  95.         String myPath = DB_PATH + DB_NAME;
  96.         this.myDatabase = sqliteDatabase.openDatabase(myPath,sqliteDatabase.CREATE_IF_NECESSARY);
  97.         return this.myDatabase != null;
  98.     }
  99.  
  100.     @Override
  101.     public synchronized void close() {
  102.  
  103.         if(this.myDatabase != null)
  104.             this.myDatabase.close();
  105.  
  106.         super.close();
  107.  
  108.     }
  109.  
  110.     @Override
  111.     public void onCreate(sqliteDatabase db) {
  112.         // TODO Auto-generated method stub
  113.  
  114.     }
  115.  
  116.     @Override
  117.     public void onUpgrade(sqliteDatabase db,int oldVersion,int newVersion) {
  118.         // TODO Auto-generated method stub
  119.  
  120.     }
  121. }

内容提供商

  1. public class WorkTCContentProvider extends ContentProvider {
  2.  
  3.     private static final String TAG = WorkTCContentProvider.class.getSimpleName();
  4.  
  5.     public static final String AUTHORITY = 
  6.             "ashton.android.personal.worktc.database";
  7.  
  8.     private static final UriMatcher sURIMatcher = new UriMatcher(UriMatcher.NO_MATCH);
  9.     static {
  10.         sURIMatcher.addURI(
  11.                 AUTHORITY,ProfessionTable.TABLE_NAME,ProfessionTable.PROFESSIONS);
  12.  
  13.         sURIMatcher.addURI(
  14.                 AUTHORITY,ProfessionTable.TABLE_NAME + "/#",ProfessionTable.PROFESSIONS_ID);
  15.     }
  16.  
  17.     private DatabaseHelper database;
  18.  
  19.     @Override
  20.     public int delete(Uri uri,String selection,String[] selectionArgs) {
  21.         // TODO Auto-generated method stub
  22.         return 0;
  23.     }
  24.  
  25.     @Override
  26.     public String getType(Uri uri) {
  27.         // TODO Auto-generated method stub
  28.         return null;
  29.     }
  30.  
  31.     @Override
  32.     public Uri insert(Uri uri,ContentValues values) {
  33.         // TODO Auto-generated method stub
  34.         return null;
  35.     }
  36.  
  37.     @Override
  38.     public boolean onCreate() {
  39.  
  40.         Log.d(TAG,"before database creation");
  41.  
  42.         this.database = new DatabaseHelper(getContext());
  43.         try {
  44.             this.database.createDataBase();
  45.         } catch (IOException e) {
  46.             // TODO Auto-generated catch block
  47.             e.printStackTrace();
  48.         }
  49.         this.database.openDataBase();
  50.         this.database.close();
  51.  
  52.         Log.d(TAG,"after database creation");
  53.  
  54. //      this.database.getWritableDatabase().execsql( "pragma foreign_keys = on;" );
  55.  
  56.         return false;
  57.     }
  58.  
  59.     @Override
  60.     public Cursor query(Uri uri,String[] projection,String[] selectionArgs,String sortOrder) {
  61.  
  62.         sqliteQueryBuilder queryBuilder = new sqliteQueryBuilder();
  63.  
  64.         switch (sURIMatcher.match(uri)) {
  65.         case ProfessionTable.PROFESSIONS:
  66.  
  67.             /*
  68.              * Dont do anything,just do the normal query.
  69.              */
  70.  
  71.             break;
  72.  
  73.         case ProfessionTable.PROFESSIONS_ID:
  74.  
  75.             queryBuilder.appendWhere(ProfessionTable._ID + "=" + uri.getLastPathSegment());
  76.  
  77.             break;
  78.  
  79.         default:
  80.             throw new IllegalArgumentException("Unknown URI: " + uri);
  81.         }
  82.  
  83.         sqliteDatabase db = this.database.getReadableDatabase();
  84.  
  85.         Cursor cursor = queryBuilder.query(
  86.                 db,projection,selection,selectionArgs,sortOrder);
  87.  
  88.         cursor.setNotificationUri(WorkTCApp.getContext().getContentResolver(),uri);
  89.  
  90.         return cursor;
  91.     }
  92.  
  93.     @Override
  94.     public int update(Uri uri,ContentValues values,String[] selectionArgs) {
  95.         // TODO Auto-generated method stub
  96.         return 0;
  97.     }
  98. }

ProfessionTable

  1. public final class ProfessionTable implements BaseColumns {
  2.  
  3.     public static final String TABLE_NAME = "Professions";
  4.  
  5.     public static final Uri URI = 
  6.             Uri.parse("content://" + WorkTCContentProvider.AUTHORITY + "/" + TABLE_NAME);
  7.  
  8.     public static final int PROFESSIONS = 10;
  9.  
  10.     public static final int PROFESSIONS_ID = 11;
  11.  
  12.     public static final String NAME = "name";
  13.  
  14.     public static final String ICON = "icon";
  15.  
  16.     private ProfessionTable() {}
  17. }

错误

  1. 09-08 11:16:18.285: E/AndroidRuntime(11651): FATAL EXCEPTION: main
  2. 09-08 11:16:18.285: E/AndroidRuntime(11651): java.lang.RuntimeException: Unable to start activity ComponentInfo{ashton.android.personal.worktc/ashton.android.personal.worktc.controllers.WorkActivity}: java.lang.IllegalStateException: Invalid tables
  3. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1651)
  4. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1667)
  5. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.ActivityThread.access$1500(ActivityThread.java:117)
  6. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:935)
  7. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.os.Handler.dispatchMessage(Handler.java:99)
  8. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.os.Looper.loop(Looper.java:130)
  9. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.ActivityThread.main(ActivityThread.java:3687)
  10. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at java.lang.reflect.Method.invokeNative(Native Method)
  11. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at java.lang.reflect.Method.invoke(Method.java:507)
  12. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:842)
  13. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:600)
  14. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at dalvik.system.NativeStart.main(Native Method)
  15. 09-08 11:16:18.285: E/AndroidRuntime(11651): Caused by: java.lang.IllegalStateException: Invalid tables
  16. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.database.sqlite.sqliteDatabase.findEditTable(sqliteDatabase.java:1127)
  17. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.database.sqlite.sqliteQueryBuilder.query(sqliteQueryBuilder.java:330)
  18. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.database.sqlite.sqliteQueryBuilder.query(sqliteQueryBuilder.java:280)
  19. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at ashton.android.personal.worktc.database.worktcContentProvider.query(worktcContentProvider.java:104)
  20. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.content.ContentProvider$Transport.query(ContentProvider.java:187)
  21. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.content.ContentResolver.query(ContentResolver.java:267)
  22. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at ashton.android.personal.worktc.views.WorkView.onFinishInflate(WorkView.java:96)
  23. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.view.LayoutInflater.rInflate(LayoutInflater.java:631)
  24. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.view.LayoutInflater.inflate(LayoutInflater.java:408)
  25. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.view.LayoutInflater.inflate(LayoutInflater.java:320)
  26. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.view.LayoutInflater.inflate(LayoutInflater.java:276)
  27. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.view.View.inflate(View.java:8884)
  28. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at ashton.android.personal.worktc.controllers.WorkActivity.onCreate(WorkActivity.java:30)
  29. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
  30. 09-08 11:16:18.285: E/AndroidRuntime(11651):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1615)
  31. 09-08 11:16:18.285: E/AndroidRuntime(11651):    ... 11 more

解决方法

从错误： 
  1. Caused by: java.lang.IllegalStateException: Invalid tables

我注意到你没有调用setTables()：

  1. sqliteQueryBuilder queryBuilder = new sqliteQueryBuilder();
  2. queryBuilder.setTables(ProfessionalTable.TABLE_NAME);

在尝试运行查询之前.

猜你在找的Android相关文章

directBootAware 和 defaultToDeviceProtectedStorage
以下为个人理解，如错请评 CE: 凭据加密 (CE) 存储空间, 实际路径/data/user_ce/ DE: 设备...
[Android] EventLogTags.logtags简单使用
转载来源：https://blog.csdn.net/yfbdxz/article/details/114702144 用EventLog.writeEve...
Android事件分发机制详解
事件分发机制详解 一、基础知识介绍 1、经常用的事件有：MotionEvent.ACTION_DOWN，Motion...
Android性能优化——之防止内存泄露
又是好久没有写博客了，一直都比较忙，最近终于有时间沉淀和整理一下最近学到和解决的一些...
Android 性能优化——之控件的优化
Android性能优化——之控件的优化 前面讲了图像的优化，接下来分享一下控件的性能优化，这...
安卓Native和H5页面进行交互
安卓Native和H5页面进行交互 1、H5页面调用安卓Native界面 1）通过给webView添加JsInterfa...
Android 性能优化——之图片的优化
Android性能优化——之图片的优化在Android性能优化中，我们会发现占内存最大的和对性能影...
AndroidStudio 各种异常情况处理大法
最近使用AndroidStudio出现了.java文件，显示为xml文件等问题，通过各种采坑之后，发现删除...
FragmentContainerView、ViewPager、ViewPager2与 BottomNaviagtionView结合使用的区别
FragmentContainerView、ViewPager、ViewPager2与 BottomNaviagtionView结合使用的区别
[android]android下apk的安装过程
/********************2016年4月23日更新********************************/ 知乎：有什么...
iOSAndroidSwiftHybridCocos2d-xFlutterXcodeSilverlightcocoaCordova
调试桥筛选栏假异步不会丢失AndPermissio权限申请抽屉式systemUI信号栏多行排列跨多行显示viewmode数据共享录制语音视频通话多行显示Studio3.5拉伸控件望远镜发动态走势图点赞控件显示牌冷启动v3签名v2签名v1签名本地html外接键盘流式标签