From 9bce48a9f30f7d80c43f43f46d40df20fcb00e15 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 03 二月 2023 09:39:59 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/helper/GdbHelper.java | 145 +++++++++++++++++++++++++++++++++--------------- 1 files changed, 99 insertions(+), 46 deletions(-) diff --git a/src/main/java/com/lf/server/helper/GdbHelper.java b/src/main/java/com/lf/server/helper/GdbHelper.java index f952c8a..31ddbd5 100644 --- a/src/main/java/com/lf/server/helper/GdbHelper.java +++ b/src/main/java/com/lf/server/helper/GdbHelper.java @@ -24,8 +24,6 @@ public class GdbHelper { private final static Log log = LogFactory.getLog(GdbHelper.class); - private final static String OBJECT ="java.lang.Object"; - /** * 閿�姣佽祫婧� */ @@ -77,9 +75,10 @@ Driver driver = null; DataSource dataSource = null; try { - driver = ogr.GetDriverByName("OpenFileGDB"); + // driver = ogr.GetDriverByName("OpenFileGDB") + driver = ogr.GetDriverByName("FileGDB"); if (null == driver) { - log.error("GdbHelper.getTabNames.driver(OpenFileGDB) is null."); + log.error("GdbHelper.getTabNames.driver is null."); return list; } @@ -113,7 +112,8 @@ Driver driver = null; DataSource dataSource = null; try { - driver = ogr.GetDriverByName("OpenFileGDB"); + // driver = ogr.GetDriverByName("OpenFileGDB") + driver = ogr.GetDriverByName("FileGDB"); if (null == driver) { return list; } @@ -209,7 +209,7 @@ } } - if (!OBJECT.equals(clazz.getSuperclass().getName())) { + if (!StaticData.OBJECT.equals(clazz.getSuperclass().getName())) { getFieldMapper(clazz.getSuperclass(), layer, map); } } catch (Exception ex) { @@ -243,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)); @@ -257,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)); @@ -282,7 +288,11 @@ String geo = "null"; if (null != f.GetGeometryRef()) { String wkt = f.GetGeometryRef().ExportToWkt(); + // noinspection AlibabaRemoveCommentedCode switch (f.GetGeometryRef().GetGeometryType()) { + //case 1: + // wkt = wkt.replace("POINT", "MULTIPOINT"); + // break; case 2: wkt = wkt.replace("LINESTRING (", "MULTILINESTRING ((") + ")"; break; @@ -322,6 +332,23 @@ ); return Timestamp.valueOf(localDateTime); + } + + /** + * 鑾峰彇 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]); } /** @@ -399,7 +426,7 @@ Integer srid = baseMapper.selectSrid(tab); SpatialReference sr = new SpatialReference(); - sr.ImportFromEPSG(null == srid ? 4326 : srid); + sr.ImportFromEPSG(null == srid ? 4490 : srid); return dataSource.CreateLayer(tab, sr, getGeomType(geomType), null); } @@ -415,6 +442,8 @@ switch (geomType) { case "ST_Point": return ogr.wkbPoint; + case "ST_MultiPoint": + return ogr.wkbMultiPoint; case "ST_LineString": return ogr.wkbLineString; case "ST_MultiLineString": @@ -443,7 +472,7 @@ list.add(f); } - if (!OBJECT.equals(clazz.getSuperclass().getName())) { + if (!StaticData.OBJECT.equals(clazz.getSuperclass().getName())) { getFields(clazz.getSuperclass(), list); } } catch (Exception ex) { @@ -454,7 +483,7 @@ /** * 娣诲姞鍥惧眰瀛楁 */ - private static void addLayerField(Layer layer, List<Field> list) { + public static void addLayerField(Layer layer, List<Field> list) { for (int i = 0, c = list.size(); i < c; i++) { Field f = list.get(i); @@ -482,6 +511,8 @@ return ogr.OFTInteger; case "java.sql.Timestamp": return ogr.OFTDateTime; + case "java.time.LocalDate": + return ogr.OFTDate; default: return ogr.OFTString; } @@ -498,44 +529,55 @@ Geometry geom = Geometry.CreateFromWkt(geoEntity.getGeom()); f.SetGeometry(geom); - 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 = (double) val; - f.SetField(i, d); - break; - case "java.lang.Long": - case "long": - long l = (long) val; - f.SetField(i, l); - break; - case "java.lang.Integer": - case "int": - int n = (int) val; - f.SetField(i, n); - break; - case "java.sql.Timestamp": - Timestamp time = (Timestamp) field.get(t); - setTimestamp(f, i, time); - break; - default: - String str = (String) val; - f.SetField(i, str); - break; - } - } + setFeatureData(f, fields, t); layer.CreateFeature(f); + } + } + + /** + * 璁剧疆瑕佺礌鐨勬暟鎹� + */ + public static <T> void setFeatureData(Feature f, List<Field> fields, T t) throws Exception { + 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 = (double) val; + f.SetField(i, d); + break; + case "java.lang.Long": + case "long": + long l = (long) val; + f.SetField(i, l); + break; + case "java.lang.Integer": + case "int": + int n = (int) val; + f.SetField(i, n); + break; + case "java.sql.Timestamp": + 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; + f.SetField(i, str); + break; + } } } @@ -550,4 +592,15 @@ 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