How to get the data through Parsing with SQLite in android studio.

File => New => New Project => Configure your new project => Select the form factor yours app will run on => Add an Activity to Mobile => Customize the Activity => Finish.
First we need to add Volley Library to our project.
    compile 'com.android.support:design:23.1.1'
    compile 'com.google.code.gson:gson:2.2.3'
    compile 'org.apache.httpcomponents:httpclient:4.5'
    compile 'org.jbundle.util.osgi.wrapped:org.jbundle.util.osgi.wrapped.org.apache.http.client:4.1.2'
    compile files('libs/picasso-2.5.0.jar')  

Create Xml file in project.   

Open => app => res => layout - activity_main.xml.

<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"
    tools:context=".MainActivity">

    <ListView
        android:id="@+id/listview"
        android:layout_width="match_parent"
        android:layout_height="match_parent"/>
</LinearLayout>

Open => app => res => layout - row_item.xml.

<?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:background="#307fc1"
    android:orientation="vertical"
    android:padding="8dp">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content">

        <TextView
            android:id="@+id/txtname"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_gravity="center"
            android:text="Kamal Sharma"
            android:textAppearance="?android:attr/textAppearanceMedium"
            android:textColor="#ffffff" />

        <ImageView
            android:id="@+id/img"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_gravity="right"
            android:layout_marginLeft="42dp"
            android:src="@drawable/ic_launcher" />

    </LinearLayout>

    <TextView
        android:id="@+id/txtdes"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginTop="4dp"
        android:text="William Bradley 'Brad'"
        android:textAppearance="?android:attr/textAppearanceSmall"
        android:textColor="#ffffff" />

    <TextView
        android:id="@+id/txtdob"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginTop="8dp"
        android:text="14-09-1989"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:textColor="#ffffff" />

    <TextView
        android:id="@+id/txtcountry"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginTop="8dp"
        android:text="United States"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:textColor="#ffffff" />

    <TextView
        android:id="@+id/txtheight"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginTop="8dp"
        android:text="1.80m"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:textColor="#ffffff" />

    <TextView
        android:id="@+id/txtchildren"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginTop="8dp"
        android:text="ABC,XYZ"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:textColor="#ffffff" />
  
</LinearLayout>

Create the Java file in project.

Open app => main => src = MainActivity.java

package com.appified.jsonparsingexample;

import android.annotation.SuppressLint;
import android.app.Activity;
import android.os.AsyncTask;
import android.os.Bundle;
import android.util.Log;
import android.widget.ListView;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.util.EntityUtils;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import java.io.IOException;
import java.util.ArrayList;


public class MainActivity extends AppCompatActivity{
    ListView listView;
    CustomAdapter adapter;
    ArrayList<CustomItem> arrayList;
    DBHandler handler;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        listView = (ListView) findViewById(R.id.listview);
        handler = new DBHandler(this);
        NetworkUtils utils = new NetworkUtils(MainActivity.this);
        if(handler.getItemCount() == 0 && utils.isConnectingToInternet())
        {
            new DataFetcherTask().execute();
        }
        else
        {
             ArrayList<CustomItem> cityList = handler.getAllItem();
            adapter = new CustomAdapter(MainActivity.this,cityList);
            listView.setAdapter(adapter);
        }
        }
    @SuppressLint("NewApi") class DataFetcherTask extends AsyncTask<Void,Void,Void> {

        @SuppressLint("NewApi") @Override
        protected void onPreExecute() {
            super.onPreExecute();
        }

        @SuppressWarnings("deprecation")
        @Override
        protected Void doInBackground(Void... params) {
            String serverData = null;// String object to store fetched data from server
            // HTTP Request Code start
            DefaultHttpClient httpClient = new DefaultHttpClient();
            HttpGet httpGet = new HttpGet("http://microblogging.wingnity.com/JSONParsingTutorial/jsonActors");
            try {
                HttpResponse httpResponse = httpClient.execute(httpGet);
                HttpEntity httpEntity = httpResponse.getEntity();
                serverData = EntityUtils.toString(httpEntity);
                Log.d("response", serverData);
            } catch (ClientProtocolException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
             // HTTP Request Code end
            // JSON Parsing Code Start
            try {
                arrayList = new ArrayList<CustomItem>();
                JSONObject jsonObject = new JSONObject(serverData);
                JSONArray jsonArray = jsonObject.getJSONArray("actors");
                for(int i=0;i<jsonArray.length();i++)
                {
                    JSONObject jsonObjectItem = jsonArray.getJSONObject(i);
                    String Name = jsonObjectItem.getString("name");
                    String Desc = jsonObjectItem.getString("description");
                    String DOB = jsonObjectItem.getString("dob");
                    String Country= jsonObjectItem.getString("country");
                    String Height = jsonObjectItem.getString("height");
                    String children=jsonObjectItem.getString("children");
                    CustomItem value = new CustomItem();
                    value.setName(Name);
                    value.setDesc(Desc);
                    value.setDob(DOB);
                    value.setCountry(Country);
                    value.setHeight(Height);
                    value.setchildren(children);
                    handler.addItem(value);  // Inserting into DB
                }
            } catch (JSONException e) {
                e.printStackTrace();
            }
            //Json Parsing code end
            return null;
        }

        @Override
        protected void onPostExecute(Void aVoid) {
            super.onPostExecute(aVoid);
            ArrayList<CustomItem> itemList = handler.getAllItem();
            adapter = new CustomAdapter(MainActivity.this,itemList);
            listView.setAdapter(adapter);
        }
    }
}
 Create the CustomListener class in project

