public String updateExcludeOnlySql(ValueObject obj, String[] fields) throws SQLException {
fields = KJFUtil.getDifferenceOfSets(default_fields, fields);
if ((obj instanceof PT_KICA_ERR_LOGEntity) == false) {
throw new SQLException("DAO 에러(1): PT_KICA_ERR_LOG : updateModifiedOnly() ");
}
PT_KICA_ERR_LOGEntity entity = (PT_KICA_ERR_LOGEntity) obj;
HashMap clobs = new HashMap();
if (fields == null) throw new SQLException("Field Name can not be Null");
StringBuffer setString = new StringBuffer();
boolean flag = false;
for (int i = 0; i < fields.length; i++) {
if (fields[i] == null) throw new SQLException("Field Name can not be Null");
if (default_update_field.containsKey(fields[i]) == false) {
if (flag) setString.append(",");
flag = true;
if (clobs.containsKey(fields[i])) {
setString.append(fields[i]).append("=?");
} else {
setString.append(fields[i]).append("=").append(toDB(entity.getByName(fields[i])));
}
}
}
if (flag = false) throw new SQLException("Nothing to update");
StringBuffer sb = new StringBuffer();
sb.append("update PT_KICA_ERR_LOG set ").append(setString.toString()).append(" where 1=1 ");
sb.append(" and SEQ = ").append(toDB(entity.getSEQ()));
return sb.toString();
}
///////////////////////////////////////////////////////////////////////////////////
// 특정필드를 제외한 전체 필드를 수정한다.
public int updateExcludeOnly(ValueObject obj, String[] fields) throws SQLException {
fields = KJFUtil.getDifferenceOfSets(default_fields, fields);
if ((obj instanceof PT_KICA_ERR_LOGEntity) == false) {
throw new SQLException("DAO 에러(1): PT_KICA_ERR_LOG : updateModifiedOnly() ");
}
PT_KICA_ERR_LOGEntity entity = (PT_KICA_ERR_LOGEntity) obj;
HashMap clobs = new HashMap();
Connection conn = null;
PreparedStatement ps = null;
int result = 0;
if (fields == null) throw new SQLException("Field Name can not be Null");
StringBuffer setString = new StringBuffer();
boolean flag = false;
for (int i = 0; i < fields.length; i++) {
if (fields[i] == null) throw new SQLException("Field Name can not be Null");
if (default_update_field.containsKey(fields[i]) == false) {
if (flag) setString.append(",");
flag = true;
if (clobs.containsKey(fields[i])) {
setString.append(fields[i]).append("=?");
} else {
setString.append(fields[i]).append("=").append(toDB(entity.getByName(fields[i])));
}
}
}
if (flag = false) throw new SQLException("Nothing to update");
StringBuffer sb = new StringBuffer();
sb.append("update PT_KICA_ERR_LOG set ").append(setString.toString()).append(" where 1=1 ");
sb.append(" and SEQ = ").append(toDB(entity.getSEQ()));
KJFLog.sql(sb.toString());
try {
conn = this.getConnection();
ps = conn.prepareStatement(sb.toString());
int k = 1;
for (int i = 0; i < fields.length; i++) {
if (clobs.containsKey(fields[i])) {
ps.setString(k++, (entity.getByName(fields[i])).toString());
}
}
result = ps.executeUpdate();
} catch (SQLException e) {
throw e;
} finally {
if (ps != null) ps.close();
this.release(conn);
}
return result;
}