public boolean checkUpdate(ArrayList<Object> where) {
DBConnect db = DBConnect.getDBConnect();
String sql = "select count(*) from product where image=?"; // image 값은 URL이라 타 상품과 중복 없음..아마도..
ArrayList<Object> checkWhere = new ArrayList<Object>();
checkWhere.add(where.get(1));
ResultSet rs = db.selectDB(sql, checkWhere);
System.out.println("checkWhere : " + where.get(1));
try {
rs.next();
int cnt;
if ((cnt = rs.getInt(1)) > 0) {
System.out.println(where.get(3) + " : duplication " + cnt);
return false;
} else {
System.out.println(cnt);
return true;
}
} catch (SQLException e) {
System.out.println(sData.getBRAND_NAME() + " checkUpdate Error : " + e.getMessage());
return false;
} finally {
DBClose.dbClose(null, null, rs);
}
}
