效果图示如下
后台代码用的框架是SSM 双Y轴根据后台数据展示
大致代码如下:
List<Map> findqushi(@Param("date_id") String date_id, @Param("goodsId") String goodsId);
//决定Y轴的最值
List<Map> getgoodsCost(@Param("goodsId") String goodsId);
二、service
//echarts需要的后台数据
public List<Map> findqushi(String date_id, String goodsId) {
return tradeDao.findqushi(date_id, goodsId);
}
三、Controller
@ResponseBody
@RequestMapping(value = "/qushi", method = RequestMethod.POST)
@RequiresPermissions("trade")
public void findqushi(String goodsId) {
List<Map> goodsCost = tradeDao.getgoodsCost(goodsId);
String date_id = null;
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
Date date = new Date();
date_id = simpleDateFormat.format(date); // 当天
List<Map> entityList = tradeService.findqushi(date_id, goodsId);
Map<String, Object> map = new HashMap<>();
map.put("rows", entityList);
map.put("goodsCost", goodsCost);
System.out.println(map.toString());
try {
response.getWriter().write(new String(JSON.toJSONString(map).getBytes(), "UTF-8"));
request.setCharacterEncoding("UTF-8");
} catch (Exception e) {
e.printStackTrace();
}
}
四、xml
<select id="findqushi" resultType="java.util.Map">
SELECT
DATE_FORMAT(t.buy_time,'%Y-%c-%d %H:%i:%s')
as buyTime,
t.buy_point as buyPoint,
t.hold_num as holdNum
FROM
tb_trade t LEFT
JOIN
tb_user tu
ON
t.user_id
=
tu.id LEFT JOIN
tb_ml3_agent
tma on
tma.agent_invite_code &#