· 7 years ago · Sep 07, 2018, 06:08 PM
1sqlite onCreate() problem I want my database created once,and it will not changed,but i can't create data when i'm in onCreate()
2public class EventsData extends SQLiteOpenHelper {
3 private static final String DATABASE_NAME = "events.db";
4 private static final int DATABASE_VERSION = 1;
5
6
7 public EventsData(Context ctx) {
8 super(ctx, DATABASE_NAME, null, DATABASE_VERSION);
9 }
10
11 @Override
12 public void onCreate(SQLiteDatabase db) {
13
14 db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
15 + " INTEGER PRIMARY KEY AUTOINCREMENT, " + TIME
16 + " TEXT NOT NULL," + TITLE + " TEXT NOT NULL);");
17
18 //This doesn't work..
19 db.execSQL("INSERT INTO"+TABLE_NAME+"VALUES(null, 'hello', 'android');");
20 }
21
22 @Override
23 public void onUpgrade(SQLiteDatabase db, int oldVersion,
24 int newVersion) {
25 db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
26 onCreate(db);
27 }
28
29 }
30
31db.execSQL("INSERT INTO"+TABLE_NAME+"VALUES(null, 'hello', 'android');