API tools faq
paste
Guest User

Untitled

a guest
Jan 19th, 2018
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.90 KB | None | 0 0
raw download clone embed print report
  1. 1.)public void addToCart(Order order){
  2. SQLiteDatabase db = getReadableDatabase();
  3. String query = String.format("INSERT INTO OrderDetail(Productid,ProductName,Quantity,Price) VALUES('%s','%s','%s','%s');",
  4. order.getProductid(),
  5. order.getProductName(),
  6. order.getQuantity(),
  7. order.getPrice());
  8. db.execSQL(query);
  9. }
  10.  
  11. 2.)btncart = (FloatingActionButton)findViewById(R.id.btncart);
  12. btncart.setOnClickListener(new View.OnClickListener() {
  13. @Override
  14. public void onClick(View v) {
  15. new Database(FoodDetails.this).addToCart(new Order(
  16. foodId,
  17. currentFood.getName(),
  18. numberButton.getNumber(),
  19. currentFood.getPrice()
  20. ));
  21. Toast.makeText(FoodDetails.this,"Added to cart",Toast.LENGTH_SHORT).show();
  22. }
  23. });
  24.  
  25. 01-19 17:14:23.035 3876-3876/com.k.menu E/SQLiteAssetHelper: Couldn't open eatitDb.db for writing (will try read-only):
  26. com.readystatesoftware.sqliteasset.SQLiteAssetHelper$SQLiteAssetException: Missing databases/eatitDb.db file (or .zip, .gz archive) in assets, or target folder not writable
  27. at android.content.res.AssetManager.openAsset(Native Method)
  28. at android.content.res.AssetManager.open(AssetManager.java:347)
  29. at android.content.res.AssetManager.open(AssetManager.java:321)
  30. at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.copyDatabaseFromAssets(SQLiteAssetHelper.java:436)
  31. at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.createOrOpenDatabase(SQLiteAssetHelper.java:400)
  32. at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getWritableDatabase(SQLiteAssetHelper.java:176)
  33. at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:254)
  34. at com.k.menu.Database.Database.addToCart(Database.java:54)
  35. at com.k.menu.FoodDetails$1.onClick(FoodDetails.java:49)
  36. at android.view.View.performClick(View.java:5637)
  37. at android.view.View$PerformClick.run(View.java:22429)
  38. at android.os.Handler.handleCallback(Handler.java:751)
  39. at android.os.Handler.dispatchMessage(Handler.java:95)
  40. at android.os.Looper.loop(Looper.java:154)
  41. at android.app.ActivityThread.main(ActivityThread.java:6119)
  42. at java.lang.reflect.Method.invoke(Native Method)
  43. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
  44. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
  45. 01-19 17:14:23.035 3876-3876/com.k.menu E/SQLiteLog: (14) cannot open file at line 32460 of [69906880ce]
  46. 01-19 17:14:23.035 3876-3876/com.k.menu E/SQLiteLog: (14) os_unix.c:32460: (2) open(/data/user/0/com.k.menu/databases/eatitDb.db) -
  47. 01-19 17:14:23.036 3876-3876/com.k.menu E/SQLiteDatabase: Failed to open database '/data/user/0/com.k.menu/databases/eatitDb.db'.
  48. android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
  49. at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
  50. at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
  51. at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
  52. at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
  53. at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
  54. at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
  55. at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:808)
  56. at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:793)
  57. at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:696)
  58. at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:671)
  59. at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:264)
  60. at com.k.menu.Database.Database.addToCart(Database.java:54)
  61. at com.k.menu.FoodDetails$1.onClick(FoodDetails.java:49)
  62. at android.view.View.performClick(View.java:5637)
  63. at android.view.View$PerformClick.run(View.java:22429)
  64. at android.os.Handler.handleCallback(Handler.java:751)
  65. at android.os.Handler.dispatchMessage(Handler.java:95)
  66. at android.os.Looper.loop(Looper.java:154)
  67. at android.app.ActivityThread.main(ActivityThread.java:6119)
  68. at java.lang.reflect.Method.invoke(Native Method)
  69. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
  70. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
  71. 01-19 17:14:23.036 3876-3876/com.k.menu D/AndroidRuntime: Shutting down VM
  72. 01-19 17:14:23.036 3876-3876/com.k.menu E/AndroidRuntime: FATAL EXCEPTION: main
  73. Process: com.k.menu, PID: 3876
  74. android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
  75. at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
  76. at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
  77. at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
  78. at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
  79. at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
  80. at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
  81. at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:808)
  82. at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:793)
  83. at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:696)
  84. at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:671)
  85. at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:264)
  86. at com.k.menu.Database.Database.addToCart(Database.java:54)
  87. at com.k.menu.FoodDetails$1.onClick(FoodDetails.java:49)
  88. at android.view.View.performClick(View.java:5637)
  89. at android.view.View$PerformClick.run(View.java:22429)
  90. at android.os.Handler.handleCallback(Handler.java:751)
  91. at android.os.Handler.dispatchMessage(Handler.java:95)
  92. at android.os.Looper.loop(Looper.java:154)
  93. at android.app.ActivityThread.main(ActivityThread.java:6119)
  94. at java.lang.reflect.Method.invoke(Native Method)
  95. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
  96. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!