From ab849f796bdc17236a95ea5fe5c166fb8f24a75c Mon Sep 17 00:00:00 2001 From: sws <15810472099@163.com> Date: 星期六, 26 十一月 2022 16:12:02 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/helper/MdbHelper.java | 90 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 90 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/lf/server/helper/MdbHelper.java b/src/main/java/com/lf/server/helper/MdbHelper.java new file mode 100644 index 0000000..4a7a158 --- /dev/null +++ b/src/main/java/com/lf/server/helper/MdbHelper.java @@ -0,0 +1,90 @@ +package com.lf.server.helper; + +import org.apache.commons.logging.Log; +import org.apache.commons.logging.LogFactory; +import org.gdal.ogr.DataSource; +import org.gdal.ogr.Driver; +import org.gdal.ogr.Layer; +import org.gdal.ogr.ogr; + +import java.util.ArrayList; +import java.util.List; + +/** + * MDB甯姪绫� + * @author WWW + */ +public class MdbHelper { + private final static Log log = LogFactory.getLog(MdbHelper.class); + + /** + * 鑾峰彇琛ㄥ悕 + */ + public static List<String> getTabNames(String filePath) { + List<String> list = new ArrayList<>(); + + Driver driver = null; + DataSource dataSource = null; + try { + driver = ogr.GetDriverByName("PGeo"); + if (null == driver) { + return list; + } + + dataSource = driver.Open(filePath, 0); + if (null == dataSource) { + return list; + } + + for (int i = 0, count = dataSource.GetLayerCount(); i < count; i++) { + Layer layer = dataSource.GetLayer(i); + list.add(layer.GetName()); + + layer.delete(); + } + } catch (Exception ex) { + log.error(ex.getMessage(), ex); + } finally { + GdbHelper.delete(dataSource, driver); + } + + return list; + } + + /** + * 璇诲彇鏁版嵁 + */ + public static <T> List<T> readData(Class clazz, String filePath, String layerName) { + List<T> list = new ArrayList<>(); + + Driver driver = null; + DataSource dataSource = null; + try { + driver = ogr.GetDriverByName("PGeo"); + if (null == driver) { + return list; + } + + dataSource = driver.Open(filePath, 0); + if (null == dataSource) { + return list; + } + + for (int i = 0, count = dataSource.GetLayerCount(); i < count; i++) { + Layer layer = dataSource.GetLayer(i); + if (layer.GetName().equals(layerName)) { + GdbHelper.readLayer(clazz, layer, list); + break; + } + + layer.delete(); + } + } catch (Exception ex) { + log.error(ex.getMessage(), ex); + } finally { + GdbHelper.delete(dataSource, driver); + } + + return list; + } +} -- Gitblit v1.9.3