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 保持小写 用来解决某些框架问题 需要小写入参**
Oracle查询出来的集合 Map中的Key大写的问题
最新推荐文章于 2022-08-23 11:30:08 发布