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

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

<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

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