• 2.05.2024
  • 241
  • Android Studio local veri tabanı örneği xml java kodlarıYazılı Ders

Android Studio local veri tabanı örneği xml java kodları

rehber isminde proje oluşturunuz

Xml

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:padding="10dp"
    tools:context=".MainActivity">

    <TextView
        android:id="@+id/texttitle"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Lütfen Aşağıdaki Bilgieri Doldurunuz"
        android:textSize="24dp"
        android:layout_marginTop="20dp"/>
    <EditText
        android:id="@+id/name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="İsim"
        android:textSize="24dp"
        android:layout_below="@+id/texttitle"
        android:inputType="textPersonName"/>
    <EditText
        android:id="@+id/contact"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="Telefon"
        android:textSize="24dp"
        android:layout_below="@+id/name"
        android:inputType="number"/>
    <EditText
        android:id="@+id/dob"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="Doğum Tarihi"
        android:textSize="24dp"
        android:layout_below="@+id/contact"
        android:inputType="number"/>
    <Button
        android:id="@+id/btnInsert"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:textSize="24dp"
        android:text="Yeni Kayıt"
        android:layout_marginTop="30dp"
        android:layout_below="@id/dob"/>
    <Button
        android:id="@+id/btnUpdate"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:textSize="24dp"
        android:text="Güncelle"
        android:layout_below="@id/btnInsert"/>
    <Button
        android:id="@+id/btnDelete"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:textSize="24dp"
        android:text="Sil"
        android:layout_below="@id/btnUpdate"/>
    <Button
        android:id="@+id/btnView"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:textSize="24dp"
        android:text="Listele"
        android:layout_below="@id/btnDelete"/>
</RelativeLayout>


 

MainActivity.java

 


	

package com.example.rehber;

import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {
    EditText name, contact, dob;
    Button insert, update, delete, view;
    DBHelper DB;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        name = findViewById(R.id.name);
        contact = findViewById(R.id.contact);
        dob = findViewById(R.id.dob);
        insert = findViewById(R.id.btnInsert);
        update = findViewById(R.id.btnUpdate);
        delete = findViewById(R.id.btnDelete);
        view = findViewById(R.id.btnView);

        DB = new DBHelper(this);

       insert.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                String nameTXT = name.getText().toString();
                String contactTXT = contact.getText().toString();
                String dobTXT = dob.getText().toString();

                Boolean checkinsertdata = DB.insertuserdata(nameTXT, contactTXT, dobTXT);
                if(checkinsertdata==true)
                    Toast.makeText(MainActivity.this, "Yeni Kayıt Eklendi", Toast.LENGTH_SHORT).show();
                else
                    Toast.makeText(MainActivity.this, "Yeni Kayıt Eklenemedi", Toast.LENGTH_SHORT).show();
            }        });
        update.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                String nameTXT = name.getText().toString();
                String contactTXT = contact.getText().toString();
                String dobTXT = dob.getText().toString();

                Boolean checkupdatedata = DB.updateuserdata(nameTXT, contactTXT, dobTXT);
                if(checkupdatedata==true)
                    Toast.makeText(MainActivity.this, "Kayıt Güncellendi", Toast.LENGTH_SHORT).show();
                else
                    Toast.makeText(MainActivity.this, "Kayıt Güncellenemedi", Toast.LENGTH_SHORT).show();
            }        });
        delete.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                String nameTXT = name.getText().toString();
                Boolean checkudeletedata = DB.deletedata(nameTXT);
                if(checkudeletedata==true)
                    Toast.makeText(MainActivity.this, "Kayı Silindi", Toast.LENGTH_SHORT).show();
                else
                    Toast.makeText(MainActivity.this, "Entry Kayıt Silinemedi", Toast.LENGTH_SHORT).show();
            }        });

        view.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Cursor res = DB.getdata();
                if(res.getCount()==0){
                    Toast.makeText(MainActivity.this, "Kayıt Bulunamadı", Toast.LENGTH_SHORT).show();
                    return;
                }
                StringBuffer buffer = new StringBuffer();
                while(res.moveToNext()){
                    buffer.append("İsim :"+res.getString(0)+"\n");
                    buffer.append("Telefon :"+res.getString(1)+"\n");
                    buffer.append("Doğum Tarihi :"+res.getString(2)+"\n\n");
                }

                AlertDialog.Builder builder = new AlertDialog.Builder(MainActivity.this);
                builder.setCancelable(true);
                builder.setTitle("Liste");
                builder.setMessage(buffer.toString());
                builder.show();
            }        });
    }

    public static class DBHelper extends SQLiteOpenHelper {
        public DBHelper(Context context) {
            super(context, "Userdata.db", null, 1);
        }
        @Override
        public void onCreate(SQLiteDatabase DB) {
            DB.execSQL("create Table Userdetails(name TEXT primary key, contact TEXT, dob TEXT)");
        }
        @Override
        public void onUpgrade(SQLiteDatabase DB, int i, int ii) {
            DB.execSQL("drop Table if exists Userdetails");
        }
        public Boolean insertuserdata(String name, String contact, String dob)
        {
            SQLiteDatabase DB = this.getWritableDatabase();
            ContentValues contentValues = new ContentValues();
            contentValues.put("name", name);
            contentValues.put("contact", contact);
            contentValues.put("dob", dob);
            long result=DB.insert("Userdetails", null, contentValues);
            if(result==-1){
                return false;
            }else{
                return true;
            }
        }
        public Boolean updateuserdata(String name, String contact, String dob)
        {
            SQLiteDatabase DB = this.getWritableDatabase();
            ContentValues contentValues = new ContentValues();
            contentValues.put("contact", contact);
            contentValues.put("dob", dob);
            Cursor cursor = DB.rawQuery("Select * from Userdetails where name = ?", new String[]{name});
            if (cursor.getCount() > 0) {
                long result = DB.update("Userdetails", contentValues, "name=?", new String[]{name});
                if (result == -1) {
                    return false;
                } else {
                    return true;
                }
            } else {
                return false;
            }
        }
        public Boolean deletedata (String name)
        {
            SQLiteDatabase DB = this.getWritableDatabase();
            Cursor cursor = DB.rawQuery("Select * from Userdetails where name = ?", new String[]{name});
            if (cursor.getCount() > 0) {
                long result = DB.delete("Userdetails", "name=?", new String[]{name});
                if (result == -1) {
                    return false;
                } else {
                    return true;
                }
            } else {
                return false;
            }
        }

        public Cursor getdata ()
        {
            SQLiteDatabase DB = this.getWritableDatabase();
            Cursor cursor = DB.rawQuery("Select * from Userdetails", null);
            return cursor;
        }
    }
}

 

app_inspection panelinde veri tabanını görebilirsiniz.

 

Yeni kayıt ekle

 

Kayıt Listele

 

SQL örnekleri;

Veri ekle

insert into Userdetails (name) values ("cc")

Veri güncelleme

update Userdetails set contact="545345345"  where name="cc"

Veri silme

delete from Userdetails where name="bb"

Veri listele

SELECT * FROM  Userdetails

Yeni tablo Oluşturmak

CREATE TABLE IF NOT EXISTS urunler(id INTEGER PRIMARY KEY,urunadi VARCHAR,fiyat DOUBLE,adet INTEGER)

 

YORUM YAP