1-) Android - VERİ TABANI SQL
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent"
android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity">
<TextView android:text="@string/hello_world" android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:id="@+id/textView" />
<EditText
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:id="@+id/ad"
android:layout_below="@+id/textView"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:hint="adınızı giriniz" />
<EditText
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:id="@+id/soyad"
android:layout_below="@+id/ad"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:hint="soyadınızı gırınız" />
<LinearLayout
android:orientation="horizontal"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_below="@+id/soyad"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:id="@+id/linearLayout">
<Button
android:layout_width="wrap_content"
android:layout_height="50dp"
android:text="KAydet"
android:id="@+id/keydet"
android:onClick="kaydet"
android:layout_marginTop="82dp"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:layout_below="@+id/getir"
android:layout_weight="1"
android:layout_gravity="left" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="veri getir"
android:id="@+id/getir"
android:onClick="getir"
android:layout_centerVertical="true"
android:layout_centerHorizontal="true"
android:layout_weight="1" />
</LinearLayout>
<EditText
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:inputType="number"
android:ems="10"
android:id="@+id/tvid"
android:layout_below="@+id/linearLayout"
android:layout_alignRight="@+id/btnidgetir"
android:layout_alignEnd="@+id/btnidgetir"
android:hint="id girin" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="idgetir"
android:id="@+id/btnidgetir"
android:onClick="idgetir"
android:layout_below="@+id/tvid"
android:layout_alignRight="@+id/btnguncelle"
android:layout_alignEnd="@+id/btnguncelle" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="GÜNCELLE"
android:id="@+id/btnguncelle"
android:layout_below="@+id/btnidgetir"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:onClick="guncelle" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="SİL"
android:id="@+id/btnsil"
android:layout_below="@+id/btnguncelle"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:onClick="sil" />
</RelativeLayout>
2-)activity_tum_kayitlar.xml içi
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
tools:context="com.example.ramazan.veritabanisql.TumKayitlar">
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:layout_alignParentTop="true"
android:layout_centerHorizontal="true"
android:orientation="vertical">
<TableLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_gravity="center_horizontal">
<TableRow
android:layout_width="match_parent"
android:layout_height="match_parent"
android:layout_column="0">
<TextView
android:id="@+id/textView2"
android:layout_width="120dp"
android:layout_height="match_parent"
android:layout_weight="1"
android:text="soyad"
android:textSize="35dp" />
<TextView
android:id="@+id/textView3"
android:layout_width="120dp"
android:layout_height="match_parent"
android:layout_weight="1"
android:text="isimler"
android:textSize="35dp" />
</TableRow>
</TableLayout>
<TextView
android:id="@+id/tvtumkayitlar"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="DB'den Gelenler"
android:textSize="15dp" />
</LinearLayout>
</RelativeLayout>
3-)strings.xml içi
<resources>
<string name="app_name">VeriTabaniSql</string>
<string name="hello_world">Hello world!</string>
<string name="action_settings">Settings</string>
<string name="title_activity_insanlar">insanlar</string>
<string name="title_activity_tum_kayitlar">TumKayitlar</string>
</resources>
4-)AndroidManifest.xml içi
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.ramazan.veritabanisql" >
<application
android:allowBackup="true"
android:icon="@mipmap/ic_launcher"
android:label="@string/app_name"
android:theme="@style/AppTheme" >
<activity
android:name=".MainActivity"
android:label="@string/app_name" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:name=".insanlar"
android:label="@string/title_activity_insanlar" >
</activity>
<activity
android:name=".TumKayitlar"
android:label="@string/title_activity_tum_kayitlar" >
</activity>
</application>
</manifest>
5-)MainActivity.java içi
package com.example.ramazan.veritabanisql;
import android.app.Dialog;
import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import java.sql.SQLException;
public class MainActivity extends AppCompatActivity {
Button kaydet, getir, btnidgetir, btnguncelle, btnsil;
EditText soyad, tvgirilenid;
EditText ad;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
kaydet = (Button) findViewById(R.id.keydet);
getir = (Button) findViewById(R.id.getir);
btnidgetir = (Button) findViewById(R.id.btnidgetir);
btnguncelle = (Button) findViewById(R.id.btnguncelle);
btnsil = (Button) findViewById(R.id.btnsil);
ad = (EditText) findViewById(R.id.ad);
soyad = (EditText) findViewById(R.id.soyad);
tvgirilenid = (EditText) findViewById(R.id.tvid); }
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true; }
public void idgetir(View v) throws SQLException {
String id = tvgirilenid.getText().toString();
long aranacakid = Long.valueOf(id);
veritabani db = new veritabani(MainActivity.this);
db.veritabani_baglantiyi_ac();
String eldeedilenisim = db.getName(aranacakid);
String eldeedilenyas = db.getYas(aranacakid);
db.veritabani_baglantiyi_kapat();
ad.setText(eldeedilenisim);
soyad.setText(eldeedilenyas); }
public void guncelle(View v) throws SQLException {
String add = ad.getText().toString();
String yass = soyad.getText().toString();
String idd = tvgirilenid.getText().toString();
long guncellenecekid = Long.valueOf(idd);
veritabani dbb = new veritabani(MainActivity.this);
dbb.veritabani_baglantiyi_ac();
dbb.kaydiguncelle(guncellenecekid, add, yass);
dbb.veritabani_baglantiyi_kapat(); }
public void sil(View v) throws SQLException {
String silinecekkayit = tvgirilenid.getText().toString();
long silinecekid = Long.valueOf(silinecekkayit);
veritabani db=new veritabani(MainActivity.this);
db.veritabani_baglantiyi_ac();
db.kaydisil(silinecekid);
db.veritabani_baglantiyi_kapat(); }
public void kaydet(View v) {
String add = ad.getText().toString();
String soyadd = soyad.getText().toString();
try {
veritabani db = new veritabani(MainActivity.this);
db.veritabani_baglantiyi_ac();
db.isim_soyisim_kaydet(add, soyadd);
db.veritabani_baglantiyi_kapat();
Dialog dialog = new Dialog(this);
dialog.setTitle("Ekleme İşlemi");
TextView tvsonuc = new TextView(this);
tvsonuc.setText("BAŞARILI");
dialog.setContentView(tvsonuc);
dialog.show();
} catch (Exception e) {
Dialog hata = new Dialog(this);
hata.setTitle("Ekleme İşlemi");
TextView tvsonuc = new TextView(this);
tvsonuc.setText(e.toString());
hata.setContentView(tvsonuc);
hata.show(); } }
public void getir(View v) {
Intent ıntent = new Intent(getApplicationContext(), TumKayitlar.class);
startActivity(ıntent); }
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true; }
return super.onOptionsItemSelected(item); }}
6-)TumKayitlar.java içi
package com.example.ramazan.veritabanisql;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.TextView;
import java.sql.SQLException;
public class TumKayitlar extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_tum_kayitlar);
TextView tv = (TextView) findViewById(R.id.tvtumkayitlar);
veritabani db = new veritabani(TumKayitlar.this);
try {
db.veritabani_baglantiyi_ac();
String Tumkayitlar = db.tumkayitlar();
db.veritabani_baglantiyi_kapat();
tv.setText(Tumkayitlar);
} catch (SQLException e) {
e.printStackTrace(); } }
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_tum_kayitlar, menu);
return true; }
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true; }
return super.onOptionsItemSelected(item); }}
7-)veritabani.java içi
package com.example.ramazan.veritabanisql;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import java.sql.SQLException;
public class veritabani {
private static final String DATABASE_ISIM = "egitimdb";
private static final String DATABASE_TABLO = "insanlar";
private static final int DATABASE_VERSION = 5;
//oluşturulacak insanlar tablosunun sütünları
public static final String KEY_ROW_ID = "_id";
public static final String KEY_ISIM = "_isim";
public static final String KEY_YAS = "_yas";
private final Context contextim;
private Veritabanihelper veritabanihelper;
private SQLiteDatabase veritabanim;
public veritabani(Context contextim) {
this.contextim = contextim; }
public veritabani veritabani_baglantiyi_ac() throws SQLException {
veritabanihelper = new Veritabanihelper(contextim);
veritabanim = veritabanihelper.getWritableDatabase();
return this; }
public void veritabani_baglantiyi_kapat() {
veritabanihelper.close(); }
public long isim_soyisim_kaydet(String add, String soyadd) {
ContentValues cv = new ContentValues();
cv.put(KEY_ISIM, add);
cv.put(KEY_YAS, soyadd);
return veritabanim.insert(DATABASE_TABLO, null, cv); }
public String tumkayitlar() {
String[] sutunlar = new String[]{KEY_ROW_ID, KEY_ISIM, KEY_YAS};
Cursor c = veritabanim.query(DATABASE_TABLO, sutunlar, null, null, null, null, null);
String tumkayitlar = "";
int idsirano = c.getColumnIndex(KEY_ROW_ID);
int isimsirano = c.getColumnIndex(KEY_ISIM);
int soyisim = c.getColumnIndex(KEY_YAS);
for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
tumkayitlar = tumkayitlar + c.getString(idsirano) + " " + c.getString(isimsirano)+" " + c.getString(soyisim) + "\n";
} return tumkayitlar; }
public String getName(long aranacakid) {
String[] sutunlar = new String[]{KEY_ROW_ID, KEY_ISIM, KEY_YAS};
Cursor c = veritabanim.query(DATABASE_TABLO, sutunlar, KEY_ROW_ID+"="+aranacakid, null, null, null, null);
if(c!=null){
c.moveToFirst();
String isim =c.getString(1);//tumkayitlar() metodundaki gibide yapabilirsin "1" demek 1.sutunda
return isim; }
return null; }
public String getYas(long aranacakid) {
String[] sutunlar = new String[]{KEY_ROW_ID, KEY_ISIM, KEY_YAS};
Cursor c = veritabanim.query(DATABASE_TABLO, sutunlar, KEY_ROW_ID+"="+aranacakid, null, null, null, null);
if(c!=null){
c.moveToFirst();
String yas =c.getString(2);//tumkayitlar() metodundaki gibide yapabilirsin "1" demek 1.sutunda
return yas; } return null; }
public void kaydiguncelle(long guncellenecekid, String add, String yass) {
ContentValues cvguncelle=new ContentValues();
cvguncelle.put(KEY_ISIM,add);
cvguncelle.put(KEY_YAS,yass);
veritabanim.update(DATABASE_TABLO,cvguncelle,KEY_ROW_ID+"="+guncellenecekid,null); }
public void kaydisil(long silinecekid) {
veritabanim.delete(DATABASE_TABLO,KEY_ROW_ID+"="+silinecekid,null); }
private static class Veritabanihelper extends SQLiteOpenHelper {
public Veritabanihelper(Context context) {
super(context, DATABASE_ISIM, null, DATABASE_VERSION); }
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + DATABASE_TABLO + " ("
+ KEY_ROW_ID + " INTEGER PRIMARY KEY AUTOINCREMENT , " +
KEY_ISIM + " TEXT NOT NULL, " +
KEY_YAS + " TEXT NOT NULL);"); }
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLO);
onCreate(db); } }}