Java 参数转换(工具类)
1 /** 2 * 参数转换 3 */ 4 public class RptUtils { 5 6 public static List<List<Object>> convert(List<Map<String, Object>> list) { 7 List<List<Object>> arrayList = new ArrayList<>(); 8 if (CollectionUtils.isEmpty(list)) { 9 return arrayList; 10 } 11 list.forEach(stringObjectMap -> { 12 arrayList.add(new ArrayList(stringObjectMap.values())); 13 }); 14 return arrayList; 15 } 16 }
1.转成后的结果:注前端打印(consloe.log(" "))
一、mapper层 (参数根据自己需要添加)注:返回值类型
/** * #统计个人收款情况 * @param startTime * @param endTime * @return */ List<Map<String,Object>> selectSysCrmPersonalCollectionCount(@Param("startTime") String startTime,@Param("endTime") String endTime);
二、mapper.xml文件; 注:返回值类型不要弄错
1 <!-- #统计个人收款情况 --> 2 <select id="selectSysCrmPersonalCollectionCount" resultType="java.util.LinkedHashMap"> 3 select commissioner,SUM(money) AS money from sys_crm_collection 4 where collection_date >= #{startTime} and collection_date <= #{endTime} 5 GROUP BY commissioner 6 ORDER BY money DESC 7 LIMIT 10 8 </select>
三、service层
1 /** 2 * #统计个人收款情况 3 * @param startTime 4 * @param endTime 5 * @return 6 */ 7 List<List<Object>> selectSysCrmPersonalCollectionCount(String startTime,String endTime);
Impl 实现类: (是上面封装的工具类【将参数转换】)
/** * #统计个人收款情况 * @param startTime * @param endTime * @return */ @Override public List<List<Object>> selectSysCrmPersonalCollectionCount(String startTime, String endTime) { return RptUtils.convert(countMapper.selectSysCrmPersonalCollectionCount(startTime,endTime)); }
四:Controller控制层
/** * #统计个人收款情况 * @param startTime * @param endTime * @return */ @GetMapping("/sysCrmPersonalCollectionCount/{startTime}/{endTime}") public AjaxResult sysCrmPersonalCollectionCount(@PathVariable("startTime")String startTime,@PathVariable("endTime")String endTime){ return AjaxResult.success(countService.selectSysCrmPersonalCollectionCount(startTime,endTime)); }