解决导出xls异常

13693261870

2024-03-21 b20fd29dc3864405af4afa0aeb99d13d74fbfcdc

 src/main/java/com/lf/server/helper/MdbHelper.java

@@ -3,6 +3,7 @@
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;

@@ -21,23 +22,32 @@
     */
    public static List<String> getTabNames(String filePath) {
        List<String> list = new ArrayList<>();

        Driver driver = null;
        DataSource dataSource = null;
        try {
            org.gdal.ogr.Driver driver = ogr.GetDriverByName("PGeo");
            if (driver == null) {
            driver = ogr.GetDriverByName("PGeo");
            if (null == driver) {
                log.error("MdbHelper.getTabNames: PGeo is null");
                return list;
            }

            DataSource dataSource = driver.Open(filePath, 0);
            dataSource = driver.Open(filePath, 0);
            if (null == dataSource) {
                log.error("MdbHelper.getTabNames.dataSource is null. " + filePath);
                return list;
            }

            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);
        } finally {
            GdbHelper.delete(dataSource, driver);
        }

        return list;
@@ -48,27 +58,33 @@
     */
    public static <T> List<T> readData(Class clazz, String filePath, String layerName) {
        List<T> list = new ArrayList<>();

        Driver driver = null;
        DataSource dataSource = null;
        try {
            org.gdal.ogr.Driver driver = ogr.GetDriverByName("PGeo");
            if (driver == null) {
            driver = ogr.GetDriverByName("PGeo");
            if (null == driver) {
                return list;
            }

            DataSource dataSource = driver.Open(filePath, 0);
            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);
                if (layer.GetName().equals(layerName)) {
                    GdbHelper.readLayer(clazz, layer, list, true);
                    break;
                }

                layer.delete();
            }

            driver.delete();
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);
        } finally {
            GdbHelper.delete(dataSource, driver);
        }

        return list;