package com.example.usingsqlite;

import androidx.appcompat.app.AppCompatActivity;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Color;
import android.os.Bundle;
import android.util.Log;
import android.view.View;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        try{

            SQLiteDatabase sqLiteDatabase = this.openOrCreateDatabase("Database1", MODE_PRIVATE, null );
            sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS users (username VARCHAR, userage int(3))");
            sqLiteDatabase.execSQL("INSERT INTO users (username, userage) VALUES ('Varun', 37)");
            sqLiteDatabase.execSQL("INSERT INTO users (username, userage) VALUES ('Rahul', 25)");
            sqLiteDatabase.execSQL("INSERT INTO users (username, userage) VALUES ('Amit', 23)");
            sqLiteDatabase.execSQL("INSERT INTO users (username, userage) VALUES ('Amit', 23)");

            Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM users", null);

            int usernameIndex = cursor.getColumnIndex("username");
            int userageIndex = cursor.getColumnIndex("userage");

            cursor.moveToFirst();
            
            while(cursor!=null)
            {
                Log.i("username", cursor.getString(usernameIndex));
                Log.i("username", cursor.getString(userageIndex));
                cursor.moveToNext();
            }
            
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}