使用Mybatis通用Mapper接口导出数据库视图（单表数据）的实现

1.自定义mapper接口（泛型）

public interface SelectMapMapper{
    @SelectProvider(type = MySelectProvider.class, method = "dynamicSQL")
    List<Map> selectAllWithMap(String tableName);
}

2.自定义查询模板类

public class MySelectProvider extends MapperTemplate{
    public MySelectProvider(Class<?> mapperClass, MapperHelper mapperHelper) {
        super(mapperClass, mapperHelper);
    }

    public String selectAllWithMap(MappedStatement ms) {
        StringBuilder sql = new StringBuilder();
        sql.append("select * from  ");
        String str="${@com.xxx.common.mybatis.ognl.GetTableName@getName(value)}\n";//匹配正则方法 
        sql.append(str);
        String string=sql.toString();
        return string;
    }
}

3.模块mapper继承自定义mapper接口，即可调用

public interface ViewExportMapper extends SelectMapMapper{}

[接口文档]

https://mapperhelper.github.io/all/
https://blog.youkuaiyun.com/shadowsick/article/details/53664829
http://blog.tingyun.com/web/article/detail/1188