vJSrDERv

1package com.example.student.telefony;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class PomocnikBD extends SQLiteOpenHelper
8{
9    private Context mKontekst;
10    public final static int WERSJA_BAZY = 1;
11    public final static String NAZWA_BAZY = "baza_telefonow";
12    public final static String NAZWA_TABELI = "telefony";
13    public final static String ID = "_id";
14    public final static String PRODUCENT = "producent";
15    public final static String MODEL = "model";
16    public final static String ANDROID = "android";
17    public final static String WWW = "www";
18    public final static String ETYKIETA = "PomocnikBD";
19    public final static String TW_BAZY = "CREATE TABLE " + NAZWA_TABELI + "(" + ID + " integer primary key autoincrement, " + PRODUCENT + " text not null," + MODEL + " text not null," + ANDROID + " text not null," + WWW + " text);";
20    private static final String KAS_BAZY = "DROP TABLE IF EXISTS " + NAZWA_TABELI;
21
22    public PomocnikBD(Context context)
23    {
24        super(context, NAZWA_BAZY, null, WERSJA_BAZY);
25        mKontekst = context;
26    }
27
28    @Override
29    public void onCreate(SQLiteDatabase db)
30    {
31        //Tworzenie bazy
32        db.execSQL(TW_BAZY);
33    }
34
35    @Override
36    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
37    {
38        //Aktualizacja bazy
39        db.execSQL(KAS_BAZY);
40        onCreate(db);
41    }
42}