示例#1
0
  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;
    }
  }
示例#4
0
  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;
  }
示例#5
0
  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;
  }
示例#6
0
  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;
  }
示例#7
0
  // 处理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;
  }
示例#8
0
  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;
  }
示例#9
0
  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;
  }
示例#10
0
  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;
  }