Notes

package com.example.uaspm;

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

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

public class NotaHelper extends SQLiteOpenHelper {
private static final int VERSION = 1;
private static final String DBNAME = "RECORDDB3.sqlite";
private static final String TABLENAME = "laporan";

private static String colID = "id";
private static String colNama = "nama";
private static String colJumlah = "jumlah";
private static String colHarga = "harga";
private static String colTanggal = "tanggal";

public NotaHelper(Context context) {
super(context, DBNAME, null, VERSION);
}

@Override
public void onCreate(SQLiteDatabase database) {
String createTable = "CREATE TABLE " + TABLENAME + "("
+ colID + " INTEGER PRIMARY KEY AUTOINCREMENT," + colNama + " TEXT,"
+ colJumlah + " TEXT,"
+ colHarga + " TEXT,"
+ colTanggal + "DATETIME DEFAULT CURRENT_TIMESTAMP)";
database.execSQL(createTable);
}

@Override
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
database.execSQL("DROP TABLE IF EXISTS "+ TABLENAME);
onCreate(database);
}

public void insertData(String nama, String harga,String jumlah, String tanggal){
String insertData = "INSERT INTO "+ TABLENAME + " ("+ colNama +","+colHarga+","+colJumlah+","+colTanggal+") VALUES ('"+nama +"','"+harga+"','"+jumlah+",'"+tanggal+"')";
this.getWritableDatabase().execSQL(insertData);
}

public void updateData(int id, String nama, String harga,String jumlah){
String updateData = "UPDATE "+TABLENAME+ " SET "+ colNama + "= '"+nama +"', "+colHarga + "= '"+harga + "',"+ colNama + "= '"+nama +"' WHERE "+colID +" ="+id;
this.getWritableDatabase().execSQL(updateData);
}

public void deleteData(int id){
String deleteData = "DELETE FROM "+TABLENAME +" WHERE id="+id;
this.getWritableDatabase().execSQL(deleteData);
}

public Nota getData(int id){
Nota model = null;
String selectData = "SELECT * FROM "+TABLENAME + " WHERE id="+String.valueOf(id);
Cursor data = this.getWritableDatabase().rawQuery(selectData, null);
if(data.moveToFirst()){
model = new Nota(Integer.parseInt(data.getString(data.getColumnIndex(colID))),
data.getString(data.getColumnIndex(colNama)),data.getString(data.getColumnIndex(colJumlah)) ,data.getString(data.getColumnIndex(colHarga)), data.getString(data.getColumnIndex(colTanggal)));
}
return model;
}
public Cursor getBunga(String sql){
SQLiteDatabase database = getReadableDatabase();
return database.rawQuery(sql, null);
}

public Cursor getTable(String sql){
SQLiteDatabase database = getReadableDatabase();
return database.rawQuery(sql, null);
}

public List<Nota> getAll(){
List<Nota> model = new ArrayList<>();
String selectData = "SELECT * FROM "+TABLENAME;
Cursor data = this.getWritableDatabase().rawQuery(selectData, null);
if(data.moveToFirst()){
do{
model.add(new Nota(Integer.parseInt(data.getString(data.getColumnIndex(colID))),
data.getString(data.getColumnIndex(colNama)),data.getString(data.getColumnIndex(colJumlah)) ,data.getString(data.getColumnIndex(colHarga)),data.getString(data.getColumnIndex(colTanggal))));
}while (data.moveToNext());
}
return model;
}
}