HZmVG5an

1mDatabaseHelper = new DataBaseHelper(this, "mydatabase.db", null, 1);
2mSqLiteDatabase = mDatabaseHelper.getWritableDatabase();
3	
4Cursor cursor = mSqLiteDatabase.query(DataBaseHelper.DATABASE_TABLE, new String[]{
5        DataBaseHelper.NAME,
6        DataBaseHelper.NUMBER},
7        null,null,null,null,null);
8	
9Process: 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	
50package ru.startandroid.begin;
51
52import android.content.Context;
53import android.database.DatabaseErrorHandler;
54import android.database.sqlite.SQLiteDatabase;
55import android.database.sqlite.SQLiteOpenHelper;
56
57public 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	
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    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}
139	
140private static final String SCRIPT = "CREATE TABLE IF NOT EXISTS "
141    + DATABASE_TABLE + " ("
142    + " integer primary key autoincrement, " + NAME + " text no null, "
143    + NUMBER + " long, " + " (Field1 VARCHAR, Field2 VARCHAR;)";
144	
145private static final String SCRIPT = "CREATE TABLE IF NOT EXISTS "
146    + DATABASE_TABLE + " ("
147    + "_id integer primary key autoincrement, " + NAME + " text no null, "
148    + NUMBER + " long, " + " (Field1 VARCHAR, Field2 VARCHAR;)";
149	
150private static final String SCRIPT = "CREATE TABLE IF NOT EXISTS "
151    + DATABASE_TABLE + " ("
152    + " integer primary key autoincrement, " + NAME + " text no null, "
153    + NUMBER + " long, " + " (Field1 VARCHAR, Field2 VARCHAR;)";
154	
155"_id integer primary key autoincrement, "
156	
157" text not null, "
158	
159" Field1 VARCHAR, Field2 VARCHAR)"
160	
161private static final String SCRIPT = "CREATE TABLE IF NOT EXISTS "
162        + DATABASE_TABLE + " ("
163        + "_id integer primary key autoincrement, " + NAME + " text not null, "
164        + NUMBER + " long, " + " Field1 VARCHAR, Field2 VARCHAR)";