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();
        }