Oracle查询出来的集合 Map中的Key大写的问题

最新推荐文章于 2022-08-23 11:30:08 发布

未知的羊

最新推荐文章于 2022-08-23 11:30:08 发布

阅读量1.2k

点赞数

文章标签： java

本文链接：https://blog.csdn.net/weixin_45742139/article/details/102566649

版权

		StringBuilder sb = new StringBuilder(); 
		sb.append("   SELECT       ");
		sb.append("   CONTCODE AS \"contcode\",  CONTNAME AS \"contname\",  SIGNDATE AS \"signdate\" ");
		sb.append("   ,SIGNAGENCY AS \"signagency\",  CONSTATUS AS \"constatus\",  CONTAMT AS \"contamt\" ");
		sb.append("   ,BEGINPAYAMT AS \"beginpayamt\",  CONTPAYAMT AS \"contpayamt\",  PERCENTAGEPAID AS \"percentagepaid\" ");
		sb.append("   FROM CTM_T_CONTRACT C WHERE C.GUID = ?   ");
		List<Map<String,Object>> list = this.queryForList(sb.toString(), new String[] {contcode});
		return list;```
 

 1. **如上图所示  可以将sql 查询出来的Map 的key  保持小写 用来解决某些框架问题  需要小写入参**