package gec.com.db;

import android.R.string;
import android.accounts.OnAccountsUpdateListener;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.text.Selection;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;


public class maindb extends Activity {
    /** Called when the activity is first created. */
    SQLiteDatabase mydb;
    EditText et;
   
   
    @Override
   
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
      
       
        et=(EditText)findViewById(R.id.EditText01);
     
      
        Button bt1=(Button)findViewById(R.id.Button01);
        bt1.setOnClickListener(new OnClickListener(){

            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                String s=et.getText().toString();
                 mydb=openOrCreateDatabase("rajesh",MODE_PRIVATE, null);
                    mydb.execSQL("CREATE TABLE IF NOT EXISTS RAJESH(name varchar);");
                 mydb.execSQL("INSERT INTO RAJESH VALUES(' "+s+" ');");
                 Toast.makeText(getApplicationContext(), "inserted rajesh", 50).show();
               
            }
           
           
        });
       
       
        Button bt2=(Button)findViewById(R.id.Button02);
        bt2.setOnClickListener(new OnClickListener(){

            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
               
    Cursor c=mydb.rawQuery("SELECT * FROM RAJESH WHERE NAME LIKE 'R%'",null);
   
    Toast.makeText(getApplicationContext(), "RETRIEVED IS+C",30).show();
               
            }
           
           
        });

}
}

--
rajesh