java调用存储过程返回map组装List(含SqlServer存储过程).docx

《java调用存储过程返回map组装List(含SqlServer存储过程).docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Action层publicActionForwardgetProjectPayMoneyJsonByPayType(ActionMappingmapping,ActionFormform,HttpServletRequestrequest,HttpServletResponseresponse)throwsException{JiLiangZhiFuServicejiLiangZhiFuService=this.getServiceLocator().getJiLiangZhiFuService();inty

2、ear=Integer.parseInt(request.getParameter("year"));Stringdata=jiLiangZhiFuService.getProjectPayMoneyJsonByPayType(year);response.setContentType("text/xml");response.getWriter().write(data);response.getWriter().flush();response.getWriter().close();returnnull

3、;}Service层publicStringgetProjectPayMoneyJsonByPayType(intyear){doubleallTotal=0;Mapmap=jiLiangZhiFuDao.getProjectPayMoneyByPayType(year);ListdataItemList=SessionBean.getServiceLocator().getDataItemService().getAllDataItemByTypeId("payType");Mapmap

4、_ep=newHashMap();map_ep.put("account_id",2);map_ep.put("isSelectTwoStageProject",true);ListengineeringPhaseList=SessionBean.getServiceLocator().getEngineeringPhaseService().getEngineeringPhaseList(map_ep).getData();Mapmap_type=newHashMap()

5、;StringBuildersb=newStringBuilder();sb.append(""+engineeringPhaseList.size()+"");for(EngineeringPhaseengineeringPhase:engineeringPhaseList){Stringep_id=engineeringPhase.getEp_id();sb.append("");sb.append(""+e

6、p_id+"");sb.append(""+engineeringPhase.getEp_name()+"");for(DataItemdataItem:dataItemList){Stringdi_id=dataItem.getId();Stringr_key=ep_id+","+di_id;if(map.containsKey(r_key)){map_type.put(di_id,map_type.containsKey(di_id)?(Double.

7、parseDouble(map_type.get(di_id).toString())+Double.parseDouble(map.get(r_key).toString())):Double.parseDouble(map.get(r_key).toString()));sb.append("<"+di_id+">"+map.get(r_key)+"");}}//项目支付金额合计sb.append(""+map.get(engineeringPhase.

8、getEp_id())+"");allTotal+=Double.parseDouble(map.get(engineeringPhase.getEp_id()).toString());sb.append("");}//某支付类别金额合计sb.append("");sb.append