Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.50 KB | None | 0 0
  1. mDatabaseHelper = new DataBaseHelper(this, "mydatabase.db", null, 1);
  2. mSqLiteDatabase = mDatabaseHelper.getWritableDatabase();
  3.  
  4. Cursor cursor = mSqLiteDatabase.query(DataBaseHelper.DATABASE_TABLE, new String[]{
  5. DataBaseHelper.NAME,
  6. DataBaseHelper.NUMBER},
  7. null,null,null,null,null);
  8.  
  9. Process: ru.startandroid.begin, PID: 12643
  10. java.lang.RuntimeException: Unable to start activity ComponentInfo{ru.startandroid.begin/ru.startandroid.begin.StartActivity}: android.database.sqlite.SQLiteException: no such table: database1 (code 1): , while compiling: SELECT name, number FROM database1
  11. #################################################################
  12. Error Code : 1 (SQLITE_ERROR)
  13. Caused By : SQL(query) error or missing database.
  14. (no such table: database1 (code 1): , while compiling: SELECT name, number FROM database1)
  15. #################################################################
  16. at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3184)
  17. at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3294)
  18. at android.app.ActivityThread.access$1000(ActivityThread.java:210)
  19. at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1704)
  20. at android.os.Handler.dispatchMessage(Handler.java:102)
  21. at android.os.Looper.loop(Looper.java:145)
  22. at android.app.ActivityThread.main(ActivityThread.java:6938)
  23. at java.lang.reflect.Method.invoke(Native Method)
  24. at java.lang.reflect.Method.invoke(Method.java:372)
  25. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
  26. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
  27. Caused by: android.database.sqlite.SQLiteException: no such table: database1 (code 1): , while compiling: SELECT name, number FROM database1
  28. #################################################################
  29. Error Code : 1 (SQLITE_ERROR)
  30. Caused By : SQL(query) error or missing database.
  31. (no such table: database1 (code 1): , while compiling: SELECT name, number FROM database1)
  32. #################################################################
  33. at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
  34. at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1093)
  35. at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:670)
  36. at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
  37. at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
  38. at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
  39. at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
  40. at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1454)
  41. at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1301)
  42. at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1172)
  43. at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1340)
  44. at ru.startandroid.begin.StartActivity.onCreate(StartActivity.java:30)
  45. at android.app.Activity.performCreate(Activity.java:6575)
  46. at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1134)
  47. at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3137)
  48. ... 10 more
  49.  
  50. package ru.startandroid.begin;
  51.  
  52. import android.content.Context;
  53. import android.database.DatabaseErrorHandler;
  54. import android.database.sqlite.SQLiteDatabase;
  55. import android.database.sqlite.SQLiteOpenHelper;
  56.  
  57. public class DataBaseHelper extends SQLiteOpenHelper {
  58. // имя базы данных
  59. private static final String DATABASE_NAME = "mydatabase.db";
  60. // версия базы данных
  61. private static final int DATABASE_VERSION = 1;
  62. //имя таблицы
  63. public static final String DATABASE_TABLE = "database1";
  64. // название столбцов
  65. public static final String NAME = "name";
  66. public static final String NUMBER = "number";
  67. //скрипт создания
  68. private static final String SCRIPT = "CREATE TABLE IF NOT EXISTS "
  69. + DATABASE_TABLE + " ("
  70. + " integer primary key autoincrement, " + NAME + " text no null, "
  71. + NUMBER + " long, " + " (Field1 VARCHAR, Field2 VARCHAR;)";
  72.  
  73. DataBaseHelper(Context context) {
  74. super(context, DATABASE_NAME, null, DATABASE_VERSION);
  75. }
  76.  
  77. ////конструктор БД
  78. public DataBaseHelper(Context context, String name,
  79. SQLiteDatabase.CursorFactory factory, int version) {
  80. super(context, name, factory, version);
  81. }
  82.  
  83. public DataBaseHelper(Context context, String name,
  84. SQLiteDatabase.CursorFactory factory, int version,
  85. DatabaseErrorHandler errorHandler) {
  86. super(context, name, factory, version, errorHandler);
  87. }
  88.  
  89.  
  90. @Override
  91. public void onCreate(SQLiteDatabase db) {
  92. db.execSQL(SCRIPT);
  93. }
  94.  
  95. @Override
  96. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  97. // Удаляем старую таблицу и создаём новую
  98. db.execSQL("DROP TABLE IF IT EXISTS " + DATABASE_TABLE);
  99. // Создаём новую таблицу
  100. onCreate(db);
  101. }
  102. }
  103.  
  104. package ru.startandroid.begin;
  105.  
  106. import android.app.ListFragment;
  107. import android.app.ListActivity;
  108. import android.content.Intent;
  109. import android.database.Cursor;
  110. import android.database.sqlite.SQLiteDatabase;
  111. import android.os.Bundle;
  112. import android.util.StringBuilderPrinter;
  113. import android.view.View;
  114. import android.widget.ArrayAdapter;
  115. import android.widget.ListView;
  116.  
  117. public class StartActivity extends ListActivity {
  118. private ArrayAdapter<String> mAdapter;
  119. private DataBaseHelper mDatabaseHelper;
  120. private SQLiteDatabase mSqLiteDatabase;
  121.  
  122. @Override
  123. protected void onCreate(Bundle savedInstanceState) {
  124. super.onCreate(savedInstanceState);
  125.  
  126. //подключаемся к БД!!!!!
  127. //mDatabaseHelper = new DataBaseHelper(this, "mydatabase.db", null, 1);
  128. //mSqLiteDatabase = mDatabaseHelper.getWritableDatabase();
  129. mSqLiteDatabase = this.openOrCreateDatabase("mydatabase.db", MODE_PRIVATE, null);
  130.  
  131. ///////////////////////////////////// List
  132. Cursor cursor = mSqLiteDatabase.query(DataBaseHelper.DATABASE_TABLE, new String[] {
  133. DataBaseHelper.NAME,
  134. DataBaseHelper.NUMBER},
  135. null,null,null,null,null);
  136. //cursor.moveToFirst();
  137. }
  138. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement