08:29:00

Android Tutorial-android-database-exampleANDROIDKAWE - Welcome to ANDROID KAWE, Ini adalah sebuah blog directory tentang burung,baik itu suara burung ataupun tips perawatan burung.Blog ini adalah situs perangkum otomatis dari pencarian google yang kali ini berjudul Android Tutorial-android-database-exampleANDROIDKAWE.Ada ribuan artikel yang sudah terekam ke dalam situs ini,silahkan cari sesuai yang kalian kehendaki,untuk artikel selanjutnya tentang judul diatas bisa kalian baca di bawah ini.

Konten : Android Tutorial-android-database-exampleANDROIDKAWE
Judul : Android Tutorial-android-database-exampleANDROIDKAWE

Android Tutorial-android-database-exampleANDROIDKAWE

Android Data Base 

In Android Device sqlite database is use to store information. i am going to  give very example to maintain all crucial operation on database like database creation table creation record insertion, deletion, updation and view.

Code for activity_main.xml file

- <ScrollView xmlns:android="http://schemas.android.com/apk/res/android" android:id="@+id/scrollView1" android:layout_width="fill_parent" android:layout_height="fill_parent">

- <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical">

  <TextView android:id="@+id/textView1" android:layout_width="195dp" android:layout_height="wrap_content" android:text="Plz Fill This Form" android:textAppearance="?android:attr/textAppearanceLarge" />

- <EditText android:id="@+id/editText1" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" android:hint="name" android:inputType="textPersonName">

  <requestFocus />

  </EditText>

  <EditText android:id="@+id/editText2" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" android:hint="phno" android:inputType="phone" />

  <EditText android:id="@+id/editText3" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" android:hint="emailid" android:inputType="textEmailAddress" android:text="" />

  <EditText android:id="@+id/editText4" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" android:hint="add" android:inputType="textPostalAddress" />

  <Button android:id="@+id/button1" android:layout_width="match_parent" android:layout_height="wrap_content" android:text="Register New Record" />

  <Button android:id="@+id/button2" android:layout_width="match_parent" android:layout_height="wrap_content" android:text="View All Record" />

  <Button android:id="@+id/button5" android:layout_width="match_parent" android:layout_height="wrap_content" android:text="UPDATE YOUR EXisting Record" />

- <TableRow android:id="@+id/tableRow1" android:layout_width="match_parent" android:layout_height="wrap_content">

  <Button android:id="@+id/button3" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Delete By ID" />

  <EditText android:id="@+id/editText5" android:layout_width="wrap_content" android:layout_height="wrap_content" android:ems="10" android:hint="Enter Id to Update and Delete Record" android:inputType="number" />

  </TableRow>

  <Button android:id="@+id/button4" android:layout_width="match_parent" android:layout_height="wrap_content" android:text="Get By Id" />

  </LinearLayout>

  </ScrollView>

Source code for MainActivity.java file:

package com.apsmind.ddbconnect;

import android.os.Bundle;

import android.provider.BaseColumns;

import android.app.Activity;

import android.content.ContentValues;

import android.content.Intent;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.text.InputFilter.LengthFilter;

import android.view.ContextMenu;

import android.view.Menu;

import android.view.View;

import android.view.ContextMenu.ContextMenuInfo;

import android.widget.Button;

import android.widget.CheckBox;

import android.widget.EditText;

import android.widget.TextView;

import android.widget.Toast;

public class MainActivity extends Activity {

EditText n1,phno,e1,add,edit;

Button b1,b2,b3,b4,b5;

TextView t1;

Record record=new Record(MainActivity.this);;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

t1=(TextView)findViewById(R.id.textView1);

n1=(EditText)findViewById(R.id.editText1);

phno=(EditText)findViewById(R.id.editText2);

e1=(EditText)findViewById(R.id.editText3);

add=(EditText)findViewById(R.id.editText4);

b1=(Button)findViewById(R.id.button1);

b2=(Button)findViewById(R.id.button2);

b3=(Button)findViewById(R.id.button3);

b4=(Button)findViewById(R.id.button4);

b5=(Button)findViewById(R.id.button5);

edit=(EditText)findViewById(R.id.editText5);

b1.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String name=n1.getText().toString();

String phone=phno.getText().toString();

String email=e1.getText().toString();

String address=add.getText().toString();

SQLiteDatabase db=record.getWritableDatabase();/*to open database in writable format*/

ContentValues values= new ContentValues();/*a class whoese object helps to insert values in table*/

values.put(Record.Col1_name, name);

values.put(Record.Col3_password, phone);

values.put(Record.Col2_email,email );

values.put(Record.Col4_address, address);

db.insert(Record.Table_name, null, values);//null stands for null hacker(insert null for not defined positions

n1.setText("");

phno.setText("");

e1.setText("");

add.setText("");

}

});

b2.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

Intent i=new Intent(MainActivity.this,Activity1.class);

startActivity(i);

}

});

//get by id

b3.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String id= edit.getText().toString();

SQLiteDatabase db=record.getWritableDatabase();

try{

db.delete(Record.Table_name, BaseColumns._ID+"="+id, null);

}

catch(Exception e)

{

Toast.makeText(MainActivity.this, e.toString(), Toast.LENGTH_LONG).show();

}

Toast.makeText(MainActivity.this,"deleted", Toast.LENGTH_SHORT).show();

}

});

b5.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String id= edit.getText().toString();

