Android - Simple CRUD Application

Submitted by razormist on Saturday, March 31, 2018 - 22:00.

Operating System

In this tutorial we will try to create a Simple CRUD Application using Android. Android is an open source so that developer find it easy to develop and expand new features. It used in several gadget like smartphone, tablet, and even television. Android is open source to developers who has an interest in developing mobile apps. It also provide an adaptive framework that allow the developer to develop an apps in a simpler way. So let's do the coding...

Getting Started:

First you will have to download & install the Android Development IDE (Android Studio or Eclipse). Android Studio is an open source development feel free to develop your things. Here's the link for the Android Studio https://developer.android.com/studio/index.html.

Android Manifest File

The Android Manifest file provides essential information about your app to the Android system in which the system must required before running the code. It describe the overall information about the application. It contains some libraries that needed to access the several method within the app.

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.razormist.simplecrudapplication">
 
    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity
            android:name=".MainActivity"
            android:configChanges="orientation"
            android:screenOrientation="portrait">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
 
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
        <activity
            android:name=".Registration"
            android:configChanges="orientation"
            android:screenOrientation="portrait">
            <intent-filter>
                <action android:name="com.razormist.simplecrudapplication.Registration" />
 
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
        <activity android:name=".EmployeeDetail" />
        <activity android:name=".UpdateEmployee"></activity>
    </application>
</manifest>

Layout Design

We will now create the design for the application, first locate the layout file called activity_main.xml, this is the default name when create a new activity. Then write these codes inside your layout file.

<?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"
    tools:context="com.razormist.simplecrudapplication.MainActivity"
    android:orientation="vertical">
 
    <ListView
        android:id="@+id/lv_list"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_weight="1" />
 
    <RelativeLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content">
        <Button
            android:id="@+id/btn_add"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="ADD"
            android:ems="10"
            android:layout_centerHorizontal="true" />
 
    </RelativeLayout>
</LinearLayout>

Now that we created the main interface we will now create another activities. To do that right click the app directory then choose new activity and select Empty Activity. Create 3 new activities called Registration, UpdateEmployee and EmployeeDetail, this also create a java file according to the activity name. Next write these blocks of code according to the activity xml file. activity_registration.xml

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 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"
    tools:context="com.razormist.simplecrudapplication.Registration">
    <TextView
        android:id="@+id/tv_firstname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Firstname"
        android:textSize="25sp"
        android:layout_marginLeft="20dp"
        android:layout_marginTop="64dp"
        android:layout_alignParentTop="true"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true"
        />
 
    <EditText
        android:id="@+id/et_firstname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:ems="10"
        android:inputType="text"
        android:layout_toRightOf="@+id/tv_firstname"
        android:layout_marginTop="55dp"
        android:layout_alignParentTop="true"
        android:layout_alignParentRight="true"
        />
 
    <TextView
        android:id="@+id/tv_lastname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Lastname"
        android:textSize="25sp"
        android:layout_marginLeft="20dp"
        android:layout_marginTop="30dp"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true"
        android:layout_below="@id/tv_firstname"/>
 
    <EditText
        android:id="@+id/et_lastname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:ems="10"
        android:inputType="textPersonName"
        android:layout_toRightOf="@+id/tv_lastname"
        android:layout_marginTop="15dp"
        android:layout_alignParentRight="true"
        android:layout_below="@+id/et_firstname"
        />
 
    <TextView
        android:id="@+id/tv_address"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Address"
        android:textSize="25sp"
        android:layout_marginLeft="40dp"
        android:layout_marginTop="30dp"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true"
        android:layout_below="@id/tv_lastname"/>
 
    <EditText
        android:id="@+id/et_address"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:ems="10"
        android:inputType="textPersonName"
        android:layout_toRightOf="@+id/tv_address"
        android:layout_marginTop="15dp"
        android:layout_alignParentRight="true"
        android:layout_below="@+id/et_lastname"
        />
 
    <Button
        android:id="@+id/btn_regsave"
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_marginRight="20dp"
        android:layout_alignParentRight="true"
        android:layout_below="@+id/tv_address"
        android:text="SAVE"
        android:ems="10"
        android:layout_marginTop="30dp"/>
 
    <Button
        android:id="@+id/btn_regback"
        android:layout_height="wrap_content"
        android:layout_width="wrap_content"
        android:layout_marginLeft="20dp"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/tv_address"
        android:text="BACK"
        android:ems="10"
        android:layout_marginTop="30dp"/>
