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; } }