Пример #1
1
  /** 获取指定CPU ID的CPU利用率列表 */
  public List<CPUPerc> getPercsById(long id) {
    String sql = "select * from t_cpu_prec where prec_cpuid=?";
    List<CPUPerc> list = new ArrayList<CPUPerc>(20);
    try {
      super.doStart();
      pstmt = super.conn.prepareStatement(sql);
      pstmt.setLong(1, id);
      rs = pstmt.executeQuery();
      while (rs.next()) {
        CPUPerc cp = new CPUPerc(rs.getLong("prec_timestamp"));
        cp.setIdle(rs.getDouble("prec_idle"));
        cp.setNice(rs.getDouble("prec_nice"));
        cp.setSys(rs.getDouble("prec_sys"));
        cp.setUser(rs.getDouble("prec_user"));
        cp.setWait(rs.getDouble("prec_wait"));
        cp.setCombined(rs.getDouble("prec_combined"));
        cp.setTimestamp(rs.getLong("prec_timestamp"));

        list.add(cp);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DButil.getInstance().close(pstmt, rs);
    }
    return list;
  }
Пример #2
0
  /** 获取指定设备ID的CPU列表 */
  public List<CPU> getCPUsById(long id) {
    String sql = "select * from t_cpu where cpu_eqptid =?";
    List<CPU> list = new ArrayList<CPU>(3);
    try {
      super.doStart();
      pstmt = super.conn.prepareStatement(sql);
      pstmt.setLong(1, id);
      rs = pstmt.executeQuery();
      while (rs.next()) {
        CPU cpu = new CPU(rs.getLong("cpu_id"));
        cpu.setTotalCores(rs.getInt("cpu_totalCores"));
        cpu.setMhz(rs.getInt("cpu_mhz"));
        cpu.setCacheSize(rs.getLong("cpu_cacheSize"));
        cpu.setModel(rs.getString("cpu_model"));
        cpu.setVendor(rs.getString("cpu_vendor"));

        list.add(cpu);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DButil.getInstance().close(pstmt, rs);
    }

    return list;
  }
Пример #3
0
 /** 获取指定CPU ID和时间戳的CPU利用率 */
 public CPUPerc getCPUPercById(long id, long timestamp) {
   String sql = "select * from t_cpu_prec where prec_cpuid=? and prec_timestamp=?";
   CPUPerc cp = null;
   try {
     super.doStart();
     pstmt = super.conn.prepareStatement(sql);
     pstmt.setLong(1, id);
     pstmt.setLong(2, timestamp);
     rs = pstmt.executeQuery();
     while (rs.next()) {
       cp = new CPUPerc(rs.getLong("prec_timestamp"));
       cp.setIdle(rs.getDouble("prec_idle"));
       cp.setNice(rs.getDouble("prec_nice"));
       cp.setSys(rs.getDouble("prec_sys"));
       cp.setUser(rs.getDouble("prec_user"));
       cp.setWait(rs.getDouble("prec_wait"));
       cp.setCombined(rs.getDouble("prec_combined"));
       cp.setTimestamp(rs.getLong("prec_timestamp"));
     }
   } catch (Exception e) {
     e.printStackTrace();
   } finally {
     DButil.getInstance().close(pstmt, rs);
   }
   return cp;
 }
Пример #4
0
 /** 更新指定CPU ID的CPU利用率 */
 public void addCPUPrecsById(long cpuid, double percent, long timestamp) {
   String sql = "insert into t_cpu_prec (prec_cpuid,prec_combined,prec_timestamp)values (?,?,?)";
   try {
     super.doStart();
     pstmt = super.conn.prepareStatement(sql);
     pstmt.setLong(1, cpuid);
     pstmt.setDouble(2, percent);
     pstmt.setLong(3, timestamp);
     pstmt.executeUpdate();
   } catch (Exception e) {
     e.printStackTrace();
   } finally {
     DButil.getInstance().close(pstmt, null);
   }
 }
Пример #5
0
  /** 存储主机CPU的配置信息 */
  public void saveHostCPUInfo(
      long hcpu_mosn,
      String hcpu_name,
      String hcpu_type,
      String hcpu_catch,
      String hcpu_sign,
      double hcpu_mhz,
      String hcpu_model,
      String hcpu_vender,
      long hcpu_eqptmosn) {

    String sql =
        "insert into t_hostcpu (hcpu_mosn,hcpu_name,hcpu_type,hcpu_catch,hcpu_sign,hcpu_mhz,hcpu_model,hcpu_vender,hcpu_eqptmosn) values  (?,?,?,?,?,?,?,?,?)";

    try {
      super.doStart();
      pstmt = super.conn.prepareStatement(sql);
      pstmt.setLong(1, hcpu_mosn);
      pstmt.setString(2, hcpu_name);
      pstmt.setString(3, hcpu_type);
      pstmt.setString(4, hcpu_catch);
      pstmt.setString(5, hcpu_sign);
      pstmt.setDouble(6, hcpu_mhz);
      pstmt.setString(7, hcpu_model);
      pstmt.setString(8, hcpu_vender);
      // pstmt.setLong(9, hcpu_bits);
      pstmt.setLong(9, hcpu_eqptmosn);

      pstmt.executeUpdate();

    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DButil.getInstance().close(pstmt, null);
    }
  }