public boolean update(BaseVo baseVo) {
Oraspaceconfig vo = (Oraspaceconfig) baseVo;
boolean result = false;
StringBuffer sql = new StringBuffer();
sql.append("update system_oraspaceconf set ipaddress='");
sql.append(vo.getIpaddress());
sql.append("',spacename='");
sql.append(vo.getSpacename());
sql.append("',linkuse='");
sql.append(vo.getLinkuse());
sql.append("',sms=");
sql.append(vo.getSms());
sql.append(",bak='");
sql.append(vo.getBak());
sql.append("',reportflag=");
sql.append(vo.getReportflag());
sql.append(",alarmvalue=");
sql.append(vo.getAlarmvalue());
sql.append(" where id=");
sql.append(vo.getId());
try {
conn.executeUpdate(sql.toString());
result = true;
} catch (Exception e) {
result = false;
SysLogger.error("OraspaceconfigDao:update()", e);
} finally {
conn.close();
}
return result;
}
public boolean save(BaseVo baseVo) {
Oraspaceconfig vo = (Oraspaceconfig) baseVo;
StringBuffer sql = new StringBuffer(100);
sql.append(
"insert into system_oraspaceconf(ipaddress,spacename,linkuse,sms,bak,reportflag,alarmvalue)values(");
sql.append("'");
sql.append(vo.getIpaddress());
sql.append("','");
sql.append(vo.getSpacename());
sql.append("','");
sql.append(vo.getLinkuse());
sql.append("',");
sql.append(vo.getSms());
sql.append(",'");
sql.append(vo.getBak());
sql.append("',");
sql.append(vo.getReportflag());
sql.append(",");
sql.append(vo.getAlarmvalue());
sql.append(")");
return saveOrUpdate(sql.toString());
}