siAQXjHf

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