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 void collect_data(String id, Hashtable gatherHash) {
Hashtable data_ht = new Hashtable();
String jvm_utilization = "0";
try {
ServerStream serverstream = new ServerStream();
Hashtable returnVal = new Hashtable();
String ipaddress = "";
Tomcat node = new Tomcat();
TomcatDao dao = new TomcatDao();
try {
node = (Tomcat) dao.findByID(id);
} catch (Exception e) {
} finally {
dao.close();
}
try {
com.afunms.polling.node.Tomcat tc = new com.afunms.polling.node.Tomcat();
BeanUtils.copyProperties(tc, node);
ipaddress = tc.getIpAddress();
com.afunms.polling.node.Tomcat tnode =
(com.afunms.polling.node.Tomcat) PollingEngine.getInstance().getTomcatByIP(ipaddress);
Calendar date = Calendar.getInstance();
Date cc = date.getTime();
String tempsenddate = sdf.format(cc);
// 初始化Tomcat服务的状态
tnode.setLastTime(tempsenddate);
tnode.setAlarm(false);
tnode.getAlarmMessage().clear();
tnode.setStatus(0);
StringBuffer tmp = new StringBuffer();
tmp.append(tc.getIpAddress());
tmp.append(",");
tmp.append(tc.getPort());
tmp.append(",");
tmp.append(tc.getUser());
tmp.append(" , ");
tmp.append(tc.getPassword());
returnVal.put(String.valueOf(0), tmp.toString());
} catch (Exception e) {
e.printStackTrace();
}
String liststr = serverstream.validServer(returnVal);
if ("".equals(liststr)) {
try {
com.afunms.polling.node.Tomcat tc = new com.afunms.polling.node.Tomcat();
BeanUtils.copyProperties(tc, node);
// if (data_ht==null){
// 需要增加邮件服务所在的服务器是否能连通
Host host = (Host) PollingEngine.getInstance().getNodeByIP(node.getIpAddress());
Vector ipPingData = (Vector) ShareData.getPingdata().get(node.getIpAddress());
if (ipPingData != null) {
Pingcollectdata pingdata = (Pingcollectdata) ipPingData.get(0);
Calendar tempCal = (Calendar) pingdata.getCollecttime();
Date cc = tempCal.getTime();
String _time = sdf.format(cc);
String lastTime = _time;
String pingvalue = pingdata.getThevalue();
if (pingvalue == null || pingvalue.trim().length() == 0) pingvalue = "0";
double pvalue = new Double(pingvalue);
if (pvalue == 0) {
// 主机服务器连接不上***********************************************
com.afunms.polling.node.Tomcat tnode =
(com.afunms.polling.node.Tomcat)
PollingEngine.getInstance().getTomcatByIP(ipaddress);
tnode.setAlarm(true);
tnode.setStatus(1);
List alarmList = tnode.getAlarmMessage();
if (alarmList == null) alarmList = new ArrayList();
tnode.getAlarmMessage().add("TOMCAT服务停止");
String sysLocation = "";
try {
SmscontentDao eventdao = new SmscontentDao();
String eventdesc =
"TOMCAT服务("
+ tnode.getAlias()
+ " IP:"
+ tnode.getAdminIp()
+ ")"
+ "的TOMCAT服务停止";
eventdao.createEventWithReasion(
"poll",
tnode.getId() + "",
tnode.getAdminIp() + "(" + tnode.getAdminIp() + ")",
eventdesc,
3,
"tomcat",
"ping",
"所在的服务器连接不上");
} catch (Exception e) {
e.printStackTrace();
}
} else {
com.afunms.polling.node.Tomcat tnode =
(com.afunms.polling.node.Tomcat)
PollingEngine.getInstance().getTomcatByIP(ipaddress);
tnode.setAlarm(true);
tnode.setStatus(3);
List alarmList = tnode.getAlarmMessage();
if (alarmList == null) alarmList = new ArrayList();
tnode.getAlarmMessage().add("TOMCAT服务停止");
Pingcollectdata hostdata = null;
hostdata = new Pingcollectdata();
hostdata.setIpaddress(ipaddress);
Calendar date = Calendar.getInstance();
hostdata.setCollecttime(date);
hostdata.setCategory("TomcatPing");
hostdata.setEntity("Utilization");
hostdata.setSubentity("ConnectUtilization");
hostdata.setRestype("dynamic");
hostdata.setUnit("%");
hostdata.setThevalue("0");
TomcatDao tomcatdao = new TomcatDao();
try {
tomcatdao.createHostData(hostdata);
} catch (Exception e) {
e.printStackTrace();
} finally {
tomcatdao.close();
}
}
} else {
com.afunms.polling.node.Tomcat tnode =
(com.afunms.polling.node.Tomcat)
PollingEngine.getInstance().getTomcatByIP(ipaddress);
tnode.setAlarm(true);
tnode.setStatus(3);
List alarmList = tnode.getAlarmMessage();
if (alarmList == null) alarmList = new ArrayList();
tnode.getAlarmMessage().add("TOMCAT服务停止");
Pingcollectdata hostdata = null;
hostdata = new Pingcollectdata();
hostdata.setIpaddress(ipaddress);
Calendar date = Calendar.getInstance();
hostdata.setCollecttime(date);
hostdata.setCategory("TomcatPing");
hostdata.setEntity("Utilization");
hostdata.setSubentity("ConnectUtilization");
hostdata.setRestype("dynamic");
hostdata.setUnit("%");
hostdata.setThevalue("0");
TomcatDao tomcatdao = new TomcatDao();
try {
tomcatdao.createHostData(hostdata);
} catch (Exception e) {
e.printStackTrace();
} finally {
tomcatdao.close();
}
}
// }
createSMS("tomcat", tc);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} else {
Pingcollectdata hostdata = null;
hostdata = new Pingcollectdata();
hostdata.setIpaddress(ipaddress);
Calendar date = Calendar.getInstance();
hostdata.setCollecttime(date);
hostdata.setCategory("TomcatPing");
hostdata.setEntity("Utilization");
hostdata.setSubentity("ConnectUtilization");
hostdata.setRestype("dynamic");
hostdata.setUnit("%");
hostdata.setThevalue("100");
TomcatDao tomcatdao = new TomcatDao();
try {
tomcatdao.createHostData(hostdata);
} catch (Exception e) {
e.printStackTrace();
} finally {
tomcatdao.close();
}
}
String[] pos_s = liststr.split(",");
for (int list_i = 0; list_i < pos_s.length - 1; list_i++) {
String tmps = returnVal.get(pos_s[list_i]).toString();
String[] serverinfo = tmps.split(",");
serverstream.foundData(serverinfo[0], serverinfo[1], serverinfo[2], serverinfo[3]);
data_ht = serverstream.data_ht;
TomcatDao tomcatdao = new TomcatDao();
Hashtable sendeddata = ShareData.getSendeddata();
try {
Calendar time = Calendar.getInstance();
String lasttime = data_ht.get("mon_time").toString();
String nexttime = data_ht.get("nexttime").toString();
String server = data_ht.get("server").toString();
String jvm = data_ht.get("jvm").toString();
String ip = data_ht.get("ip").toString();
String port = data_ht.get("port").toString();
String portsum1 = data_ht.get("portsum1").toString();
String portsum2 = data_ht.get("portsum2").toString();
String portdetail1 = data_ht.get("portdetail1").toString();
String portdetail2 = data_ht.get("portdetail2").toString();
if (data_ht != null) {
int jvm_memoryuiltillize = 0;
String[] temjvm = jvm.split(",");
double freememory = Double.parseDouble(temjvm[0].trim());
double totalmemory = (double) Double.parseDouble(temjvm[1].trim());
double maxmemory = (double) Double.parseDouble(temjvm[2].trim());
jvm_memoryuiltillize = (int) Math.rint((totalmemory - freememory) * 100 / totalmemory);
jvm_utilization = String.valueOf(jvm_memoryuiltillize);
Pingcollectdata hostdata = null;
hostdata = new Pingcollectdata();
hostdata.setIpaddress(ip);
Calendar date = Calendar.getInstance();
hostdata.setCollecttime(date);
hostdata.setCategory("tomcat_jvm");
hostdata.setEntity("Utilization");
hostdata.setSubentity("jvm_utilization");
hostdata.setRestype("dynamic");
hostdata.setUnit("%");
hostdata.setThevalue(jvm_utilization);
try {
tomcatdao.createHostData(hostdata);
if (sendeddata.containsKey("tomcat" + ":" + ip))
sendeddata.remove("tomcat" + ":" + ip);
} catch (Exception e) {
e.printStackTrace();
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
tomcatdao.close();
}
}
try {
data_ht.put("jvm_utilization", jvm_utilization);
ShareData.setTomcatdata(node.getIpAddress(), data_ht);
} catch (Exception ex) {
ex.printStackTrace();
}
data_ht = null;
} catch (Exception e) {
e.printStackTrace();
} finally {
}
}
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());
}