Android SQLite CRUD – RecyclerView ContextMenu- INSERT SELECT, DELETE Tutorial
This is an android tutorial of how to work with SQLite datbase and RecyclerView with ContextMenu.
Today we see how to insert data to sqlite database from an input dialog,select that data and show it in a RecyclerView. We shall also see how to delete.Now for deleting we shall use a ContextMenu. User longclicks/long presses a RecyclerView card,then selects the action to perform. In short :
We perform the following:
- Insert Data to SQLite Database
- Retrieve Data from SQLite Database and render in a RecyclerView
- Long press the recyclerview to show a contextmenu.
- When uses longpresses,he gets presented with a ContextMenu to select the action to perform.
- If he selects “New” we show an input dialog.While if he selects “Delete”,we delete the data from our database.
- Choose Delete to Delete data from SQLite database.
SQLite RecyclerView ContextMenu
SQLite RecyclerView ContextMenu
SQLite RecyclerView ContextMenu
Let’s go.
1. Create Basic Activity Project
Start by creating an empty project in android studio. Go to File –> New Project.
2. Add Dependencies
Let’s add build.gradle dependencies. These are basically support library dependencies and no special third party library
dependencies { compile fileTree(dir: 'libs', include: ['*.jar']) testCompile 'junit:junit:4.12' compile 'com.android.support:appcompat-v7:23.3.0' compile 'com.android.support:design:23.3.0' compile 'com.android.support:cardview-v7:23.3.0' }
Here are our layouts for this project:
(a). activity_main.xml
- This layout gets inflated to MainActivity user interface.
- It includes the content_main.xml.
<?xml version="1.0" encoding="utf-8"?> <android.support.design.widget.CoordinatorLayout android_layout_width="match_parent" android_layout_height="match_parent" android_fitsSystemWindows="true" tools_context="com.tutorials.hp.sqlitecontextmenudelete.MainActivity"> <android.support.design.widget.AppBarLayout android_layout_width="match_parent" android_layout_height="wrap_content" android_theme="@style/AppTheme.AppBarOverlay"> <android.support.v7.widget.Toolbar android_id="@+id/toolbar" android_layout_width="match_parent" android_layout_height="?attr/actionBarSize" android_background="?attr/colorPrimary" app_popupTheme="@style/AppTheme.PopupOverlay" /> </android.support.design.widget.AppBarLayout> <include layout="@layout/content_main" /> <android.support.design.widget.FloatingActionButton android_id="@+id/fab" android_layout_width="wrap_content" android_layout_height="wrap_content" android_layout_gravity="bottom|end" android_layout_margin="@dimen/fab_margin" android_src="@android:drawable/ic_dialog_email" /> </android.support.design.widget.CoordinatorLayout>
(b). content_main.xml
This layout gets included in your activity_main.xml.
You define your UI widgets right here.
In this case we add a RecyclerView as our AdapterView.
<?xml version="1.0" encoding="utf-8"?> <RelativeLayout android_layout_width="match_parent" android_layout_height="match_parent" android_paddingBottom="@dimen/activity_vertical_margin" android_paddingLeft="@dimen/activity_horizontal_margin" android_paddingRight="@dimen/activity_horizontal_margin" android_paddingTop="@dimen/activity_vertical_margin" app_layout_behavior="@string/appbar_scrolling_view_behavior" tools_context="com.tutorials.hp.sqlitecontextmenudelete.MainActivity" tools_showIn="@layout/activity_main"> <android.support.v7.widget.RecyclerView android_id="@+id/rv" android_layout_width="match_parent" android_layout_height="wrap_content"></android.support.v7.widget.RecyclerView> </RelativeLayout>
(c). dialog_layout.xml
This is our input dialog layout.
This layout will inflate to an input dialog that will be used as the data entry form.
<?xml version="1.0" encoding="utf-8"?> <android.support.v7.widget.CardView android_orientation="horizontal" android_layout_width="500dp" android_layout_margin="1dp" card_view_cardCornerRadius="10dp" card_view_cardElevation="5dp" android_layout_height="match_parent"> <LinearLayout android_layout_width="match_parent" android_orientation="vertical" android_layout_height="match_parent"> <android.support.design.widget.TextInputLayout android_id="@+id/nameLayout" android_layout_width="match_parent" android_layout_height="wrap_content"> <EditText android_id="@+id/nameEditTxt" android_layout_width="match_parent" android_layout_height="wrap_content" android_singleLine="true" android_hint= "Name" /> </android.support.design.widget.TextInputLayout> <Button android_id="@+id/saveBtn" android_layout_width="fill_parent" android_layout_height="wrap_content" android_text="Save" android_clickable="true" android_background="@color/colorAccent" android_layout_marginTop="40dp" android_textColor="@android:color/white"/> <Button android_id="@+id/retrieveBtn" android_layout_width="fill_parent" android_layout_height="wrap_content" android_text="Retrieve" android_clickable="true" android_background="@color/colorAccent" android_layout_marginTop="40dp" android_textColor="@android:color/white"/> </LinearLayout> </android.support.v7.widget.CardView>
(d). model.xml
This is our model or template layout for each row in our recyclerview.
At the root we have a CardView.
<?xml version="1.0" encoding="utf-8"?> <android.support.v7.widget.CardView android_orientation="horizontal" android_layout_width="match_parent" android_layout_margin="5dp" card_view_cardCornerRadius="10dp" card_view_cardElevation="5dp" android_layout_height="wrap_content"> <RelativeLayout android_layout_width="match_parent" android_layout_height="match_parent"> <TextView android_layout_width="wrap_content" android_layout_height="wrap_content" android_textAppearance="?android:attr/textAppearanceLarge" android_text="Name" android_id="@+id/nameTxt" android_padding="10dp" android_layout_alignParentTop="true" /> </RelativeLayout> </android.support.v7.widget.CardView>
4. Java Classes
Here are our Java classes:
Our Data Object
This is our POJO class. Our data object.
Represents a single Planet object with several properties.
package com.tutorials.hp.sqlitecontextmenudelete.mDataObject; public class Planet { String name; int id; public Planet() { } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getId() { return id; } public void setId(int id) { this.id = id; } }
Our SQLite classes
(a). Constants.java
This is a class that represents our SQLite database Constants. These include:
- Database name
- database version
- Table Name
- Column Names.
- SQLite Table-Creation and Table-Deletion statement.
package com.tutorials.hp.sqlitecontextmenudelete.mDataBase; public class Constants { //COLUMNS static final String ROW_ID="id"; static final String NAME="name"; //DB PROPS static final String DB_NAME="ff_DB"; static final String TB_NAME="ff_TB"; static final int DB_VERSION=1; //CREATE TB static final String CREATE_TB="CREATE TABLE ff_TB(id INTEGER PRIMARY KEY AUTOINCREMENT," + "name TEXT NOT NULL);"; //TABLE DROP STMT static final String DROP_TB="DROP TABLE IF EXISTS "+TB_NAME; }
(c). DBHelper.java
This is our SQlite database helper class.
This class derives from SQLiteOpenHelper class.
This class is responsible for two tasks:
- Creating Database Table
- Upgrading Database Table
package com.tutorials.hp.sqlitecontextmenudelete.mDataBase; import android.content.Context; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class DBHelper extends SQLiteOpenHelper { public DBHelper(Context context) { super(context, Constants.DB_NAME, null, Constants.DB_VERSION); } @Override public void onCreate(SQLiteDatabase db) { try { db.execSQL(Constants.CREATE_TB); }catch (SQLException e) { e.printStackTrace(); } } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL(Constants.DROP_TB); onCreate(db); } }
(c). DBAdapter.java
This is our SQLite database Adapter class.
This class is responsible for:
- Opening Database Connection.
- Closing Database Connection.
- Inserting Data to SQLite Database.
- Retrieving Data from SQlite database.
- Deletion of data from SQLite Database.
package com.tutorials.hp.sqlitecontextmenudelete.mDataBase; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; public class DBAdapter { Context c; SQLiteDatabase db; DBHelper helper; public DBAdapter(Context c) { this.c = c; helper=new DBHelper(c); } //OPEN public void openDB() { try { db=helper.getWritableDatabase(); }catch (SQLException e) { e.printStackTrace(); } } //CLOSE DB public void closeDB() { try { helper.close(); }catch (SQLException e) { e.printStackTrace(); } } //INSERT/SAVE public boolean add(String name) { try { ContentValues cv=new ContentValues(); cv.put(Constants.NAME, name); db.insert(Constants.TB_NAME, Constants.ROW_ID, cv); return true; }catch (SQLException e) { e.printStackTrace(); } return false; } //RETRIEVE public Cursor retrieve() { String[] columns={Constants.ROW_ID,Constants.NAME}; return db.query(Constants.TB_NAME,columns,null,null,null,null,null); } //DELETE/REMOVE public boolean delete(int id) { try { int result=db.delete(Constants.TB_NAME,Constants.ROW_ID+" =?",new String[]{String.valueOf(id)}); if(result>0) { return true; } }catch (SQLException e) { e.printStackTrace(); } return false; } }
Our RecyclerView classes
(a). MyLongClickListener.java
Our RecyclerView viewitems long click listener interface. With contextmenu we simply mean you longclick and you are then presented with a menu where you can select a menu item.Therefore we need to implement the OnLongClickListener.But first lets define its signature :
package com.tutorials.hp.sqlitecontextmenudelete.mRecycler; public interface MyLongClickListener { void onLongClick(int pos); }
(b). MyHolder.java
Our RecyclerView.ViewHolder class.The above LongClickListener interface shall get implemented by our ViewHolder class.Take note that also we implement the OnCreateContextMenuListener interface as well :
package com.tutorials.hp.sqlitecontextmenudelete.mRecycler; import android.support.v7.widget.RecyclerView; import android.view.ContextMenu; import android.view.View; import android.widget.TextView; import com.tutorials.hp.sqlitecontextmenudelete.R; public class MyHolder extends RecyclerView.ViewHolder implements View.OnLongClickListener,View.OnCreateContextMenuListener { TextView nameTxt; MyLongClickListener longClickListener; public MyHolder(View itemView) { super(itemView); this.nameTxt= (TextView) itemView.findViewById(R.id.nameTxt); itemView.setOnLongClickListener(this); itemView.setOnCreateContextMenuListener(this); } public void setLongClickListener(MyLongClickListener longClickListener) { this.longClickListener=longClickListener; } @Override public boolean onLongClick(View v) { this.longClickListener.onLongClick(getLayoutPosition()); return false; } @Override public void onCreateContextMenu(ContextMenu menu, View v, ContextMenu.ContextMenuInfo menuInfo) { //OUR CONTEXT MENU menu.setHeaderTitle("ACTION : "); menu.add(0,0,0,"New"); menu.add(0,1,0,"Delete"); } }
(c). MyAdapter.java
Our RecyclerView Adapter class.Remember we shall be using using a RecyclerView as our component,therefore here’s our adapter class. It Will inflate our model.xml layout into a view objects and bind data from the sqlite database to them.
package com.tutorials.hp.sqlitecontextmenudelete.mRecycler; import android.content.Context; import android.support.v7.widget.RecyclerView; import android.view.LayoutInflater; import android.view.View; import android.view.ViewGroup; import android.widget.Toast; import com.tutorials.hp.sqlitecontextmenudelete.R; import com.tutorials.hp.sqlitecontextmenudelete.mDataBase.DBAdapter; import com.tutorials.hp.sqlitecontextmenudelete.mDataObject.Planet; import java.util.ArrayList; public class MyAdapter extends RecyclerView.Adapter<MyHolder> { Context c; ArrayList<Planet> planets; int selectedPos; public MyAdapter(Context c, ArrayList<Planet> planets) { this.c = c; this.planets = planets; } @Override public MyHolder onCreateViewHolder(ViewGroup parent, int viewType) { View v= LayoutInflater.from(parent.getContext()).inflate(R.layout.model,parent,false); MyHolder holder=new MyHolder(v); return holder; } @Override public void onBindViewHolder(MyHolder holder, int position) { holder.nameTxt.setText(planets.get(position).getName()); holder.setLongClickListener(new MyLongClickListener() { @Override public void onLongClick(int pos) { selectedPos=pos; } }); } @Override public int getItemCount() { return planets.size(); } //DELETE PLANET public void deletePlanet() { //GET ID Planet p=planets.get(selectedPos); int id=p.getId(); //DELETE IT FROM DB DBAdapter db=new DBAdapter(c); db.openDB(); if(db.delete(id)) { //DELETE ALSO FROM ARRAYLIST planets.remove(selectedPos); }else { Toast.makeText(c,"Unable To Delete",Toast.LENGTH_SHORT).show(); } db.closeDB(); this.notifyItemRemoved(selectedPos); } }
Our Activity class
MainActivity.java
This is our main activity. It represents our UI screen.
Our UI will comprise of a RecyclerView with data items from SQLite database.
It will also host a dialog which will act as our data entry form.
package com.tutorials.hp.sqlitecontextmenudelete; import android.app.Dialog; import android.database.Cursor; import android.os.Bundle; import android.support.design.widget.FloatingActionButton; import android.support.design.widget.Snackbar; import android.support.v7.app.AppCompatActivity; import android.support.v7.widget.LinearLayoutManager; import android.support.v7.widget.RecyclerView; import android.support.v7.widget.Toolbar; import android.view.View; import android.view.Menu; import android.view.MenuItem; import android.widget.Button; import android.widget.EditText; import android.widget.Toast; import com.tutorials.hp.sqlitecontextmenudelete.mDataBase.DBAdapter; import com.tutorials.hp.sqlitecontextmenudelete.mDataObject.Planet; import com.tutorials.hp.sqlitecontextmenudelete.mRecycler.MyAdapter; import java.util.ArrayList; public class MainActivity extends AppCompatActivity { RecyclerView rv; MyAdapter adapter; EditText nameEditText; Button saveBtn,retrieveBtn; ArrayList<Planet> planets=new ArrayList<>(); @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar); setSupportActionBar(toolbar); FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab); rv= (RecyclerView) findViewById(R.id.rv); rv.setLayoutManager(new LinearLayoutManager(this)); adapter=new MyAdapter(this,planets); fab.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { displayDialog(); } }); } private void displayDialog() { Dialog d=new Dialog(this); d.setTitle("SQLite Database"); d.setContentView(R.layout.dialog_layout); nameEditText= (EditText) d.findViewById(R.id.nameEditTxt); saveBtn= (Button) d.findViewById(R.id.saveBtn); retrieveBtn= (Button) d.findViewById(R.id.retrieveBtn); saveBtn.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { save(nameEditText.getText().toString()); } }); retrieveBtn.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { getPlanets(); } }); d.show(); } private void save(String name) { DBAdapter db=new DBAdapter(this); db.openDB(); if(db.add(name)) { nameEditText.setText(""); }else { Toast.makeText(this,"Unable To Save",Toast.LENGTH_SHORT).show(); } db.closeDB(); //REFRESH getPlanets(); } private void getPlanets() { planets.clear(); DBAdapter db=new DBAdapter(this); db.openDB(); Planet p=null; Cursor c=db.retrieve(); while (c.moveToNext()) { int id=c.getInt(0); String name=c.getString(1); p=new Planet(); p.setId(id); p.setName(name); planets.add(p); } db.closeDB(); if(planets.size()>0) { rv.setAdapter(adapter); } } @Override public boolean onContextItemSelected(MenuItem item) { if(item.getTitle()=="New") { displayDialog(); }else if(item.getTitle()=="Delete") { adapter.deletePlanet(); } return super.onContextItemSelected(item); } }
Download
No. | Location | Link |
---|---|---|
1. | GitHub | Direct Download) |
2. | GitHub | Browse |
3. | YouTube | Video Tutorial |
4. | YouTube | Our YouTube Channel |