2. Example (Conceptual - Android with Kotlin): Kotlin

Example (Conceptual - Android with Kotlin):

Kotlin

import android.content.Context

import android.database.sqlite.SQLiteDatabase

import android.database.sqlite.SQLiteOpenHelper

import android.content.ContentValues

 

class DatabaseHelper(context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {

 

    companion object {

        const val DATABASE_NAME = "my_database.db"

        const val DATABASE_VERSION = 1

        const val TABLE_NAME = "users"

        const val COLUMN_ID = "id"

        const val COLUMN_NAME = "name"

        const val COLUMN_EMAIL = "email"

    }

 

    override fun onCreate(db: SQLiteDatabase) {

        val createTableQuery = "CREATE TABLE $TABLE_NAME ($COLUMN_ID INTEGER PRIMARY KEY, $COLUMN_NAME TEXT, $COLUMN_EMAIL TEXT)"

        db.execSQL(createTableQuery)

    }

 

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

        // Handle database upgrades if needed (e.g., adding new columns)

    }

 

    fun addUser(name: String, email: String) {

        val db = writableDatabase  // Get a writable database

        val values = ContentValues()

        values.put(COLUMN_NAME, name)

        values.put(COLUMN_EMAIL, email)

        db.insert(TABLE_NAME, null, values) // Insert the data

        db.close() // Close the database

    }

 

    // ... other database operations (get users, update user, delete user, etc.) ...

}

// Example usage:

val dbHelper = DatabaseHelper(this) // 'this' is the Activity context

dbHelper.addUser("John Doe", "john.doe@example.com")