1-) Android RMOS - sqlite kullanimi

implementation 'com.readystatesoftware.sqliteasset:sqliteassethelper:+'

1-)database_helper.java

package com.rm.kitap;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;

public class database_helper extends SQLiteAssetHelper {
    private  static final String DATABASE_NAME="kitap1.db";
    private  static final int DATABASE_VERSION=1;

    public database_helper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

//veya

    public database_helper(Context context) {
//        super(context, "kullanici", null, DATABASE_VERSION);
//    }
//
//    @Override
//    public void onCreate(SQLiteDatabase db){
//
//        String sql="create table kullanici (id integer primary key  autoincrement, isim text not null)";
//        db.execSQL(sql);
//
//    }
//
//    @Override
//    public void onUpgrade(SQLiteDatabase db, int eski, int yeni){
//
//        db.execSQL("drop table if exists kullanici");
//    }

}

1-) Android RMOS - database_access.java

package com.rm.kitap;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import com.rm.kitap.kitaplist.kitapModel;

import java.util.ArrayList;
import java.util.List;

public class database_access {
    private SQLiteOpenHelper openHelper;
    SQLiteDatabase db;
    static database_access instance;
    Cursor c = null;

    database_access(Context context) {
        this.openHelper = new database_helper(context);
    }

    public static database_access getInstance(Context context) {
        if (instance == null) {
            instance = new database_access(context);
        }
        return instance;
    }

    public void open() {
        this.db = openHelper.getWritableDatabase();
    }

    public void close() {
        if (db != null) {
            this.db.close();
            this.db.close();
        }
    }

    public String getText(String sql) { // top 1 ile ilk değeri döndürür
        c = db.rawQuery(sql, null);
        StringBuffer buffer = new StringBuffer();
        while (c.moveToNext()){
            String adress=c.getString(0);
            buffer.append(""+adress);
        }
        return  buffer.toString();
    }

    public void kitap_ekle(String sql) { // top 1 ile ilk değeri döndürür
       db.execSQL(sql);
    }
/*
* "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"baslik" TEXT,
"yazar" TEXT,
"kitapozeti" TEXT,
"resim" TEXT,
"kategori" TEXT
* */

    public List<kitapModel> getTable(String sql) { // top 1 ile ilk değeri döndürür
        List<kitapModel> modelList=new ArrayList<>();
        c = db.rawQuery(sql,null);
        while (c.moveToNext()){
            kitapModel model = new kitapModel();
            model.setId(c.getInt(0)); //id
            model.setBaslik(c.getString(1)); //baslik
            model.setYazar(c.getString(2));//yazar
            model.setKitapozeti(c.getString(3));//kitapozeti
            model.setResim(c.getString(4));//resim
            model.setKategori(c.getString(5));//kategori
            modelList.add(model);
        }
        return  modelList;
    }
}

1-) Android RMOS - MainActivty.java

database_access acces = database_access.getInstance(getActivity().getApplicationContext());
acces.open();
List<kitapModel> modelList= acces.getTable("select * from kitaplar where kategori='"+mykategori+"'");
if(modelList.size()==0){
    Toast.makeText(getActivity(), "Hiç Kitap Yok !", Toast.LENGTH_SHORT).show();
    return;
}

list_item.setAdapter(kitapAdapter);

Toast.makeText(getActivity(), mykategori+" Listelendi...", Toast.LENGTH_SHORT).show();
acces.close();