vnMzikeu

1public class Databasehelper extends SQLiteOpenHelper {
2    public static final int DATABASE_VERSION=1;
3    public static final String DATABASE_NAME="MyActivity.db";
4
5    public Databasehelper(Context context){
6        super(context, DATABASE_NAME, null, DATABASE_VERSION);
7    }
8
9    private static final String SQL_CREATES_TABEL_ACTIVITAS1= String.format(
10            "CREATE TABLE %s"
11                    +"(%s INTEGER PRIMARY KEY AUTOINCREMENT,"+
12                    " %s TEXT NOT NULL," +
13                    " %s TEXT NOT NULL," +
14                    " %s TEXT NOT NULL)",
15            SQLData1.TABEL_ACT1,
16            SQLData1.Aktivitas_Column.COLUMN_ACT_ID_BUKU,
17            SQLData1.Aktivitas_Column.COLUMN_ACT_JUDUL,
18            SQLData1.Aktivitas_Column.COLUMN_ACT_PENULIS,
19            SQLData1.Aktivitas_Column.COLUMN_ACT_TAHUN
20    );
21
22    private static final String SQL_CREATES_TABEL_ACTIVITAS2= String.format(
23            "CREATE TABLE %s"+
24                    "(%s INTEGER PRIMARY KEY AUTOINCREMENT,"+
25                    " %s INTEGER,"+
26                    " FOREIGN KEY (%s) REFERENCES %s(%s),"+
27                    " %s TEXT NOT NULL,"+
28                    " %s TEXT NOT NULL)",
29            SQLData2.TABEL_ACT2,
30            SQLData2.Aktivitas_Column.COLUMN_ACT_ID_MHS,
31            SQLData2.Aktivitas_Column.COLUMN_ACT_ID_BUKU,
32            SQLData2.Aktivitas_Column.COLUMN_ACT_ID_BUKU,
33            SQLData1.TABEL_ACT1,
34            SQLData1.Aktivitas_Column.COLUMN_ACT_ID_BUKU,
35            SQLData2.Aktivitas_Column.COLUMN_ACT_TGL_PINJAM,
36            SQLData2.Aktivitas_Column.COLUMN_ACT_TGL_KEMBALI
37    );
38
39    @Override
40    public void onCreate(SQLiteDatabase db) {
41        db.execSQL(SQL_CREATES_TABEL_ACTIVITAS1);
42        db.execSQL(SQL_CREATES_TABEL_ACTIVITAS2);
43    }
44
45    @Override
46    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
47        db.execSQL("DROP TABLE IF EXISTS " + SQLData1.TABEL_ACT1);
48        db.execSQL("DROP TABLE IF EXISTS " + SQLData2.TABEL_ACT2);
49        onCreate(db);
50    }
51
52
53}