마스터Q&A 안드로이드는 안드로이드 개발자들의 질문과 답변을 위한 지식 커뮤니티 사이트입니다. 안드로이드펍에서 운영하고 있습니다. [사용법, 운영진]

장바구니 DB 연동 과정에서 오류가 납니다 [closed]

0 추천

오류가 나는 부분은 db.execSQL(sb.toString()); 입니다 

제 DB생성 코드입니다.

 

로그캣은

 Process: com.example.jangan.myapplication, PID: 15143
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.jangan.myapplication/com.example.jangan.myapplication.MainActivity}: android.database.sqlite.SQLiteException: incomplete input (code 1 SQLITE_ERROR): , while compiling: CREATE TABLE Cart( _ID INTEGER PRIMARY KEY AUTOINCREMENT, Title TEXT, Description TEXT, Count TEXT,  Price TEXT,
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2913)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3048)
        at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:78)
        at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108)
        at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68)
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1808)
        at android.os.Handler.dispatchMessage(Handler.java:106)
        at android.os.Looper.loop(Looper.java:193)
        at android.app.ActivityThread.main(ActivityThread.java:6669)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:493)
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858)
     Caused by: android.database.sqlite.SQLiteException: incomplete input (code 1 SQLITE_ERROR): , while compiling: CREATE TABLE Cart( _ID INTEGER PRIMARY KEY AUTOINCREMENT, Title TEXT, Description TEXT, Count TEXT,  Price TEXT,
        at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
        at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903)
        at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:514)
        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:1769)
        at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1698)
        at com.example.jangan.myapplication.DBHelper_Cart.onCreate(DBHelper_Cart.java:40)
        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:393)
        at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:322)
        at com.example.jangan.myapplication.DBHelper_Cart.GetAllCart(DBHelper_Cart.java:105)
        at com.example.jangan.myapplication.CartAdapter.<init>(CartAdapter.java:26)
        at com.example.jangan.myapplication.MainActivity.onCreate(MainActivity.java:24)
        at android.app.Activity.performCreate(Activity.java:7136)
        at android.app.Activity.performCreate(Activity.java:7127)
        at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1271)
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2893)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3048) 
        at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:78) 
        at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108) 
        at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68) 
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1808) 
        at android.os.Handler.dispatchMessage(Handler.java:106) 
        at android.os.Looper.loop(Looper.java:193) 
        at android.app.ActivityThread.main(ActivityThread.java:6669) 
        at java.lang.reflect.Method.invoke(Native Method) 
        at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:493) 
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858) 

 

이렇게 나오네요ㅜㅠㅠ Caused by 인 SQLiteProgram에서는 

이부분에서 cannot resolved 오류가 뜨고 있구요 SQLiteProgram 파일은 처음 건드려보는거라

어디를 어떻게 해야하는지 모르겠네요ㅠㅠㅠ 

도움 부탁드리겠습니다!

질문을 종료한 이유: 해결!
그로악 (270 포인트) 님이 2018년 10월 10일 질문
그로악님이 2018년 10월 26일 closed

1개의 답변

0 추천
스스로 고쳤습니다! 코드 문제였네요 db마지막에 ); 를 닫아주지 않아 생겼던 오류였습니다ㅠㅠ
그로악 (270 포인트) 님이 2018년 10월 10일 답변
...