R99FjcmL

1
2import android.content.Context;
3import android.database.sqlite.SQLiteDatabase;
4import android.database.sqlite.SQLiteOpenHelper;
5
6public class DatabaseHelper extends SQLiteOpenHelper {
7
8    // Base de Datos
9    static final String BD = "COLEGIO";
10
11    // Nombre de Tabla
12    public static final String TABLA = "alumno";
13
14    // Columnas
15    public static final String _ID = "_id";
16    public static final String NOMBRE = "nombre";
17    public static final String CARRERA = "carrera";
18    public static final String CURP = "curp";
19
20    // database version
21    static final int BD_VERSION = 1;
22
23    // Creating table query
24    private static final String CREATE_TABLE = "create table " + TABLA + "(" + _ID
25            + " INTEGER PRIMARY KEY AUTOINCREMENT, " + NOMBRE + " TEXT NOT NULL, " + CARRERA + " TEXT, " + CURP + " TEXT);";
26
27    public DatabaseHelper(Context context) {
28        super(context, BD, null, BD_VERSION);
29    }
30
31    @Override
32    public void onCreate(SQLiteDatabase db) {
33        db.execSQL(CREATE_TABLE);
34    }
35
36    @Override
37    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
38        db.execSQL("DROP TABLE IF EXISTS " + TABLA);
39        onCreate(db);
40    }
41}