From 488677202ae47d556bb6f4a69c86c8892efc6b05 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 20 十二月 2022 16:48:22 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/helper/GdbHelper.java | 76 ++++++++++++++++++++++++-------------- 1 files changed, 48 insertions(+), 28 deletions(-) diff --git a/src/main/java/com/lf/server/helper/GdbHelper.java b/src/main/java/com/lf/server/helper/GdbHelper.java index 048adc4..f952c8a 100644 --- a/src/main/java/com/lf/server/helper/GdbHelper.java +++ b/src/main/java/com/lf/server/helper/GdbHelper.java @@ -10,6 +10,7 @@ import org.gdal.osr.SpatialReference; import java.lang.reflect.Field; +import java.math.BigDecimal; import java.sql.Timestamp; import java.time.LocalDate; import java.time.LocalDateTime; @@ -78,7 +79,7 @@ try { driver = ogr.GetDriverByName("OpenFileGDB"); if (null == driver) { - log.error("GdbHelper.getTabNames: OpenFileGDB is null"); + log.error("GdbHelper.getTabNames.driver(OpenFileGDB) is null."); return list; } @@ -326,17 +327,18 @@ /** * 鍒涘缓GDB */ - public static void createGdb(String filePath, Map<String, List<?>> map) { + public static void createGdb(String filePath, Map<String, List<?>> map) throws Exception { Driver driver = null; DataSource dataSource = null; try { - driver = ogr.GetDriverByName("OpenFileGDB"); + driver = ogr.GetDriverByName("FileGDB"); if (null == driver) { + log.error("GdbHelper.createGdb.driver(FileGDB) is null."); return; } - - dataSource = driver.CreateDataSource(filePath); + dataSource = driver.CreateDataSource(filePath, null); if (null == dataSource) { + log.error("GdbHelper.createGdb.dataSource is null. " + filePath); return; } @@ -354,26 +356,28 @@ String className = ClassHelper.getClassName(baseMapper); Class clazz = ClassHelper.getEntityClass(className); - Field gField = getGeomField(clazz); - if (null == gField) { + if (null == clazz) { continue; } List<Field> fields = new ArrayList<>(); + // fields.add(getGeomField(clazz)) getFields(clazz, fields); addLayerField(layer, fields); setLayerData(layer, fields, map.get(key)); - } catch (Exception e) { - log.error(e.getMessage(), e); } finally { if (null != layer) { layer.delete(); } } } + + dataSource.SyncToDisk(); + dataSource.FlushCache(); } catch (Exception ex) { log.error(ex.getMessage(), ex); + throw ex; } finally { GdbHelper.delete(dataSource, driver); } @@ -453,20 +457,12 @@ private static void addLayerField(Layer layer, List<Field> list) { for (int i = 0, c = list.size(); i < c; i++) { Field f = list.get(i); - FieldDefn fd = getLayerField(f); - layer.CreateField(fd, i); + + int fieldType = getFieldType(f); + FieldDefn fd = new FieldDefn(f.getName(), fieldType); + + layer.CreateField(fd, i + 1); } - } - - private static FieldDefn getLayerField(Field f ) { - int fieldType = getFieldType(f); - FieldDefn fd = new FieldDefn(f.getName(), fieldType); - - if (fieldType == ogr.OFTString) { - // fd.SetWidth(100) - } - - return fd; } /** @@ -504,30 +500,54 @@ for (int i = 0, c = fields.size(); i < c; i++) { Field field = fields.get(i); + Object val = field.get(t); + if (null == val) { + continue; + } + switch (field.getType().getName()) { case "java.math.BigDecimal": + BigDecimal big = (BigDecimal) val; + f.SetField(i, big.doubleValue()); + break; case "java.lang.Double": case "double": - Double d = field.getDouble(t); + double d = (double) val; f.SetField(i, d); + break; case "java.lang.Long": case "long": - Long l = field.getLong(t); + long l = (long) val; f.SetField(i, l); + break; case "java.lang.Integer": case "int": - Integer n = field.getInt(t); + int n = (int) val; f.SetField(i, n); + break; case "java.sql.Timestamp": - //return ogr.OFTDateTime; + Timestamp time = (Timestamp) field.get(t); + setTimestamp(f, i, time); + break; default: - String str = (String) field.get(t); + String str = (String) val; f.SetField(i, str); break; } } - layer.CreateFeature(f); } } + + /** + * 璁剧疆Timestamp + */ + private static void setTimestamp(Feature f, int i, Timestamp time) { + if (null == time) { + return; + } + + LocalDateTime local = time.toLocalDateTime(); + f.SetField(i, local.getYear(), local.getMonthValue(), local.getDayOfMonth(), local.getHour(), local.getMinute(), local.getSecond(), 8); + } } -- Gitblit v1.9.3