how to create database sqlite on android

MainActivity.java

package com.sqlexample;

import java.io.IOException;
import java.util.ArrayList;

import android.app.Activity;
import android.content.Context;
import android.database.SQLException;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;

public class MainActivity extends Activity {

    public static ListView listView;
    private Button btnsave, btnshow;
    DataBaseHelper myDbHelper;
    private EditText fname, lname, age;
    public static Context con;
    public static String Mfname, Mlname, Mage;
   
    public static void Insert_Success_responces(Context myContext) {
       
    }
    static ArrayList<Datalist> arr_ = new ArrayList<Datalist>();
    public static void select_responces(Context conn, ArrayList<Datalist> data) {
        con = conn;
        arr_ = data;

        info_Baseadepter adepter = new info_Baseadepter(conn, data);
        listView.setAdapter(adepter);

    }
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        btnsave = (Button) findViewById(R.id.button1);
        btnshow = (Button) findViewById(R.id.button2);
        listView=(ListView)findViewById(R.id.listView1);

        fname = (EditText) findViewById(R.id.editText1);
        lname = (EditText) findViewById(R.id.editText2);
        age = (EditText) findViewById(R.id.editText3);
       
        btnsave.setOnClickListener(new OnClickListener() {

            @Override
            public void onClick(View v) {

                Mfname=fname.getText().toString();
                Mlname=lname.getText().toString();
                Mage=age.getText().toString();
               
                if(!Mfname.equals("")&&!Mlname.equals("")&&!Mage.equals("")){
                   
                    myDbHelper = new DataBaseHelper(MainActivity.this);
                    try {
                        myDbHelper.createDataBase();
                    } catch (IOException ioe) {
                        throw new Error("Unable to create database");
                    }
                    try {
                        myDbHelper.openDataBase();
                    } catch (SQLException sqle) {
                        throw sqle;
                    }

                    myDbHelper.Insert_data();
                   
                }else{
                   
                    Toast.makeText(MainActivity.this,"Enter value", Toast.LENGTH_SHORT).show();
                }
               
            }
        });
        btnshow.setOnClickListener(new OnClickListener() {
           
            @Override
            public void onClick(View v) {
               
                myDbHelper = new DataBaseHelper(MainActivity.this);
                try {
                    myDbHelper.createDataBase();
                } catch (IOException ioe) {
                    throw new Error("Unable to create database");
                }
                try {
                    myDbHelper.openDataBase();
                } catch (SQLException sqle) {
                    throw sqle;
                }

                myDbHelper.Select_Data();
            }
        });
    }

}

DataBaseHelper.java

package com.sqlexample;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;

public class DataBaseHelper extends SQLiteOpenHelper {

    private static String DB_PATH = "/data/data/com.sqlexample/databases/";
    private static String DB_NAME = "personalinformation.db";
    public SQLiteDatabase myDataBase;

    public ArrayList<Datalist> arr_info = null;

    private Context myContext;
    public Cursor allrow;
    Activity ll;
    int id;

    public DataBaseHelper(Context context) {
        super(context, DB_NAME, null, 1);
        this.myContext = context;
    }

    public void createDataBase() throws IOException {
        boolean dbExist = checkDataBase();
        if (dbExist) {
           
        } else {
           
            this.getReadableDatabase();
            try {
                copyDataBase();
            } catch (IOException e) {
                throw new Error("Error copying database");
            }
        }
    }

    private boolean checkDataBase() {
        SQLiteDatabase checkDB = null;
        try {
            String myPath = DB_PATH + DB_NAME;
            checkDB = SQLiteDatabase.openDatabase(myPath, null,SQLiteDatabase.OPEN_READWRITE);
        } catch (SQLiteException e) {
           
        }
        if (checkDB != null) {
            checkDB.close();
        }
        return checkDB != null ? true : false;
    }

    private void copyDataBase() throws IOException {
       
        InputStream myInput = myContext.getAssets().open(DB_NAME);
       
        String outFileName = DB_PATH + DB_NAME;
       
        OutputStream myOutput = new FileOutputStream(outFileName);
       
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myInput.read(buffer)) > 0) {
            myOutput.write(buffer, 0, length);
        }
       
        myOutput.flush();
        myOutput.close();
        myInput.close();
    }

    public void openDataBase() throws SQLException {
       
        String myPath = DB_PATH + DB_NAME;
        myDataBase = SQLiteDatabase.openDatabase(myPath, null,
                SQLiteDatabase.OPEN_READWRITE);
    }

    @Override
    public synchronized void close() {

        if (myDataBase != null)
            myDataBase.close();

        super.close();

    }

    @Override
    public void onCreate(SQLiteDatabase db) {

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    public void Insert_data() {

        try {

            ContentValues values = new ContentValues();

            values.put("fname", MainActivity.Mfname);
            values.put("lname", MainActivity.Mlname);
            values.put("age", MainActivity.Mage);
           

            myDataBase.insert("personainfo", null, values);

            MainActivity.Insert_Success_responces(myContext);

        } catch (Exception e) {

        }
    }

    @SuppressWarnings("deprecation")
    public void Select_Data() {

        arr_info = null;

        try {

            String[] Resultcol = new String[] { "fname", "lname", "age"};
            allrow = myDataBase.query("personainfo", Resultcol, null, null,null, null, null);

            int fname = allrow.getColumnIndex("fname");
            int lname = allrow.getColumnIndex("lname");
            int age = allrow.getColumnIndex("age");

            allrow.moveToFirst();
           
            for (int i = 0; i < allrow.getCount(); i++) {

                if (arr_info == null) {
                    arr_info = new ArrayList<Datalist>();

                }

                Datalist data = new Datalist();

                data.Fname = allrow.getString(fname);
                data.Lname = allrow.getString(lname);
                data.Age = allrow.getString(age);
               
                arr_info.add(data);

                allrow.moveToNext();

                ll = new Activity();

                ll.startManagingCursor(allrow);

            }

            MainActivity.select_responces(myContext, arr_info);

        } catch (Exception e) {

           
        }

    }
}

