mybatis-plus 处理JGeometry数据类型

最新推荐文章于 2024-07-15 16:48:12 发布

格陵兰鲨僧

最新推荐文章于 2024-07-15 16:48:12 发布

阅读量405

点赞数 2

文章标签： java mybatis 几何学 oracle spring boot

本文链接：https://blog.youkuaiyun.com/qq_35653053/article/details/116265830

版权

mybatis-plus 处理JGeometry数据类型

1.自定义typehandler类，用于处理JGeometry数据类型

@MappedTypes({JGeometry.class})
@MappedJdbcTypes({JdbcType.STRUCT})
public class SdoTypeHandler implements TypeHandler<JGeometry> {

    @Override
    public void setParameter(PreparedStatement ps, int i, JGeometry parameter, JdbcType jdbcType) throws SQLException {
        STRUCT dbObject = JGeometry.store(parameter, ps.getConnection());
        ps.setObject(i, dbObject);
    }

    @Override
    public JGeometry getResult(ResultSet rs, String columnName) throws SQLException {
        STRUCT st = (STRUCT) rs.getObject(columnName);
        if (st != null) {
            JGeometry load = JGeometry.load(st);
            return load;
        }
        return null;
    }

    @Override
    public JGeometry getResult(ResultSet rs, int columnIndex) throws SQLException {
        STRUCT st = (STRUCT) rs.getObject(columnIndex);
        if (st != null) {
            return JGeometry.load(st);
        }
        return null;
    }

    @Override
    public JGeometry getResult(CallableStatement cs, int columnIndex) throws SQLException {
        STRUCT st = (STRUCT) cs.getObject(columnIndex);
        if (st != null) {
            return JGeometry.load(st);
        }
        return null;
    }
}

2.相应属性配置

    @TableField(typeHandler = SdoTypeHandler.class,value = "SDODATA")
    private JGeometry sdodata;

3.配置application.yml,指定自定义typehandler所在

mybatis-plus:
    #typehandler所在包名
    type-handlers-package: com.package.handler