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>
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>