SQlite DB search where
Edittexte yazdýðým isime göre veritabanýnda nasýl arama yapabilirim.
sample:phone book application
my code;
SQLiteDatabase vt = VtArac.getReadableDatabase(); Cursor VTYeri =
vt.query(DatabaseHelper.VT_TABLO, new String[]{ "Id", "banka", "sira",
"kod", "aktif", "rea", "kap", "Ryzde", "Kyzde"}, "Id" + "=" + "1", null,
null, null,null, null); startManagingCursor(VTYeri);
while(VTYeri.moveToNext()) { String Id_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("Id")));
IDDD.setText(Id_Degiskeni.toString()); String banka_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("banka")));
editText1.setText(banka_Degiskeni.toString()); String sira_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("sira")));
editText2.setText(sira_Degiskeni.toString()); String kod_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("kod")));
editText3.setText(kod_Degiskeni.toString()); String aktif_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("aktif")));
aktif.setText(aktif_Degiskeni.toString()); String rea_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("rea")));
reaktif.setText(rea_Degiskeni.toString()); String kap_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("kap")));
kapasitif.setText(kap_Degiskeni.toString()); String Ryzde_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("Ryzde")));
Ryuzde.setText(Ryzde_Degiskeni.toString()); String Kyzde_Degiskeni =
VTYeri.getString((VTYeri.getColumnIndex("Kyzde")));
Kyuzde.setText(Kyzde_Degiskeni.toString()); } } });
No comments:
Post a Comment