Notes

dbLİSTVİEW-INSERT-DELETE-UPDATE
----------- VeriTabaniClass ---------
public class VeriTabani extends SQLiteOpenHelper {
public VeriTabani(Context context) {
super(context,"ardaDB",null,1); //adres defteri veritabanı versiyonu
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table kisiler(id integer primary key autoincrement,"+
"isim text,soyisim text,yas text);");

}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

}
}
----------------- MAİNACTİVİTY------------
public class MainActivity extends AppCompatActivity implements View.OnClickListener {

Button btnSil,btnEkle,btnGuncelle,btnListele,btnTemizle,btnOku,btnOkuGoruntulle,btnListeSayfa;
EditText etAd,etSoyad,etYas,etID;
ListView listView;
VeriTabani vt;
static ArrayList<String> arrayList ;
ArrayAdapter<String> adapter;
String isim1,soyisim1,yas1,_id1;
int kisiID;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
btnEkle = findViewById(R.id.btnEkle);
btnListeSayfa = findViewById(R.id.btnListeSayfa);
btnOkuGoruntulle = findViewById(R.id.okuGuncelle);
btnOku = findViewById(R.id.btnOku);
btnSil = findViewById(R.id.btnSil);
btnGuncelle = findViewById(R.id.btnGuncelle);
btnListele = findViewById(R.id.btnListele);
btnTemizle =findViewById(R.id.btnTemizle);
etAd = findViewById(R.id.etAd);
etSoyad = findViewById(R.id.etSoyad);
etYas = findViewById(R.id.etYas);
listView = findViewById(R.id.listView);
etID = findViewById(R.id.etID);
vt = new VeriTabani(this);
btnOkuGoruntulle.setOnClickListener(this);
btnEkle.setOnClickListener(this);
btnSil.setOnClickListener(this);
btnGuncelle.setOnClickListener(this);
btnListele.setOnClickListener(this);
btnOku.setOnClickListener(this);
btnTemizle.setOnClickListener(this);
btnListeSayfa.setOnClickListener(this);

}
@Override
public void onClick(View v) {
String secim = null;
String[] secmAra = null;
ContentValues cv = new ContentValues(); // parametreler için
SQLiteDatabase db = vt.getWritableDatabase(); //SQLiteDatabase sınıfında yazılabilir bağlantı açmak
switch (v.getId())
{
case R.id.btnEkle:
cv.put("isim",etAd.getText().toString());
cv.put("soyisim",etSoyad.getText().toString());
cv.put("yas",etYas.getText().toString());

long rowID = db.insert("kisiler",null,cv);
if (rowID > -1)
{
Toast.makeText(this, rowID+" Nolu Kayıt Ekleme İşlemi Başarılı", Toast.LENGTH_SHORT).show();
arrayList = new ArrayList<String>();
Cursor cursor = db.query("kisiler",null,null,null,null,null,null);
if(cursor != null)
{
while (cursor.moveToNext())
{ kisiID = cursor.getInt(cursor.getColumnIndex("id"));

arrayList.add(kisiID +"t"+ cursor.getString(cursor.getColumnIndex("isim")) + "t"+ cursor.getString(cursor.getColumnIndex("soyisim")) + "t"+ cursor.getString(cursor.getColumnIndex("yas")));
}
}
cursor.close();
db.close();
adapter =new ArrayAdapter<String>(this,android.R.layout.simple_list_item_1,android.R.id.text1,arrayList);
listView.setAdapter(adapter);

listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
String [] veri = arrayList.get(i).split("t");
Intent intent = new Intent(MainActivity.this,Main2Activity.class);
intent.putExtra("id",veri[0]);
intent.putExtra("isim",veri[1]);
intent.putExtra("soyisim",veri[2]);
intent.putExtra("yas",veri[3]);
startActivity(intent);
}
});
}
else
{
Toast.makeText(this, "Kayıt Eklenirken Bir Hata Oluştu", Toast.LENGTH_SHORT).show();
}
break;

case R.id.btnListele:
arrayList = new ArrayList<String>();
String[] sutunlar = {"isim","soyisim","yas"};
Cursor cursor = db.query("kisiler",sutunlar,null,null,null,null,null);
if(cursor != null)
{
while (cursor.moveToNext())
{
arrayList.add(cursor.getString(0) + "t"+ cursor.getString(1) + "t"+ cursor.getString(2));
}
}
cursor.close();
db.close();
adapter =new ArrayAdapter<String>(this,android.R.layout.simple_list_item_1,android.R.id.text1,arrayList);
listView.setAdapter(adapter);
break;

case R.id.btnTemizle:
int silinenKayitSayisi = db.delete("kisiler",null,null);
Toast.makeText(this, silinenKayitSayisi+" Adet Kayit Silindi", Toast.LENGTH_SHORT).show();
break;

case R.id.btnSil:
String id = etID.getText().toString();

int silinen = db.delete("kisiler","id="+id,null);

if (silinen == 0)
{
Toast.makeText(this, silinen+"Aranan Kayit Bulunamadı", Toast.LENGTH_SHORT).show();
}
else
{
Toast.makeText(this, silinen+"Kayıt Silindi", Toast.LENGTH_SHORT).show();
}
break;

case R.id.btnGuncelle:
String id1 = etID.getText().toString();
cv.put("isim",etAd.getText().toString());
cv.put("soyisim",etSoyad.getText().toString());
cv.put("yas",etYas.getText().toString());
int sonuc = db.update("kisiler",cv,"id="+id1,null);
Toast.makeText(this, sonuc +" Nolu Kayıt Güncellendi", Toast.LENGTH_SHORT).show();
break;

case R.id.btnOku:
String isim = etAd.getText().toString();
String soyisim = etSoyad.getText().toString();
String yas = etYas.getText().toString();
String _id = etID.getText().toString();

