From 4bd8e808271964d14b519b0d04cf6d1686d89869 Mon Sep 17 00:00:00 2001 From: ZhuDongming <773644075@qq.com> Date: Wed, 01 Apr 2020 09:11:37 +0800 Subject: [PATCH] update小时插入报错 --- src/main/java/com/moral/task/HistoryTableInsertTask.java | 27 +++++++++++++++++++++------ 1 files changed, 21 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/moral/task/HistoryTableInsertTask.java b/src/main/java/com/moral/task/HistoryTableInsertTask.java index fe94ff9..ac2d823 100644 --- a/src/main/java/com/moral/task/HistoryTableInsertTask.java +++ b/src/main/java/com/moral/task/HistoryTableInsertTask.java @@ -519,8 +519,13 @@ if (!key.equals("mac") && !key.startsWith("M")) { List<Object> date = new ArrayList<>(); date.add(deviceData.get(key)); - date.add(new BigDecimal(deviceData.get("MIN" + key).toString())); - date.add(new BigDecimal(deviceData.get("MAX" + key).toString())); + if (deviceData.get("MIN" + key) instanceof String) { + date.add(new BigDecimal(deviceData.get("MIN" + key).toString())); + date.add(new BigDecimal(deviceData.get("MAX" + key).toString())); + } else if (deviceData.get("MIN" + key) instanceof byte[]) { + date.add(new BigDecimal(new String((byte[]) (deviceData.get("MIN" + key))))); + date.add(new BigDecimal(new String((byte[]) (deviceData.get("MAX" + key))))); + } jo.put(key, date); } } @@ -584,8 +589,13 @@ if (!key.equals("mac") && !key.startsWith("M")) { List<Object> date = new ArrayList<>(); date.add(deviceData.get(key)); - date.add(new BigDecimal(deviceData.get("MIN" + key).toString())); - date.add(new BigDecimal(deviceData.get("MAX" + key).toString())); + if (deviceData.get("MIN" + key) instanceof String) { + date.add(new BigDecimal(deviceData.get("MIN" + key).toString())); + date.add(new BigDecimal(deviceData.get("MAX" + key).toString())); + } else if (deviceData.get("MIN" + key) instanceof byte[]) { + date.add(new BigDecimal(new String((byte[]) (deviceData.get("MIN" + key))))); + date.add(new BigDecimal(new String((byte[]) (deviceData.get("MAX" + key))))); + } jo.put(key, date); } } @@ -643,8 +653,13 @@ if (!key.equals("mac") && !key.startsWith("M")) { List<Object> date = new ArrayList<>(); date.add(deviceData.get(key)); - date.add(new BigDecimal(deviceData.get("MIN" + key).toString())); - date.add(new BigDecimal(deviceData.get("MAX" + key).toString())); + if (deviceData.get("MIN" + key) instanceof String) { + date.add(new BigDecimal(deviceData.get("MIN" + key).toString())); + date.add(new BigDecimal(deviceData.get("MAX" + key).toString())); + } else if (deviceData.get("MIN" + key) instanceof byte[]) { + date.add(new BigDecimal(new String((byte[]) (deviceData.get("MIN" + key))))); + date.add(new BigDecimal(new String((byte[]) (deviceData.get("MAX" + key))))); + } jo.put(key, date); } } -- Gitblit v1.8.0