xkFrP4kU

1package com.example.linden.carbonloyalty;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class DatabaseHelper extends SQLiteOpenHelper{
8    private static final int DATABASE_VERSION = 1;
9    private static final String DATABASE_NAME="customers.db";
10    private static final String TABLE_NAME="customers";
11    private static final String COLUMN_ID="id";
12    private static final String COLUMN_NUMBER="phoneNo";
13    private static final String COLUMN_VISIT="visitNo";
14    private static final String COLUMN_PROMOTER="netNo";
15    SQLiteDatabase db;
16    private static final String TABLE_CREATE = "create table customers (id integer primary key not null, auto_increment ," +
17            "phoneNo int not null, visitNo int not null, netNo int not null);";
18
19
20    public DatabaseHelper(Context context){
21        super(context, DATABASE_NAME, null, DATABASE_VERSION);
22    }
23
24    @Override
25    public void onCreate(SQLiteDatabase sqLiteDatabase) {
26        db.execSQL(TABLE_CREATE);
27        this.db=db;
28    }
29
30    @Override
31    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
32        String query = "DROP TABLE IF EXISTS " + TABLE_NAME;
33        db.execSQL(query);
34        this.onCreate(db);
35    }
36}