Android Veritabanı İşlemleri

Veritabanı Bağlantıları

        Button button = (Button) findViewById(R.id.btngiris);
        final EditText et1 = (EditText)findViewById(R.id.et1);

Database.Java

public class Database extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "veritabani";
    private static final int DATABASE_VERSION =1;
    private static final String KİSİLER_TABLE ="kisiler";

    public static final String ROW_ID = "id";
    public static final String ROW_NAME = "ad";
    public static final String ROW_PASS = "sifre";

    public Database(Context context){
        super(context,DATABASE_NAME,null,DATABASE_VERSION);
    }
    public void onCreate(SQLiteDatabase db){
        db.execSQL("CREATE TABLE " + KİSİLER_TABLE +"("+ROW_ID+" INTEGER PRIMARY KEY, "+ROW_NAME+" TEXT NOT NULL, "+ROW_PASS+" TEXT NOT NULL)");
    }
    public  void onUpgrade(SQLiteDatabase db,int i ,int i1){
        db.execSQL("DROP TABLE IF EXISTS"+KİSİLER_TABLE);
        onCreate(db);

    }
    public void veriEkle(String ad, String sifre){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues ctv = new ContentValues();
        ctv.put(ROW_NAME,ad.trim());
        ctv.put(ROW_PASS,sifre.trim());
        db.insert(KİSİLER_TABLE,null,ctv);
        db.close();


    }
    public List<String> VeriListele(ListView listView){
        List<String> veriler = new ArrayList<String>();
        SQLiteDatabase db = this.getWritableDatabase();
        String[] sutunlar = {ROW_ID, ROW_NAME,  ROW_PASS};
        Cursor cursor = db.query(KİSİLER_TABLE,sutunlar,null,null,null,null,null);
        while (cursor.moveToNext()){
            veriler.add(cursor.getInt(0)+"-"+cursor.getString(1)+"-"+cursor.getString(2));


        }
        return  veriler;

    }
}

ListView Veri Listeleme

Button Click Metodunda Listeleme

Button listele = (Button) findViewById(R.id.btnlistele);
        final ListView listview = (ListView) findViewById(R.id.listview);
        listele.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Database database = new Database(MainActivity.this);
                List<String> vVeriler = database.VeriListele(listview);
                ArrayAdapter<String> adapter = new ArrayAdapter<String>(MainActivity.this, android.R.layout.simple_list_item_1,android.R.id.text1, vVeriler);
                listview.setAdapter(adapter);

            }
        });

OnCreate Metodunda Listeleme

final ListView listvw1 = (ListView) findViewById(R.id.listvw1);

        Database database = new Database(Homepage.this);
        List<String> Veriler = database.VeriListele(listvw1);
        ArrayAdapter<String> adapter = new ArrayAdapter<String>(Homepage.this, android.R.layout.simple_list_item_1,android.R.id.text1, Veriler);
        listvw1.setAdapter(adapter);