From 926a8b4621713460dd5622a5847edecda1e905ea Mon Sep 17 00:00:00 2001 From: whycxzp <glperry@163.com> Date: 星期四, 05 六月 2025 17:26:25 +0800 Subject: [PATCH] 表格生成调整 --- src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java b/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java index 6894c2a..da30755 100644 --- a/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java +++ b/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java @@ -245,4 +245,28 @@ } } + public List<BattRealTimeDataHistory> getFirstRecordList(String tableName) { + String sql = "select * from db_power_history." + tableName + " limit 104"; + List<BattRealTimeDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() { + + @Override + public List getResults(ResultSet rs) throws SQLException { + List<BattRealTimeDataHistory> list = new LinkedList<>(); + //濡傛灉瀛樺湪璁板綍 + while (rs.next()) { + BattRealTimeDataHistory his = new BattRealTimeDataHistory(); + his.setTestStartTime(rs.getTimestamp("test_start_time")); + his.setMonNum(rs.getInt("mon_num")); + his.setMonVol(rs.getFloat("mon_vol")); + his.setMonRes(rs.getFloat("mon_res")); + his.setMonTmp(rs.getFloat("mon_tmp")); + + list.add(his); + } + return list; + + } + }); + return list; + } } -- Gitblit v1.9.1