package com.example.myapplicationgb;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import androidx.annotation.Nullable;
public class DatabaseHelper extends SQLiteOpenHelper {
public static final String COST_MONEY = "cost_money";
public static final String COST_DATE = "cost_date";
public static final String COST_TITLE = "cost_title";
public static final String FAMILY_BILL = "family_bill";
public DatabaseHelper(@Nullable Context context) {
super(context, "family_bill", null, 2);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table if not exists family_bill(" +
"id integer primary key, " +
"cost_title varchar, "+
"cost_date varchar, "+
"cost_money varchar)");
}
public void insertCost(CostBean costBean){
SQLiteDatabase database = getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(COST_TITLE,costBean.costTitle);
cv.put(COST_DATE,costBean.costDate);
cv.put(COST_MONEY,costBean.costMoney);
database.insert(FAMILY_BILL,null,cv);
}
public Cursor getAllCostData(){
SQLiteDatabase database = getWritableDatabase();
return database.query(FAMILY_BILL,null,null,null,null,null,"COST_DATE ASC");
}
public void deleteOne(CostBean costBean)
{
SQLiteDatabase database=getWritableDatabase();
database.delete(FAMILY_BILL,"COST_TITLE = ? and COST_MONEY = ? and COST_DATE = ?", new String[]{""+costBean.costTitle,""+costBean.costMoney,""+costBean.costDate});
}
public void deleteAllData(){
SQLiteDatabase database = getWritableDatabase();
database.delete(FAMILY_BILL,null,null);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
public int countTotalCost(){
int sum=0;
SQLiteDatabase database=getWritableDatabase();
String sum_dbString="select sum(cost_money)from "+FAMILY_BILL;
Cursor cursor=database.rawQuery(sum_dbString,null);
if (cursor!=null){
if (cursor.moveToFirst()){
do{
sum=cursor.getInt(0);
}while (cursor.moveToNext());
}
}
return sum;
}
public Cursor selectlist(String s){
SQLiteDatabase database =getWritableDatabase();
// String sql = "select * from "+ FAMILY_BILL +"where cost_date = '%"+s+"%' ";
// database.execSQL(sql);
// database.close();
return database.query(FAMILY_BILL,null,"cost_date LIKE ?",new String[]{"%"+s+"%"},null,null,"COST_DATE ASC");
}
}