| | |
| | | } |
| | | //插入数据 |
| | | 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()); |
| | |
| | | } |
| | | 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, "); |
| | |
| | | // 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(); |
| | | } |