Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. package com.example.myapplication
  2.  
  3. import android.content.Context
  4. import android.database.sqlite.SQLiteDatabase
  5. import android.database.sqlite.SQLiteOpenHelper
  6.  
  7. class DBHelper(val context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {
  8.  
  9. companion object {
  10.  
  11. internal const val DATABASE_VERSION = 1
  12. internal const val DATABASE_NAME = "Users.db"
  13. internal const val TABLE_NAME = "users"
  14. internal const val COL_ID = "id"
  15. internal const val COL_NAME = "name"
  16. internal const val COL_SURNAME = "surname"
  17.  
  18. }
  19.  
  20. override fun onCreate(db: SQLiteDatabase?) {
  21.  
  22. val sql = db!!.execSQL("CREATE TABLE IF NOT EXISTS $TABLE_NAME(" +
  23. "$COL_ID INTEGER PRIMARY KEY, " +
  24. "$COL_NAME TEXT NOT NULL, " +
  25. "$COL_SURNAME TEXT NOT NULL)")
  26. }
  27.  
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement