e1xSWSNW

1public class sqlitehelper extends SQLiteOpenHelper {
2    private static final String DATABASE_NAME = "uangKas";
3    private static final int DATABASE_VERSION = 1;
4
5    public sqlitehelper(Context context) {
6        super(context, DATABASE_NAME, null, DATABASE_VERSION);
7        // TODO Auto-generated constructor stub
8    }
9
10    @Override
11    public void onCreate(SQLiteDatabase db) {
12        // TODO Auto-generated method stub
13        db.execSQL(
14                "CREATE TABLE transaksi (transaksi_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, status TEXT," +
15                        "jumlah DOUBLE, keterangan TEXT, tanggal DATE DEFAULT CURRENT_DATE );"
16        );
17    }
18
19
20    @Override
21    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
22        // TODO Auto-generated method stub
23        // Drop older table if existed
24        db.execSQL("DROP TABLE IF EXISTS transaksi");
25    }
26}