Datalist.java

package com.sqlexample;

public class Datalist {

    String Fname,Lname,Age;
}

info_Baseadepter.java

package com.sqlexample;

import java.util.ArrayList;

import android.app.Activity;
import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;

public class info_Baseadepter extends BaseAdapter {

    LayoutInflater mInflater;
    public Activity activity;
    ArrayList<Datalist> data;
    public Context mContext;
   
    info_Baseadepter(Context activity, ArrayList<Datalist> data) {

        mContext = activity;
        this.activity = (Activity) activity;
        this.data = data;

        mInflater = (LayoutInflater) activity.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
       

    }

    public int getCount() {
        try {
            return data.size();

        } catch (Exception e) {
            // TODO: handle exception
        }
        return 0;
    }

    public Object getItem(int position) {
        // TODO Auto-generated method stub
        return null;
    }

    public long getItemId(int position) {
        // TODO Auto-generated method stub
        return position;
    }

    public class getitemutils {

        public TextView tv_fnmae, tv_lname,tv_age;
    }

    public View getView(final int position, View convertView, ViewGroup parent) {
        View vi = convertView;
        final getitemutils item = new getitemutils();
        vi = mInflater.inflate(R.layout.listitem, null);

        item.tv_fnmae = (TextView) vi.findViewById(R.id.textView1);
        item.tv_lname = (TextView) vi.findViewById(R.id.textView2);
        item.tv_age =(TextView) vi.findViewById(R.id.textView3);

       

        item.tv_fnmae.setText(data.get(position).Fname);
        item.tv_lname.setText(data.get(position).Lname);
        item.tv_age.setText(data.get(position).Age);

        return vi;
    }

}

activity_main.xml

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:id="@+id/container"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <LinearLayout
        android:id="@+id/container2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:orientation="horizontal" >

        <TextView
            android:id="@+id/textView1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="First Name:" />

        <EditText
            android:id="@+id/editText1"
            android:layout_width="200dp"
            android:layout_height="wrap_content"
            android:layout_weight="1" />
    </LinearLayout>

    <LinearLayout
        android:id="@+id/container3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/container2"
        android:layout_centerHorizontal="true"
        android:orientation="horizontal" >

        <TextView
            android:id="@+id/textView2"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Last Name:" />

        <EditText
            android:id="@+id/editText2"
            android:layout_width="200dp"
            android:layout_height="wrap_content"
            android:layout_weight="1" />
    </LinearLayout>

    <LinearLayout
        android:id="@+id/container4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/container3"
        android:layout_centerHorizontal="true"
        android:orientation="horizontal" >

        <TextView
            android:id="@+id/textView3"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Age:            " />

        <EditText
            android:id="@+id/editText3"
            android:layout_width="200dp"
            android:layout_height="wrap_content"
            android:layout_weight="1" />
    </LinearLayout>

    <LinearLayout
        android:id="@+id/container5"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/container4"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="5dp" >

        <Button
            android:id="@+id/button1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Save Data" />

        <Button
            android:id="@+id/button2"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Show Data" />
    </LinearLayout>

    <RelativeLayout
        android:id="@+id/container6"
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:layout_below="@+id/container5"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="5dp" >

        <ListView
            android:id="@+id/listView1"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_centerHorizontal="true"
            android:layout_centerVertical="true" >
        </ListView>

    </RelativeLayout>

</RelativeLayout>

listitem.xml

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <LinearLayout
        android:id="@+id/container"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:orientation="horizontal" >

        <TextView
            android:id="@+id/textView1"
            android:layout_width="0dp"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="TextView" />

        <TextView
            android:id="@+id/textView2"
            android:layout_width="0dp"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="TextView" />

        <TextView
            android:id="@+id/textView3"
            android:layout_width="0dp"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="TextView" />
    </LinearLayout>

</RelativeLayout>