package com.shouhuoji.SQLite;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteStatement;
import android.util.Log;
import com.shouhuoji.data.FreightData;
import com.shouhuoji.data.LocalGoodsData;
import java.util.ArrayList;
import java.util.List;
public class SQLiteManager{
private DBSOpenHelper helper;
public SQLiteManager(Context context) {
helper = DBSOpenHelper.getInstance(context);
}
// 增加商品
public void addGoodsSQL(List<LocalGoodsData> list) {
SQLiteDatabase db = null;
try {
db = helper.getReadableDatabase();
ContentValues values = new ContentValues();
for (int i =0;i<list.size();i++) {
values.put("id",list.get(i).getId());
values.put("goodsId",list.get(i).getGoodsID());
values.put("name",list.get(i).getName());
values.put("inventory",list.get(i).getInventory());
values.put("picurl", list.get(i).getURL());
values.put("costPrice", list.get(i).getCostPrice());
values.put("price", list.get(i).getPrice());
values.put("particulars", list.get(i).getParticulars());
values.put("standby", list.get(i).getStandby());
db.insert("goods", null, values);
}
} catch (Exception e) {
// TODO: handle exception
} finally {
}
}
//添加货道
public void addFreightsSQL(List<FreightData> list){
SQLiteDatabase db = helper.getReadableDatabase();
String sql = "insert into freights(freightId ,goodsId ,goodsname ,goodurl ,isinventory ,inventory ,capacity ,isCheap ,cheapLevel ," +
"price ,costPrice ,outway ,isfreight ,standby ) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
SQLiteStatement stat = db.compileStatement(sql);
db.beginTransaction();
for (FreightData line : list) {
stat.bindLong(1, line.getFreightId());
stat.bindLong(2, line.getGoodsId());
stat.bindString(3, line.getGoodsname());
stat.bindString(4, line.getGoodurl());
stat.bindString(5, line.getIsinventory());
stat.bindString(6, line.getInventory());
stat.bindString(7, line.getCapacity());
stat.bindString(8, line.getIsCheap());
stat.bindString(9, line.getCheapLevel());
stat.bindString(10, line.getPrice());
stat.bindString(11, line.getCostPrice());
stat.bindString(12, line.getOutway());
stat.bindString(13, line.getIsfreight());
stat.bindString(14, line.getStandby());
stat.executeInsert();
}
db.setTransactionSuccessful();
Log.i("TAG","成功======");
db.endTransaction();
// db.close();
}
// 商品查询
public List<LocalGoodsData> goodselectSQL() {
List<LocalGoodsData> list = new ArrayList<>();
SQLiteDatabase db = null;
// 获取一个光标对象
Cursor cursor = null;
try {
db = helper.getReadableDatabase();
cursor = db.query(true, "goods", null, null, null, null, null, null, null, null);
LocalGoodsData data = null;
while (cursor.moveToNext()) {
data = new LocalGoodsData();
data.setId(cursor.getInt(cursor.getColumnIndex("id")));
data.setName(cursor.getString(cursor.getColumnIndex("name")));
data.setURL(cursor.getString(cursor.getColumnIndex("picurl")));
data.setPrice(cursor.getString(cursor.getColumnIndex("price")));
data.setParticulars(cursor.getString(cursor
.getColumnIndex("particulars")));
data.setInventory(cursor.getString(cursor
.getColumnIndex("inventory")));
data.setGoodsID(cursor.getString(cursor
.getColumnIndex("goodsId")));
data.setStandby(cursor.getString(cursor
.getColumnIndex("standby")));
data.setCostPrice(cursor.getString(cursor
.getColumnIndex("costPrice")));
list.add(data);
}
cursor.close();
// db.close();
} catch (Exception e) {
// TODO: handle exception
} finally {
}
return list;
}
// 货道查询
public List<FreightData> freightSelectSQL() {
List<FreightData> list = new ArrayList<>();
SQLiteDatabase db = null;
// 获取一个光标对象
Cursor cursor = null;
try {
db = helper.getReadableDatabase();
cursor = db.query("freights", null, null, null, null, null, null);
FreightData data = null;
while (cursor.moveToNext()) {
data = new FreightData();
data.setFreightId(cursor.getInt(cursor
.getColumnIndex("freightId")));
data.setGoodsId(cursor.getInt(cursor
.getColumnIndex("goodsId")));
data.setIsinventory(cursor.getString(cursor
.getColumnIndex("isinventory")));
data.setInventory(cursor.getString(cursor
.getColumnIndex("inventory")));
data.setCapacity(cursor.getString(cursor
.getColumnIndex("capacity")));
data.setIsCheap(cursor.getString(cursor.getColumnIndex("isCheap")));
data.setCheapLevel(cursor.getString(cursor.getColumnIndex("cheapLevel")));
data.setPrice(cursor.getString(cursor
.getColumnIndex("price")));
data.setCostPrice(cursor.getString(cursor
.getColumnIndex("costPrice")));
data.setOutway(cursor.getString(cursor
.getColumnIndex("outway")));
data.setIsfreight(cursor.getString(cursor.getColumnIndex("isfreight")));
data.setStandby(cursor.getString(cursor.getColumnIndex("standby")));
data.setGoodurl(cursor.getString(cursor.getColumnIndex("goodurl")));
data.setGoodsname(cursor.getString(cursor.getColumnIndex("goodsname")));
list.add(data);
}
cursor.close();
// db.close();
} catch (Exception e) {
// TODO: handle exception
} finally {
}
return list;
}
// 货道删除
public void deleteSQL(final long id) {
SQLiteDatabase db = null;
try {
db = helper.getWritableDatabase();
db.delete("freight", "freightId=" + id, null);
} catch (Exception e) {
} finally {
// db.close();
}
}
// 货道更新
public void updateFreight(int freightId,int goodsId, String isinventory, String inventory,
String capacity, String isCheap, String cheapLevel, String price,
String costPrice, String outway, String isfreight, String standby,
String goodurl,String goodsname) {
SQLiteDatabase db = null;
try {
db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("freightId", freightId);
values.put("goodsId", goodsId);
values.put("isinventory", isinventory);
values.put("inventory", inventory);
values.put("capacity", capacity);