From d7e3011a44a85f32aaab975f603f17a9bec198c5 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 20 十一月 2022 14:54:36 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/data/DataLoaderService.java | 39 ++++++++++++++++++++++++++++++++++++---
1 files changed, 36 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/lf/server/service/data/DataLoaderService.java b/src/main/java/com/lf/server/service/data/DataLoaderService.java
index aba8341..97c2edd 100644
--- a/src/main/java/com/lf/server/service/data/DataLoaderService.java
+++ b/src/main/java/com/lf/server/service/data/DataLoaderService.java
@@ -7,6 +7,7 @@
import com.lf.server.helper.ClassHelper;
import com.lf.server.helper.ExcelHelper;
import com.lf.server.helper.FileHelper;
+import com.lf.server.mapper.all.GeomBaseMapper;
import com.lf.server.service.all.BaseUploadService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -211,6 +212,11 @@
rows += baseMapper.insert(list.get(i));
}
+ if (baseMapper instanceof GeomBaseMapper) {
+ GeomBaseMapper geomBaseMapper = (GeomBaseMapper) baseMapper;
+ updateGeom(geomBaseMapper, list);
+ }
+
return rows;
}
@@ -224,9 +230,36 @@
cuField.setAccessible(true);
cuField.set(t, mfe.getCreateUser());
- Field cuTime = t.getClass().getDeclaredField("createTime");
- cuTime.setAccessible(true);
- cuTime.set(t, mfe.getCreateTime());
+ Field ctField = t.getClass().getDeclaredField("createTime");
+ ctField.setAccessible(true);
+ ctField.set(t, mfe.getCreateTime());
+ }
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+ }
+
+ /**
+ * 璁剧疆绌洪棿淇℃伅
+ */
+ private <T> void updateGeom(GeomBaseMapper geomBaseMapper, List<T> list) {
+ try {
+ for (T t : list) {
+ Field xField = t.getClass().getDeclaredField("x");
+ xField.setAccessible(true);
+ double x = (double) xField.get(t);
+
+ Field yField = t.getClass().getDeclaredField("y");
+ yField.setAccessible(true);
+ double y = (double) yField.get(t);
+
+ String wkt = String.format("POINT(%f %f)", x, y);
+
+ Field gField = t.getClass().getDeclaredField("geom");
+ gField.setAccessible(true);
+ gField.set(t, wkt);
+
+ //Integer gid=
}
} catch (Exception ex) {
log.error(ex.getMessage(), ex);
--
Gitblit v1.9.3