Spring JPA如何将EWKT字符串插入PostGIS数据库？

1. 引入必要依赖 #

确保项目中包含Spring Data JPA、PostGIS JDBC驱动和JTS Core的依赖（以Maven为例）：

<dependencies>
    <!-- Spring Data JPA -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <!-- PostGIS JDBC驱动 -->
    <dependency>
        <groupId>org.postgis</groupId>
        <artifactId>postgis-jdbc</artifactId>
        <version>2.5.0</version>
    </dependency>
    <!-- JTS Core（LocationTech） -->
    <dependency>
        <groupId>org.locationtech.jts</groupId>
        <artifactId>jts-core</artifactId>
        <version>1.18.2</version>
    </dependency>
</dependencies>

2. 配置数据库连接 #

在application.properties中配置PostGIS数据库连接，指定专用驱动和空间方言：

spring.datasource.url=jdbc:postgresql://localhost:5432/your_database?currentSchema=public
spring.datasource.driver-class-name=org.postgis.DriverWrapper
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.spatial.dialect.postgis.PostgisDialect

3. 定义实体类 #

创建对应数据库表的实体类，使用JTS的CircularString类型映射PostGIS的geometry字段：

import jakarta.persistence.*;
import org.locationtech.jts.geom.CircularString;
import org.hibernate.spatial.GeometryType;

@Entity
@Table(name = "spatial_curves")
public class SpatialCurve {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(columnDefinition = "geometry")
    @Type(type = "org.hibernate.spatial.GeometryType")
    private CircularString circularArc;

    // 构造方法、Getter、Setter
    public SpatialCurve() {}

    public SpatialCurve(CircularString circularArc) {
        this.circularArc = circularArc;
    }

    public Long getId() { return id; }
    public void setId(Long id) { this.id = id; }
    public CircularString getCircularArc() { return circularArc; }
    public void setCircularArc(CircularString circularArc) { this.circularArc = circularArc; }
}

4. 创建Repository接口 #

继承JpaRepository实现基础CRUD操作：

import org.springframework.data.jpa.repository.JpaRepository;

public interface SpatialCurveRepository extends JpaRepository<SpatialCurve, Long> {
}

5. 生成并插入圆弧 #

通过JTS的GeometryFactory创建CircularString实例，再通过Repository保存到数据库：

import org.locationtech.jts.geom.Coordinate;
import org.locationtech.jts.geom.CircularString;
import org.locationtech.jts.geom.GeometryFactory;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
public class SpatialCurveService {
    private final SpatialCurveRepository curveRepository;
    private final GeometryFactory geometryFactory = new GeometryFactory();

    public SpatialCurveService(SpatialCurveRepository curveRepository) {
        this.curveRepository = curveRepository;
    }

    @Transactional
    public void saveCircularArc() {
        // 定义圆弧的三个控制点：起点、中间点、终点
        Coordinate[] coordinates = {
                new Coordinate(4, 0),
                new Coordinate(4, 4),
                new Coordinate(8, 4)
        };
        CircularString circularString = geometryFactory.createCircularString(coordinates);
        SpatialCurve curve = new SpatialCurve(circularString);
        curveRepository.save(curve);
    }
}

6. 验证插入结果 #

在PostgreSQL终端执行查询，查看存储的EWKT格式圆弧：

SELECT id, ST_AsEWKT(circular_arc) FROM spatial_curves;

返回结果应包含：CIRCULARSTRING(4 0,4 4,8 4)

注意事项 #

• 确保目标数据库已启用PostGIS扩展：执行CREATE EXTENSION IF NOT EXISTS postgis;
• 保持JTS和PostGIS版本兼容，避免序列化/反序列化异常
• 若使用Spring Boot，建议使用2.0及以上版本，对空间类型的支持更完善

内容的提问来源于stack exchange，提问作者tm1701