1

13693261870

2022-11-02 e54ef5e185c46a35641dce47b792c4f20b98879a

 src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java

@@ -1,21 +1,21 @@
package com.lf.server.mapper.all;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 空间基础Mapper
 * @author WWW
 * @param <T>
 * @param <T> 泛型
 */
public interface GeomBaseMapper<T> extends BaseMapper<T> {
public interface GeomBaseMapper<T> extends BasicMapper<T> {
    /**
     * 根据ID查询WKT
     *
     * @param gid
     * @return
     * @param tab 表名
     * @param gid GID
     * @return WKT
     */
    @Select("select st_astext(geom) geom from bd.dlg_agnp where gid = #{gid}")
    public String selectWktById(@Param("gid") Integer gid);
    @Select("select st_astext(geom) geom from ${tab} where gid = #{gid}")
    public String selectWktById(@Param("tab") String tab, @Param("gid") Integer gid);
}