请求android studio的帮助 [英] Please need help with android studio

问题描述

所以，我决定使用sqlite数据库创建一个应用程序。然后添加一个添加按钮，但点击它时，我有一条消息（该应用程序已停止工作）。下面我将给出logcat详细信息：

So, I decided to create an application with sqlite database. Then put an add button but when click on it, I have a message("The app has stopped working"). Below I gonna give logcat details:

03-04 11:35:09.210 17673-17673/com.a00003454.tyreshopapp E/AndroidRuntime: FATAL EXCEPTION: main
                                                                           Process: com.a00003454.tyreshopapp, PID: 17673
                                                                           java.lang.RuntimeException: Unable to start activity ComponentInfo{com.a00003454.tyreshopapp/com.a00003454.tyreshopapp.AllTyresActivity}: android.database.sqlite.SQLiteException: near "table": syntax error (code 1): , while compiling: CREATE TABLE Tyre.table(ID INTEGER PRIMARY KEY AUTOINCREMENT, TyreBrand TEXT Size INTEGER Cost INTEGER );
                                                                               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 "table": syntax error (code 1): , while compiling: CREATE TABLE Tyre.table(ID INTEGER PRIMARY KEY AUTOINCREMENT, TyreBrand TEXT Size INTEGER Cost INTEGER );
                                                                               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.<init>(SQLiteProgram.java:58)
                                                                               at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
                                                                               at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
                                                                               at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
                                                                               at com.a00003454.tyreshopapp.TyreDatabaseHelper.onCreate(TyreDatabaseHelper.java:33)
                                                                               at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
                                                                               at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
                                                                               at com.a00003454.tyreshopapp.TyreDatabaseHelper.select(TyreDatabaseHelper.java:59)
                                                                               at com.a00003454.tyreshopapp.AllTyresActivity.onCreate(AllTyresActivity.java:28)
                                                                               at android.app.Activity.performCreate(Activity.java:6237)
                                                                               at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)
                                                                               at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)
                                                                               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) 
03-04 11:35:12.643 17673-17673/com.a00003454.tyreshopapp I/Process: Sending signal. PID: 17673 SIG: 9

我尝试过：



在我看来，sql语句存在问题并尝试更改很多次但没有结果，这里是：

What I have tried:

It seems to me that there is a problem with sql statement and tried to change lots of times but no result and here it is:

String sql = "CREATE TABLE " + Table_Name + "(" +
               COL_1 + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
               COL_2 + " TEXT " +
               COL_3 + " INTEGER " +
               COL_4 + " INTEGER " +
               ");";

推荐答案

H.handleMessage（ActivityThread.java:1344）
at android.os.Handler.dispatchMessage （Handler.java:102）
在android.os.Looper.loop（Looper.java:148）
在android.app.ActivityThread.main（ActivityThread.java:5417）
at java.lang.reflect.Method.invoke（Native Method）
at com.android.internal.os.ZygoteInit

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)
引起：android.database.sqlite.SQLiteException：neartable：语法错误（代码1）:,同时编译：CREATE TABLE Tyre.table（ID INTEGER PRIMARY KEY AUTOINCREMENT，TyreBrand TEXT Size INTEGER Cost INTEGER）;
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）
在android.database.sqlite.SQLiteSession.prepare（SQLiteSession.java:588）
在android.database.sqlite.SQLiteProgram。< init>（SQLiteProgram .java：58）
在android.database.sqlite.SQLiteStatement。< init>（SQLiteStatement.java:31）
在android.database.sqlite.SQLiteDatabase.executeSql（SQLiteDatabase.java:1674）
在android.database.sqlite.SQLiteDatabase.execSQL（SQLiteDatabase.java:1605）
at com.a00003454.tyreshopapp.TyreDatabaseHelper .onCreate（TyreDatabaseHelper.java:33）
在android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked（SQLiteOpenHelper.java:251）
在android.database.sqlite.SQLiteOpenHelper.getWritableDatabase（SQLiteOpenHelper.java:163 ）
at com.a00003454.tyreshopapp.TyreDatabaseHelper.select（TyreDatabaseHelper.java:59）
at com.a00003454.tyreshopapp.AllTyresActivity.onCreate（AllTyresActivity.java:28）
at android.app.Activity.performCreate（Activity.java:6237）
at android.app.Instrumentation。 callActivityOnCreate（Instrumentation.java:1107）
at android.app.ActivityThread.performLaunchActivity（ActivityThread.java:2369）
at android.app.ActivityThread.handleLaunchActivity（ActivityThread.java:2476） 
在android.app.ActivityThread.-wrap11（ActivityThread.java） 
在android.app.ActivityThread

MethodAndArgsCaller.run(ZygoteInit.java:726) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616) Caused by: android.database.sqlite.SQLiteException: near "table": syntax error (code 1): , while compiling: CREATE TABLE Tyre.table(ID INTEGER PRIMARY KEY AUTOINCREMENT, TyreBrand TEXT Size INTEGER Cost INTEGER ); 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.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674) at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605) at com.a00003454.tyreshopapp.TyreDatabaseHelper.onCreate(TyreDatabaseHelper.java:33) at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251) at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163) at com.a00003454.tyreshopapp.TyreDatabaseHelper.select(TyreDatabaseHelper.java:59) at com.a00003454.tyreshopapp.AllTyresActivity.onCreate(AllTyresActivity.java:28) at android.app.Activity.performCreate(Activity.java:6237) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)  at android.app.ActivityThread.-wrap11(ActivityThread.java)  at android.app.ActivityThread

H.handleMessage（ActivityThread.java:1344） 
在android.os.Handler.dispatchMessage（Handler.java:102） 
在android.os.Looper.loop（Looper.java:148） 
在android.app.ActivityThread.main（ActivityThread.java:5417） 
at java.lang.reflect.Method.invoke（Native Method） 
at com.android.internal.os.ZygoteInit

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

这篇关于请求android studio的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！