String[] stats = new String[STATS.values().length]; StringBuilder sb = new StringBuilder(); for(STATS func : STATS.values()) { if(sb.length()!=0) { sb.append(", "); sb.append(func.name()); sb.append("("); sb.append(columnName); sb.append("::double precision) "); sb.append(func.name()); try(ResultSet rs = st.executeQuery(String.format("SELECT %s FROM %s",sb.toString(), tableName ))) { if(rs.next()) { for(STATS func : STATS.values()) { stats[func.ordinal()] = rs.getString(func.name());
message.append(I18N.tr("Row count : {0}\n", stats[ReadTable.STATS.COUNT.ordinal()])); message.append(I18N.tr("Minimum : {0}\n", stats[ReadTable.STATS.MIN.ordinal()])); message.append(I18N.tr("Maximum : {0}\n", stats[ReadTable.STATS.MAX.ordinal()])); message.append(I18N.tr("Sum : {0}\n", stats[ReadTable.STATS.SUM.ordinal()])); message.append(I18N.tr("Average : {0}\n", stats[ReadTable.STATS.AVG.ordinal()])); message.append(I18N.tr("Standard deviation : {0}\n", stats[ReadTable.STATS.STDDEV_SAMP.ordinal()])); LOGGER.info(message.toString()); } catch (SQLException ex) {
String[] res = new String[STATS.values().length]; SummaryStatistics stats = new SummaryStatistics(); try(Statement st = connection.createStatement()) { res[STATS.SUM.ordinal()] = Double.toString(stats.getSum()); res[STATS.AVG.ordinal()] = Double.toString(stats.getMean()); res[STATS.COUNT.ordinal()] = Long.toString(stats.getN()); res[STATS.MIN.ordinal()] = Double.toString(stats.getMin()); res[STATS.MAX.ordinal()] = Double.toString(stats.getMax()); res[STATS.STDDEV_SAMP.ordinal()] = Double.toString(stats.getStandardDeviation()); return res;
String[] stats = new String[STATS.values().length]; StringBuilder sb = new StringBuilder(); for(STATS func : STATS.values()) { if(sb.length()!=0) { sb.append(", "); sb.append(func.name()); sb.append("("); sb.append(columnName); sb.append("::double) "); sb.append(func.name()); try(ResultSet rs = st.executeQuery(String.format("SELECT %s FROM %s",sb.toString(), tableName ))) { if(rs.next()) { for(STATS func : STATS.values()) { stats[func.ordinal()] = rs.getString(func.name());
String[] res = new String[STATS.values().length]; SummaryStatistics stats = new SummaryStatistics(); try(Statement st = connection.createStatement()) { res[STATS.SUM.ordinal()] = Double.valueOf(stats.getSum()).toString(); res[STATS.AVG.ordinal()] = Double.valueOf(stats.getMean()).toString(); res[STATS.COUNT.ordinal()] = Long.valueOf(stats.getN()).toString(); res[STATS.MIN.ordinal()] = Double.valueOf(stats.getMin()).toString(); res[STATS.MAX.ordinal()] = Double.valueOf(stats.getMax()).toString(); res[STATS.STDDEV_SAMP.ordinal()] = Double.valueOf(stats.getStandardDeviation()).toString(); return res;