找不到数据库的表,我用sql语句写的,在问问是否要开辟一个子线程

09-19 11:25:32.349: E/SQLiteLog(28075): (1) no such table: classlist
09-19 11:25:32.358: D/AndroidRuntime(28075): Shutting down VM
09-19 11:25:32.358: W/dalvikvm(28075): threadid=1: thread exiting with uncaught exception (group=0xb4ea3288)
09-19 11:25:32.379: E/AndroidRuntime(28075): FATAL EXCEPTION: main
09-19 11:25:32.379: E/AndroidRuntime(28075): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.kakabuli.phonesafe/com.kakabuli.phonesafe.CommonNumberActivity}: android.database.sqlite.SQLiteException: no such table: classlist (code 1): , while compiling: select count(*) from classlist
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2059)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.ActivityThread.access$600(ActivityThread.java:130)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.os.Handler.dispatchMessage(Handler.java:99)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.os.Looper.loop(Looper.java:137)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.ActivityThread.main(ActivityThread.java:4745)
09-19 11:25:32.379: E/AndroidRuntime(28075): at java.lang.reflect.Method.invokeNative(Native Method)
09-19 11:25:32.379: E/AndroidRuntime(28075): at java.lang.reflect.Method.invoke(Method.java:511)
09-19 11:25:32.379: E/AndroidRuntime(28075): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
09-19 11:25:32.379: E/AndroidRuntime(28075): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
09-19 11:25:32.379: E/AndroidRuntime(28075): at dalvik.system.NativeStart.main(Native Method)
09-19 11:25:32.379: E/AndroidRuntime(28075): Caused by: android.database.sqlite.SQLiteException: no such table: classlist (code 1): , while compiling: select count(*) from classlist
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
09-19 11:25:32.379: E/AndroidRuntime(28075): at com.kakabuli.phonesafe.db.dao.CommonNumberDao.getGroupCount(CommonNumberDao.java:23)
09-19 11:25:32.379: E/AndroidRuntime(28075): at com.kakabuli.phonesafe.CommonNumberActivity$CommonNumberAdapter.getGroupCount(CommonNumberActivity.java:63)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.widget.ExpandableListConnector.getCount(ExpandableListConnector.java:397)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.widget.ListView.setAdapter(ListView.java:460)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.widget.ExpandableListView.setAdapter(ExpandableListView.java:470)
09-19 11:25:32.379: E/AndroidRuntime(28075): at com.kakabuli.phonesafe.CommonNumberActivity.onCreate(CommonNumberActivity.java:39)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.Activity.performCreate(Activity.java:5008)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
09-19 11:25:32.379: E/AndroidRuntime(28075): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)

提示是找不到表,你确认没访问错数据库,是不是被重新创建了

1.看一下你访问的数据库有没有错
2.看你要访问的那个数据库中是否存在要访问的表

数据库创建有没有问题,可以运行完看看/data/data/包名/ 下的db文件用sqlite查看器看看。

访问数据库出错了,要看一下数据库的连接是否正确