springcloud 参数接收## 标题springcloud ## map
新入职场小白,java方面真是不通,那就记录一下自己每天做了什么
springcloud 参数接收
这里做的功能点是查询一张表格里的两个字段总和和总数赋值给页面中的两个单独字段,因为数据库表中没有想要页面中的字段所以用map接收:
controller:
@GetMapping("/query/total")
@ApiOperation(value = “查询总和”, notes = “”)
protected ResultDto<Map<String,Object>> selecttotal(String itemNo) {
Map<String, Object> selecttotal = dispItemCustMidService.selecttotal(itemNo);
return new ResultDto<Map<String,Object>>(selecttotal);
}
service:
public Map<String,Object> selecttotal(String itemNo) {
Map<String,Object> sumMap = dispItemCustMidMapper.selecttotal(itemNo);
return sumMap;
}
mapper:
Map<String,Object> selecttotal(@Param(“itemNo”) String itemNo);
xml:
<select id="selecttotal" parameterType="cn.com.yusys.yusp.commons.mapper.QueryModel" resultType="java.util.Map">
select
count(CUST_NO) AS TOTAL_CUST,SUM(BASE_DEBT_BAL) AS TOTAL_BASE_DEBT_BAL
from DISP_ITEM_CUST_MID
where
ITEM_NO = #{itemNo,jdbcType=VARCHAR}
</select>