转载自:https://blog.csdn.net/weixin_47287824/article/details/107578254
- 创建定时任务类 每一分钟执行一次
@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 {
<span class="token keyword">void</span> <span class="token function">checkAllianceDiscounts</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token keyword">throws</span> Exception<span class="token punctuation">;</span>
}
- 创建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>
</div><div><div></div></div>
<link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-60ecaf1f42.css" rel="stylesheet">
</div>
</article>