import lombok.Data;
@Data
public class CPoint {
    double[] coordinates;
}

@Data
public class CLine {
    private List<double[]> coordinates;
}

import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.MappedTypes;
import org.postgis.PGgeometry;
import org.postgis.Point;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

@MappedTypes({CPoint.class})
public class PointHandler extends BaseTypeHandler<CPoint> {

    @Override
    // 重写CPoint getter 方法, 其他方法可以为默认值
    public CPoint getNullableResult(ResultSet resultSet, String s) throws SQLException {
        PGgeometry pGgeometry = (PGgeometry) resultSet.getObject(s);
        Point point = pGgeometry.getGeometry().getPoint(0);

        CPoint cPoint = new CPoint();
        cPoint.setCoordinates(new double[]{point.x, point.y});
        return cPoint;
    }
}


@MappedTypes(CLine.class)
public class LineHandler extends BaseTypeHandler<CLine> {
    
    @Override
    public CLine getNullableResult(ResultSet resultSet, String s) throws SQLException {
        List<double[]> coordinates = new ArrayList<>();

        PGgeometry pGgeometry = (PGgeometry) resultSet.getObject(s);
        // 正常的数据类型应该为LineString的
        // 因为数据库里面是MultiLineString, 所以我取了第一条多段线
        MultiLineString multiLineString = (MultiLineString) pGgeometry.getGeometry();
        if(multiLineString.getLines().length == 0) return null;

        LineString firstLine = multiLineString.getLine(0);
        for (Point point : firstLine.getPoints()){
            double[] coord = new double[]{point.x, point.y};
            coordinates.add(coord);
        }
        CLine cLine = new CLine();
        cLine.setCoordinates(coordinates);
        return cLine;
    }
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="org.postgresql.Driver"/>
                <property name="url" value="jdbc:postgresql://0.0.0.0:5432/database"/>
                <property name="username" value=""/>
                <property name="password" value=""/>
            </dataSource>
        </environment>
    </environments>
</configuration>

server.port=9000

# 数据库配置
spring.datasource.driverClassName=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://0.0.0.0:5432/database
spring.datasource.username=
spring.datasource.password=
spring.jackson.serialization.fail-on-empty-beans=false


# Mybatis 配置
mybatis.mapperLocations=classpath:mapper/*.xml