How to retrieve a single record from sqllite in android using eclipse?

See more:

Mobile

Android

Hi,

I have started coding for Finder app which contains employee records and user will be able to find employee record by using 'id' when click on Search button in useractivity.java and data should display in Empdetails.java activity in textview contains 3 textfields to display. Below is my code Please help me in this

My requirement : I want to retrieve a single record by giving an id in UserActivity.java and when i click on Search button it should get a (select * from emp;)record details in Empdetails.java in text view

Output:

id: 12345

name : vijay kumar

Email: vijay@gmail.com

like above shown

Thanks inadvance,
Vijay Kumar


1) AdminActivity.java

package com.example.finder;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Color;
import android.graphics.Typeface;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;
import android.widget.Toast;

public class AdminActivity extends Activity {

	String id,name,email;
	SQLiteDatabase db;
		
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_admin);
		db=openOrCreateDatabase("EMP",MODE_PRIVATE,null);
		db.execSQL("CREATE TABLE IF NOT EXISTS EMP(id integer primary key,name varchar,email varchar);");
	}

	public void Submit(View view)
	{		
		EditText edittext1=(EditText) findViewById(R.id.id);
		EditText edittext2=(EditText) findViewById(R.id.name);
		EditText edittext3=(EditText) findViewById(R.id.email);
		id=edittext1.getText().toString();
		name=edittext2.getText().toString();
		email=edittext3.getText().toString();
		db.execSQL("INSERT INTO EMP(id,name,email) values ('"+id+"','"+name+"','"+email+"');");
		
		if(id.equals("") && name.equals("") && email.equals(""))
	    {
			Toast.makeText(getApplicationContext(), "Please enter details and submit", Toast.LENGTH_SHORT).show();
		}
		else 
			if(id.equals(""))
		   {
				Toast toast=new Toast (getApplicationContext());
				toast.setDuration(Toast.LENGTH_LONG);
				Toast.makeText(getApplicationContext(), "Enter id....", Toast.LENGTH_SHORT).show();
		   }
		else
			if(name.equals(""))
			   {
				Toast toast=new Toast (getApplicationContext());
				toast.setDuration(Toast.LENGTH_LONG);
			    Toast.makeText(getApplicationContext(), "Enter Name....", Toast.LENGTH_SHORT).show();
			   }
			else
		         if(email.equals(""))
			    {
		        Toast toast=new Toast (getApplicationContext());
		        toast.setDuration(Toast.LENGTH_LONG);
			     Toast.makeText(getApplicationContext(), "Enter email.....", Toast.LENGTH_SHORT).show();
			    }
		         else 
		            { 
		        	    Toast toast=new Toast (getApplicationContext());
		        	   	toast.setDuration(Toast.LENGTH_LONG);
		        	   	edittext1.setText("");
			        	edittext2.setText("");
			        	edittext3.setText("");
			        	Toast.makeText(getApplicationContext(), "Data submitted successfully", Toast.LENGTH_SHORT).show();
			        	db.close();
		        	 }
				}
	
	public void Exit(View view){
		System.exit(0);
	}
	
	}

2) UserActivity.java

package com.example.finder;

import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;

public class UserActivity extends Activity {
	
	SQLiteDatabase db;
	String id;
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_user);

	}

public void Search(View view){

////what is the logic/code here i have to use?????
}

public void Update(View view){

////what is the logic/code here i have to use?????
}

public void Delete(View view){

////what is the logic/code here i have to use?????
}


public void Exit(View view){
	System.exit(0);
}

}