if (isim.length() != 0)
{
secim = "isim= ?";
secmAra = new String[]{isim};
}
if (soyisim.length() != 0)
{
secim = "soyisim= ?";
secmAra = new String[]{soyisim};
}
if (yas.length() != 0)
{
secim = "yas= ?";
secmAra = new String[]{yas};
}
if (_id.length() != 0)
{
secim = "id= ?";
secmAra = new String[]{_id};
}
Cursor cr =db.query("kisiler",null,secim,secmAra,null,null,null);

if (cr.moveToFirst())
{
int isimIndex = cr.getColumnIndex("isim");
isim1 = cr.getString(isimIndex);

int soyisimIndex = cr.getColumnIndex("soyisim");
soyisim1 = cr.getString(soyisimIndex);

int telIndex = cr.getColumnIndex("yas");
yas1 = cr.getString(telIndex);

int idIndex = cr.getColumnIndex("id");
_id1 = cr.getString(idIndex);

Intent i = new Intent(MainActivity.this,Main2Activity.class);
i.putExtra("isim",isim1);
i.putExtra("soyisim",soyisim1);
i.putExtra("yas",yas1);
i.putExtra("id",_id1);
startActivity(i);
}
break;

case R.id.okuGuncelle:

isim = etAd.getText().toString();
soyisim = etSoyad.getText().toString();
yas = etYas.getText().toString();
_id = etID.getText().toString();

if (isim.length() != 0)
{
secim = "isim= ?";
secmAra = new String[]{isim};
}
if (soyisim.length() != 0)
{
secim = "soyisim= ?";
secmAra = new String[]{soyisim};
}
if (yas.length() != 0)
{
secim = "yas= ?";
secmAra = new String[]{yas};
}
if (_id.length() != 0)
{
secim = "id= ?";
secmAra = new String[]{_id};
}
cr =db.query("kisiler",null,secim,secmAra,null,null,null);
if (cr.moveToFirst())
{
int isimIndex = cr.getColumnIndex("isim");
isim1 = cr.getString(isimIndex);
int soyisimIndex = cr.getColumnIndex("soyisim");
soyisim1 = cr.getString(soyisimIndex);
int telIndex = cr.getColumnIndex("yas");
yas1 = cr.getString(telIndex);
int idIndex = cr.getColumnIndex("id");
_id1 = cr.getString(idIndex);
etID.setText(_id1);
etAd.setText(isim1);
etSoyad.setText(soyisim1);
etYas.setText(yas1);
}
break;
case R.id.btnListeSayfa:
Intent i = new Intent(MainActivity.this,Main3Activity.class);
startActivity(i);
break;
}
}
}

------------------- MAİNACTİVİTY2 OKU------------------------
TextView id,ad,yas,soyad;
ListView listView;
VeriTabani vt;
String _ad,_soyad,_yas;
int _id;
@Override
protected void onCreate(Bundle savedInstanceState) {
ImageButton ibArama,ibSms,ibMail;
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main2);
id = findViewById(R.id.tvId);
ad = findViewById(R.id.tvAd);
yas = findViewById(R.id.tvYas);
soyad = findViewById(R.id.tvSoyad);
listView = findViewById(R.id.listView);
vt = new VeriTabani(this);
Intent i = getIntent();
id.setText(i.getStringExtra("id"));
ad.setText(i.getStringExtra("isim"));
soyad.setText(i.getStringExtra("soyisim"));
yas.setText(i.getStringExtra("yas"));
ibArama = findViewById(R.id.ibArama);
ibMail = findViewById(R.id.ibMail);
ibSms = findViewById(R.id.ibSms);
ibArama.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Intent aramaIntent = new Intent(Intent.ACTION_VIEW, Uri.parse("tel:"+yas.getText().toString()));
startActivity(aramaIntent);
}
});
ibSms.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Intent mesajIntent = new Intent(Intent.ACTION_VIEW);
mesajIntent.setData(Uri.parse("sms:"+yas.getText().toString()));

startActivity(mesajIntent);
}
});
ibMail.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Intent mailIntent = new Intent(Intent.ACTION_SEND);
mailIntent.setType("plain/text");
String mailList [] = {ad.getText().toString()};
mailIntent.putExtra(Intent.EXTRA_EMAIL,mailList);

startActivity(mailIntent);
}
});
}
}
---------------------------------LİSTELE
ListView lv;
String ad,soyad,yas;
int id1;
VeriTabani vt;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main3);
lv = findViewById(R.id.listView);
vt = new VeriTabani(this);
Cursor cursor;
SQLiteDatabase db = vt.getWritableDatabase();
cursor = db.query("kisiler",null,null,null,null,null,null);
final ArrayList<String> txt = new ArrayList<String>();
while(cursor.moveToNext())
{
ad = cursor.getString(cursor.getColumnIndex("isim"));
id1 = cursor.getInt(cursor.getColumnIndex("id"));
soyad = cursor.getString(cursor.getColumnIndex("soyisim"));
yas = cursor.getString(cursor.getColumnIndex("yas"));
txt.add(id1 + "t" + ad + "t" + soyad + "t" + yas);
}
ArrayAdapter<String> veriAdaptoru = new ArrayAdapter<String>(this,android.R.layout.simple_list_item_1,android.R.id.text1,txt);
lv.setAdapter(veriAdaptoru);
cursor.close();
db.close();
lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
String [] veri = txt.get(i).split("t");
Intent intent = new Intent(Main3Activity.this,Main2Activity.class);
intent.putExtra("id",veri[0]);
intent.putExtra("isim",veri[1]);
intent.putExtra("soyisim",veri[2]);
intent.putExtra("yas",veri[3]);
startActivity(intent);
}
});
}
}