List of queryHistoryValue() Examples

Examples of queryHistoryValue()

com.narirelays.ems.exchange.sophic.SophicHistoryDAO.queryHistoryValue()
通用查询，查询value_col_name列的值并通过func_name计算后返回,sum,avg,max,min,count style=0单点查询，需要将func_name拼接到sql语句上 style=1序列查询，无需在sql上拼接func_name，且一般调用时func_name应为空

Examples of com.narirelays.ems.exchange.sophic.SophicHistoryDAO.queryHistoryValue()

    else//sum,max,min,count,avg等函数
    {
      SophicHistoryDAO sophicHistoryDAO = (SophicHistoryDAO)StorageService.ctx.getBean("sophicHistoryDAO");
      if(sophicHistoryDAO!=null)
      {
        List<Double> values = sophicHistoryDAO.queryHistoryValue(table_meta_name, table_unit, id_col_name, value_col_name, time_col_name, key, startTime, endTime, interval, target, 0);
        if(values!=null&&values.size()>0)
          value = values.get(0);          
      }      
    }
    return value;

View Full Code Here

Examples of com.narirelays.ems.exchange.sophic.SophicHistoryDAO.queryHistoryValue()

    String value_col_name = "value";
    String time_col_name = "attr_time";
    SophicHistoryDAO sophicHistoryDAO = (SophicHistoryDAO)StorageService.ctx.getBean("sophicHistoryDAO");
    if(sophicHistoryDAO!=null)
    {
      values = sophicHistoryDAO.queryHistoryValue(table_meta_name, table_unit, id_col_name, value_col_name, time_col_name, key, startTime, endTime, interval, null, 1);
    }
    return values;
  }
  
  /**

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.