CRUD : Insert data in SQLITE Database using Java in Android

 INSERT SQLITE

DBHelper.java

package com.example.myapplication10;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

import androidx.annotation.Nullable;

public class DBHelper extends SQLiteOpenHelper {
    public static String DBNAME="Database.db";
    public  static String TABLE_NAME="Student";
    Context activity;



    public DBHelper(@Nullable Context context) {
        super(context, DBNAME, null, 1);
        activity=context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String query="CREATE TABLE "+TABLE_NAME+"(id INTEGER PRIMARY KEY AUTOINCREMENT,grid INTEGER,name TEXT,mobile TEXT)";
        db.execSQL(query);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    void InsertData(int grid,String name,String mobile)
    {
        SQLiteDatabase sqLiteDatabase=getWritableDatabase();

        ContentValues contentValues=new ContentValues();
        contentValues.put("grid",grid);
        contentValues.put("name",name);
        contentValues.put("mobile",mobile);

       long result  =  sqLiteDatabase.insert(TABLE_NAME,null,contentValues);

        Toast.makeText(activity, ""+result, Toast.LENGTH_SHORT).show();

    }

}

MainActivity.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:gravity="center"
    android:orientation="vertical"
    tools:context=".MainActivity">

    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="grid"
        android:inputType="number"
        android:id="@+id/grid_edt"/>

    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="Name"
        android:inputType="text"
        android:id="@+id/name_edt"/>

    <EditText
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="mobile"
        android:inputType="number"
        android:id="@+id/mobile_edt"/>

    <Button
        android:id="@+id/btn"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Submit"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintEnd_toEndOf="parent"
        app:layout_constraintStart_toStartOf="parent"
        app:layout_constraintTop_toTopOf="parent" />


</LinearLayout>

MainActivity.java

public class MainActivity extends AppCompatActivity {


    private Button btn;
    EditText mobile_edt,grid_edt,name_edt;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        DBHelper dbHelper=new DBHelper(MainActivity.this);

        btn=findViewById(R.id.btn);
        mobile_edt=findViewById(R.id.mobile_edt);
        name_edt=findViewById(R.id.name_edt);
        grid_edt=findViewById(R.id.grid_edt);

        btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String name=name_edt.getText().toString();
                String mobile=mobile_edt.getText().toString();
                int grid=Integer.parseInt(grid_edt.getText().toString());

                dbHelper.InsertData(grid,name,mobile);
            }
        });
    }
    
}