栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

java统计一段时间内的数据折线图数据(一天内的各小时,一段时间天数内)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

java统计一段时间内的数据折线图数据(一天内的各小时,一段时间天数内)

}

}

throw new RrkException(“typeId查询类型必填,且只能为(1:今日,2:7天,3:30天,4:全部,5:其他自定义)”);

}

private Map getCustomizeChart(Long userId, String startTime, String endTime) throws Exception {

Map map = new HashMap<>(4);

Date frontDay = NewDateUtil.stringToDate(startTime, “yyyy-MM-dd HH:mm:ss”);

Date endDay = NewDateUtil.stringToDate(endTime, “yyyy-MM-dd HH:mm:ss”);

// System.out.println(“frontDay=” + frontDay);

// System.out.println(“endDay=” + endDay);

List timeList2 = NewDateUtil.findDates(frontDay, endDay);

List dateList = new ArrayList<>(12);

List fansCount = new ArrayList<>(12);

for (int i = 0; i < timeList2.size() - 1; i++) {

List fansList = getFansCount(userId, NewDateUtil.getDayStartTime2(timeList2.get(i)), NewDateUtil.getDayEndTime2(timeList2.get(i)));

fansCount.add(fansList.size());

String formatDate = DateUtils.formatDate(timeList2.get(i), “yyyy-MM-dd HH:mm:ss”);

dateList.add(formatDate);

// System.out.println(timeList2.get(i));

// System.out.println(“frontDay=” + NewDateUtil.getDayStartTime2(timeList2.get(i)));

// System.out.println(“endDay=” + NewDateUtil.getDayEndTime2(timeList2.get(i)));

}

map.put(“dateList”, dateList);

map.put(“fansCount”, fansCount);

return map;

}

private Map getWeekChart(Long userId, int count) {

Map map = new HashMap<>(4);

Date frontDay = NewDateUtil.getFrontDay(new Date(), count);

// System.out.println(“frontDay=” + frontDay);

List timeList2 = NewDateUtil.findDates(frontDay, new Date());

List dateList = new ArrayList<>(12);

List fansCount = new ArrayList<>(12);

for (int i = 0; i < timeList2.size() - 1; i++) {

Date dayStartTime = NewDateUtil.getDayStartTime2(timeList2.get(i));

Date dayEndTime = NewDateUtil.getDayEndTime2(timeList2.get(i));

List fansList = getFansCount(userId, dayStartTime, dayEndTime);

fansCount.add(fansList.size());

String formatDate = DateUtils.formatDate(timeList2.get(i), “yyyy-MM-dd HH:mm:ss”);

dateList.add(formatDate);

// System.out.println(timeList2.get(i));

}

map.put(“dateList”, dateList);

map.put(“fansCount”, fansCount);

return map;

}

private Map getTodayChart(Date dateBegin, Long userId) throws Exception {

Map

《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》

【docs.qq.com/doc/DSmxTbFJ1cmN1R2dB】 完整内容开源分享

map = new HashMap<>(4);

//获取今天内的各时间点

List todayHours = NewDateUtil.getTodayHours(dateBegin, 4);

List dateList = new ArrayList<>(12);

List fansCount = new ArrayList<>(12);

for (int i = 0; i < todayHours.size() - 1; i++) {

List fansList = getFansCount(userId, todayHours.get(i), todayHours.get(i + 1));

fansCount.add(fansList.size());

String formatDate = DateUtils.formatDate(todayHours.get(i + 1), “yyyy-MM-dd HH:mm:ss”);

dateList.add(formatDate);

}

map.put(“dateList”, dateList);

map.put(“fansCount”, fansCount);

return map;

}

用到的日期工具类

//获取某个日期的开始时间

public static Date getDayStartTime2(Date d) {

Calendar calendar = Calendar.getInstance();

if (null != d) {

calendar.setTime(d);

}

calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH), calendar.get(Calendar.DAY_OF_MONTH), 0, 0, 0);

calendar.set(Calendar.MILLISECOND, 0);

return calendar.getTime();

}

//获取某个日期的结束时间

public static Date getDayEndTime2(Date d) {

Calendar calendar = Calendar.getInstance();

if (null != d) {

calendar.setTime(d);

}

calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH), calendar.get(Calendar.DAY_OF_MONTH), 23, 59, 59);

calendar.set(Calendar.MILLISECOND, 999);

return calendar.getTime();

}

//JAVA获取某段时间内的所有日期

public static List findDates(Date dStart, Date dEnd) {

Calendar cStart = Calendar.getInstance();

cStart.setTime(dStart);

List dateList = new ArrayList<>();

//别忘了,把起始日期加上

dateList.add(dStart);

// 此日期是否在指定日期之后

while (dEnd.after(cStart.getTime())) {

// 根据日历的规则,为给定的日历字段添加或减去指定的时间量

cStart.add(Calendar.DAY_OF_MONTH, 1);

dateList.add(cStart.getTime());

}

return dateList;

}

// string类型转换为date类型

// strTime要转换的string类型的时间,formatType要转换的格式yyyy-MM-dd HH:mm:ss//yyyy年MM月dd日

// HH时mm分ss秒,

// strTime的时间格式必须要与formatType的时间格式相同

public static Date stringToDate(String strTime, String formatType)

throws ParseException {

SimpleDateFormat formatter = new SimpleDateFormat(formatType);

Date date = null;

date = formatter.parse(strTime);

return date;

}

public static String formatDate(Date date, String pattern) {

String formatDate = null;

if (date != null){

// if (StringUtils.isNotBlank(pattern)) {

// formatDate = DateFormatUtils.format(date, pattern);

// } else {

// formatDate = DateFormatUtils.format(date, “yyyy-MM-dd”);

// }

if (StringUtils.isBlank(pattern)) {

pattern = “yyyy-MM-dd”;

}

formatDate = FastDateFormat.getInstance(pattern).format(date);

}

return formatDate;

}

// date类型转换为String类型

// formatType格式为yyyy-MM-dd HH:mm:ss//yyyy年MM月dd日 HH时mm分ss秒

// data Date类型的时间

public static String dateToString(Date data, String formatType) {

return new SimpleDateFormat(formatType).format(data);

}

工具类补充:

public class NewDateUtil {

//获取当天的开始时间

public static Date getDayBegin() {

Calendar cal = new GregorianCalendar();

cal.set(Calendar.HOUR_OF_DAY, 0);

cal.set(Calendar.MINUTE, 0);

cal.set(Calendar.SECOND, 0);

cal.set(Calendar.MILLISECOND, 0);

return cal.getTime();

}

//返回某个日期前几天的日期

public static Date getFrontDay(Date date, int i) {

Calendar cal = new GregorianCalendar();

cal.setTime(date);

cal.set(Calendar.DATE, cal.get(Calendar.DATE) - i);

return cal.getTime();

}

/**

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/658849.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号