Hi everybody,
I am creating a database and i have done it, buti dont know
how to print those records on console ,actully i am getting value from
edittext box and i can print those value in Toast but i want to print those
value on simulator when user click on View button to see records pls help
me if any one hava any clue.
*This is my code*
*
*
*
*
package SQliteDemo.s;
import java.util.Locale;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.MotionEvent;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class SQliteDemo extends Activity {
/** Called when the activity is first created. */
SQLiteDatabase sampleDB;
Button btninsert,btn_view;
EditText edtid,etname,passwrd;
int id;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
initializeUI();
sampleDB=this.openOrCreateDatabase("sampleDB",SQLiteDatabase.CREATE_IF_NECESSARY,null);
sampleDB.setVersion(1);
sampleDB.setLocale(Locale.getDefault());
sampleDB.setLockingEnabled(true);
String createTable="Create table if not exists USER(id int,name
Varchar,password Varchar);";
sampleDB.execSQL(createTable);
btninsert.setOnTouchListener(new View.OnTouchListener() {
@Override
public boolean onTouch(View v, MotionEvent event) {
// TODO Auto-generated method stub
//int id=Integer.parseInt(edtid.getText().toString().trim());
String id1 = edtid.getText().toString().trim();
id=Integer.valueOf(id1);
String name=etname.getText().toString().trim();
String pass=passwrd.getText().toString().trim();
try
{
if (!edtid.equals("")|| edtid!=null){
// depositAmount1 = Integer.valueOf(costt);
}}
catch(NumberFormatException ex1)
{
// Uh oh! Bad input!
}
//String sqlForInsert="insert into USER values("+ id +" , "+ name +",
"+pass+");";
ContentValues values=new ContentValues();
values.put("id",id);
values.put("name",name);
values.put("password",pass);
sampleDB.insert("USER"," ", values);
return false;
}
});
btn_view.setOnTouchListener(new View.OnTouchListener() {
@Override
public boolean onTouch(View v, MotionEvent event) {
// TODO Auto-generated method stub
String query="select *from USER";
Cursor cursor=sampleDB.rawQuery(query,null);
String result="";
cursor.moveToFirst();
do
{
int id=cursor.getInt(cursor.getColumnIndex("id"));
String name=cursor.getString(cursor.getColumnIndex("name"));
String pass=cursor.getString(cursor.getColumnIndex("password"));
result=id+" |"+name+" |"+pass;
Toast.makeText(getApplicationContext(), result, 9).show();
Log.d("Result,--------------" + result,"------------");
}
while(cursor.moveToNext());
return false;}});
//return false;
}
private void initializeUI() {
// TODO Auto-generated method stub
edtid=(EditText)findViewById(R.id.editText1);
etname=(EditText)findViewById(R.id.editText2);
passwrd=(EditText)findViewById(R.id.editText3);
btninsert=(Button)findViewById(R.id.button1);
btn_view=(Button)findViewById(R.id.button2);
}
protected void onStop()
{
super.onStop();
sampleDB.close();
}
}
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
