From 1d53dd8f501a98ddcce8146443b51b357ef5f9b1 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期四, 29 十二月 2022 16:55:46 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/helper/GdbHelper.java | 103 ++++++++++++++++++++++++++++++++++----------------- 1 files changed, 69 insertions(+), 34 deletions(-) diff --git a/src/main/java/com/lf/server/helper/GdbHelper.java b/src/main/java/com/lf/server/helper/GdbHelper.java index 854a787..a051f32 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; } @@ -242,6 +243,9 @@ private static <T> void setValue(T t, Feature f, Field field, Integer i) throws Exception { switch (field.getType().getName()) { case "java.math.BigDecimal": + double dd = f.GetFieldAsDouble(i); + field.set(t, BigDecimal.valueOf(dd)); + break; case "java.lang.Double": case "double": field.set(t, f.GetFieldAsDouble(i)); @@ -256,6 +260,9 @@ break; case "java.sql.Timestamp": field.set(t, getTimestamp(f, i)); + break; + case "java.time.LocalDate": + field.set(t, getLocalDate(f, i)); break; default: field.set(t, f.GetFieldAsString(i)); @@ -324,19 +331,37 @@ } /** + * 鑾峰彇 LocalDate + */ + private static LocalDate getLocalDate(Feature f, int index) { + int[] pnYear = new int[1]; + int[] pnMonth = new int[1]; + int[] pnDay = new int[1]; + int[] pnHour = new int[1]; + int[] pnMinute = new int[1]; + float[] pfSecond = new float[1]; + int[] pnTzFlag = new int[1]; + + f.GetFieldAsDateTime(index, pnYear, pnMonth, pnDay, pnHour, pnMinute, pfSecond, pnTzFlag); + + return LocalDate.of(pnYear[0], pnMonth[0], pnDay[0]); + } + + /** * 鍒涘缓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,18 +379,16 @@ 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(); @@ -377,6 +400,7 @@ dataSource.FlushCache(); } catch (Exception ex) { log.error(ex.getMessage(), ex); + throw ex; } finally { GdbHelper.delete(dataSource, driver); } @@ -456,20 +480,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; } /** @@ -489,6 +505,8 @@ return ogr.OFTInteger; case "java.sql.Timestamp": return ogr.OFTDateTime; + case "java.time.LocalDate": + return ogr.OFTDate; default: return ogr.OFTString; } @@ -507,34 +525,45 @@ 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": - Timestamp time = null == field.get(t) ? null : (Timestamp) field.get(t); - setTimestamp(f, i, time); + Timestamp timestamp = (Timestamp) field.get(t); + setTimestamp(f, i, timestamp); + break; + case "java.time.LocalDate": + LocalDate localDate = (LocalDate) field.get(t); + setLocalDate(f, i, localDate); break; default: - String str = null == field.get(t) ? null : (String) field.get(t); + String str = (String) val; f.SetField(i, str); break; } } - layer.CreateFeature(f); } } @@ -542,17 +571,23 @@ /** * 璁剧疆Timestamp */ - @SuppressWarnings("AlibabaRemoveCommentedCode") private static void setTimestamp(Feature f, int i, Timestamp time) { if (null == time) { return; } - //Calendar now = Calendar.getInstance(); - //now.setTimeInMillis(time.getTime()); - // f.SetField(i, now.get(Calendar.YEAR), now.get(Calendar.MONTH) + 1, now.get(Calendar.DATE), now.get(Calendar.HOUR), now.get(Calendar.MINUTE), now.get(Calendar.SECOND), 8); - LocalDateTime local = time.toLocalDateTime(); f.SetField(i, local.getYear(), local.getMonthValue(), local.getDayOfMonth(), local.getHour(), local.getMinute(), local.getSecond(), 8); } + + /** + * 璁剧疆LocalDate + */ + private static void setLocalDate(Feature f, int i, LocalDate local) { + if (null == local) { + return; + } + + f.SetField(i, local.getYear(), local.getMonthValue(), local.getDayOfMonth(), 0, 0, 0, 8); + } } -- Gitblit v1.9.3