Echart 作图java程序最近一周交易记录

最新推荐文章于 2024-01-18 16:39:04 发布

莫知莫言

最新推荐文章于 2024-01-18 16:39:04 发布

阅读量266

点赞数

分类专栏： java 文章标签： echart java

本文链接：https://blog.csdn.net/weixin_43190879/article/details/86063819

版权

java 专栏收录该内容

29 篇文章 1 订阅

订阅专栏

Echart 作图java程序最近一周交易记录
直接上代码
//页面隐藏域获取后台controller传的值

在这里插入图片描述
页面js代码

页面完成
controller里的某方法的代码获取countsStr
以下是controller某方法

 String countsStr = "";
		Calendar calendar = Calendar.getInstance();
        while (calendar.get(Calendar.DAY_OF_WEEK) != Calendar.MONDAY) {
            calendar.add(Calendar.DAY_OF_WEEK, -1);
        }
        for (int i = 0; i < 7; i++) {
        	String dateStr = sff.format(calendar.getTime());
        	Integer count = Db.queryInt("SELECT COUNT(id) FROM shop_order WHERE createDate>='"+dateStr

+" 00:00:00' AND createDate<='"+dateStr+" 23:59:59' AND status!='"+CommonAttribute.ORDER_STATUS_CANCELED

+"'");
        	count += Db.queryInt("SELECT COUNT(id) FROM shop_pointorder WHERE createDate>='"+dateStr+" 

00:00:00' AND createDate<='"+dateStr+" 23:59:59' AND status!='"+CommonAttribute.ORDER_STATUS_CANCELED+"'");
        	if("".equals(countsStr)){
        		countsStr = count.toString();
        	}else{
        		countsStr += ","+count.toString();
        	}
            calendar.add(Calendar.DATE, 1);
        }
        setAttr("countsStr", countsStr);//把数据返回页面