Yine ilk olarak asagidaki gibi bir ekran tasarlayacagiz. Ve bu ekranda Anasayfa butonu ile ekleme yapacagimiz ekrana ulasacagiz.<\/p>\n\n
![](\"http:\/\/www.yazilimmutfagi.com\/Uploads\/sqllite1.png\")
<\/p>\n\n
Tasarlayacagimiz ekranin xml kodlari da asagidaki gibidir.<\/p>\n\n
\n<LinearLayout xmlns:android="http:\/\/schemas.android.com\/apk\/res\/android"\n android:layout_width="match_parent"\n android:layout_height="match_parent"\n android:orientation="vertical" >\n\n <ListView\n android:id="@+id\/listView1"\n android:layout_width="wrap_content"\n android:layout_height="0dp"\n android:layout_weight="0.99"\n android:background="@drawable\/ysl"\n android:cacheColorHint="#ff330044"\n android:divider="#ffffff"\n android:textColor="#ffffff" >\n\n <\/ListView>\n\n <Button\n android:id="@+id\/anaekran"\n android:layout_width="match_parent"\n android:layout_height="58dp"\n android:text="@string\/ana_ekran" \n \n \/>\n\n<\/LinearLayout>\n<\/pre>\n\nAsagida .java sinifinin kodlari ve açiklamasi verilmistir.<\/p>\n\n
\nVeritabani sifre;\/\/veritabanimizin adi\n\tpublic static int idSnf;\/\/\n\n\tprivate String[] SELECT = { "id", "kullanici_adi", "sifre","kullanilan_yer","hesap_no"};\/\/select islemi için hangi alanlarin çekilecegini belirleyelim\n\n\tprotected void onCreate(Bundle savedInstanceState) {\/\/onCreate metodu\n\t\tsuper.onCreate(savedInstanceState);\n\t\tsetContentView(R.layout.lstvw);\/\/View sinifinin adi\n\t\t\n\t\tButton anaekran = (Button) findViewById(R.id.anaekran);\/\/buton nesnesi\n\t\t\n\t\t\n\t\t\n\t\t\n\t\tanaekran.setOnClickListener(new View.OnClickListener() {\/\/butonun Click metodu\n\t\t\t\n\t\t\t@Override\n\t\t\tpublic void onClick(View v) {\n\t\t\t\t\n\t\t\t\tstartActivity(new Intent("android.intent.action.ACILIS"));\/\/butona tiklandiginda açilacak .java sinifinin adi\n\t\t\t\t\n\t\t\t}\n\t\t});\n\t\t\n\t\tsifre = new Veritabani(this);\/\/ veritabani sinifinin nesnesi...(5. derste anlatilacak olan sinif)\n\t\t SQLiteDatabase db = sifre.getReadableDatabase();\/\/Sqlite Nesnesi \n\t\t \n\t\t Cursor cursor = db.query("sifre", SELECT, null, null, null, null, null);\/\/select islemi\n\t\t final ListView listemiz=(ListView) findViewById(R.id.listView1);\/\/listview nesnesi\n\t\t startManagingCursor(cursor); \n\n\t final ArrayList<String> txt = new ArrayList<String>();\/\/array list\n\t\t final ArrayList<Integer> idtxt = new ArrayList<Integer>();\/\/array list\n\t\t \n\t\t \n\t\t int i = 1;\n\t\t while(cursor.moveToNext()){ \/\/döngü ile veritabanindan çekilen kolonlarin degiskenlere aktarilmasi\n\t\t String k_adi = cursor.getString((cursor.getColumnIndex("kullanici_adi"))); \n\t\t long id = cursor.getLong(cursor.getColumnIndex("id"));\n\t\t String sifre = cursor.getString((cursor.getColumnIndex("sifre")));\n\t\t String k_yeri = cursor.getString((cursor.getColumnIndex("kullanilan_yer")));\n\t\t int h_No = cursor.getInt((cursor.getColumnIndex("hesap_no"))); \n\t\t \n\t\t \n\t\t idtxt.add((int)id);\/\/array liste bunlarin aktarilmasi\n\t\t txt.add(i+"-) "+k_adi+ " , "+ sifre+ " , "+k_yeri);\/\/arrayliste aktarim yapilmasi\n\t\t i++;\n\t\t\t \n\t\t }\n\t\t \n\t\t\t\t \n\t\t\t\t \n\t\t\t ArrayAdapter<String> veriAdaptoru=new ArrayAdapter<String>\n\t\t\t (this, android.R.layout.simple_list_item_1, android.R.id.text1, txt);\n\t\t\t \n\t\t\t listemiz.setAdapter(veriAdaptoru);\/\/ listview e gerekli bilgilerin aktarilmasi\n\t\t\t\t\n\t\t\t listemiz.setOnItemClickListener(new OnItemClickListener() {\/\/listview in click metodu\n\t\t\t \t\t@Override\n\t\t\t\t\t\tpublic void onItemClick(AdapterView<?> arg0, View arg1,\n\t\t\t\t\t\t\t\tint arg2, long arg3) {\n\t\t\t \t\t\n\t\t\t \t\t idSnf = idtxt.get(arg2 );\/\/seçilenin ID degerini integer degiskenine atariz.\n\t\t\t \n\t\t\t\t\t\t Toast.makeText(getApplicationContext(), txt.get(arg2) , Toast.LENGTH_LONG).show();\n\t\t\t\t\t\t startActivity(new Intent("android.intent.action.LIST_MAIN"));\/\/listede seçilenin ardindan açilacak sinif\n\t\t\t\t\t\t\t\n\t\t\t \t\t}\n\t\t\t\t\t});\n\n\t }\n<\/pre>\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Bu dersimizde Androidde sqLite veritabanina önceden eklenmis verileri listeleme islemi yapacagiz. Yani bildigimiz select islemi. Ve bu çektigimiz verileri ListView de gösterecegiz.<\/p>\n","protected":false},"author":521,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[448],"tags":[3973],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/1416"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/521"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=1416"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/1416\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=1416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=1416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=1416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}