zjh20250729-1

zjh

4 天以前 6cd2d32a724d7c3414e00a0866acf45ade2e5bfe

 ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiGetMethodService.java

@@ -337,15 +337,17 @@
                creatTable(object, tabName, connection);
            } catch (SQLException e) {
                log.error(String.valueOf(e),e.getMessage());
                return AjaxResult.error();
//                return AjaxResult.error();
            }
        }
        //插入数据
        try {
            //TODO 报错
            // 17:05:33.949 [http-nio-5000-exec-15] ERROR c.l.w.c.h.HisApiGetMethodService - [save,347] - java.sql.SQLDataException: Value '4294967295' is outside of valid range for type java.lang.Integer
            operationTable(object,connection,hisApiConfig,paramsJson,code);
        } catch (SQLException e) {
            log.error(String.valueOf(e),e.getMessage());
            return AjaxResult.error();
//            return AjaxResult.error();
        }finally {
            try {
                connection.close();
@@ -481,7 +483,7 @@
            String key = entry.getKey().trim().toLowerCase();
            if (StrUtil.isBlank(defaultVal) || defaultVal.equals("null"))
                continue;
            String val = defaultVal.trim().replaceAll("\\s+", "");
            String val = defaultVal.trim().replaceAll("\\s+", "").replaceAll("[^\\x00-\\x7F]", "");
            if (primaryKesList.contains(key)) {
                deleteSqlBuilder.append(key).append(" = '").append(val).append("' and ");
            }
@@ -503,9 +505,9 @@
        }
        deleteSqlBuilder.delete(deleteSqlBuilder.length() - 5, deleteSqlBuilder.length());
        Statement statement = connection.prepareStatement(deleteSqlBuilder.toString());
        log.info("HIS数据保存类 执行删除 ->{}",deleteSqlBuilder.toString());
//        log.info("HIS数据保存类 执行删除 ->{}",deleteSqlBuilder.toString());
        int i = statement.executeUpdate(deleteSqlBuilder.toString());
        log.info("HIS数据保存类 删除条数 ->{}",i);
//        log.info("HIS数据保存类 删除条数 ->{}",i);
        statement.close();
        insertSqlBuilder.append("insert_time, ");
        insertSqlBuilder.append("request_params, ");
@@ -543,11 +545,11 @@
//                break;
//        }
        statement = connection.createStatement();
        log.info("HIS数据保存类 执行插入 ->{}",insertSqlBuilder.toString());
//        log.info("HIS数据保存类 执行插入 ->{}",insertSqlBuilder.toString());
        boolean execute = statement.execute(insertSqlBuilder.toString());
        if (!execute){
            int updateCount = statement.getUpdateCount();
            log.info("HIS数据保存类 执行插入成功 影响行数->{}",updateCount);
//            log.info("HIS数据保存类 执行插入成功 影响行数->{}",updateCount);
        }
        statement.close();
    }