DataBaseKullanm Tamamını indir
package com.example.ali.databasekullanm;
import android.app.AlertDialog;
import android.content.ContentValues;
import android.content.Context;
import android.content.DialogInterface;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.Toast;
import java.util.ArrayList;
import java.util.List;
import adepter.myadepter;
import kisi.Kisi;
import veritabani.vt;
public class MainActivity extends AppCompatActivity implements View.OnClickListener{
ListView lv;
EditText[] et,et_gun;
int[] id={R.id.ad,R.id.soyad,R.id.yas};
myadepter adp;
List<Kisi> liste;
ArrayList<Integer> idliste;
Button btn;
vt vtys;
SQLiteDatabase db;
AlertDialog.Builder dialog;
LinearLayout layout;
int secilenid;
Context context;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
context=this;
et=new EditText[id.length];
vtys=new vt(this);
lv=(ListView)findViewById(R.id.list);
liste=new ArrayList<Kisi>();
adp=new myadepter(this,liste);
lv.setAdapter(adp);
for(int i=0;i<id.length;i++)
et[i]=(EditText)findViewById(id[i]);
btn=(Button)findViewById(R.id.btnekle);
btn.setOnClickListener(this);
idliste=new ArrayList<Integer>();
datagetir();
lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
secilenid=i;
layout=new LinearLayout(context);
layout.setOrientation(LinearLayout.VERTICAL);
dialog=new AlertDialog.Builder(context);
dialog.setTitle("Düzenle veya Sil");
dialog.setCancelable(true);
et_gun=new EditText[et.length];
for(int a=0;a<id.length;a++) {
et_gun[a] = new EditText(context);
layout.addView(et_gun[a]);
}
Kisi k=liste.get(secilenid);
et_gun[0].setText(k.ad);
et_gun[1].setText(k.soyad);
et_gun[2].setText(k.yas+"");
dialog.setView(layout);
dialog.setPositiveButton("Düzenle", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialogInterface, int i) {
if(kontrol(et_gun))
{ int id=idliste.get(secilenid);
try {
baglan();
int yas=Integer.parseInt(et_gun[2].getText()+"");
ContentValues par=new ContentValues();
par.put("ad",et_gun[0].getText()+"");
par.put("soyad",et_gun[1].getText()+"");
par.put("yas",yas);
db.update("Kisi",par,"id=?",new String[]{id+""});
db.close();
datagetir();
}catch (Exception ex)
{
Toast.makeText(context,ex.getMessage(),Toast.LENGTH_LONG).show();
}
}
}
});
dialog.setNegativeButton("Sil", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialogInterface, int i) {
int id=idliste.get(secilenid);
try {
baglan();
int yas=Integer.parseInt(et_gun[2].getText()+"");
db.delete("Kisi","id=?",new String[]{id+""});
db.close();
datagetir();
}catch (Exception ex) {
Toast.makeText(context, ex.getMessage(), Toast.LENGTH_LONG).show();
}
}
});
dialog.create().show();
}
});
}
public void baglan()
{
try {
db=vtys.getWritableDatabase();
}
catch (Exception ex)
{
Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
}
}
public boolean kontrol(EditText[] jtext)
{
int sayac=0;
for(int i=0;i<jtext.length;i++)
if(jtext[i].getText().length()>0)
sayac++;
if(sayac==jtext.length)
return true;
return false;
}
@Override
public void onClick(View view) {
try {
baglan();
int yas=Integer.parseInt(et[2].getText()+"");
if(kontrol(et))
{
ContentValues par=new ContentValues();
par.put("ad",et[0].getText()+"");
par.put("soyad",et[1].getText()+"");
par.put("yas",yas);
db.insertOrThrow("Kisi",null,par);
db.close();
datagetir();
}
}
catch (Exception ex)
{
Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
}
}
public void datagetir(){
try {
baglan();
Cursor c=db.query("Kisi",new String[]{"id","ad","soyad","yas"},null,null,null,null,null);
liste.clear();
idliste.clear();
adp.notifyDataSetChanged();//liste değisiklik oldupu için adepteri güncelliyoruz
c.moveToPosition(-1);//işaretcinin(Cursor) pozisyonu ayalıyoruz tablonun ilk satırından baslaması için
while(c.moveToNext())//ileri diyoruz boylece Cursor tablonun ilk satırına geciyor
{
Kisi k=new Kisi();
k.ad=c.getString(1);
k.soyad=c.getString(2);
k.yas=c.getInt(3);
liste.add(k);//liste Kisi tipinde item aldığı için Kisi sınıfından nesne turetip degiskenlerine atıp nesneyi attık
idliste.add(c.getInt(0));
}
db.close();
c.close();
}
catch (Exception ex)
{
Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
}
}
}
package adepter;
import android.app.Activity;
import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;
import com.example.ali.databasekullanm.R;
import java.util.List;
import kisi.Kisi;
public class myadepter extends BaseAdapter {
List<Kisi> liste;
LayoutInflater layout;
public myadepter(Activity a,List<Kisi> liste){
this.liste=liste;
layout=(LayoutInflater)a.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
}
@Override
public int getCount() {
return liste.size();
}
@Override
public Object getItem(int i) {
return liste.get(i);
}
@Override
public long getItemId(int i) {
return i;
}
@Override
public View getView(int i, View view, ViewGroup viewGroup) {
View v=layout.inflate(R.layout.colum,null);
TextView t1=(TextView)v.findViewById(R.id.ad);
TextView t2=(TextView)v.findViewById(R.id.soyad);
TextView t3=(TextView)v.findViewById(R.id.yas);
Kisi k=liste.get(i);
t1.setText(k.ad);
t2.setText(k.soyad);
t3.setText(""+k.yas);
return v;
}
}<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1"></span>
package kisi;
public class Kisi {
public String ad;
public String soyad;
public int yas;
}
<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1"></span>