Android Sqlite Veri Ekleme Class Yapısı

---------------------MainActivity XML-----------------------
<LinearLayout
    android:layout_width="368dp"
    android:layout_height="495dp"
    android:orientation="vertical"
    tools:layout_editor_absoluteX="8dp"
    tools:layout_editor_absoluteY="8dp">

    <EditText
        android:id="@+id/etad"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:hint="ad"
        android:inputType="textPersonName" />

    <EditText
        android:id="@+id/etsoyad"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:hint="soyad"
        android:inputType="textPersonName" />

    <EditText
        android:id="@+id/etyas"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:hint="yas"
        android:inputType="textPersonName" />

    <Button
        android:id="@+id/btnekle"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Ekle" />




</LinearLayout>

------------------------MainActivity-------------------------------

public class MainActivity extends AppCompatActivity { DatabaseHelper myDb; EditText ad,soyad,yas; Button btnEkle; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); myDb = new DatabaseHelper(this); ad = (EditText) findViewById(R.id.etad); soyad = (EditText) findViewById(R.id.etsoyad); yas = (EditText) findViewById(R.id.etyas); btnEkle = (Button) findViewById(R.id.btnekle); kayitEkle(); } public void kayitEkle(){ btnEkle.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { boolean eklendiMi = myDb.veriEkle(ad.getText().toString(),soyad.getText().toString(),yas.getText().toString()); if(eklendiMi==true){ Toast.makeText(MainActivity.this, "Veri Eklendi!", Toast.LENGTH_LONG).show(); } else { Toast.makeText(MainActivity.this, "Veri Eklenemedi!", Toast.LENGTH_LONG).show(); } } }); } }

-------------------------SQLiteOpenHelper------------------------

import android.content.ContentValues; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class DatabaseHelper extends SQLiteOpenHelper { public static final String DATABASE_NAME = "BIGBOSS.db"; public static final String TABLE_NAME = "KULLANICI"; public static final String COL1 = "ID"; public static final String COL2 = "AD"; public static final String COL3 = "SOYAD"; public static final String COL4 = "YAS"; public DatabaseHelper(Context context) { super(context, DATABASE_NAME, null, 1); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("create table " + TABLE_NAME + "( ID INTEGER PRIMARY KEY AUTOINCREMENT , AD TEXT , SOYAD TEXT , YAS INTEGER )"); } @Override public void onUpgrade(SQLiteDatabase db, int i, int i1) { db.execSQL("DROP TABLE IF EXISTS " +TABLE_NAME); onCreate(db); } public boolean veriEkle(String ad , String soyad , String yas){ SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL2,ad); contentValues.put(COL3,soyad); contentValues.put(COL4,yas); long result = db.insert( TABLE_NAME,null,contentValues); if(result==-1) { return false; } else{ return true; } } }

Hiç yorum yok:

Yorum Gönder