MyBatis处理jts-gis空间数据类型

最新推荐文章于 2024-06-02 21:24:34 发布

原来我不知道啊

最新推荐文章于 2024-06-02 21:24:34 发布

阅读量824

点赞数

分类专栏： Java 文章标签： mybatis java spring boot postgresql

本文链接：https://blog.csdn.net/u010412088/article/details/126509984

版权

Java 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

背景

使用PostGis存储空间数据类型（点、多边形、多多边形等），使用java的jts库中的相应类型映射数据库中的字段。

依赖

使用spring-boot管理依赖版本，springboot版本：2.1.4.RELEASE

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
</dependency>

typehandler

Geometry 类型的通用tpyehandler

/**
 * 将WKB转换为JTS对应的Geometry几何类型，或反向转换
 */
public class AbstractGeometryTypeHandler<T extends Geometry> extends BaseTypeHandler<Geometry> {

    private static GeometryFactory geometryFactory;
    static {
        // 经度保留6为小数
        PrecisionModel precisionModel = new PrecisionModel(1000000);
        geometryFactory = new GeometryFactory(precisionModel, 4326);
    }
    @Override
    public void setNonNullParameter(PreparedStatement preparedStatement, int i, Geometry geometry, JdbcType jdbcType) throws SQLException {
        PGobject object = new PGobject();
        object.setType("geometry");
        WKBWriter wkbWriter = new WKBWriter();
        byte[] bytes = wkbWriter.write(geometry);
        object.setValue(WKBWriter.toHex(bytes));
        preparedStatement.setObject(i, object);
    }

    @Override
    public Geometry getNullableResult(ResultSet resultSet, String s) throws SQLException {
        Object object = resultSet.getObject(s);
        return getGeometry(object);
    }

    @Override
    public Geometry getNullableResult(ResultSet resultSet, int i) throws SQLException {
        Object object = resultSet.getObject(i);
        return getGeometry(object);
    }

    @Override
    public Geometry getNullableResult(CallableStatement callableStatement, int i) throws SQLException {

        Object object = callableStatement.getObject(i);
        return getGeometry(object);
    }

    private Geometry getGeometry(Object object) {
        if (ObjectUtils.isEmpty(object)) {
            return null;
        }
        String source = object.toString();
        byte[] bytes = WKBReader.hexToBytes(source);
        WKBReader reader = new WKBReader(geometryFactory);
        try {
            Geometry geometry = reader.read(bytes);
            return geometry;
        } catch (ParseException e) {
            throw new RuntimeException(e);
        }
    }

}

MultiPolygon类型的typehandler

@MappedJdbcTypes(JdbcType.OTHER)
@MappedTypes(value = MultiPolygon.class)
public class MultiPolygonTypeHandler extends AbstractGeometryTypeHandler<MultiPolygon> {
}

Polygon类型的typehandler

@MappedJdbcTypes(JdbcType.OTHER)
@MappedTypes(value = Polygon.class)
public class PolygonTypeHandler extends AbstractGeometryTypeHandler<Polygon> {
}

springboot配置

mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml
  # 自动扫描 typehandler
  type-handlers-package: com.example.demo.typehandler

实体类与mepper.xml示例

public class Area {
    private String name;
    private Polygon area;

    // getter/setter
    ...
}

<resultMap id="BaseResultMap" type="com.example.demo.entity.Area">
    <result column="name" jdbcType="VARCHAR" property="name"/>
    <result column="area" jdbcType="OTHER" property="area"/>
</resultMap>