public int update(ValueObject obj) throws SQLException { if ((obj instanceof PT_BBS_COM_FILESEntity) == false) { throw new SQLException("DAO 에러(1): PT_BBS_COM_FILES : update() "); } PT_BBS_COM_FILESEntity entity = (PT_BBS_COM_FILESEntity) obj; Connection conn = null; PreparedStatement ps = null; int result = 0; StringBuffer sb = new StringBuffer(); sb.append("update PT_BBS_COM_FILES set ") .append("CT_ID = ") .append(toDB(entity.getCT_ID())) .append(",") .append("BOARD_SEQ = ") .append(toDB(entity.getBOARD_SEQ())) .append(",") .append("FILE_REAL_NAME = ") .append(toDB(entity.getFILE_REAL_NAME())) .append(",") .append("FILE_SIZE = ") .append(toDB(entity.getFILE_SIZE())) .append(",") .append("UPD_DT = ") .append(toDB(entity.getUPD_DT())) .append(",") .append("DOWN_HIT = ") .append(toDB(entity.getDOWN_HIT())) .append(" where 1=1 "); sb.append(" and SYS_FILE_NAME = ").append(toDB(entity.getSYS_FILE_NAME())); KJFLog.sql(sb.toString()); try { conn = this.getConnection(); ps = conn.prepareStatement(sb.toString()); int i = 1; result = ps.executeUpdate(); } catch (SQLException e) { throw e; } finally { if (ps != null) ps.close(); this.release(conn); } return result; }