GeometryCollection 的类型映射器（TypeHandler） - ToB企服应用市场:ToB评测及商务社交产业平台

<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-geojson-core</artifactId>
<version>28.2</version>
</dependency>
<repositories>
<repository>
<id>osgeo</id>
<name>OSGeo Release Repository</name>
<url>https://repo.osgeo.org/repository/release/</url>
<snapshots>
<enabled>false</enabled>
</snapshots>
<releases>
<enabled>true</enabled>
</releases>
</repository>
<repository>
<id>osgeo-snapshot</id>
<name>OSGeo Snapshot Repository</name>
<url>https://repo.osgeo.org/repository/snapshot/</url>
<snapshots>
<enabled>true</enabled>
</snapshots>
<releases>
<enabled>false</enabled>
</releases>
</repository>
</repositories>

复制代码

package top.emanjusaka.test;
import com.iles.handler.GeometryCollectionTypeHandler;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.locationtech.jts.geom.GeometryCollection;
import tk.mybatis.mapper.annotation.ColumnType;
import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
@Data
@EqualsAndHashCode(callSuper = false)
@Table(name = "car_work_area")
public class CarWorkAreaDO {
private static final long serialVersionUID = 1L;
/**
* 自增 ID
*/
@Id
@GeneratedValue(generator = "JDBC")
private Long id;
@Column(name = "area_geom")
@ColumnType(typeHandler = GeometryCollectionTypeHandler.class)
private GeometryCollection areaGeom;
}

复制代码

package top.emanjusaka.handler;
import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import org.locationtech.jts.geom.GeometryCollection;
import org.locationtech.jts.io.ParseException;
import org.locationtech.jts.io.WKTReader;
import org.locationtech.jts.io.WKTWriter;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @Author emanjusaka
*/
public class GeometryCollectionTypeHandler extends BaseTypeHandler<GeometryCollection> {
private static final WKTReader wktReader = new WKTReader();
@Override
public void setNonNullParameter(PreparedStatement ps, int i, GeometryCollection parameter, JdbcType jdbcType) throws SQLException {
ps.setString(i, parameter.toText());
}
@Override
public GeometryCollection getNullableResult(ResultSet rs, String columnName) throws SQLException {
String wkt = rs.getString(columnName);
try {
return wkt != null ? (GeometryCollection) wktReader.read(wkt) : null;
} catch (ParseException e) {
throw new RuntimeException(e);
}
}
@Override
public GeometryCollection getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
String wkt = rs.getString(columnIndex);
try {
return wkt != null ? (GeometryCollection) wktReader.read(wkt) : null;
} catch (ParseException e) {
throw new RuntimeException(e);
}
}
@Override
public GeometryCollection getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
String wkt = cs.getString(columnIndex);
try {
return wkt != null ? (GeometryCollection) wktReader.read(wkt) : null;
} catch (ParseException e) {
throw new RuntimeException(e);
}
}
}

复制代码

package top.emanjusaka.mapper;
import top.emanjusaka.test.CarWorkAreaDO;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.common.Mapper;
import java.util.List;
public interface CarWorkAreaMapper extends Mapper<CarWorkAreaDO> {
/**
* 插入数据
*
* @param carWorkArea
* @return:
*/
int insertCustom(CarWorkAreaDO carWorkArea);
}

复制代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="top.emanjusaka.mapper.CarWorkAreaMapper">
<resultMap type="com.iles.models.car.CarWorkAreaDO" id="carWorkAreaResult">
<result property="id" column="id"/>
<result property="areaGeom" column="area_geom" javaType="org.locationtech.jts.geom.GeometryCollection"
jdbcType="OTHER"
typeHandler="top.emanjusaka.handler.GeometryCollectionTypeHandler"/>
</resultMap>
<insert id="insertCustom" parameterType="com.iles.models.car.CarWorkAreaDO">
insert into
car_work_area(id,area_geom)
values
(#{id},ST_GeomCollFromText(#{areaGeom,typeHandler=top.emanjusaka.handler.GeometryCollectionTypeHandler}))
</insert>
</mapper>

复制代码