public void executeTask() {
if (!PollingEngine.getInstance().getCurrentDate().equals(SysUtil.getCurrentDate())) // 过了一天
{
PollingEngine.getInstance().setCurrentDate(SysUtil.getCurrentDate());
List nodeList = PollingEngine.getInstance().getNodeList();
for (int i = 0; i < nodeList.size(); i++) {
Node node = (Host) nodeList.get(i);
node.setFailTimes(0); // failTimes和normalTimes用于计算今天的可用率
node.setNormalTimes(0);
}
PerformanceDao dao = new PerformanceDao();
try {
dao.deleteData();
} catch (Exception e) {
e.printStackTrace();
} finally {
dao.close();
}
}
}
private void ajaxUpdate_availability() {
double avgpingcon = 0;
DBVo vo = new DBVo();
DBDao dao = new DBDao();
String id = getParaValue("id");
request.setAttribute("id", id);
try {
vo = (DBVo) dao.findByID(id);
} catch (Exception e) {
} finally {
dao.close();
}
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String time1 = sdf.format(new Date());
String newip = SysUtil.doip(vo.getIpAddress());
String starttime1 = time1 + " 00:00:00";
String totime1 = time1 + " 23:59:59";
Hashtable ConnectUtilizationhash = new Hashtable();
I_HostCollectData hostmanager = new HostCollectDataManager();
try {
ConnectUtilizationhash =
hostmanager.getCategory(
vo.getId() + "", "INFORMIXPing", "ConnectUtilization", starttime1, totime1);
} catch (Exception ex) {
ex.printStackTrace();
}
String pingconavg = "";
if (ConnectUtilizationhash.get("avgpingcon") != null)
pingconavg = (String) ConnectUtilizationhash.get("avgpingcon");
if (pingconavg != null) {
pingconavg = pingconavg.replace("%", "");
}
avgpingcon = new Double(pingconavg + "").doubleValue();
int percent1 = Double.valueOf(avgpingcon).intValue();
int percent2 = 100 - percent1;
Map<String, Integer> map = new HashMap<String, Integer>();
map.put("percent1", percent1);
map.put("percent2", percent2);
// System.out.println("percent1:"+percent1);
// System.out.println("percent2:"+percent2);
JSONObject json = JSONObject.fromObject(map);
out.print(json);
out.flush();
}
/** 根据采集结果生成对应的sql放入到内存列表中 */
public void CreateResultTosql(Hashtable ipdata, String ip) {
if (ipdata.containsKey("ping")) {
// ping
String allipstr = SysUtil.doip(ip);
Vector pingVector = null;
Pingcollectdata pingdata = null;
// Hashtable pinghash = (Hashtable)ipdata.get("ping");
pingVector = (Vector) ipdata.get("ping");
// pinghash = null;
if (pingVector != null && pingVector.size() > 0) {
for (int i = 0; i < pingVector.size(); i++) {
pingdata = (Pingcollectdata) pingVector.elementAt(i);
if (pingdata.getRestype().equals("dynamic")) {
Calendar tempCal = (Calendar) pingdata.getCollecttime();
Date cc = tempCal.getTime();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time = sdf.format(cc);
String tablename = "ping" + allipstr;
String sql = "";
if ("mysql".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,restype,category,entity,subentity,unit,chname,bak,count,thevalue,collecttime) "
+ "values('"
+ ip
+ "','"
+ pingdata.getRestype()
+ "','"
+ pingdata.getCategory()
+ "','"
+ pingdata.getEntity()
+ "','"
+ pingdata.getSubentity()
+ "','"
+ pingdata.getUnit()
+ "','"
+ pingdata.getChname()
+ "','"
+ pingdata.getBak()
+ "',"
+ pingdata.getCount()
+ ",'"
+ pingdata.getThevalue()
+ "','"
+ time
+ "')";
} else if ("oracle".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,restype,category,entity,subentity,unit,chname,bak,count,thevalue,collecttime) "
+ "values('"
+ ip
+ "','"
+ pingdata.getRestype()
+ "','"
+ pingdata.getCategory()
+ "','"
+ pingdata.getEntity()
+ "','"
+ pingdata.getSubentity()
+ "','"
+ pingdata.getUnit()
+ "','"
+ pingdata.getChname()
+ "','"
+ pingdata.getBak()
+ "',"
+ pingdata.getCount()
+ ",'"
+ pingdata.getThevalue()
+ "',to_date('"
+ time
+ "','YYYY-MM-DD HH24:MI:SS'))";
}
// System.out.println(sql);
GathersqlListManager.Addsql(sql);
sql = null;
// tablename=null;
/// time=null;
// sdf=null;
// tempCal=null;
}
pingdata = null;
}
}
pingVector = null;
}
}
public synchronized boolean createHostData(Was5jdbc was5, String tablesub) {
if (was5 == null) return false;
try {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ip = was5.getIpaddress();
if (ip != null) {
String allipstr = SysUtil.doip(ip);
Calendar tempCal = (Calendar) was5.getRecordtime();
Date cc = tempCal.getTime();
String time = sdf.format(cc);
String tablename = "";
tablename = tablesub + allipstr;
String delsql = "delete from " + tablename;
conn.executeUpdate(delsql);
String sql = "";
if ("mysql".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,createCount,closeCount,poolSize,freePoolSize,waitingThreadCount,percentUsed,useTime,waitTime,allocateCount,prepStmtCacheDiscardCount,jdbcTime,faultCount,recordtime) "
+ "values('"
+ ip
+ "','"
+ was5.getCreateCount()
+ "','"
+ was5.getCloseCount()
+ "','"
+ was5.getPoolSize()
+ "','"
+ was5.getFreePoolSize()
+ "','"
+ was5.getWaitingThreadCount()
+ "','"
+ was5.getPercentUsed()
+ "','"
+ was5.getUseTime()
+ "','"
+ was5.getWaitTime()
+ "','"
+ was5.getAllocateCount()
+ "','"
+ was5.getPrepStmtCacheDiscardCount()
+ "','"
+ was5.getJdbcTime()
+ "','"
+ was5.getFaultCount()
+ "','"
+ time
+ "')";
} else if ("oracle".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,createCount,closeCount,poolSize,freePoolSize,waitingThreadCount,percentUsed,useTime,waitTime,allocateCount,prepStmtCacheDiscardCount,jdbcTime,faultCount,recordtime) "
+ "values('"
+ ip
+ "','"
+ was5.getCreateCount()
+ "','"
+ was5.getCloseCount()
+ "','"
+ was5.getPoolSize()
+ "','"
+ was5.getFreePoolSize()
+ "','"
+ was5.getWaitingThreadCount()
+ "','"
+ was5.getPercentUsed()
+ "','"
+ was5.getUseTime()
+ "','"
+ was5.getWaitTime()
+ "','"
+ was5.getAllocateCount()
+ "','"
+ was5.getPrepStmtCacheDiscardCount()
+ "','"
+ was5.getJdbcTime()
+ "','"
+ was5.getFaultCount()
+ "',to_date('"
+ time
+ "','YYYY-MM-DD HH24:MI:SS'))";
}
conn.executeUpdate(sql);
}
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
conn.close();
System.gc();
}
return true;
}
public synchronized boolean createHostData(Was5jvminfo was5, String tablesub) {
if (was5 == null) return false;
try {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ip = was5.getIpaddress();
if (ip != null) {
String allipstr = SysUtil.doip(ip);
Calendar tempCal = (Calendar) was5.getRecordtime();
Date cc = tempCal.getTime();
String time = sdf.format(cc);
String tablename = "";
tablename = tablesub + allipstr;
String delsql = "delete from " + tablename;
conn.executeUpdate(delsql);
String sql = "";
if ("mysql".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,heapSize,freeMemory,usedMemory,upTime,memPer,recordtime) "
+ "values('"
+ ip
+ "','"
+ was5.getHeapSize()
+ "','"
+ was5.getFreeMemory()
+ "','"
+ was5.getUsedMemory()
+ "','"
+ was5.getUpTime()
+ "','"
+ was5.getMemPer()
+ "','"
+ time
+ "')";
} else if ("oracle".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,heapSize,freeMemory,usedMemory,upTime,memPer,recordtime) "
+ "values('"
+ ip
+ "','"
+ was5.getHeapSize()
+ "','"
+ was5.getFreeMemory()
+ "','"
+ was5.getUsedMemory()
+ "','"
+ was5.getUpTime()
+ "','"
+ was5.getMemPer()
+ "',to_date('"
+ time
+ "','YYYY-MM-DD HH24:MI:SS'))";
}
conn.executeUpdate(sql);
}
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
conn.close();
System.gc();
}
return true;
}
public synchronized boolean createHostData(Was5trans was5, String tablesub) {
if (was5 == null) return false;
try {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ip = was5.getIpaddress();
if (ip != null) {
String allipstr = SysUtil.doip(ip);
Calendar tempCal = (Calendar) was5.getRecordtime();
Date cc = tempCal.getTime();
String time = sdf.format(cc);
String tablename = "";
tablename = tablesub + allipstr;
String delsql = "delete from " + tablename;
conn.executeUpdate(delsql);
String sql = "";
if ("mysql".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,activeCount,committedCount,rolledbackCount,globalTranTime,globalBegunCount,localBegunCount,localActiveCount,localTranTime,localTimeoutCount,localRolledbackCount,globalTimeoutCount,recordtime) "
+ "values('"
+ ip
+ "','"
+ was5.getActiveCount()
+ "','"
+ was5.getCommittedCount()
+ "','"
+ was5.getRolledbackCount()
+ "','"
+ was5.getGlobalTranTime()
+ "','"
+ was5.getGlobalBegunCount()
+ "','"
+ was5.getLocalBegunCount()
+ "','"
+ was5.getLocalActiveCount()
+ "','"
+ was5.getLocalTranTime()
+ "','"
+ was5.getLocalTimeoutCount()
+ "','"
+ was5.getLocalRolledbackCount()
+ "','"
+ was5.getGlobalTimeoutCount()
+ "','"
+ time
+ "')";
} else if ("oracle".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,activeCount,committedCount,rolledbackCount,globalTranTime,globalBegunCount,localBegunCount,localActiveCount,localTranTime,localTimeoutCount,localRolledbackCount,globalTimeoutCount,recordtime) "
+ "values('"
+ ip
+ "','"
+ was5.getActiveCount()
+ "','"
+ was5.getCommittedCount()
+ "','"
+ was5.getRolledbackCount()
+ "','"
+ was5.getGlobalTranTime()
+ "','"
+ was5.getGlobalBegunCount()
+ "','"
+ was5.getLocalBegunCount()
+ "','"
+ was5.getLocalActiveCount()
+ "','"
+ was5.getLocalTranTime()
+ "','"
+ was5.getLocalTimeoutCount()
+ "','"
+ was5.getLocalRolledbackCount()
+ "','"
+ was5.getGlobalTimeoutCount()
+ "','"
+ time
+ "')";
}
conn.executeUpdate(sql);
}
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
conn.close();
System.gc();
}
return true;
}
// 处理Ping得到的数据，放到历史表里
public synchronized boolean createHostData(Interfacecollectdata pingdata, String tablesub) {
if (pingdata == null) return false;
try {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ip = pingdata.getIpaddress();
if (pingdata.getRestype().equals("dynamic")) {
String allipstr = SysUtil.doip(ip);
Calendar tempCal = (Calendar) pingdata.getCollecttime();
Date cc = tempCal.getTime();
String time = sdf.format(cc);
String tablename = "";
tablename = tablesub + allipstr;
String sql = "";
if ("mysql".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,restype,category,entity,subentity,unit,chname,bak,count,thevalue,collecttime) "
+ "values('"
+ ip
+ "','"
+ pingdata.getRestype()
+ "','"
+ pingdata.getCategory()
+ "','"
+ pingdata.getEntity()
+ "','"
+ pingdata.getSubentity()
+ "','"
+ pingdata.getUnit()
+ "','"
+ pingdata.getChname()
+ "','"
+ pingdata.getBak()
+ "',"
+ pingdata.getCount()
+ ",'"
+ pingdata.getThevalue()
+ "','"
+ time
+ "')";
} else if ("oracle".equalsIgnoreCase(SystemConstant.DBType)) {
sql =
"insert into "
+ tablename
+ "(ipaddress,restype,category,entity,subentity,unit,chname,bak,count,thevalue,collecttime) "
+ "values('"
+ ip
+ "','"
+ pingdata.getRestype()
+ "','"
+ pingdata.getCategory()
+ "','"
+ pingdata.getEntity()
+ "','"
+ pingdata.getSubentity()
+ "','"
+ pingdata.getUnit()
+ "','"
+ pingdata.getChname()
+ "','"
+ pingdata.getBak()
+ "',"
+ pingdata.getCount()
+ ",'"
+ pingdata.getThevalue()
+ "',to_date('"
+ time
+ "','YYYY-MM-DD HH24:MI:SS'))";
}
conn.executeUpdate(sql);
}
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
conn.close();
System.gc();
}
return true;
}
public boolean delete(String id) {
boolean result = false;
try {
WasConfig pvo = (WasConfig) findByID(id + "");
String ipstr = pvo.getIpaddress();
String allipstr = SysUtil.doip(ipstr);
CreateTableManager ctable = new CreateTableManager();
ctable.deleteTable("wasping", allipstr, "wasping"); // Ping
ctable.deleteTable("waspinghour", allipstr, "waspinghour"); // Ping
ctable.deleteTable("waspingday", allipstr, "waspingday"); // Ping
// 自服务器启动以来的CPU平均使用率
ctable.deleteTable("wasrcpu", allipstr, "wasrcpu"); // Ping
ctable.deleteTable("wasrcpuhour", allipstr, "wasrcpuhour"); // Ping
ctable.deleteTable("wasrcpuday", allipstr, "wasrcpuday"); // Ping
// 自上次查询以来的平均CPU使用率
ctable.deleteTable("wasscpu", allipstr, "wasscpu"); // Ping
ctable.deleteTable("wasscpuhour", allipstr, "wasscpuhour"); // Ping
ctable.deleteTable("wasscpuday", allipstr, "wasscpuday"); // Ping
// 缓存命中率
ctable.deleteTable("wasrate", allipstr, "wasrate"); // Ping
ctable.deleteTable("wasratehour", allipstr, "wasratehour"); // Ping
ctable.deleteTable("wasrateday", allipstr, "wasrateday"); // Ping
// JVM内存利用率
ctable.deleteTable("wasjvm", allipstr, "wasjvm");
ctable.deleteTable("wasjvmhour", allipstr, "wasjvmhour");
ctable.deleteTable("wasjvmday", allipstr, "wasjvmday");
// 性能表
ctable.deleteTable("wassystem", allipstr, "wassystem");
ctable.deleteTable("wassystemhour", allipstr, "wassystemhour");
ctable.deleteTable("wassystemday", allipstr, "wassystemday");
ctable.deleteTable("wasjdbc", allipstr, "wasjdbc");
ctable.deleteTable("wasjdbchour", allipstr, "wasjdbchour");
ctable.deleteTable("wasjdbcday", allipstr, "wasjdbcday");
ctable.deleteTable("wassession", allipstr, "wassession");
ctable.deleteTable("wassessionh", allipstr, "wassessionh"); // wassessionhour
// 必须保留session字段
ctable.deleteTable("wassessiond", allipstr, "wassessiond"); // wassessionday
ctable.deleteTable("wasjvminfo", allipstr, "wasjvminfo");
ctable.deleteTable("wasjvminfoh", allipstr, "wasjvmhour"); // wasjvminfohour
// 必须保留jvminfo字段
ctable.deleteTable("wasjvminfod", allipstr, "wasjvmday"); // wasjvminfoday
ctable.deleteTable("wascache", allipstr, "wascache");
ctable.deleteTable("wascachehour", allipstr, "wascachehour");
ctable.deleteTable("wascacheday", allipstr, "wascacheday");
ctable.deleteTable("wasthread", allipstr, "wasthread");
ctable.deleteTable("wasthreadhour", allipstr, "wasthreadhour");
ctable.deleteTable("wasthreadday", allipstr, "wasthreadday");
ctable.deleteTable("wastrans", allipstr, "wastrans");
ctable.deleteTable("wastranshour", allipstr, "wastranshour");
ctable.deleteTable("wastransday", allipstr, "wastransday");
conn.addBatch("delete from nms_wasconfig where id=" + id);
conn.executeBatch();
result = true;
try {
// 同时删除事件表里的相关数据
EventListDao eventdao = new EventListDao();
eventdao.delete(Integer.parseInt(id), "wasserver");
} catch (Exception e) {
e.printStackTrace();
}
} catch (Exception e) {
e.printStackTrace();
} finally {
conn.close();
}
return result;
}
public boolean update(BaseVo vo) {
boolean flag = true;
WasConfig vo1 = (WasConfig) vo;
WasConfig pvo = (WasConfig) findByID(vo1.getId() + "");
StringBuffer sql = new StringBuffer();
sql.append("update nms_wasconfig set name='");
sql.append(vo1.getName());
sql.append("',ipaddress='");
sql.append(vo1.getIpaddress());
sql.append("',portnum='");
sql.append(vo1.getPortnum());
sql.append("',nodename='");
sql.append(vo1.getNodename());
sql.append("',servername='");
sql.append(vo1.getServername());
sql.append("',sendmobiles='");
sql.append(vo1.getSendmobiles());
sql.append("',mon_flag='");
sql.append(vo1.getMon_flag());
sql.append("',netid='");
sql.append(vo1.getNetid());
sql.append("',sendemail='");
sql.append(vo1.getSendemail());
sql.append("',supperid='");
sql.append(vo1.getSupperid());
sql.append("',version='");
sql.append(vo1.getVersion());
sql.append("' where id=" + vo1.getId());
try {
conn = new DBManager();
saveOrUpdate(sql.toString());
if (!vo1.getIpaddress().equals(pvo.getIpaddress())) {
String ipstr = pvo.getIpaddress();
String allipstr = SysUtil.doip(ipstr);
CreateTableManager ctable = new CreateTableManager();
// conn = new DBManager();
ctable.deleteTable("wasping", allipstr, "wasping"); // Ping
ctable.deleteTable("waspinghour", allipstr, "waspinghour"); // Ping
ctable.deleteTable("waspingday", allipstr, "waspingday"); // Ping
// 自服务器启动以来的CPU平均使用率
ctable.deleteTable("wasrcpu", allipstr, "wasrcpu"); // Ping
ctable.deleteTable("wasrcpuhour", allipstr, "wasrcpuhour"); // Ping
ctable.deleteTable("wasrcpuday", allipstr, "wasrcpuday"); // Ping
// 自上次查询以来的平均CPU使用率
ctable.deleteTable("wasscpu", allipstr, "wasscpu"); // Ping
ctable.deleteTable("wasscpuhour", allipstr, "wasscpuhour"); // Ping
ctable.deleteTable("wasscpuday", allipstr, "wasscpuday"); // Ping
// 缓存命中率
ctable.deleteTable("wasrate", allipstr, "wasrate"); // Ping
ctable.deleteTable("wasratehour", allipstr, "wasratehour"); // Ping
ctable.deleteTable("wasrateday", allipstr, "wasrateday"); // Ping
// JVM内存利用率
ctable.deleteTable("wasjvm", allipstr, "wasjvm");
ctable.deleteTable("wasjvmhour", allipstr, "wasjvmhour");
ctable.deleteTable("wasjvmday", allipstr, "wasjvmday");
// 性能表
ctable.deleteTable("wassystem", allipstr, "wassystem");
ctable.deleteTable("wassystemhour", allipstr, "wassystemhour");
ctable.deleteTable("wassystemday", allipstr, "wassystemday");
ctable.deleteTable("wasjdbc", allipstr, "wasjdbc");
ctable.deleteTable("wasjdbchour", allipstr, "wasjdbchour");
ctable.deleteTable("wasjdbcday", allipstr, "wasjdbcday");
ctable.deleteTable("wassession", allipstr, "wassession");
ctable.deleteTable("wassessionh", allipstr, "wassessionh"); // wassessionhour
// 必须保留session字段
ctable.deleteTable("wassessiond", allipstr, "wassessiond");
ctable.deleteTable("wasjvminfo", allipstr, "wasjvminfo");
ctable.deleteTable("wasjvminfoh", allipstr, "wasjvminfoh"); // wasjvminfohour
// 必须保留jvminfo字段，详情见函数内部
ctable.deleteTable("wasjvminfod", allipstr, "wasjvminfod"); // wasjvminfoday
ctable.deleteTable("wascache", allipstr, "wascache");
ctable.deleteTable("wascachehour", allipstr, "wascachehour");
ctable.deleteTable("wascacheday", allipstr, "wascacheday");
ctable.deleteTable("wasthread", allipstr, "wasthread");
ctable.deleteTable("wasthreadhour", allipstr, "wasthreadhour");
ctable.deleteTable("wasthreadday", allipstr, "wasthreadday");
ctable.deleteTable("wastrans", allipstr, "wastrans");
ctable.deleteTable("wastranshour", allipstr, "wastranshour");
ctable.deleteTable("wastransday", allipstr, "wastransday");
try {
// 同时删除事件表里的相关数据
EventListDao eventdao = new EventListDao();
eventdao.delete(vo1.getId(), "wasserver");
} catch (Exception e) {
e.printStackTrace();
}
// 测试生成表
String ip = vo1.getIpaddress();
allipstr = SysUtil.doip(ip);
ctable = new CreateTableManager();
// 可用性
ctable.createTable("wasping", allipstr, "wasping"); // Ping
ctable.createTable("waspinghour", allipstr, "waspinghour"); // Ping
ctable.createTable("waspingday", allipstr, "waspingday"); // Ping
// 自服务器启动以来的CPU平均使用率
ctable.createTable("wasrcpu", allipstr, "wasrcpu"); // Ping
ctable.createTable("wasrcpuhour", allipstr, "wasrcpuhour"); // Ping
ctable.createTable("wasrcpuday", allipstr, "wasrcpuday"); // Ping
// 自上次查询以来的平均CPU使用率
ctable.createTable("wasscpu", allipstr, "wasscpu"); // Ping
ctable.createTable("wasscpuhour", allipstr, "wasscpuhour"); // Ping
ctable.createTable("wasscpuday", allipstr, "wasscpuday"); // Ping
// 缓存命中率
ctable.createTable("wasrate", allipstr, "wasrate"); // Ping
ctable.createTable("wasratehour", allipstr, "wasratehour"); // Ping
ctable.createTable("wasrateday", allipstr, "wasrateday"); // Ping
// JVM内存利用率
ctable.createTable("wasjvm", allipstr, "wasjvm");
ctable.createTable("wasjvmhour", allipstr, "wasjvmhour");
ctable.createTable("wasjvmday", allipstr, "wasjvmday");
// 建立性能表
ctable.createWasTable(conn, "wassystem", allipstr);
ctable.createWasTable(conn, "wassystemhour", allipstr);
ctable.createWasTable(conn, "wassystemday", allipstr);
ctable.createWasTable(conn, "wasjdbc", allipstr);
ctable.createWasTable(conn, "wasjdbchour", allipstr);
ctable.createWasTable(conn, "wasjdbcday", allipstr);
ctable.createWasTable(conn, "wassession", allipstr);
ctable.createWasTable(conn, "wassessionh", allipstr); // wassessionhour
ctable.createWasTable(conn, "wassessiond", allipstr);
ctable.createWasTable(conn, "wasjvminfo", allipstr);
ctable.createWasTable(conn, "wasjvminfoh", allipstr); // wasjvminfohour
ctable.createWasTable(conn, "wasjvminfod", allipstr); // wasjvminfoday
ctable.createWasTable(conn, "wascache", allipstr);
ctable.createWasTable(conn, "wascachehour", allipstr);
ctable.createWasTable(conn, "wascacheday", allipstr);
ctable.createWasTable(conn, "wasthread", allipstr);
ctable.createWasTable(conn, "wasthreadhour", allipstr);
ctable.createWasTable(conn, "wasthreadday", allipstr);
ctable.createWasTable(conn, "wastrans", allipstr);
ctable.createWasTable(conn, "wastranshour", allipstr);
ctable.createWasTable(conn, "wastransday", allipstr);
}
} catch (Exception e) {
flag = false;
e.printStackTrace();
} finally {
conn.close();
}
return flag;
}
public boolean save(BaseVo vo) {
boolean flag = true;
WasConfig vo1 = (WasConfig) vo;
StringBuffer sql = new StringBuffer();
sql.append(
"insert into nms_wasconfig(id,name,ipaddress,nodename,servername,portnum,sendmobiles,mon_flag,netid,sendemail,supperid,version) values(");
sql.append(vo1.getId());
sql.append(",'");
sql.append(vo1.getName());
sql.append("','");
sql.append(vo1.getIpaddress());
sql.append("','");
sql.append(vo1.getNodename());
sql.append("','");
sql.append(vo1.getServername());
sql.append("','");
sql.append(vo1.getPortnum());
sql.append("','");
sql.append(vo1.getSendmobiles());
sql.append("','");
sql.append(vo1.getMon_flag());
sql.append("','");
sql.append(vo1.getNetid());
sql.append("','");
sql.append(vo1.getSendemail());
sql.append("','");
sql.append(vo1.getSupperid());
sql.append("','");
sql.append(vo1.getVersion());
sql.append("')");
try {
saveOrUpdate(sql.toString());
CreateTableManager ctable = new CreateTableManager();
String ip = vo1.getIpaddress();
String allipstr = SysUtil.doip(ip);
// 可用性
ctable.createTable("wasping", allipstr, "wasping"); // Ping
ctable.createTable("waspinghour", allipstr, "waspinghour"); // Ping
ctable.createTable("waspingday", allipstr, "waspingday"); // Ping
// 自服务器启动以来的CPU平均使用率
ctable.createTable("wasrcpu", allipstr, "wasrcpu"); // Ping
ctable.createTable("wasrcpuhour", allipstr, "wasrcpuhour"); // Ping
ctable.createTable("wasrcpuday", allipstr, "wasrcpuday"); // Ping
// 自上次查询以来的平均CPU使用率
ctable.createTable("wasscpu", allipstr, "wasscpu"); // Ping
ctable.createTable("wasscpuhour", allipstr, "wasscpuhour"); // Ping
ctable.createTable("wasscpuday", allipstr, "wasscpuday"); // Ping
// 缓存命中率
ctable.createTable("wasrate", allipstr, "wasrate"); // Ping
ctable.createTable("wasratehour", allipstr, "wasratehour"); // Ping
ctable.createTable("wasrateday", allipstr, "wasrateday"); // Ping
// JVM内存利用率
ctable.createTable("wasjvm", allipstr, "wasjvm");
ctable.createTable("wasjvmhour", allipstr, "wasjvmhour");
ctable.createTable("wasjvmday", allipstr, "wasjvmday");
// 建立性能表
ctable.createWasTable(conn, "wassystem", allipstr);
ctable.createWasTable(conn, "wassystemhour", allipstr);
ctable.createWasTable(conn, "wassystemday", allipstr);
ctable.createWasTable(conn, "wasjdbc", allipstr);
ctable.createWasTable(conn, "wasjdbchour", allipstr);
ctable.createWasTable(conn, "wasjdbcday", allipstr);
ctable.createWasTable(conn, "wassession", allipstr);
ctable.createWasTable(conn, "wassessionh", allipstr); // wassessionhour
// 必须保留session字段
ctable.createWasTable(conn, "wassessiond", allipstr); // wassessionday
ctable.createWasTable(conn, "wasjvminfo", allipstr);
ctable.createWasTable(conn, "wasjvminfoh", allipstr); // wasjvminfohour
ctable.createWasTable(conn, "wasjvminfod", allipstr);
ctable.createWasTable(conn, "wascache", allipstr);
ctable.createWasTable(conn, "wascachehour", allipstr);
ctable.createWasTable(conn, "wascacheday", allipstr);
ctable.createWasTable(conn, "wasthread", allipstr);
ctable.createWasTable(conn, "wasthreadhour", allipstr);
ctable.createWasTable(conn, "wasthreadday", allipstr);
ctable.createWasTable(conn, "wastrans", allipstr);
ctable.createWasTable(conn, "wastranshour", allipstr);
ctable.createWasTable(conn, "wastransday", allipstr);
} catch (Exception e) {
e.printStackTrace();
flag = false;
} finally {
try {
conn.executeBatch();
} catch (Exception e) {
e.printStackTrace();
}
conn.close();
}
return flag;
}
