Код: Выделить всё
public class DBHandlerImpl extends SQLiteOpenHelper implements DBHandler<Goods>{
private static final int DATABASE_VERSION = 4;
private static final String DATABASE_NAME = "app_bases";
private static final String TABLE_USERS = "users";
private static final String ID = "_id_users";
private static final String GOODS = "users_goods";
private static final String DATE = "users_date";
private static final String AMOUNT = "users_amount";
private static final String COST = "users_cost";
private static final String TABLE_SELL = "sell";
private static final String ID_SELL = "_id_sell";
private static final String SELL_GOODS = "sell_goods";
private static final String SELL_DATE = "sell_date";
private static final String SELL_AMOUNT = "sell_amount";
private static final String SELL_COST = "sell_cost";
private static final String TABLE_RESULT = "result";
private static final String ID_RESULT = "_id_result";
private static final String RESULT_LAST = "result_last";
private static final String RESULT_DATE = "result_date";
private static final String RESULT_AMOUNT = "result_amount";
private static final String RESULT_COST = "result_cost";
public DBHandlerImpl(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String query = "Create Table " + TABLE_USERS + "(" + ID + "INTEGER PRIMARY KEY, " +
GOODS + " TEXT, " +
DATE + " TEXT, " +
AMOUNT + " DOUBLE NOT NULL, " +
COST + " DOUBLE NOT NULL);";
db.execSQL(query);
query = "Create Table " + TABLE_SELL + "(" + ID_SELL + "INTEGER PRIMARY KEY, " +
SELL_GOODS + " TEXT, " +
SELL_DATE + " TEXT, " +
SELL_AMOUNT + " DOUBLE NOT NULL, " +
SELL_COST + " DOUBLE NOT NULL);";
db.execSQL(query);
query = "Create Table " + TABLE_RESULT + "(" + ID_RESULT + "INTEGER PRIMARY KEY, " +
RESULT_LAST + " TEXT, " +
RESULT_DATE + " TEXT, " +
RESULT_AMOUNT + " DOUBLE NOT NULL, " +
RESULT_COST + " DOUBLE NOT NULL);";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int i, int i2) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_USERS);
db.execSQL("DROP TABLE IF EXISTS " + TABLE_SELL);
db.execSQL("DROP TABLE IF EXISTS " + TABLE_RESULT);
onCreate(db);
}
@Override
public void addPrihod(Goods goods) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
// values.put(ID, goods.getId());
values.put(GOODS, goods.getName_goods());
values.put(DATE, goods.getDate());
values.put(AMOUNT, goods.getAmount());
values.put(COST, goods.getCost());
db.insert(TABLE_USERS, null, values);
db.close();
}
@Override
public void addRashod(Goods goods) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(SELL_GOODS, goods.getName_goods());
values.put(SELL_DATE, goods.getDate());
values.put(SELL_AMOUNT, goods.getAmount());
values.put(SELL_COST, goods.getCost());
db.insert(TABLE_SELL, null, values);
db.close();
}