Android Basit SQLite Bağlantısı Kendi Sınıfı İçinden
SQLiteOpenHelperdan sınıf kalıtmadan, basit sqlite bağlantısı kodları…
try { SQLiteDatabase eventsDB = this.openOrCreateDatabase("Events", MODE_PRIVATE, null); eventsDB.execSQL("CREATE TABLE IF NOT EXISTS events (event VARCHAR, year INT(4))"); eventsDB.execSQL("INSERT INTO events (event, year) VALUES ('End Of WW2', 1945)"); eventsDB.execSQL("INSERT INTO events (event, year) VALUES ('Wham split up', 1986)"); Cursor c = eventsDB.rawQuery("SELECT * FROM events", null); int eventIndex = c.getColumnIndex("event"); int yearIndex = c.getColumnIndex("year"); c.moveToFirst(); while (c != null) { Log.e("Results - event", c.getString(eventIndex)); Log.e("Results - year", Integer.toString(c.getInt(yearIndex))); c.moveToNext(); } } catch (Exception e) { e.printStackTrace(); }
Son Yorumlar