String name=n1.getText().toString();

String phone=phno.getText().toString();

String email=e1.getText().toString();

String address=add.getText().toString();

try{

SQLiteDatabase db=record.getWritableDatabase();/*to open database in writable format*/

ContentValues values= new ContentValues();/*a class whoese object helps to insert values in table*/

values.put(Record.Col1_name, name);

values.put(Record.Col3_password, phone);

values.put(Record.Col2_email,email );

values.put(Record.Col4_address, address);

db.update(Record.Table_name, values, BaseColumns._ID+"="+id, null);

}

catch(Exception e)

{

Toast.makeText(MainActivity.this, e.toString(), Toast.LENGTH_LONG).show();

}

}

});

b4.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String id= edit.getText().toString();

try{

SQLiteDatabase db=record.getReadableDatabase();

Cursor mCursor =

               db.query( Record.Table_name,null, BaseColumns._ID+"="+id, null,

               null, null, null, null);

       if (mCursor != null) {

          while(mCursor.moveToNext())

          {

           n1.setText(mCursor.getString(1));

           phno.setText(mCursor.getString(2));

           e1.setText(mCursor.getString(3));

           add.setText(mCursor.getString(4));

          }

       }

}

catch(Exception e)

{

Toast.makeText(MainActivity.this, e.toString(), Toast.LENGTH_LONG).show();

}

}

});

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

// Inflate the menu; this adds items to the action bar if it is present.

getMenuInflater().inflate(R.menu.main, menu);

return true;

}

}

Create another Record.java file.

package com.apsmind.ddbconnect;

import android.content.ContentValues;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.provider.BaseColumns;

import android.provider.OpenableColumns;

import android.util.Log;

public class Record extends SQLiteOpenHelper

{

public static final String DB_name = "Student.db";

public static final int DB_version =2;

public static final String Table_name ="Info";

public static final String Col1_name = "Name";

public static final String Col2_email ="Email";

public static final String Col3_password ="Password";

public static final String Col4_address = "Address";

String query;

public Record(Context context) 

{

super(context, DB_name, null, DB_version);/*null being cursor position*/

}

@Override

public void onCreate(SQLiteDatabase db) 

{

query =  "CREATE TABLE " + Table_name + "( " + BaseColumns._ID

+ " INTEGER PRIMARY KEY AUTOINCREMENT, " + Col1_name + " TEXT, "

+ Col2_email + " TEXT," +Col3_password+ " not null," +Col4_address+ " text not null );";

Log.d("Eventsdata", "onCreate"  +query);

db.execSQL(query);

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 

{

{

if (oldVersion >= newVersion)

return;/*code to apply if database is sent from one version to another*/

String sql = null;

if (oldVersion == 1) 

sql = "alter table " + Table_name + " add note text;";

if (oldVersion == 2)

sql = "";

Log.d("EventsData", "onUpgrade : " + sql);

if (sql != null)

db.execSQL(sql);

}

}

}

Create Another Activity for view all record:-

source code for .xml file:

- <ScrollView xmlns:android="http://schemas.android.com/apk/res/android" android:id="@+id/scrollView1" android:layout_width="fill_parent" android:layout_height="fill_parent">

- <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical">

  <TextView android:id="@+id/textView1" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Medium Text" android:textAppearance="?android:attr/textAppearanceMedium" />

  </LinearLayout>

  </ScrollView>

package com.apsmind.ddbconnect;

import android.os.Bundle;

import android.app.Activity;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.view.Menu;

import android.widget.TextView;

public class Activity1 extends Activity {

TextView t1;

Record eventsdata;

@Override

protected void onCreate(Bundle savedInstanceState) {

 super.onCreate(savedInstanceState);

 setContentView(R.layout.activity_activity1);

 t1=(TextView)findViewById(R.id.textView1);

 eventsdata =new Record(this);

 SQLiteDatabase db=eventsdata.getReadableDatabase();//event is an entry of database table

 Cursor cursor=db.query(Record.Table_name, null, null, null, null, null, null);

 StringBuilder stb=new StringBuilder("Saved Events :\n\n");

while(cursor.moveToNext())

{

 long id=cursor.getLong(0);

 String name=cursor.getString(1);

 String email=cursor.getString(2);

 String password=cursor.getString(3);

 String address=cursor.getString(4);

  stb.append(id +": name--: " + name +",\n"+ " email--:" + email +",\n"+ " password--:" + password +",\n"+ " address--:" + address + "\n\n");

}

 t1.setText(stb);

 

 

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

// Inflate the menu; this adds items to the action bar if it is present.

getMenuInflater().inflate(R.menu.activity1, menu);

return true;

}

}

check you application 

Get complete Source Code

Demikianlah Artikel Android Tutorial-android-database-exampleANDROIDKAWE

Semoga artikel tentang Android Tutorial-android-database-exampleANDROIDKAWE, mudah-mudahan bisa memberi manfaat untuk anda semua.

Anda sedang membaca artikel Android Tutorial-android-database-exampleANDROIDKAWE dan artikel ini url permalinknya adalah http://androidkawe.blogspot.com/2016/10/android-tutorial-android-database.html Semoga artikel ini bisa bermanfaat.Sekali lagi,ini adalah situs auto yang tidak ditulis langsung oleh admin,Kami tidak menjamin akan kebenaran dari artikel yang tertulis.

Bagikan :

Tweet

Tag : android database, Android Development, android local database, sqlite database