| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.time.Instant; |
| | | import java.util.LinkedHashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | |
| | | public List<Map<String, Object>> queryData(String sql) { |
| | | try { |
| | | // 执行查询 |
| | | Stream<Object[]> query = influxDBClient.query(sql); |
| | | logger.info("查询数据:{}", query); |
| | | Stream<Map<String, Object>> mapStream = influxDBClient.queryRows(sql); |
| | | logger.info("查询数据:{}", mapStream.collect(Collectors.toList())); |
| | | //query.forEach(row -> System.out.printf("| %-8s | %-8s | %-30s |%n", row[1], row[2], row[0])); |
| | | // 转换为 Map 列表(便于后续处理) |
| | | List<Map<String, Object>> collect = query.map(record -> { |
| | | Map<String, Object> map = new LinkedHashMap<>(); |
| | | for (int i = 0; i < record.length; i += 2) { |
| | | map.put((String) record[i], record[i + 1]); |
| | | } |
| | | return map; |
| | | }) |
| | | .collect(Collectors.toList()); |
| | | return collect; |
| | | // List<Map<String, Object>> collect = query.map(record -> { |
| | | // Map<String, Object> map = new LinkedHashMap<>(); |
| | | // for (int i = 0; i < record.length; i += 2) { |
| | | // map.put((String) record[i], record[i + 1]); |
| | | // } |
| | | // return map; |
| | | // }) |
| | | // .collect(Collectors.toList()); |
| | | return null; |
| | | } catch (Exception e) { |
| | | logger.error("Failed to query data from the database."); |
| | | e.printStackTrace(); |