Oracle迁移到高斯查询字段默认小写的解决办法

import org.apache.ibatis.executor.executor;
import org.apache.ibatis.mapping.mappedstatement;
import org.apache.ibatis.plugin.*;
import org.apache.ibatis.session.resulthandler;
import org.apache.ibatis.session.rowbounds;
import java.lang.reflect.method;
import java.util.*;
/**
 * @desc map接收查询结果，将map的key转为大写，解决从oracle切换高斯后，高斯默认小写，jsp字段绑定异常，生成推送文件字段变化等问题
 * {@link mapkeyuppercase}
 */
@intercepts({
        @signature(type = executor.class, method = "query", args = {
                mappedstatement.class, object.class, rowbounds.class,
                resulthandler.class})})
public class mapkeyuppercaseinterceptor implements interceptor {
    @override
    public object intercept(invocation invocation) throws throwable {
        // 执行原方法，获取返回结果
        object result = invocation.proceed();
        // 获取当前执行的mapper方法，executor.query的第一个参数为mappedstatement
        mappedstatement mappedstatement = (mappedstatement) invocation.getargs()[0];
        // 方法全路径：com.example.mapper.usermapper.selectusermap
        string methodname = mappedstatement.getid();
        // 通过反射获取mapper接口的方法，检查是否有自定义注解
        string classname = methodname.substring(0, methodname.lastindexof("."));
        string simplemethodname = methodname.substring(methodname.lastindexof(".") + 1);
        class<?> mapperinterface = class.forname(classname);
        method method = arrays.stream(mapperinterface.getmethods())
                .filter(m -> m.getname().equals(simplemethodname))
                .findfirst().orelse(null);
        // 只对配置了自定义注解的方法生效
        if (method != null && method.isannotationpresent(mapkeyuppercase.class)) {
            // 返回结果是list，处理每一项
            if (result instanceof list) {
                list<map<?, ?>> resultlist = (list<map<?, ?>>) result;
                for (map<?, ?> map : resultlist) {
                    // 原记录索引替换为新记录
                    resultlist.set(resultlist.indexof(map), upcaseresultmapkey(map));
                }
                return resultlist;
            }
            // 返回单条记录
            else if (result instanceof map) {
                return upcaseresultmapkey((map<?, ?>) result);
            }
        }
        return result;
    }
    /**
     * @param resultmap 初始查询结果
     * @return java.util.hashmap<java.lang.object, java.lang.object>
     * @desc 将map接收的查询结果的key转为大写
     */
    private hashmap<object, object> upcaseresultmapkey(map<?, ?> resultmap) {
        hashmap<object, object> newmap = new hashmap<>();
        for (map.entry<?, ?> entry : resultmap.entryset()) {
            object key = entry.getkey();
            object value = entry.getvalue();
            if (key instanceof string) {
                newmap.put(((string) key).touppercase(), value);
            } else {
                newmap.put(key, value);
            }
        }
        return newmap;
    }
    @override
    public object plugin(object target) {
        if (target instanceof executor) {
            return plugin.wrap(target, this);
        }
        return target;
    }
    @override
    public void setproperties(properties properties) {
    }
}

import java.lang.annotation.*;
/**
 * @desc 声明在mapper中以map接收查询结果的查询方法上，标明该方法返回字段名称大写
 * {@link mapkeyuppercaseinterceptor}
 */
@target(elementtype.method)
@retention(retentionpolicy.runtime)
@documented
public @interface mapkeyuppercase {
}

<configuration>
    <plugins>
        <plugin interceptor="com.example.mapkeyuppercaseinterceptor">
        </plugin>
    </plugins>
</configuration>

@configuration
public class mybatisconfig {
    @bean
    public mapkeyuppercaseinterceptor mapkeyuppercaseinterceptor() {
        return new mapkeyuppercaseinterceptor();
    }
    @bean
    public sqlsessionfactory sqlsessionfactory(datasource datasource, mapkeyuppercaseinterceptor mapkeyuppercaseinterceptor) throws exception {
        sqlsessionfactorybean factorybean = new sqlsessionfactorybean();
        factorybean.setdatasource(datasource);
        factorybean.setplugins(mapkeyuppercaseinterceptor); // 注册拦截器
        return factorybean.getobject();
    }
}

@mapkeyuppercase
map<string, object> getmap();
@mapkeyuppercase
list<map<string, object>> getmaplist();
@mapkeyuppercase
page<hashmap<string, string>> querymapbypage(rowbounds rb);