我想我的数据库中查询第二表的数据。
我能够插入到数据库中(或我带领相信它是成功的)
我修改的版本号,但似乎仍有效果都没有。
任何人都可以看到我做了什么错在这里?
目前,我发现了以下错误:
logcat的:
20 01-20:32:15.076:E / AndroidRuntime(303):致命异常:主要01-20 20:32:15.076:E / AndroidRuntime(303):了java.lang.RuntimeException:无法启动活动ComponentInfo {com.example.flybase2 / com.example.flybase2.ViewAppointments}:android.database.sqlite.SQLiteException :没有这样的表:appointmentTable:,编译时:选择_id,APP_NAME,APP_TYPE,APP_TIME,app_date,app_comments FROM appointmentTable ORDER BY ASC APP_NAME01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663)01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679)01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.ActivityThread.access $ 2300(ActivityThread.java:125)01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.ActivityThread $ H.handleMessage(ActivityThread.java:2033)01-20 20:32:15.076:E / AndroidRuntime(303):在android.os.Handler.dispatchMessage(Handler.java:99)01-20 20:32:15.076:E / AndroidRuntime(303):在android.os.Looper.loop(Looper.java:123)01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.ActivityThread.main(ActivityThread.java:4627)01-20 20:32:15.076:E / AndroidRuntime(303):在java.lang.reflect.Method.invokeNative(本机方法)01-20 20:32:15.076:E / AndroidRuntime(303):在java.lang.reflect.Method.invoke(Method.java:521)01-20 20:32:15.076:E / AndroidRuntime(303):在com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run(ZygoteInit.java:868)01-20 20:32:15.076:E / AndroidRuntime(303):在com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)01-20 20:32:15.076:E / AndroidRuntime(303):在dalvik.system.NativeStart.main(本机方法)01-20 20:32:15.076:E / AndroidRuntime(303):android.database.sqlite.SQLiteException:没有这样的表:产生的原因appointmentTable:,编译时:选择_id,APP_NAME,APP_TYPE,APP_TIME,app_date,app_comments FROM appointmentTable ORDER BY ASC APP_NAME01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteCompiledSql.native_compile(本机方法)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteCompiledSql<&初始化GT;(SQLiteCompiledSql.java:64)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteProgram<&初始化GT;(SQLiteProgram.java:80)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteQuery<&初始化GT;(SQLiteQuery.java:46)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1229)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1184)01-20 20:32:15.076:E / AndroidRuntime(303):在android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1301)01-20 20:32:15.076:E / AndroidRuntime(303):在com.example.flybase2.DBHandler.getAppointmentsData(DBHandler.java:325)01-20 20:32:15.076:E / AndroidRuntime(303):在com.example.flybase2.ViewAppointments.onCreate(ViewAppointments.java:34)01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)01-20 20:32:15.076:E / AndroidRuntime(303):在android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627)
列变量:
公共静态最后弦乐KEY_ROWAPPID =_appid;公共静态最后弦乐KEY_NAMEAPP =APP_NAME公共静态最后弦乐KEY_TYPEAPP =APP_TYPE;公共静态最后弦乐KEY_TIMEAPP =APP_TIME;公共静态最后弦乐KEY_DATEAPP =app_date;公共静态最后弦乐KEY_COMMENTAPP =app_comments;公共静态最后弦乐KEY_ALARM =app_alarm;
表名称和版本:
私有静态字符串DATABASE_TABLEAPP =appointmentTable;私有静态诠释DATABASE_VERSIONAPP = 1;
我的继承人上创建方式:
@覆盖 公共无效的onCreate(SQLiteDatabase DB){ db.execSQL(CREATE TABLE+ DATABASE_TABLE +(+ KEY_ROWID +INTEGER PRIMARY KEY AUTOINCREMENT,+ KEY_NAME +TEXT NOT NULL,+ KEY_TEL +TEXT NOT NULL,+ KEY_EMAIL +TEXT NOT NULL,+ KEY_COMMENTS +TEXT NOT NULL); ); db.execSQL(CREATE TABLE+ DATABASE_TABLEAPP +(+ KEY_ROWAPPID +INTEGER PRIMARY KEY AUTOINCREMENT,+ KEY_NAMEAPP +TEXT NOT NULL,+ KEY_TYPEAPP +TEXT NOT NULL,+ KEY_TIMEAPP +TEXT NOT NULL,+ KEY_DATEAPP +TEXT NOT NULL,+ KEY_COMMENTAPP +TEXT NOT NULL,+ KEY_ALARM +布尔NOT NULL); );
在升级:
@覆盖 公共无效onUpgrade(SQLiteDatabase分贝,INT oldVersion,诠释静态网页){ db.execSQL(DROP TABLE IF EXISTS+ DATABASE_TABLE); 的onCreate(DB); db.execSQL(DROP TABLE IF EXISTS+ DATABASE_TABLEAPP); 的onCreate(DB); }
用于查询表方法:
公共光标getAppointmentsData(){ 的String [] =列新的String [] {KEY_ROWAPPID,KEY_NAMEAPP,KEY_TYPEAPP,KEY_TIMEAPP,KEY_DATEAPP,KEY_COMMENTAPP}; 光标C = ourDatabase.query(DATABASE_TABLEAPP,列,NULL,NULL,NULL,NULL,KEY_NAMEAPP +ASC,NULL); 返回℃;
解决方案
删除第一个的onCreate(DB)
电话。
@覆盖公共无效onUpgrade(SQLiteDatabase分贝,INT oldVersion,诠释静态网页){ db.execSQL(DROP TABLE IF EXISTS+ DATABASE_TABLE); db.execSQL(DROP TABLE IF EXISTS+ DATABASE_TABLEAPP); 的onCreate(DB);}
I'm trying to query the data of the second table within my database.
I am able to insert into the database (or am led to believe it is successful)
I have altered the version numbers, but this still seems to have effect at all.
Can anyone see what I have done wrong here?
Currently I'm getting the following error:
Logcat:
01-20 20:32:15.076: E/AndroidRuntime(303): FATAL EXCEPTION: main
01-20 20:32:15.076: E/AndroidRuntime(303): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.flybase2/com.example.flybase2.ViewAppointments}: android.database.sqlite.SQLiteException: no such table: appointmentTable: , while compiling: SELECT _id, app_name, app_type, app_time, app_date, app_comments FROM appointmentTable ORDER BY app_name ASC
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.ActivityThread.access$2300(ActivityThread.java:125)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.os.Handler.dispatchMessage(Handler.java:99)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.os.Looper.loop(Looper.java:123)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.ActivityThread.main(ActivityThread.java:4627)
01-20 20:32:15.076: E/AndroidRuntime(303): at java.lang.reflect.Method.invokeNative(Native Method)
01-20 20:32:15.076: E/AndroidRuntime(303): at java.lang.reflect.Method.invoke(Method.java:521)
01-20 20:32:15.076: E/AndroidRuntime(303): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
01-20 20:32:15.076: E/AndroidRuntime(303): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
01-20 20:32:15.076: E/AndroidRuntime(303): at dalvik.system.NativeStart.main(Native Method)
01-20 20:32:15.076: E/AndroidRuntime(303): Caused by: android.database.sqlite.SQLiteException: no such table: appointmentTable: , while compiling: SELECT _id, app_name, app_type, app_time, app_date, app_comments FROM appointmentTable ORDER BY app_name ASC
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:64)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:80)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:46)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1229)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1184)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1301)
01-20 20:32:15.076: E/AndroidRuntime(303): at com.example.flybase2.DBHandler.getAppointmentsData(DBHandler.java:325)
01-20 20:32:15.076: E/AndroidRuntime(303): at com.example.flybase2.ViewAppointments.onCreate(ViewAppointments.java:34)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
01-20 20:32:15.076: E/AndroidRuntime(303): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627)
Column variables:
public static final String KEY_ROWAPPID = "_appid";
public static final String KEY_NAMEAPP = "app_name";
public static final String KEY_TYPEAPP = "app_type";
public static final String KEY_TIMEAPP = "app_time";
public static final String KEY_DATEAPP = "app_date";
public static final String KEY_COMMENTAPP = "app_comments";
public static final String KEY_ALARM = "app_alarm";
Table name and version:
private static String DATABASE_TABLEAPP = "appointmentTable";
private static int DATABASE_VERSIONAPP = 1;
Heres my on create method:
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" +
KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_NAME + " TEXT NOT NULL, " +
KEY_TEL + " TEXT NOT NULL, " +
KEY_EMAIL + " TEXT NOT NULL, " +
KEY_COMMENTS + " TEXT NOT NULL);"
);
db.execSQL("CREATE TABLE " + DATABASE_TABLEAPP + " (" +
KEY_ROWAPPID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_NAMEAPP + " TEXT NOT NULL, " +
KEY_TYPEAPP + " TEXT NOT NULL, " +
KEY_TIMEAPP + " TEXT NOT NULL, " +
KEY_DATEAPP + " TEXT NOT NULL, " +
KEY_COMMENTAPP + " TEXT NOT NULL, " +
KEY_ALARM + " BOOLEAN NOT NULL);"
);
On upgrade:
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);
onCreate(db);
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLEAPP);
onCreate(db);
}
Method used for querying the table:
public Cursor getAppointmentsData() {
String [] columns = new String[]{KEY_ROWAPPID, KEY_NAMEAPP, KEY_TYPEAPP, KEY_TIMEAPP, KEY_DATEAPP, KEY_COMMENTAPP};
Cursor c = ourDatabase.query(DATABASE_TABLEAPP, columns, null, null, null, null, KEY_NAMEAPP + " ASC", null);
return c;
解决方案
Drop the first onCreate( db )
call.
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLEAPP);
onCreate(db);
}