查询持续10天的账单

wyxhdl

已于 2024-01-16 16:14:33 修改

阅读量353

点赞数 6

文章标签： java 开发语言

于 2024-01-12 17:03:01 首次发布

本文链接：https://blog.csdn.net/wyxhdl/article/details/135557655

版权

本文展示了如何使用Java编程语言处理交易时间数据，包括将字符串转换为LocalDate对象，对日期进行排序，找出最长连续交易日，并在特定条件下查询最近的交易记录。

摘要由CSDN通过智能技术生成

String[] trades22 = {"2024-02-25 00:00:00", "2024-02-26 00:00:00", "2024-02-27 00:00:00",
"2024-02-28 00:00:00", "2024-02-29 00:00:00", "2024-03-01 00:00:00",
"2024-03-02 00:00:00", "2024-03-03 00:00:00", "2024-03-04 00:00:00",
"2024-02-09 00:00:00", "2024-02-12 00:00:00", "2024-02-02 00:00:00",
"2024-02-01 00:00:00", "2024-02-24 00:00:00", "2022-02-24 00:00:00", "2022-04-24 00:00:00", "2023-07-24 00:00:00"};

//先定义时间格式
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
//String数组转localDate数组
LocalDate[] localDates=new LocalDate[trades22.length];
for (int i=0;i<localDates.length;i++){
localDates[i]= LocalDate.parse(trades22[i], formatter);
}
//排序
Arrays.sort(localDates);
//定义最大数
int max=0;
//当前长度
int ruutenLength=1;
LocalDate localDate = localDates[0];
for (int i=1;i<localDates.length;i++){
//localDates[i]比较前一天的明天
if (localDates[i].equals(localDates[i-1].plusDays(1))){
ruutenLength++;
}else {
ruutenLength=1;
}
if (ruutenLength>max){
max=ruutenLength;
localDate=localDates[i-max+1];
}
}

for (int i=0;i<max;i++){

//控制查询几单

if(i>=5){
System.out.println(localDate.plusDays(i));
}

}

}

/**
* 获取当前月的上月
* @return 返回短时间字符串格式yyyy-MM
*/
public static String getStringLastMonth() {
Calendar c = Calendar.getInstance();
c.add(Calendar.MONTH, -1);
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM");
return format.format(c.getTime());
}