public boolean insertDataGift(ArrayList<Object> where) {
// brand 0,name 1 , giftname 2 ,image 3 ,price 4 ,lastupdate 5
DBConnect db = DBConnect.getDBConnect();
String sql =
"insert into gift values(?,?,?,?,?,?) on duplicate key update giftname=?,image=?,price=?,lastupdate=?";
ArrayList<Object> insertWhere = new ArrayList<Object>();
insertWhere.addAll(where);
insertWhere.add(where.get(2));
insertWhere.add(where.get(3));
insertWhere.add(where.get(4));
insertWhere.add(where.get(5));
if (db.modifyDB(sql, insertWhere)) {
System.out.println(
where.get(0) + " : " + where.get(1) + " + " + where.get(2) + " Data Insert OR Update OK");
return true;
} else {
System.out.println(
where.get(0)
+ " : "
+ where.get(1)
+ " + "
+ where.get(2)
+ " Data Insert OR Update Fail");
return false;
}
}
public boolean endingEventProductDelete(String lastUpdate, String table) {
DBConnect db = DBConnect.getDBConnect();
String sql =
"delete from "
+ table
+ " where lastupdate!="
+ lastUpdate
+ " brand="
+ sData.getBRAND_NAME();
if (db.modifyDB(sql, null)) {
System.out.println("Old Data Delete");
return true;
} else {
System.out.println("Old Data Delete Fail");
return false;
}
}
// brand,image,type,name,price,lastupdate
// product 의 키값=brand+name
// 중복되는 키값이 있으면 해당 열의 값을 업데이트(image,type,price,lastupdate)
// 키값이 없으면 추가
public boolean insertData(ArrayList<Object> where) {
String sql =
"insert into product values(?,?,?,?,?,?) on duplicate key update image=?, type=?,price=?,lastupdate=?";
DBConnect db = DBConnect.getDBConnect();
ArrayList<Object> insertWhere = new ArrayList<Object>();
insertWhere.addAll(where);
insertWhere.add(where.get(1)); // image
insertWhere.add(where.get(2)); // type
insertWhere.add(where.get(4)); // price
insertWhere.add(where.get(5)); // lastupdate
if (db.modifyDB(sql, insertWhere)) {
System.out.println(
sData.getBRAND_NAME() + " : " + where.get(3) + " Data Insert OR Update OK");
return true;
} else {
System.out.println(sData.getBRAND_NAME() + " Data Insert Error");
return false;
}
}
