//获取日期
String dayTime="2020-6-18"
//年份
int y= Integer.parseInt(dayTime.substring(0,4));
//月份
int m= Integer.parseInt(dayTime.substring(5,7));
//获取的一个月的天数
int dayCount=InsureAfterController.getMonthDay(y,m);
//根据输入的年、月获取这个月的天数
public static int getMonthDay(int y, int m) {
int day = 0;
switch (m) {
case 1:
case 3:
case 5:
case 7:
case 8:
case 10:
case 12:
day = 31;
break;
case 4:
case 6:
case 9:
case 11:
day = 30;
break;
case 2:// 判断闰年的方法,能被4整除,
if (((y % 4 == 0) && !(y % 100 == 0)) || (y % 400 == 0)) {
// System.out.println("29天");
day = 29;
} else {
// System.out.println("28天");
day = 28;
}
break;
}
return day;
}
java 如果要根据该月天数做循环获取数据要注意
int i;
ArrayList<Object> list = new ArrayList<>()
for ( i=1;i<=dayCount;i++){
//每日日期
if (i<10){
dt= dayTime+"-0"+i;
}else {
dt= dayTime+"-"+i;
}
//道路救援已完成订单
Integer daoLuConplete=insureRealOrderService.getAllInsureOrderTimes("道路救援",type,"2",dt);
//道路救援已取消订单
Integer daoLuCancel=insureRealOrderService.getAllInsureOrderTimes("道路救援",type,"-2",dt);
//道路救援空驶订单
Integer daoLuEmpty=insureRealOrderService.getAllInsureOrderTimes("道路救援",type,"-3",dt);
list.add(daoLuConplete+","+daoLuCancel+","+daoLuEmpty);
}
一定记得要做判断日期2020-09 小于10日时,查询数据要做判断把0拼接上。
if (i<10){
dt= dayTime+"-0"+i;
}else {
dt= dayTime+"-"+i;
}