InventoryProductRepository.java

package com.godoro.androidsqlite;

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

public class InventoryProductRepository {

    private SQLiteDatabase database;
    private InventorySqlHelper helper;

    public InventoryProductRepository(Context context){
        helper=new InventorySqlHelper(context);
        database=helper.getWritableDatabase();
    }

    public void close() {
        helper.close();
    }

    public long insert(String productName,double salesPrice){
        ContentValues values = new ContentValues();
        values.put("productName",productName);
        values.put("salesPrice",salesPrice);
        return database.insert("product", null, values);
    }
    public void update(long id,String productName,double salesPrice){
        ContentValues values = new ContentValues();
        values.put("productName",productName);
        values.put("salesPrice",salesPrice);
        database.update("product", values, "_id=" + id,null);
    }
    public void delete(long id){
        database.delete("product", "_id=" + id, null);
    }
    public Cursor find(long id){
        String[] columns={"_id","productName","salesPrice"};
        Cursor cursor=database.query("product", columns, "_id=" + id, null, null,null, null);
        if (cursor != null) {
            cursor.moveToFirst();
        }
        return cursor;
    }
    public Cursor list(){
        String[] columns={"_id","productName","salesPrice"};
        return database.query("product", columns, null, null, null,null, null);
    }
}