</RelativeLayout>

activity_employee_detail.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"
    tools:context="com.razormist.simplecrudapplication.EmployeeDetail"
    android:orientation="vertical">
 
    <TextView
        android:id="@+id/tv_name2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Name"
        android:textStyle="bold"
        android:textSize="18sp"/>
 
    <TextView
        android:id="@+id/tv_dname"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>
 
    <TextView
        android:id="@+id/tv_address2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Address"
        android:textStyle="bold"
        android:textSize="18sp"/>
 
    <TextView
        android:id="@+id/tv_daddress"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
 
    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="horizontal">
 
        <Button
            android:id="@+id/btn_uback"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Back" />
 
        <Button
            android:id="@+id/btn_delete"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Delete" />
 
        <Button
            android:id="@+id/btn_edit"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Edit" />
    </LinearLayout>
</LinearLayout>

activity_update_employee.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"
    tools:context="com.razormist.simplecrudapplication.UpdateEmployee"
    android:orientation="vertical">
 
 
    <TextView
        android:id="@+id/textView"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Firstname"
        android:textStyle="bold"
        android:textSize="18sp"/>
 
    <EditText
        android:id="@+id/et_ufirstname"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:ellipsize="end"
        android:inputType="text" />
 
    <TextView
        android:id="@+id/textView2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Lastname"
        android:textStyle="bold"
        android:textSize="18sp"/>
 
    <EditText
        android:id="@+id/et_ulastname"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:ellipsize="end"
        android:inputType="text" />
 
    <TextView
        android:id="@+id/textView3"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Address"
        android:textStyle="bold"
        android:textSize="18sp"/>
 
    <EditText
        android:id="@+id/et_uaddress"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:ellipsize="end"
        android:inputType="text" />
 
    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="horizontal">
 
        <Button
            android:id="@+id/btn_back"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Back" />
 
        <Button
            android:id="@+id/btn_update"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Update" />
    </LinearLayout>
 
</LinearLayout>

Lastly, create a layout for the list holder of all the data within a xml file. To do that create new XML file called employee_list.xml and write this block of codes inside of the file.

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical">
 
    <TextView
        android:id="@+id/tv_name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:textSize="20sp"
        android:padding="5dp"/>
 
    <TextView
        android:id="@+id/tv_address"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:padding="5dp"/>
</LinearLayout>

Creating the List Adaptor

This will populate the data from the database to the ListView component. To do that create first create a new package called adapters then inside the new directory create a new java file called EmployeeListAdapter. Then write these block of codes insidee the java file.

package com.razormist.simplecrudapplication.adapters;
 
import android.content.Context;
import android.support.annotation.NonNull;
import android.support.annotation.Nullable;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.TextView;
 
import com.razormist.simplecrudapplication.Employee;
import com.razormist.simplecrudapplication.R;
 
import org.w3c.dom.Text;
 
import java.util.Comparator;
import java.util.List;
 
public class EmployeeListAdapter extends ArrayAdapter<Employee> {
 
    private  Context context;
    private List<Employee>employees;
 
    public EmployeeListAdapter(Context context, List<Employee> employees){
        super(context, R.layout.employee_list, employees);
        this.context = context;
        this.employees = employees;
    }
 
    @NonNull
    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        LayoutInflater layoutInflater = (LayoutInflater)context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
        View view  = layoutInflater.inflate(R.layout.employee_list, parent, false);
        TextView tv_name = (TextView)view.findViewById(R.id.tv_name);
        TextView tv_address = (TextView)view.findViewById(R.id.tv_address);
        tv_name.setText("Name: " + employees.get(position).getFirstname() + " " + employees.get(position).getLastname());
        tv_address.setText("Address: " + employees.get(position).getAddress());
 
        return view;
    }
}

Creating the Database

This is the code for the database, this will generate a database storage to be able to able to manage the data within the application. To do that create a new java file called Database, then write these block of codes inside the file.

package com.razormist.simplecrudapplication;
 
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.ContactsContract;
 