package com.appified.jsonparsingexample;

import java.util.ArrayList;

public interface CustomListener {

    public void addItem(CustomItem city);
    public ArrayList<CustomItem> getAllItem();
    public int getItemCount();
}

 Create the CustomItem class in project

package com.appified.jsonparsingexample;


public class CustomItem {

    private int id;
    private String name;
    private String Desc;
    private String DOB;
    private String Country;
    private String height;
    private String children;
    private String Image;

    public CustomItem() {
    }

    public CustomItem(String name, String Desc, String DOB, String Country, String height, String children, String Image) {
        this.name = name;
        this.Desc = Desc;
        this.DOB = DOB;
        this.Country = Country;
        this.height = height;
        this.children = children;
        this.Image = Image;
    }

    public CustomItem(int id, String name, String Desc, String DOB, String Country, String height, String children, String Image) {
        this.id = id;
        this.name = name;
        this.Desc = Desc;
        this.DOB = DOB;
        this.Country = Country;
        this.height = height;
        this.children = children;
        this.Image = Image;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDesc() {
        return Desc;
    }

    public void setDesc(String Desc) {
        this.Desc = Desc;
    }

    public String getDob() {
        return DOB;
    }

    public void setDob(String DOB) {
        this.DOB = DOB;
    }

    public String getCountry() {
        return Country;
    }

    public void setCountry(String Country) {
        this.Country = Country;
    }

    public String getHeight() {
        return height;
    }

    public void setHeight(String height) {
        this.height = height;
    }

    public String getChildren() {
        return children;
    }

    public void setchildren(String children) {
        this.children = children;
    }

    public String getImage() {
        return children;
    }

    public void setImage(String Image) {
        this.Image = Image;
    }
}

Create the CustomAdapter class in project

package com.appified.jsonparsingexample;

import java.util.ArrayList;
import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ImageView;
import android.widget.TextView;


public class CustomAdapter extends BaseAdapter {

    Context context;
    ArrayList<CustomItem> listData;


    public CustomAdapter(Context context, ArrayList<CustomItem> listData) {
        this.context = context;
        this.listData = listData;
    }

    @Override
    public int getCount() {
        return listData.size();
    }

    @Override
    public Object getItem(int position) {
        return listData.get(position);
    }

    @Override
    public long getItemId(int position) {
        return position;
    }

    class ViewHolder {
        private TextView textViewCityName, txtDesc, txtDob, txtcountry, txtheight, txtchildren;
        ImageView image;

    }

    @Override
    public View getView(int position, View view, ViewGroup viewGroup) {
        ViewHolder viewHolder = null;
        if (view == null) {
            LayoutInflater inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
            view = inflater.inflate(R.layout.row_item, null);
            viewHolder = new ViewHolder();
            viewHolder.textViewCityName = (TextView) view.findViewById(R.id.txtname);
            viewHolder.txtDesc = (TextView) view.findViewById(R.id.txtdes);
            viewHolder.txtDob = (TextView) view.findViewById(R.id.txtdob);
            viewHolder.txtcountry = (TextView) view.findViewById(R.id.txtcountry);
            viewHolder.txtheight = (TextView) view.findViewById(R.id.txtheight);
            viewHolder.image = (ImageView) view.findViewById(R.id.image);
            viewHolder.txtchildren = (TextView) view.findViewById(R.id.txtchildren);

            view.setTag(viewHolder);
        } else {
            viewHolder = (ViewHolder) view.getTag();
        }

        viewHolder.textViewCityName.setText(listData.get(position).getName());
        viewHolder.txtDesc.setText(listData.get(position).getDesc());
        viewHolder.txtDob.setText(listData.get(position).getDob());
        viewHolder.txtcountry.setText(listData.get(position).getCountry());
        viewHolder.txtheight.setText(listData.get(position).getHeight());
        viewHolder.txtchildren.setText(listData.get(position).getChildren());
        // Picasso.with(context).load(listData.get(position).getImage()).resize(150, 150).into(viewHolder.image);
      
     /*   viewHolder.image.setOnClickListener(new OnClickListener() {
          
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
          
              
            }
        });*/

        return view;
    }
}

Create the NetworkUtils class in project

package com.appified.jsonparsingexample;

import android.content.Context;
import android.net.ConnectivityManager;
import android.net.NetworkInfo;


public class NetworkUtils {

