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 | 70 +++++++++++++++++++++++++++------- 1 files changed, 55 insertions(+), 15 deletions(-) diff --git a/src/main/java/com/lf/server/helper/GdbHelper.java b/src/main/java/com/lf/server/helper/GdbHelper.java index 6b73111..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,18 +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("FileGDB"); if (null == driver) { + log.error("GdbHelper.createGdb.driver(FileGDB) is null."); return; } dataSource = driver.CreateDataSource(filePath, null); if (null == dataSource) { + log.error("GdbHelper.createGdb.dataSource is null. " + filePath); return; } @@ -358,13 +384,11 @@ } List<Field> fields = new ArrayList<>(); - fields.add(getGeomField(clazz)); + // 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(); @@ -376,6 +400,7 @@ dataSource.FlushCache(); } catch (Exception ex) { log.error(ex.getMessage(), ex); + throw ex; } finally { GdbHelper.delete(dataSource, driver); } @@ -453,13 +478,13 @@ * 娣诲姞鍥惧眰瀛楁 */ private static void addLayerField(Layer layer, List<Field> list) { - for (int i = 1, c = list.size(); i < c; i++) { + for (int i = 0, c = list.size(); i < c; i++) { Field f = list.get(i); int fieldType = getFieldType(f); FieldDefn fd = new FieldDefn(f.getName(), fieldType); - layer.CreateField(fd, i); + layer.CreateField(fd, i + 1); } } @@ -480,6 +505,8 @@ return ogr.OFTInteger; case "java.sql.Timestamp": return ogr.OFTDateTime; + case "java.time.LocalDate": + return ogr.OFTDate; default: return ogr.OFTString; } @@ -496,7 +523,7 @@ Geometry geom = Geometry.CreateFromWkt(geoEntity.getGeom()); f.SetGeometry(geom); - for (int i = 1, c = fields.size(); i < c; i++) { + for (int i = 0, c = fields.size(); i < c; i++) { Field field = fields.get(i); Object val = field.get(t); if (null == val) { @@ -505,6 +532,9 @@ 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 = (double) val; @@ -521,8 +551,12 @@ f.SetField(i, n); break; case "java.sql.Timestamp": - Timestamp time = (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 = (String) val; @@ -537,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