Python 官方文档:入门教程 => 点击学习
亲测: SELECT DEPTNO as "deptno",DEPTNAME,DEPTGRADE,PARENTDEPT FROM VMGR_DEPT
SELECT DEPTNO as "deptno",DEPTNAME,DEPTGRADE,PARENTDEPT
FROM VMGR_DEPT
ORDER BY DEPTGRADE,DEPTNO
<select id="selectBlogRetHashMap" parameterType="int" resultType="map">
SELECT id AS "id", title AS "title", content AS "content" FROM Blog WHERE id = #{id}
</select>
public class Snippet {
public static Map<String, Object> transfORMUpperCase(Map<String, Object> orgMap) {
Map<String, Object> resultMap = new HashMap<>();
if (orgMap == null || orgMap.isEmpty()) {
return resultMap;
}
Set<String> keySet = orgMap.keySet();
for (String key : keySet) {
String newKey = key.toLowerCase();
newKey = newKey.replace("_", "");
resultMap.put(newKey, orgMap.get(key));
}
return resultMap;
}
}
在查询的字段后加别名
user_id as “userId”
注意:别名必须加双引号
<select id="queryMaxPriceAAndUser" parameterType="java.lang.String" resultType="java.util.HashMap">
SELECT A.SELL_PRICE as "price", B.USER_ID as "userId"
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
</select>
以上为个人经验,希望能给大家一个参考,也希望大家多多支持编程网。
--结束END--
本文标题: mybatis返回类型map时如何将key大写转为小写
本文链接: https://www.lsjlt.com/news/129408.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0