Book App Using Sqlite - Android Studio Tutorial

     DESCRIPTION     

This tutorial is about creating the Book App using SQLite. I'll use Tabbed Activity , swipe to change the page. Each record in SQLite file contains Id(as page no) , Chapter Name , Title , Detail.

     VIDEO     

     SOURCE CODE     

Step 1: Create a new project OR Open your project (Use Tabbed Activity)

Step 2: Create assets folder. Place 'mybook' SQLite file in assets folder

Step 3: Code

Model.java

package com.blogspot.devofandroid.bookappusingsqlite;public class Model {int ids;String chapters;String titles;String details;//constructorpublic Model(int ids , String chapters , String titles , String details) {this.ids = ids;this.chapters = chapters;this.titles = titles;this.details = details;}public int getIds() {return ids;}public void setIds(int ids) {this.ids = ids;}public String getChapters() {return chapters;}public void setChapters(String chapters) {this.chapters = chapters;}public String getTitles() {return titles;}public void setTitles(String titles) {this.titles = titles;}public String getDetails() {return details;}public void setDetails(String details) {this.details = details;}}

SqlLiteDbHelper.java

package com.blogspot.devofandroid.bookappusingsqlite;import android.content.Context;import android.database.Cursor;import android.database.SQLException;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.widget.Toast;import java.io.File;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.util.ArrayList;public class SqlLiteDbHelper extends SQLiteOpenHelper {private static final int DATABASE_VERSION =1;private static final  String DATABASE_NAME = "mybook";private static final String DB_PATH_SUFFIX = "/databases/";static Context mCtx;SqlLiteDbHelper(Context context){super(context , DATABASE_NAME , null , DATABASE_VERSION);mCtx = context;}//get details from dbpublic ArrayList<Model> getDetails(){SQLiteDatabase db = this.getReadableDatabase();ArrayList<Model> modelList = new ArrayList<>();Cursor cursor = db.rawQuery("SELECT * FROM booktable" , null);if (cursor!=null){while (cursor.moveToNext()){Model count = new Model(cursor.getInt(0) , cursor.getString(1) , cursor.getString(2)  , cursor.getString(3));modelList.add(count);}cursor.close();db.close();}return modelList;}public void CopyDatabaseFromAssets() throws IOException{InputStream myInput = mCtx.getAssets().open(DATABASE_NAME);//path to the created dbString outFileName = getDatabasePath();//if the path doesnt exists first. create itFile f = new File(mCtx.getApplicationInfo().dataDir + DB_PATH_SUFFIX);if (!f.exists())f.mkdir();//open the db as the output streamOutputStream myOutput = new FileOutputStream(outFileName);//transfer bytes from the inputfile to the output filebyte[] buffer = new byte[1024];int length;while ((length = myInput.read(buffer))>0){myOutput.write(buffer ,0 ,length);}//close streammyOutput.flush();myOutput.close();myInput.close();}private static String getDatabasePath() {return mCtx.getApplicationInfo().dataDir + DB_PATH_SUFFIX+ DATABASE_NAME;}public SQLiteDatabase openDataBase() throws SQLException{File dbFile = mCtx.getDatabasePath(DATABASE_NAME);if (!dbFile.exists()){try {CopyDatabaseFromAssets();Toast.makeText(mCtx , "Coppying success from assets folder" , Toast.LENGTH_SHORT).show();}catch (IOException e){throw new RuntimeException("Error creating source database" , e);}}return SQLiteDatabase.openDatabase(dbFile.getPath() , null ,SQLiteDatabase.NO_LOCALIZED_COLLATORS | SQLiteDatabase.CREATE_IF_NECESSARY);}@Overridepublic void onCreate(SQLiteDatabase sqLiteDatabase) {}@Overridepublic void onUpgrade(SQLiteDatabase sqLiteDatabase , int i , int i1) {}}

activity_main.xml

<?xml version="1.0" encoding="utf-8"?><android.support.design.widget.CoordinatorLayout 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:id="@+id/main_content"android:layout_width="match_parent"android:layout_height="match_parent"android:fitsSystemWindows="true"tools:context=".MainActivity"><android.support.design.widget.AppBarLayoutandroid:id="@+id/appbar"android:layout_width="match_parent"android:layout_height="wrap_content"android:paddingTop="@dimen/appbar_padding_top"android:theme="@style/AppTheme.AppBarOverlay"><android.support.v7.widget.Toolbarandroid:id="@+id/toolbar"android:layout_width="match_parent"android:layout_height="?attr/actionBarSize"android:layout_weight="1"android:background="?attr/colorPrimary"app:layout_scrollFlags="scroll|exitUntilCollapsed"app:popupTheme="@style/AppTheme.PopupOverlay"app:title="@string/app_name"></android.support.v7.widget.Toolbar></android.support.design.widget.AppBarLayout><android.support.v4.view.ViewPagerandroid:id="@+id/container"android:layout_width="match_parent"android:layout_height="match_parent"app:layout_behavior="@string/appbar_scrolling_view_behavior" /></android.support.design.widget.CoordinatorLayout>

fragment_main.xml

<?xml version="1.0" encoding="utf-8"?><FrameLayout 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:id="@+id/constraintLayout"android:layout_width="match_parent"android:layout_height="match_parent"tools:context=".MainActivity$PlaceholderFragment"><ScrollViewandroid:layout_width="match_parent"android:layout_height="wrap_content"><LinearLayoutandroid:layout_width="match_parent"android:layout_height="wrap_content"android:orientation="vertical"android:padding="5dp"><Viewandroid:layout_width="50dp"android:layout_height="1dp"android:layout_gravity="center"android:background="@color/colorPrimaryDark"/><TextViewandroid:id="@+id/pageTv"android:text="01"android:textAlignment="center"android:layout_width="match_parent"android:layout_height="wrap_content" /><Viewandroid:layout_width="50dp"android:layout_height="1dp"android:layout_gravity="center"android:background="@color/colorPrimaryDark"/><TextViewandroid:id="@+id/chaptTv"android:text="Chapter"android:textStyle="bold|italic"android:textAlignment="center"android:textColor="@color/colorPrimaryDark"android:textSize="30sp"android:layout_width="match_parent"android:layout_height="wrap_content" /><TextViewandroid:id="@+id/titleTv"android:text="Title"android:textStyle="bold"android:textColor="#000"android:textSize="22sp"android:layout_width="match_parent"android:layout_height="wrap_content" /><TextViewandroid:id="@+id/detailTv"android:text="Detail of the title"android:textColor="#000"android:layout_width="match_parent"android:layout_height="wrap_content" /></LinearLayout></ScrollView><TextViewandroid:id="@+id/section_label"android:layout_width="wrap_content"android:layout_height="wrap_content"android:layout_marginStart="@dimen/activity_horizontal_margin"android:layout_marginTop="@dimen/activity_vertical_margin"android:layout_marginEnd="@dimen/activity_horizontal_margin"android:layout_marginBottom="@dimen/activity_vertical_margin"app:layout_constraintLeft_toLeftOf="parent"app:layout_constraintTop_toTopOf="@+id/constraintLayout"tools:layout_constraintLeft_creator="1"tools:layout_constraintTop_creator="1" /></FrameLayout>

MainActivity.java

package com.blogspot.devofandroid.bookappusingsqlite;import android.support.design.widget.FloatingActionButton;import android.support.design.widget.Snackbar;import android.support.v7.app.AppCompatActivity;import android.support.v7.widget.Toolbar;import android.support.v4.app.Fragment;import android.support.v4.app.FragmentManager;import android.support.v4.app.FragmentPagerAdapter;import android.support.v4.view.ViewPager;import android.os.Bundle;import android.view.LayoutInflater;import android.view.Menu;import android.view.MenuItem;import android.view.View;import android.view.ViewGroup;import android.widget.TextView;import java.util.ArrayList;public class MainActivity extends AppCompatActivity {/** * The {@link android.support.v4.view.PagerAdapter} that will provide * fragments for each of the sections. We use a * {@link FragmentPagerAdapter} derivative , which will keep every * loaded fragment in memory. If this becomes too memory intensive , it * may be best to switch to a * {@link android.support.v4.app.FragmentStatePagerAdapter}. */private SectionsPagerAdapter mSectionsPagerAdapter;/** * The {@link ViewPager} that will host the section contents. */private ViewPager mViewPager;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);setSupportActionBar(toolbar);// Create the adapter that will return a fragment for each of the three// primary sections of the activity.mSectionsPagerAdapter = new SectionsPagerAdapter(getSupportFragmentManager());// Set up the ViewPager with the sections adapter.mViewPager = (ViewPager) findViewById(R.id.container);mViewPager.setAdapter(mSectionsPagerAdapter);}@Overridepublic boolean onCreateOptionsMenu(Menu menu) {// Inflate the menu; this adds items to the action kafe if it is present.getMenuInflater().inflate(R.menu.menu_main , menu);return true;}@Overridepublic boolean onOptionsItemSelected(MenuItem item) {// Handle action kafe item clicks here. The action kafe will// automatically handle clicks on the Home/Up button , so long// as you specify a parent activity in AndroidManifest.xml.int id = item.getItemId();//noinspection SimplifiableIfStatementif (id == R.id.action_settings) {return true;}return super.onOptionsItemSelected(item);}/** * A placeholder fragment containing a simple view. */public static class PlaceholderFragment extends Fragment {/** * The fragment argument representing the section number for this * fragment. */private static final String ARG_SECTION_NUMBER = "section_number";public PlaceholderFragment() {}/** * Returns a new instance of this fragment for the given section * number. */public static PlaceholderFragment newInstance(int sectionNumber) {PlaceholderFragment fragment = new PlaceholderFragment();Bundle args = new Bundle();args.putInt(ARG_SECTION_NUMBER , sectionNumber);fragment.setArguments(args);return fragment;}@Overridepublic View onCreateView(LayoutInflater inflater , ViewGroup container , Bundle savedInstanceState) {View v = inflater.inflate(R.layout.fragment_main , container , false);TextView mPageTv , mChaptTv , mTitleTv , mDetailTv;mPageTv = v.findViewById(R.id.pageTv);mChaptTv = v.findViewById(R.id.chaptTv);mTitleTv = v.findViewById(R.id.titleTv);mDetailTv = v.findViewById(R.id.detailTv);SqlLiteDbHelper dbHelper;ArrayList<Model> modelList;int page = 0;String chap="" , title="" , detail="";modelList = new ArrayList<>();modelList.clear();dbHelper = new SqlLiteDbHelper(getContext());dbHelper.openDataBase();modelList = dbHelper.getDetails();if (getArguments().getInt(ARG_SECTION_NUMBER)==1){//get first recordModel count = modelList.get(0);//save record in stringspage = page + count.getIds();chap = chap + count.getChapters();title = title + count.getTitles();detail = detail + count.getDetails().replace(" , , , ," ,"\n");//set in TextViewmPageTv.setText(page+"");mChaptTv.setText(chap);mTitleTv.setText(title);mDetailTv.setText(detail);return v;}if (getArguments().getInt(ARG_SECTION_NUMBER)==2){//get second recordModel count = modelList.get(1);//save record in stringspage = page + count.getIds();chap = chap + count.getChapters();title = title + count.getTitles();detail = detail + count.getDetails().replace(" , , , ," ,"\n");//set in TextViewmPageTv.setText(page+"");mChaptTv.setText(chap);mTitleTv.setText(title);mDetailTv.setText(detail);return v;}if (getArguments().getInt(ARG_SECTION_NUMBER)==3){//get third recordModel count = modelList.get(2);//save record in stringspage = page + count.getIds();chap = chap + count.getChapters();title = title + count.getTitles();detail = detail + count.getDetails().replace(" , , , ," ,"\n");//set in TextViewmPageTv.setText(page+"");mChaptTv.setText(chap);mTitleTv.setText(title);mDetailTv.setText(detail);return v;}if (getArguments().getInt(ARG_SECTION_NUMBER)==4){//get fourth recordModel count = modelList.get(3);//save record in stringspage = page + count.getIds();chap = chap + count.getChapters();title = title + count.getTitles();detail = detail + count.getDetails().replace(" , , , ," ,"\n");//set in TextViewmPageTv.setText(page+"");mChaptTv.setText(chap);mTitleTv.setText(title);mDetailTv.setText(detail);return v;}if (getArguments().getInt(ARG_SECTION_NUMBER)==5){//get fifth recordModel count = modelList.get(4);//save record in stringspage = page + count.getIds();chap = chap + count.getChapters();title = title + count.getTitles();detail = detail + count.getDetails().replace(" , , , ," ,"\n");//set in TextViewmPageTv.setText(page+"");mChaptTv.setText(chap);mTitleTv.setText(title);mDetailTv.setText(detail);return v;}return v;}}/** * A {@link FragmentPagerAdapter} that returns a fragment corresponding to * one of the sections/tabs/pages. */public class SectionsPagerAdapter extends FragmentPagerAdapter {public SectionsPagerAdapter(FragmentManager fm) {super(fm);}@Overridepublic Fragment getItem(int position) {// getItem is called to instantiate the fragment for the given page.// Return a PlaceholderFragment (defined as a static inner class below).return PlaceholderFragment.newInstance(position + 1);}@Overridepublic int getCount() {// Show 5 total pages.return 5;}}}

Step 4: Run Project

Output

     DOWNLOAD FROM GITHUB