Main java

package com.example.myapplication;

import android.os.Bundle;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;

import android.widget.TextView;

import android.database.Cursor;

import androidx.appcompat.app.AppCompatActivity;

public class MainActivity extends AppCompatActivity {

MyDatabaseHelper myDb;

EditText editTextName, editTextAge;

Button buttonInsert, buttonRead;

TextView textViewResult;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

myDb = new MyDatabaseHelper(this);

editTextName = findViewById(R.id.editTextName);

editTextAge = findViewById(R.id.editTextAge);

buttonInsert = findViewById(R.id.buttonInsert);

buttonRead = findViewById(R.id.buttonRead);

textViewResult = findViewById(R.id.textViewResult);

buttonInsert.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

String name = editTextName.getText().toString();

int age = Integer.parseInt(editTextAge.getText().toString());

boolean isInserted = myDb.insertData(name, age);

if (isInserted)

Toast.makeText(MainActivity.this, "Data Inserted", Toast.LENGTH_LONG).show();

else

Toast.makeText(MainActivity.this, "Data Not Inserted", Toast.LENGTH_LONG).show();

});

buttonRead.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

Cursor res = myDb.getAllData();

if (res.getCount() == 0) {

textViewResult.setText("No Data Found");

return;

StringBuilder buffer = new StringBuilder();

while (res.moveToNext()) {
 buffer.append("ID: ").append(res.getString(0)).append("\n");

buffer.append("Name: ").append(res.getString(1)).append("\n");

buffer.append("Age: ").append(res.getString(2)).append("\n\n");

textViewResult.setText(buffer.toString());

});

Db

package com.example.myapplication;

import android.content.Context;

import android.database.Cursor;

import android.content.ContentValues;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

public class MyDatabaseHelper extends SQLiteOpenHelper {

private static final String DATABASE_NAME = "people.db";

private static final String TABLE_NAME = "person";

private static final String COL_1 = "ID";

private static final String COL_2 = "NAME";

private static final String COL_3 = "AGE";

public MyDatabaseHelper(Context context) {

 super(context, DATABASE_NAME, null, 1);

@Override

public void onCreate(SQLiteDatabase db) {

db.execSQL("CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT,
NAME TEXT, AGE INTEGER)");

@Override

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

db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);

onCreate(db);

public boolean insertData(String name, int age) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues contentValues = new ContentValues();

contentValues.put(COL_2, name);

contentValues.put(COL_3, age);

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

return result != -1;

public Cursor getAllData() {

SQLiteDatabase db = this.getWritableDatabase();

return db.rawQuery("SELECT * FROM " + TABLE_NAME, null);

}
Xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
android:padding="16dp"
tools:context=".MainActivity">

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

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

<Button
android:id="@+id/buttonInsert"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Insert Data" />

<Button
android:id="@+id/buttonRead"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Read Data" />

<TextView
android:id="@+id/textViewResult"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:paddingTop="16dp" />
</LinearLayout>