import java.util.ArrayList;
import java.util.List;
 
public class Database extends SQLiteOpenHelper{
    public static final String DATABASE_NAME = "employee.db";
    public static final String TABLE_NAME = "tbl_employee";
 
    public Database(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, firstname TEXT, lastname TEXT, address TEXT)");
    }
 
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXIST "+TABLE_NAME);
        onCreate(db);
    }
 
    public boolean InsertData(Employee employee){
        try {
            SQLiteDatabase db = getWritableDatabase();
            ContentValues contentValues = new ContentValues();
            contentValues.put("firstname", employee.getFirstname());
            contentValues.put("lastname", employee.getLastname());
            contentValues.put("address", employee.getAddress());
            long result = db.insert(TABLE_NAME, null, contentValues);
            db.close();
            if (result == -1) {
                return false;
            } else {
                return true;
            }
        }catch (Exception e){
            return false;
        }
    }
 
    public List<Employee> DisplayAll(){
        try{
            List<Employee> employees = new ArrayList<Employee>();
            SQLiteDatabase sqLiteDatabase = getWritableDatabase();
            Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM " + TABLE_NAME, null);
            if(cursor.moveToFirst()){
                do{
                    Employee employee = new Employee();
                    employee.setId(cursor.getInt(0));
                    employee.setFirstname(cursor.getString(1));
                    employee.setLastname(cursor.getString(2));
                    employee.setAddress(cursor.getString(3));
                    employees.add(employee);
                }while (cursor.moveToNext());
            }
            sqLiteDatabase.close();
            return employees;
        }catch (Exception e){
            return null;
        }
 
    }
 
    public boolean Delete(int id){
        try{
            SQLiteDatabase db = getWritableDatabase();
            int row = db.delete(TABLE_NAME, "ID = ?", new String[]{String.valueOf(id)});
            db.close();
            return row > 0;
        }catch (Exception e){
           return false;
        }
    }
 
    public boolean Update(Employee employee){
        try {
            SQLiteDatabase db = getWritableDatabase();
            ContentValues contentValues = new ContentValues();
            contentValues.put("firstname", employee.getFirstname());
            contentValues.put("lastname", employee.getLastname());
            contentValues.put("address", employee.getAddress());
            int row = db.update(TABLE_NAME, contentValues, "ID = ?", new String[]{String.valueOf(employee.getId())});
            db.close();
            return row > 0;
        }catch (Exception e){
            return false;
        }
    }
 
}

Next, we will now create a Writing function and Read function to support the manipulation of data in the database. To do that create a java file called it as Employee and write these block of codes.

package com.razormist.simplecrudapplication;
 
import java.io.Serializable;
 
public class Employee implements Serializable{
    private int id;
    private String firstname;
    private String lastname;
    private String address;
 
    public int getId() {
        return id;
    }
 
    public void setId(int id) {
        this.id = id;
    }
 
    public String getFirstname() {
        return firstname;
    }
 
    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }
 
    public String getLastname() {
        return lastname;
    }
 
    public void setLastname(String lastname) {
        this.lastname = lastname;
    }
 
    public String getAddress() {
        return address;
    }
 
    public void setAddress(String address) {
        this.address = address;
    }
 
    public Employee(int id, String firstname, String lastname, String address) {
        this.id = id;
        this.firstname = firstname;
        this.lastname = lastname;
        this.address = address;
    }
 
    public Employee() {
    }
}

Creating the Main Function

This code contains a several code that manages the data in the database. This is the main function that contain the most important part of the application the Create Read, Update, and Delete. To do that write these code inside the java file according to the given file name. MainActivity

package com.razormist.simplecrudapplication;
 
import android.content.Intent;
import android.database.Cursor;
import android.provider.ContactsContract;
import android.support.v4.media.RatingCompat;
import android.support.v4.widget.SimpleCursorAdapter;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;
 
import com.razormist.simplecrudapplication.adapters.EmployeeListAdapter;
 
import java.util.Comparator;
 
public class MainActivity extends AppCompatActivity {
    Database database;
    EditText et_firstname, et_lastname, et_address;
    Button btn_add, btn_view;
    ListView lv_list;
 
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        database = new Database(this);
 
