gHC3HhEN

1package com.example.bruna.appvalid1;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7/**
8 * Created by bruna on 24/08/2016.
9 */
10public class DBHelper extends SQLiteOpenHelper {
11
12    private static final String DATABASE_NAME = "membersdb";
13    private static final int DATABASE_VERSION = 1;
14    private static final String DATABASE_CREATE = "CREATE TABLE membersdb(_id integer primary key autoincrement, " + "username text not null,"+"password text not null"+");";
15    private static final String DATABASE_INSERT = "insert into membersdb(username, password) values('eduardo', '123')";
16
17    public  DBHelper (Context context){
18
19        super(context, DATABASE_NAME, null, DATABASE_VERSION);
20    }
21
22    public void onCreate(SQLiteDatabase db){
23        db.execSQL(DATABASE_CREATE);
24        db.execSQL(DATABASE_INSERT);
25
26
27    }
28
29    public void onUpgrade(SQLiteDatabase db, int arg1, int arg2){
30        db.execSQL("DROP TABLE IF EXISTS members");
31        onCreate(db);
32    }
33}