From de2474df7f982347fbb958bfdc624f1c01bdaccc Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 22 十一月 2022 10:24:14 +0800 Subject: [PATCH] 123 --- src/main/java/com/lf/server/helper/GdbHelper.java | 49 ++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 42 insertions(+), 7 deletions(-) diff --git a/src/main/java/com/lf/server/helper/GdbHelper.java b/src/main/java/com/lf/server/helper/GdbHelper.java index 91f476d..a70f1a0 100644 --- a/src/main/java/com/lf/server/helper/GdbHelper.java +++ b/src/main/java/com/lf/server/helper/GdbHelper.java @@ -5,6 +5,10 @@ import org.gdal.ogr.*; import java.lang.reflect.Field; +import java.sql.Timestamp; +import java.time.LocalDate; +import java.time.LocalDateTime; +import java.time.LocalTime; import java.util.ArrayList; import java.util.HashMap; import java.util.List; @@ -31,9 +35,12 @@ DataSource dataSource = driver.Open(filePath, 0); for (int i = 0, count = dataSource.GetLayerCount(); i < count; i++) { Layer layer = dataSource.GetLayer(i); - list.add(layer.GetName()); + + layer.delete(); } + + driver.delete(); } catch (Exception ex) { log.error(ex.getMessage(), ex); } @@ -168,21 +175,21 @@ */ private static <T> void setValue(T t, Feature f, Field field, Integer i) throws Exception { switch (field.getType().toString()) { - case "java.math.BigDecimal": - case "java.lang.Double": + case "class java.math.BigDecimal": + case "class java.lang.Double": case "double": field.set(t, f.GetFieldAsDouble(i)); break; - case "java.lang.Long": + case "class java.lang.Long": case "long": field.set(t, f.GetFieldAsInteger64(i)); break; - case "java.lang.Integer": + case "class java.lang.Integer": case "int": field.set(t, f.GetFieldAsInteger(i)); break; - case "java.sql.Timestamp": - field.set(t, GdalHelper.getProperty(f, i)); + case "class java.sql.Timestamp": + field.set(t, getTimestamp(f, i)); break; default: field.set(t, f.GetFieldAsString(i)); @@ -199,4 +206,32 @@ gField.set(t, geometry.ExportToWkt()); } } + + /** + * 鑾峰彇 Timestamp + */ + private static Timestamp getTimestamp(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); + + float fSecond = pfSecond[0]; + int s = (int) fSecond; + int ns = (int) (1000000000 * fSecond - s); + + LocalDateTime localDateTime = LocalDateTime.of( + LocalDate.of(pnYear[0], pnMonth[0], pnDay[0]), + LocalTime.of(pnHour[0], pnMinute[0], s, ns) + ); + + Timestamp timestamp = Timestamp.valueOf(localDateTime); + + return timestamp; + } } -- Gitblit v1.9.3