@xingjs@20241226@添加查询管线工具类,修改解决查询站点接口token存在无法获取的情况，解决后可正常获取token，并查询出需要的站点...

xingjinshuang

2024-12-26 28a856f4a6746bca61d1b6ad975b0e41654d7f70

@xingjs@20241226@添加查询管线工具类,修改解决查询站点接口token存在无法获取的情况，解决后可正常获取token，并查询出需要的站点；解析shp文件获取站点范围;新增把降水CSV文件内容解析保存到数据库中;计算CSV文件中的降水时间和降水总量

 src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java

@@ -235,19 +235,7 @@
        try (Connection conn = DriverManager.getConnection("jdbc:sqlite:rainfall.db")) {
            if (conn != null) {
                // 2. 执行SQL查询
                String queryDataSql = "SELECT sum(rainfall_difference) AS total" +
                        "FROM " +
                        "    (SELECT ABS( " +
                        "        (SELECT rainfall" +
                        "        FROM " + tableName +
                        "        WHERE station_name = s.station_name" +
                        "        ORDER BY  datetime ASC LIMIT 1) - " +
                        "            (SELECT rainfall" +
                        "            FROM " + tableName +
                        "            WHERE station_name = s.station_name" +
                        "            ORDER BY  datetime DESC LIMIT 1) ) AS rainfall_difference" +
                        "            FROM " + tableName + "s" +
                        "            GROUP BY  station_name)";
                String queryDataSql = "select sum(rainfall_difference) as total from(SELECT ABS( (SELECT rainfall FROM " + tableName + " WHERE station_name = s.station_name ORDER BY datetime ASC LIMIT 1) - (SELECT rainfall FROM " + tableName + " WHERE station_name = s.station_name ORDER BY datetime DESC LIMIT 1)) AS rainfall_difference FROM " + tableName + " s GROUP BY station_name)";
                // 3. 处理查询结果
                try (PreparedStatement pstmt = conn.prepareStatement(queryDataSql)) {
                    ResultSet rs = pstmt.executeQuery();