For COMPLETE TUTORIALS see here :
in DABASEHELPER CLASS :
String[] coloumns = new String[] { KEY_ROWID, KEY_NAME,KEY_NICKNAME }; // calling all elements in an array
Cursor c = db.query(DATABASE_TABLE, coloumns, null, null, null, null,null);// basically reading a database need cursor
String result = " ";// since string is to be returned
System.out.println("count of cursor=====>>" + c.getCount());
int iRowid = c.getColumnIndex(KEY_ROWID);
// calling each row values
int iRowName = c.getColumnIndex(KEY_NAME);
int iRowNickName = c.getColumnIndex(KEY_NICKNAME);
if (c.moveToFirst()) {
c.moveToFirst();
for (int i = 0; i < c.getCount(); i++) {result
= result + c.getString(iRowid) + " "
+ c.getString(iRowName) + " "
+ c.getString(iRowNickName) + "\n";
System.out.println(result + " <> " + iRowid + " <> "+ iRowName);
c.moveToNext();
}
}
c.close();
db.close();
return result;
in sqlite.java :
TextView infotext=(TextView) findViewById(R.id.tvsqlinfo);
DBAdapter info = new DBAdapter(this);
info.open();
String data =info.getdata();
System.out.println("result is ==========>>" + data);
info.close();
infotext.setText(data);
infotext.setTextColor(Color.RED);
Comments
Post a Comment