opt: 设置geom为4326

linwei

2026-04-07 fa1e221e3db35b55eddcd4459f533ca650b59a38

opt: 设置geom为4326

 drone-service/drone-gd/src/main/java/org/sxkj/gd/config/GeometryTypeHandler.java

@@ -30,15 +30,30 @@
        try {
            // String转Geometry
            geo = new WKTReader(new GeometryFactory(new PrecisionModel())).read(s);
            // Geometry转WKB
            byte[] geometryBytes = new WKBWriter(2, ByteOrderValues.LITTLE_ENDIAN, false).write(geo);
            // 设置SRID为mysql默认的 0
            byte[] wkb = new byte[geometryBytes.length + 4];
            wkb[0] = wkb[1] = wkb[2] = wkb[3] = 0;
            System.arraycopy(geometryBytes, 0, wkb, 4, geometryBytes.length);
            preparedStatement.setBytes(i, wkb);
        } catch (ParseException e) {

            // 解析SRID(如果字符串包含SRID=4326;前缀)
            int srid = 4326; // 默认使用WGS84坐标系
            String wktString = s;
            if (s != null && s.toUpperCase().startsWith("SRID=")) {
                int semicolonIndex = s.indexOf(';');
                if (semicolonIndex > 0) {
                    try {
                        srid = Integer.parseInt(s.substring(5, semicolonIndex));
                        wktString = s.substring(semicolonIndex + 1);
                    } catch (NumberFormatException e) {
                        // 如果解析失败,使用默认SRID 4326
                    }
                }
            }

            // 设置Geometry的SRID
            geo.setSRID(srid);

            // Geometry转WKB
            byte[] geometryBytes = new WKBWriter(2, ByteOrderValues.LITTLE_ENDIAN, true).write(geo);
            preparedStatement.setBytes(i, geometryBytes);
        } catch (ParseException e) {
            throw new SQLException("Failed to parse geometry WKT: " + s, e);
        }
    }