定时任务1

定时任务

1. repo层

@Modifying：批量修改的注解
把过期的队伍状态修改为0

    @Modifying
    @Query(value = "UPDATE ys_simple_team SET status=0,modify_time=DATE_FORMAT(NOW(),'%Y-%m-%d %H:%m:%s') WHERE game_date<(select date_format(now(),'%y-%m-%d'))",nativeQuery = true)
    void updateExpiredTeamStatus();

2. Service层/ServiceImpl层

void updateExpiredTeamStatus();

    @Override
    public void updateExpiredTeamStatus() {
        simpleTeamRepo.updateExpiredTeamStatus();
    }

3. Job定时任务启动层

@Slf4j
public class TeamOverTimeJob extends QuartzJobBean{

    private ScriptTeamService scriptTeamService;
    @Override
    @Scheduled(cron = "0 0 0 * * ?")
    protected void executeInternal(JobExecutionContext jobExecutionContext) {
        log.info("组队到期定时任务开始执行......");
        try {
        }catch (Exception e){
            log.error(new Date()+"组队到期定时任务开始执行...");
            scriptTeamService.updateExpiredTeamStatus();
            e.printStackTrace();
        }
    }
}