Database

Database.java

package com.example.program2;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class Database extends SQLiteOpenHelper {
 public static final String DATABASE_NAME = "employee.db";
 public static final String TABLE_NAME = "employee_table";
 public Database(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
 super(context, name, factory, version);
 }
 @Override
 public void onCreate(SQLiteDatabase db) {
 db.execSQL("create table " + TABLE_NAME + " (ID TEXT, NAME TEXT, AGE TEXT, ADDRESS TEXT)");
 }
 @Override
 public void onUpgrade(SQLiteDatabase db, int i, int i1) {
 }
}



activity_main.xml


<?xml version="1.0" encoding="utf-8"?>
<AbsoluteLayout
 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"
 tools:context=".MainActivity"
 tools:ignore="Deprecated">
 <EditText
 android:id="@+id/idId"
 android:layout_width="wrap_content"
android:layout_height="wrap_content"
 android:ems="10"
 android:layout_x="16dp"
 android:layout_y="16dp"
 android:hint="Enter Employee ID"/>

<EditText
 android:id="@+id/idName"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:ems="10"
 android:layout_x="16dp"
 android:layout_y="61dp"
 android:hint="Enter Employee Name"/>

<EditText
 android:id="@+id/idAge"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:ems="10"
 android:layout_x="16dp"
 android:layout_y="106dp"
 android:hint="Enter Employee Age"/>

<EditText
 android:id="@+id/idAddress"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:ems="10"
 android:layout_x="16dp"
 android:layout_y="151dp"
 android:hint="Enter Employee Address"/>

<Button
 android:id="@+id/idInsert"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_x="16dp"
 android:layout_y="196dp"
 android:text="Insert"/>

<Button
 android:id="@+id/idSearch"
 android:layout_width="wrap_content"
android:layout_height="wrap_content"
 android:layout_x="132dp"
 android:layout_y="196dp"
 android:text="Search"/>
</AbsoluteLayout>



MainActivity.java


package com.example.program2;
import android.os.Bundle;
import android.view.View;
import android.widget.Toast;
import android.widget.Button;
import android.content.Intent;
import android.widget.EditText;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import androidx.appcompat.app.AppCompatActivity;
public class MainActivity extends AppCompatActivity implements View.OnClickListener {
 EditText id, name, age, address;
 Button insert, search;
 @Override
 protected void onCreate(Bundle b) {
 super.onCreate(b);
 setContentView(R.layout.activity_main);
 id = findViewById(R.id.idId);
 name = findViewById(R.id.idName);
 age = findViewById(R.id.idAge);
 address = findViewById(R.id.idAddress);
 insert = findViewById(R.id.idInsert);
 search = findViewById(R.id.idSearcinsert.setOnClickListener(this);
 search.setOnClickListener(this);
 }
 @Override
 public void onClick(View v) {
 if(v.equals(insert)) {
 String idStr = id.getText().toString();
 String nameStr = name.getText().toString();
 String ageStr = age.getText().toString();
 String addressStr = address.getText().toString();
 Database db = new Database(this, Database.DATABASE_NAME, null, 1);
 SQLiteDatabase mydb = db.getWritableDatabase();
 ContentValues cv = new ContentValues();
 cv.put("ID", idStr);
 cv.put("NAME", nameStr);
 cv.put("AGE", ageStr);
 cv.put("ADDRESS", addressStr);
 mydb.insert(Database.TABLE_NAME, null, cv);
 mydb.close();
 Toast.makeText(this, "Data Inserted", Toast.LENGTH_SHORT).show();
 }
 else if(v.equals(search)) {
 Toast.makeText(this, "Search Activity", Toast.LENGTH_SHORT).show();
 Intent it = new Intent(this, SearchActivity.class);
 startActivity(it);
 }
 }
}



Activity_search.xml


<?xml version="1.0" encoding="utf-8"?>
<AbsoluteLayout
 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"
 tools:context=".SearchActivity"
 tools:ignore="Deprecated">
 <EditText
 android:id="@+id/idId"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:ems="10"
 android:layout_x="16dp"
 android:layout_y="16dp"
 android:hint="Enter Employee ID"/>
 <Button
 android:id="@+id/idSearch"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_x="16dp"
 android:layout_y="61dp"
 android:text="Search"/>
<TextView
 android:id="@+id/idDisplay"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_x="16dp"
 android:layout_y="109dp"/>
</AbsoluteLayout>




SearchActivity.java


package com.example.program2;
import android.os.Bundle;
import android.view.View;
import android.widget.Toast;
import android.widget.Button;
import android.database.Cursor;
import android.widget.EditText;
import android.widget.TextView;
import android.database.sqlite.SQLiteDatabase;
import androidx.appcompat.app.AppCompatActivity;
public class SearchActivity extends AppCompatActivity implements View.OnClickListener {
 EditText id;
 Button search;
 TextView display;
 @Override
 protected void onCreate(Bundle b) {
 super.onCreate(b);
 setContentView(R.layout.activity_search);
 id = findViewById(R.id.idId);
 search = findViewById(R.id.idSearch);
 display = findViewById(R.id.idDisplay);
search.setOnClickListener(this);
 }
 @Override
 public void onClick(View v) {
 if (v.equals(search)) {
 String idStr = id.getText().toString();
 Database db = new Database(this, Database.DATABASE_NAME, null, 1);
 SQLiteDatabase mydb = db.getReadableDatabase();
 String[] columns = {"ID", "NAME", "AGE", "ADDRESS"};
 String[] selectionArgs = {idStr};
 String selection = "ID = ?";
 Cursor c = mydb.query(Database.TABLE_NAME, columns, selection, selectionArgs, null, null, null);
 display.setText("");
 if(c.moveToNext()) {
 String nameStr = c.getString(1);
 String ageStr = c.getString(2);
 String addressStr = c.getString(3);
 display.append(idStr + " " + nameStr + " " + ageStr + " " + addressStr + "\n");
 }
 else {
 Toast.makeText(this, "No Data Found", Toast.LENGTH_SHORT).show();
 }
 }
 }
}