        btn_add = (Button)findViewById(R.id.btn_add);
        lv_list = (ListView)findViewById(R.id.lv_list);
 
        EmployeeListAdapter employeeListAdapter = new EmployeeListAdapter(this, database.DisplayAll());
        employeeListAdapter.sort(new Comparator<Employee>() {
            @Override
            public int compare(Employee lhs, Employee rhs) {
                return lhs.getLastname().compareTo(rhs.getLastname());
            }
        });
        lv_list.setAdapter(employeeListAdapter);
        lv_list.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
                Employee employee = database.DisplayAll().get(position);
                Intent intent = new Intent(MainActivity.this, EmployeeDetail.class);
                intent.putExtra("employee", employee);
                startActivity(intent);
            }
        });
        btn_add.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(MainActivity.this, Registration.class);
                startActivity(intent);
            }
        });
 
 
    }
}

Registration

package com.razormist.simplecrudapplication;
 
import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
 
public class Registration extends AppCompatActivity {
    Database database;
    EditText et_regfirstname, et_reglastname, et_regaddress;
    Button btn_regsave, btn_regback;
 
 
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_registration);
 
        database = new Database(this);
 
        et_regfirstname = (EditText)findViewById(R.id.et_firstname);
        et_reglastname = (EditText)findViewById(R.id.et_lastname);
        et_regaddress = (EditText)findViewById(R.id.et_address);
        btn_regsave = (Button)findViewById(R.id.btn_regsave);
        btn_regback = (Button)findViewById(R.id.btn_regback);
 
        btn_regsave.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String firstname = et_regfirstname.getText().toString();
                String lastname = et_reglastname.getText().toString();
                String address = et_regaddress.getText().toString();
 
                if(!firstname.equals("") || !lastname.equals("") || !address.equals("")){
 
                    Employee employee = new Employee();
                    employee.setFirstname(firstname);
                    employee.setLastname(lastname);
                    employee.setAddress(address);
 
                    if (database.InsertData(employee)) {
                        Toast.makeText(Registration.this, "Successfully Inserted Data", Toast.LENGTH_SHORT).show();
                        et_regfirstname.setText("");
                        et_reglastname.setText("");
                        et_regaddress.setText("");
                    }
                }else{
                    Toast.makeText(Registration.this, "Please complete the required field!", Toast.LENGTH_SHORT).show();
                }
            }
        });
 
        btn_regback.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(Registration.this, MainActivity.class);
                startActivity(intent);
            }
        });
 
    }
}

EmployeeDetail

package com.razormist.simplecrudapplication;
 
import android.content.DialogInterface;
import android.content.Intent;
import android.preference.DialogPreference;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;
 
public class EmployeeDetail extends AppCompatActivity {
    private TextView tv_dname, tv_daddress;
    private Button btn_back, btn_edit, btn_delete;
 
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_employee_detail);
 
        final Employee employee = (Employee) getIntent().getSerializableExtra("employee");
        tv_dname = (TextView)findViewById(R.id.tv_dname);
        tv_daddress = (TextView)findViewById(R.id.tv_daddress);
        this.btn_back = (Button)findViewById(R.id.btn_uback);
        btn_edit = (Button)findViewById(R.id.btn_edit);
        btn_delete = (Button)findViewById(R.id.btn_delete);
        tv_dname.setText(employee.getFirstname() + " " + employee.getLastname());
        tv_daddress.setText(employee.getAddress());
 
        this.btn_back.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(EmployeeDetail.this, MainActivity.class);
                startActivity(intent);
            }
        });
 
        btn_edit.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(EmployeeDetail.this, UpdateEmployee.class);
                intent.putExtra("employee", employee);
                startActivity(intent);
            }
        });
 
        btn_delete.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(final View v) {
                final AlertDialog.Builder builder = new AlertDialog.Builder(v.getContext());
                builder.setTitle("Confirmation");
                builder.setMessage("Are you sure you want to delete this record?");
                builder.setPositiveButton("Yes", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        Database database = new Database(getBaseContext());
                        if(database.Delete(employee.getId())){
                            Intent intent = new Intent(EmployeeDetail.this, MainActivity.class);
                            startActivity(intent);
                        }else{
                            AlertDialog.Builder builder1 = new AlertDialog.Builder(getBaseContext());
                            builder1.setMessage("Fail");
                            builder1.setCancelable(false);
                            builder1.setPositiveButton("OK", new DialogInterface.OnClickListener() {
                                @Override
                                public void onClick(DialogInterface dialog, int which) {
                                    dialog.cancel();
                                }
                            });
                            builder1.create().show();
                        }
                    }
                });
                builder.setNegativeButton("No", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        dialog.cancel();
                    }
                });
                builder.create().show();
            }
        });
    }
}

