Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.47 KB | None | 0 0
  1. public ArrayList<market> getMarkets(String table) {
  2.  
  3. ArrayList<market> markets = new ArrayList<market>();
  4. market mrkt = new market();
  5.  
  6. SQLiteDatabase db = this.getReadableDatabase();
  7. Cursor cursor = db.rawQuery("SELECT * FROM " + table, null);
  8.  
  9. if(cursor.moveToFirst()) {
  10. do {
  11. mrkt.market_id = cursor.getInt(cursor.getColumnIndex("marketid"));
  12. mrkt.market_name = cursor.getString(cursor.getColumnIndex("name"));
  13. mrkt.market_telno = cursor.getInt(cursor.getColumnIndex("telno"));
  14. mrkt.market_location = cursor.getString(cursor.getColumnIndex("location"));
  15. mrkt.market_hours = cursor.getString(cursor.getColumnIndex("hours"));
  16. markets.add(mrkt);
  17. }while(cursor.moveToNext());
  18. }
  19.  
  20. cursor.close();
  21. db.close();
  22. return markets;
  23. }
  24.  
  25. dbh = new DataBaseHelper(getApplicationContext());
  26. markets = new ArrayList<market>();
  27. marketListView = (ListView) findViewById(R.id.listViewMarkets);
  28.  
  29. markets = dbh.getMarkets("markets");
  30.  
  31.  
  32.  
  33. // Create The Adapter with passing ArrayList as 3rd parameter
  34. ArrayAdapter<market> arrayAdapter =
  35. new ArrayAdapter<market>(this,android.R.layout.simple_list_item_1, markets);
  36.  
  37. // Set The Adapter
  38. marketListView.setAdapter(arrayAdapter);
  39.  
  40. <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  41. android:layout_width="match_parent"
  42. android:layout_height="match_parent"
  43. android:orientation="vertical" >
  44.  
  45. <ListView
  46. android:id="@+id/listViewMarkets"
  47. android:layout_width="fill_parent"
  48. android:layout_height="fill_parent"
  49. android:dividerHeight="0.1dp"
  50. android:divider="#0000CC"
  51. >
  52. </ListView>
  53.  
  54. </LinearLayout>
  55.  
  56. 04-09 16:32:00.125: W/dalvikvm(17103): threadid=1: thread exiting with uncaught exception (group=0x41685c80)
  57. 04-09 16:32:00.130: E/AndroidRuntime(17103): FATAL EXCEPTION: main
  58. 04-09 16:32:00.130: E/AndroidRuntime(17103): Process: com.example.deneme, PID: 17103
  59. 04-09 16:32:00.130: E/AndroidRuntime(17103): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.deneme/com.example.deneme.MainActivity}: android.database.sqlite.SQLiteException: no such table: markets (code 1): , while compiling: SELECT * FROM markets
  60. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2215)
  61. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2265)
  62. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.ActivityThread.access$800(ActivityThread.java:145)
  63. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1206)
  64. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.os.Handler.dispatchMessage(Handler.java:102)
  65. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.os.Looper.loop(Looper.java:136)
  66. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.ActivityThread.main(ActivityThread.java:5081)
  67. 04-09 16:32:00.130: E/AndroidRuntime(17103): at java.lang.reflect.Method.invokeNative(Native Method)
  68. 04-09 16:32:00.130: E/AndroidRuntime(17103): at java.lang.reflect.Method.invoke(Method.java:515)
  69. 04-09 16:32:00.130: E/AndroidRuntime(17103): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:781)
  70. 04-09 16:32:00.130: E/AndroidRuntime(17103): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
  71. 04-09 16:32:00.130: E/AndroidRuntime(17103): at dalvik.system.NativeStart.main(Native Method)
  72. 04-09 16:32:00.130: E/AndroidRuntime(17103): Caused by: android.database.sqlite.SQLiteException: no such table: markets (code 1): , while compiling: SELECT * FROM markets
  73. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
  74. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
  75. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
  76. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
  77. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
  78. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
  79. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
  80. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
  81. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
  82. 04-09 16:32:00.130: E/AndroidRuntime(17103): at com.example.deneme.DataBaseHelper.getMarkets(DataBaseHelper.java:165)
  83. 04-09 16:32:00.130: E/AndroidRuntime(17103): at com.example.deneme.MainActivity.onCreate(MainActivity.java:25)
  84. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.Activity.performCreate(Activity.java:5231)
  85. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087)
  86. 04-09 16:32:00.130: E/AndroidRuntime(17103): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2169)
  87. 04-09 16:32:00.130: E/AndroidRuntime(17103): ... 11 more
  88.  
  89. dbh = new DataBaseHelper(null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement