mybatis返回类型map时如何将key大写转为小写

亲测：

SELECT DEPTNO as \"deptno\ FROM VMGR_DEPT

ORDER BY DEPTGRADE,DEPTNO

别⼈案例：

SELECT id AS \"id\

纯java实现⽅法(推荐)：

public class Snippet {

public static Map transformUpperCase(Map orgMap) { Map resultMap = new HashMap<>();

if (orgMap == null || orgMap.isEmpty()) { return resultMap; }

Set keySet = orgMap.keySet(); for (String key : keySet) {

String newKey = key.toLowerCase(); newKey = newKey.replace(\"_\

resultMap.put(newKey, orgMap.get(key)); }

return resultMap; }}

mybatis映射map返回的全是⼤写

解决⽅法

在查询的字段后加别名

user_id as “userId”

注意:别名必须加双引号

SELECT A.SELL_PRICE as \"price\

FROM QLYY_SELL_AUCTION_RECORD A, QLYY_SELL_APPLY B WHERE A.SELL_PRICE = (SELECT MAX(SELL_PRICE) FROM QLYY_SELL_AUCTION_RECORD WHERE SELL_PROGRAM_ID = #{programId}) AND A.SELL_PROGRAM_ID = #{programId} AND B.APPLY_CODE = A.SELL_USER

以上为个⼈经验，希望能给⼤家⼀个参考，也希望⼤家多多⽀持。