class DatabaseHelper (context : Context)
    : SQLiteOpenHelper (context , "sekolah.db"
    , null ,  1){

    override fun onCreate(db: SQLiteDatabase?) {

        val sql = "CREATE TABLE siswa ( " +
                "$COL_ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "namad TEXT, " +
                "$COL_NAMAB TEXT, " +
                "$COL_NOHP TEXT, " +
                "$COL_JENJANG TEXT, " +
                "$COL_GENDER TEXT, " +
                "$COL_ALAMAT TEXT, " +
                "$COL_HOBI TEXT)"

        db?.execSQL(sql)

    }

    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {


    }

    companion object{
        val COL_ID = "id"
        val COL_NAMAD = "namad"
        val COL_NAMAB = "namab"
        val COL_NOHP = "nohp"
        val COL_GENDER= "jk"
        val COL_HOBI = "hobi"
        val COL_JENJANG = "jenjang"
        val COL_ALAMAT = "alamat"

    }


}