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