ANDROID
Android Sqlite Database Example
Java Code(SQLiteAct)
import android.app.Activity; import android.content.ContentValues; import android.content.Intent; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.EditText; import android.widget.TextView; public class SQLiteAct extends Activity { EditText et1,et2,et3; TextView tv1,tv2,tv3; String id; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_sqlite); et1 = (EditText)findViewById(R.id.editText); et2 = (EditText)findViewById(R.id.editText2); et3 = (EditText)findViewById(R.id.editText3); tv1 = (TextView) findViewById(R.id.tv1); tv2 = (TextView) findViewById(R.id.tv2); tv3 = (TextView) findViewById(R.id.tv3); } public void saveIntoSQLite(View v) { id = et1.getText().toString().trim(); String name = et2.getText().toString().trim(); String sal = et3.getText().toString().trim(); MyDB mdb = new MyDB(this); SQLiteDatabase db = mdb.getWritableDatabase(); try { ContentValues cv=new ContentValues(); cv.put(MyDB.IDNO,id); cv.put(MyDB.NAME,name); cv.put(MyDB.SALARY,sal); db.insert(MyDB.TABLE_NAME,null,cv); et1.setText(""); et2.setText(""); et3.setText(""); } catch (Exception e) { Log.e("Insert Exception",""+e); } String col[]={MyDB.IDNO,MyDB.NAME,MyDB.SALARY}; String wer=MyDB.IDNO+"=?"; String val[]={id}; Cursor c= db.query(MyDB.TABLE_NAME,col,wer,val,null,null,null,null); if(c.moveToFirst()) { String name1= c.getString(0); String idno1= c.getString(1); String sal1= c.getString(2); tv1.setText(name1); tv2.setText(idno1); tv3.setText(sal1); } db.delete(MyDB.TABLE_NAME,wer,val); } public void view1(View v) { Intent i=new Intent(this,SQLiteNext.class); startActivity(i); } }Database Code(MyDB)
import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; public class MyDB extends SQLiteOpenHelper { Context context; public static final String DBNAME = "fdaytalk"; public static final int VERSION = 1; public static final String NAME="name"; public static final String IDNO="idno"; public static final String SALARY="salary"; public static final String TABLE_NAME = "Employee"; public MyDB(Context context) { super(context,DBNAME,null,VERSION); this.context = context; } @Override public void onCreate(SQLiteDatabase db) { try { String qry = "create table " + TABLE_NAME + " ("+MyDB.IDNO+" INTEGER PRIMARY KEY,"+MyDB.NAME+" TEXT,"+MyDB.SALARY+" real)"; db.execSQL(qry); }catch (Exception e) { Log.e("Table Creation",""+e); } } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } }Layout XML Code(activity_sqlite)
<?xml version="1.0" encoding="utf-8"?> <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" android:paddingBottom="@dimen/activity_vertical_margin" android:paddingLeft="@dimen/activity_horizontal_margin" android:paddingRight="@dimen/activity_horizontal_margin" android:paddingTop="@dimen/activity_vertical_margin" tools:context="com.andro.tech.androidproject.SQLiteAct"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:textSize="@dimen/textsize" android:layout_gravity="center" android:textStyle="bold" android:text="SQLite" android:layout_marginBottom="60dp" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_gravity="center" android:inputType="number" android:hint="IDNO" android:ems="10" android:id="@+id/editText" android:layout_alignParentTop="true" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_gravity="center" android:inputType="textPersonName" android:hint="Name" android:ems="10" android:id="@+id/editText2" android:layout_below="@+id/editText" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:inputType="numberDecimal" android:layout_gravity="center" android:ems="10" android:hint="Salary" android:id="@+id/editText3" android:layout_below="@+id/editText2" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" /> <Button android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Save and Display" android:onClick="saveIntoSQLite" android:layout_gravity="center" android:id="@+id/button" android:layout_below="@+id/editText3" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" android:layout_marginTop="22dp" android:layout_marginBottom="50dp"/> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:textSize="@dimen/textsize" android:layout_gravity="center" android:textStyle="bold" android:id="@+id/tv1"/> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:textSize="@dimen/textsize" android:layout_gravity="center" android:textStyle="bold" android:id="@+id/tv2"/> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:textSize="@dimen/textsize" android:layout_gravity="center" android:textStyle="bold" android:id="@+id/tv3"/> <Button android:layout_width="match_parent" android:layout_height="wrap_content" android:text="@string/sourcecode" android:background="@color/bgcolor" android:textStyle="bold" android:textColor="@color/text"/> </LinearLayout> Output:
Download Source Code
For More Android Programs - Click Here
Follow Us – Never Miss Update
Fb/Page, Twitter, Google+, Instagram, Pinterest
Android sqlite tutorial - Android Sqlite Database ExampleWas this guide helpful?
