Android database (p2)- SEARCH example

Create a new Android Project named Kamus, where the main activity is Carian Kamus. you may refer the example here…

After the Project has been crated, Add a new class named DBHelper class – right click on the package name –> New –-> Class

sqlite-create-new-dbhelper-class

sqlite-create-new-dbhelper-class-write-class-namePut in the class name (DBHelper)

Create a database, a table and populate preconfigured data in the table. This is coded in the DBHelper class.

package net.kerul.kamus;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {
final protected static String DATABASE_NAME="kamuskerul2";
public DBHelper(Context context) {
super(context, DATABASE_NAME, null,2);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
if (oldVersion >= newVersion) return;
db.execSQL("DROP DATABASE IF EXISTS " + DATABASE_NAME +";");
onCreate(db);
}
@Override
public void onCreate(SQLiteDatabase db) {

//here is the database definition
db.execSQL("CREATE TABLE melayuenglish " +
"(katamelayu TEXT, kataeng TEXT);");
//insert pre-configured records
db.execSQL("INSERT INTO melayuenglish (katamelayu, kataeng) VALUES('kereta','car');");
db.execSQL("INSERT INTO melayuenglish (katamelayu, kataeng) VALUES('pukul','hit');");
db.execSQL("INSERT INTO melayuenglish (katamelayu, kataeng) VALUES('duduk','sit');");
db.execSQL("INSERT INTO melayuenglish (katamelayu, kataeng) VALUES('makan','eat');");
db.execSQL("INSERT INTO melayuenglish (katamelayu, kataeng) VALUES('minum','drink');");
}

}



The SEARCH interface – reside in the main activity, which is the Carian Kamus.

interface-db-search-kamus


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

<TextView
android:id="@+id/textView1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentTop="true"
android:layout_centerHorizontal="true"
android:layout_marginTop="19dp"
android:text="Melayu - English"
android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText
android:id="@+id/txtmelayu"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_alignParentRight="true"
android:layout_below="@+id/textView1"
android:ems="10" >

<requestFocus />
</EditText>

<Button
android:id="@+id/btncari"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_alignParentRight="true"
android:layout_below="@+id/txtmelayu"
android:layout_marginTop="21dp"
android:text="Cari makna English" />

<TextView
android:id="@+id/lblmakna"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_alignParentRight="true"
android:layout_below="@+id/btncari"
android:layout_marginTop="17dp"
android:text="Papar makna sini"
android:textAppearance="?android:attr/textAppearanceLarge" />

</RelativeLayout>


Embedding the SQL SELECT statement


In the Java class file, define all GUIs elements as usual. The search process happen when user key-in a word and hit the button. Currently there are only 4 words; kereta (car), makan (eat), pukul (hit) and duduk (sit).



 

package net.kerul.kamus;

import java.util.ArrayList;

import android.os.Bundle;
import android.app.Activity;
import android.app.ListActivity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

public class CarianKamus extends Activity implements OnClickListener{
private DBHelper dbhelper = new DBHelper(this);
private SQLiteDatabase db;//the connector
private EditText txtmelayu;
private Button btncari;
private TextView lblmakna;

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

//listing data processes
//-initiate the database connector
db = dbhelper.getReadableDatabase();

txtmelayu=(EditText)findViewById(R.id.txtmelayu);
btncari=(Button)findViewById(R.id.btncari);
btncari.setOnClickListener(this);
lblmakna=(TextView)findViewById(R.id.lblmakna);
}//end onCreate

public void onClick(View v){
//fetch kata melayu dr textbox
String carimelayu=txtmelayu.getText().toString();
//kena letak dalam onclick
//-run SELECT command to fetch data from table

Cursor cmelayu=db.rawQuery("SELECT * FROM melayuenglish " +
"WHERE katamelayu='"+carimelayu+"';", null);
//-fetch record
if(cmelayu.getCount()!=0){
cmelayu.moveToFirst();//go to first row
String kataenglish=cmelayu.getString(1).toString();
lblmakna.setText(kataenglish);
}
else{
//display some notice here saying no data found
lblmakna.setText("Tiada padanan");
}

}//end onCLick

@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.activity_carian_kamus, menu);
return true;
}

//when menu is selected
@Override
public boolean onOptionsItemSelected(MenuItem item) {
//call about screen, if user hit "Tentang kami" menu
if (item.getItemId()==R.id.minsert){
Intent ins= new Intent (this, InsertActivity.class);
startActivity(ins);
}
return true;
}//end menu/

}


Display the search result


Run the app in the emulator, key-in a word and hit the button.


Output sample


display-db-kamus-search-result


Download Source-code here - https://docs.google.com/file/d/0B34ZxOOoeSDdQ3VkWVdaZE43eDg/edit?usp=sharing

Popular Posts

WorldConferences.net