SQLite创建数据库while compiling: testsystem.db

Question

android.database.sqlite.SQLiteException: near "testsystem": syntax error (code 1): , while compiling: testsystem.db
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
at com.gggd.sunny.testsystem.tools.DBOpenHelper.onCreate(DBOpenHelper.java:63)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
at com.gggd.sunny.testsystem.tools.LibraryAndTestDB.(LibraryAndTestDB.java:21)
at com.gggd.sunny.testsystem.MakeTestModeActivity.insertData(MakeTestModeActivity.java:217)
at com.gggd.sunny.testsystem.MakeTestModeActivity$2.onClick(MakeTestModeActivity.java:181)
at com.android.internal.app.AlertController$ButtonHandler.handleMessage(AlertController.java:163)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:154)
at android.app.ActivityThread.main(ActivityThread.java:5527)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:739)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:629)

Answer 1

你创建数据库的sql脚本有错误，错误临近 "testsystem" 这个单词附近，自己检查下。