MuDiQc5C

1public class DataBase extends SQLiteOpenHelper {
2public DataBase(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
3    super(context, Consts.DB.DB_NAME ,  factory, Consts.DB.DB_VERSION);
4
5    createTable();
6
7}
8
9
10
11@Override
12public void onCreate(SQLiteDatabase db) {
13}
14
15
16@Override
17public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
18
19    db.execSQL("DROP TABLE IF EXISTS " + Consts.DB.TABLE_NAME);
20    onCreate(db);
21
22}
23
24
25public void createTable(){
26    String query =   "CREATE TABLE IF NOT EXISTS " + Consts.DB.TABLE_NAME + "(" +
27            Consts.DB.KEY_ID + " INTEGER   PRIMARY KEY                   , " +
28            Consts.DB.DB_MEMBER_ROW + " TEXT                             , " +
29            Consts.DB.DB_DEBT_ROW   + " INTEGER "                       + ");";
30
31    this.executeTable(query);
32
33
34}
35
36public void executeTable(String query){
37
38    try {
39        this.getWritableDatabase().execSQL(query);
40
41    }catch (SQLiteException e){
42
43        e.printStackTrace();
44    }
45}