UpdateEmployee

package com.razormist.simplecrudapplication;
 
import android.content.DialogInterface;
import android.content.Intent;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
 
public class UpdateEmployee extends AppCompatActivity {
    private EditText et_ufirstname, et_ulastname, et_uaddress;
    private Button btn_back, btn_update;
 
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_update_employee);
        final Database db = new Database(getBaseContext());
        final Employee employee = (Employee)getIntent().getSerializableExtra("employee");
        et_ufirstname = (EditText)findViewById(R.id.et_ufirstname);
        et_ulastname = (EditText)findViewById(R.id.et_ulastname);
        et_uaddress = (EditText)findViewById(R.id.et_uaddress);
        this.btn_back = (Button)findViewById(R.id.btn_back);
        btn_update = (Button)findViewById(R.id.btn_update);
 
        et_ufirstname.setText(employee.getFirstname());
        et_ulastname.setText(employee.getLastname());
        et_uaddress.setText(employee.getAddress());
        et_ufirstname.setSelection(et_ufirstname.getText().length());
        et_ulastname.setSelection(et_ulastname.getText().length());
        et_uaddress.setSelection(et_uaddress.getText().length());
 
        this.btn_back.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(UpdateEmployee.this, EmployeeDetail.class);
                intent.putExtra("employee", employee);
                startActivity(intent);
            }
        });
 
       btn_update.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String firstname = et_ufirstname.getText().toString();
                String lastname = et_ulastname.getText().toString();
                String address = et_uaddress.getText().toString();
 
                employee.setFirstname(firstname);
                employee.setLastname(lastname);
                employee.setAddress(address);
 
 
                if(db.Update(employee)){
                    //Toast.makeText(UpdateEmployee.this, "SUCCESS!", Toast.LENGTH_SHORT).show();
                    AlertDialog.Builder builder = new AlertDialog.Builder(v.getContext());
                    builder.setTitle("System");
                    builder.setMessage("SUCCESSFULLY UPDATED");
                    builder.setCancelable(false);
                    builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {
                        @Override
                        public void onClick(DialogInterface dialog, int which) {
                            Intent intent = new Intent(UpdateEmployee.this, MainActivity.class);
                            startActivity(intent);
                        }
                    });
                    builder.create().show();
                }else{
                    Toast.makeText(UpdateEmployee.this, "FAILED!", Toast.LENGTH_SHORT).show();
                }
            }
        });
    }
}

Try to run the app and see if it worked. There you have it we have created a Simple CRUD Application using Android. I hope that this tutorial help you to what you are looking for. For more updates and tutorials just kindly visit this site. Enjoy Coding!!!

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

fyp

Can anyone help me in developong expense manager app ..plzzzzzz

I hope that this link can

I hope that this link can help you https://www.sourcecodester.com/android/11491/expense-manager.html

app not working properly

Hello razormist,
First of all, a really great example, it helped me a lot.
But I find there is one thing not working properly for me at least.
As your code sorts the list based on the "Last Name", when I click on a row, the selection seems being done by the "Id", rather than by the "position" it is shown on the screen.
For example, if I first save a record with a "Last Name" = Smith and then a second one with "Last Name" = Johnson, the list will show Johnson as first and the Smith, because of the sorting by Last Name.
But then, if I select on Johnson to Edit/Delete, what I see the app is selecting is the one with Smith.
Any solution to this?
Thank you.

Correcting the position issue

The issue is that due to the sorting done with EmployeeListAdapter.sort the position of each item on the list is not the same as the position in the database! A crazy, not efficient solution is to stop the sorting in MainActivity by returning: return lhs.getId(); instead of: return lhs.getLastname().compareTo(rhs.getLastname());

Add new comment

Add new comment
9480 views