一、Spring Task介绍
二、Spring Task_cron表达式
在线Cron表达式生成器
https://cron.qqe2.com/
三、入门案例
四、订单状态定时处理
package com.sky.task;import com.sky.entity.Orders;
import com.sky.mapper.OrderMapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;import java.time.LocalDateTime;
import java.util.List;@Component
@Slf4j
public class OrderTask {@AutowiredOrderMapper orderMapper;/*** 处理支付超时订单的方法* */@Scheduled(cron = "0 * * * * ? ")public void processTimeoutOrder(){log.info("处理超时订单：{}", LocalDateTime.now());//查询超时订单//select * from order where status = ? and order_time < (当前时间-15分钟)List<Orders> orderList = orderMapper.getByStatusAndOrderTimeLT(Orders.UN_PAID, LocalDateTime.now().plusMinutes(-15));if(orderList != null && orderList.size()>0){for (Orders orders : orderList) {orders.setStatus(Orders.CANCELLED);orders.setCancelReason("订单超时，自动取消");orders.setCancelTime(LocalDateTime.now());orderMapper.update(orders);}}}/*** 处理派送超时订单* */@Scheduled(cron = "0 0 1 * * ?")public void processDeliveryOrder(){log.info("处理派送超时订单：{}",LocalDateTime.now());List<Orders> ordersList = orderMapper.getByStatusAndOrderTimeLT(Orders.DELIVERY_IN_PROGRESS, LocalDateTime.now().plusMinutes(-60));for (Orders orders : ordersList) {orders.setStatus(Orders.COMPLETED);orderMapper.update(orders);}}
}