    private Context context;

    public NetworkUtils(Context context) {
        this.context = context;
    }

    public boolean isConnectingToInternet() {
        ConnectivityManager connectivity = (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE);
        if (connectivity != null) {
            NetworkInfo[] info = connectivity.getAllNetworkInfo();
            if (info != null)
                for (int i = 0; i < info.length; i++)
                    if (info[i].getState() == NetworkInfo.State.CONNECTED) {
                        return true;
                    }

        }
        return false;
    }
}

Create the DBHandler class in project

package com.appified.jsonparsingexample;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import java.util.ArrayList;

public class DBHandler extends SQLiteOpenHelper implements CustomListener {
    private static final int DB_VERSION = 1;
    private static final String DB_NAME = "Database.db";
    private static final String TABLE_NAME = "item_table";
    private static final String KEY_ID = "_id";
    private static final String KEY_NAME = "_name";
    private static final String KEY_DESC = "_state";
    private static final String KEY_DOB = "_description";
    private static final String KEY_COUNTRY = "_country";
    private static final String KEY_HEIGHT = "_height";
    private static final String KEY_CHILDREN = "_children";

    String CREATE_TABLE = "CREATE TABLE "+TABLE_NAME+" ("+KEY_ID+" INTEGER PRIMARY KEY,"+KEY_NAME+" TEXT,"+KEY_DESC+" TEXT,"+KEY_DOB+" TEXT,"+KEY_COUNTRY+" TEXT,"+KEY_HEIGHT+" TEXT,"+KEY_CHILDREN+" TEXT)";
    String DROP_TABLE = "DROP TABLE IF EXISTS "+TABLE_NAME;

    public DBHandler(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL(DROP_TABLE);
        onCreate(db);
    }

    @Override
    public void addItem(CustomItem item) {
        SQLiteDatabase db = this.getWritableDatabase();
        try{
            ContentValues values = new ContentValues();
            values.put(KEY_NAME, item.getName());
            values.put(KEY_DESC, item.getDesc());
            values.put(KEY_DOB,item.getDob());
            values.put(KEY_COUNTRY, item.getCountry());
            values.put(KEY_HEIGHT, item.getHeight());
            values.put(KEY_CHILDREN, item.getChildren());
            db.insert(TABLE_NAME, null, values);
            db.close();
        }catch (Exception e){
            Log.e("problem",e+"");
        }
    }

    @Override
    public ArrayList<CustomItem> getAllItem() {
        SQLiteDatabase db = this.getReadableDatabase();
        ArrayList<CustomItem> itemList = null;
        try{
            itemList = new ArrayList<CustomItem>();
            String QUERY = "SELECT * FROM "+TABLE_NAME;
            Cursor cursor = db.rawQuery(QUERY, null);
            if(!cursor.isLast())
            {
                while (cursor.moveToNext())
                {
                    CustomItem item = new CustomItem();
                    item.setId(cursor.getInt(0));
                    item.setName(cursor.getString(1));
                    item.setDesc(cursor.getString(2));
                    item.setDob(cursor.getString(3));
                    item.setCountry(cursor.getString(4));
                    item.setHeight(cursor.getString(5));
                    item.setchildren(cursor.getString(6));
                    itemList.add(item);
                }
            }
            db.close();
        }catch (Exception e){
            Log.e("error",e+"");
        }
        return itemList;
    }

    @Override
    public int getItemCount() {
        int num = 0;
        SQLiteDatabase db = this.getReadableDatabase();
        try{
            String QUERY = "SELECT * FROM "+TABLE_NAME;
            Cursor cursor = db.rawQuery(QUERY, null);
            num = cursor.getCount();
            db.close();
            return num;
        }catch (Exception e){
            Log.e("error",e+"");
        }
        return 0;
    }
}

Add Internet permission in your manifest
 <uses-permission android:name="android.permission.INTERNET"/>


May this code help you. Thanks!!!!!!