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);
Hiç yorum yok:
Yorum Gönder