E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.tw.flag.myuniversity, PID: 1890
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.tw.flag.myuniversity/com.tw.flag.myuniversity.Award}: android.database.sqlite.SQLiteException: near "TABLEnotes": syntax error (code 1): , while compiling: CREATE TABLEnotes(_id INTEGER PRIMARY KEY AUTOINCREMENT,content TEXT NOT NULL,time TEXT NOT NULL,mode INTEGER DEFAULT 1)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2416)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)
at android.app.ActivityThread.-wrap11(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:148)
at android.app.ActivityThread.main(ActivityThread.java:5417)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
Caused by: android.database.sqlite.SQLiteException: near "TABLEnotes": syntax error (code 1): , while compiling: CREATE TABLEnotes(_id INTEGER PRIMARY KEY AUTOINCREMENT,content TEXT NOT NULL,time TEXT NOT NULL,mode INTEGER DEFAULT 1)
代碼是這樣的：
package com.tw.flag.myuniversity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class NoteDataBase extends SQLiteOpenHelper {
public static final String TABLE_NAME = "notes";
public static final String CONTENT = "content";
public static final String ID = "_id";
public static final String TIME = "time";
public static final String MODE = "mode";
public NoteDataBase(Context context) {
super(context, "notes", null, 1);
}
// public NoteDataBase(Context context){super(context,"notes",null,1);}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE "+ TABLE_NAME
+ "("
+ ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ CONTENT + " TEXT NOT NULL,"
+ TIME + " TEXT NOT NULL,"
+ MODE + " INTEGER DEFAULT 1)"
);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
uj5u.com熱心網友回復：
create table后面要加空格再加表名uj5u.com熱心網友回復：
CREATE TABLEnotes(_id INTEGER PRIMARY KEY AUTOINCREMENT,content TEXT NOT NULL,time TEXT NOT NULL,mode INTEGER DEFAULT 1)uj5u.com熱心網友回復：
如何定位問題：把你拼接的sql陳述句列印出來，看看那里錯了就知道了uj5u.com熱心網友回復：
怎么列印呀？剛入門還不太會
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/58740.html
標籤：Android
下一篇：求求大佬解決一哈adt黑屏問題