SpringBoot 较为简单的定时任务

2022-07-31,,

  • 创建定时任务类 每一分钟执行一次

@Component
@EnableScheduling
public class AllianceDiscountsActivityJob {
    @Autowired
    private AllianceDiscountsActivityService allianceDiscountsActivityService;

   // @Scheduled(cron = "0 0 0 * * ?")
    @Scheduled(cron = "0 */1 * * * ?")
    public void checkAllianceDiscounts()throws  Exception{
        allianceDiscountsActivityService.checkAllianceDiscounts();
    }
}

  • 创建service

public interface AllianceDiscountsActivityService {

    void checkAllianceDiscounts() throws  Exception;
}

  • 创建serviceImpl
 @Override
    public void checkAllianceDiscounts() throws Exception {
        int num=allianceDiscountsActivityMapper.checkAllianceDiscountActivity();
    }
  • 之后创建mapper mapper mybatis-mapper 用来实现定时任务的方法
public interface AllianceDiscountsActivityMapper {
        int checkAllianceDiscountActivity();
}

 <update id="checkAllianceDiscountActivity" parameterType="java.lang.String">
    update alliance set status=3 WHERE start_time  <![CDATA[<=]]> NOW() and is_del=0 and status=1;
    update alliance set status=2 WHERE end_time  <![CDATA[<=]]> NOW() and is_del=0 and status=3;
  </update>

本文地址:https://blog.csdn.net/weixin_47287824/article/details/107578254

《SpringBoot 较为简单的定时任务.doc》

下载本文的Word格式文档,以方便收藏与打印。