在AutoDeleteLogTask類中
將
@Autowired
private ScheduleJobService scheduleJobService;
修改為
@Autowired
private ScheduleJobLogService scheduleJobLogService;
將
scheduleJobService.autoDeleteLog();
修改為
scheduleJobLogService.autoDeleteLog();
在ScheduleJobService類添加方法
/**
- 自動刪除日志
*/
void autoDeleteLog();
在ScheduleJobServiceImpl類添加
/**
- 自動刪除日志
*/
@Override
public void autoDeleteLog() {
String beforeDate = DateUtil.offsetDay(new Date(), -9).toString("yyyy-MM-dd");
UpdateWrapper wrapper = Wrappers.update();
wrapper.lt("create_time", beforeDate);
dao.delete(wrapper);
}
示例圖如下：
訂單任務(wù)表（帶數(shù)據(jù)）sql：
-- Table structure for eb_schedule_job
DROP TABLE IF EXISTS eb_schedule_job?;
CREATE TABLE eb_schedule_job? (
?job_id? int(11) NOT NULL AUTO_INCREMENT COMMENT '任務(wù)id',
?bean_name? varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'spring bean名稱',
?method_name? varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法名',
?params? varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '參數(shù)',
?cron_expression? varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'cron表達式',
?status? tinyint(4) NULL DEFAULT NULL COMMENT '任務(wù)狀態(tài) 0：正常 1：暫停',
?remark? varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '備注',
?is_delte? tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否刪除',
?create_time? timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
PRIMARY KEY (job_id?) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定時任務(wù)' ROW_FORMAT = Dynamic;
-- Records of eb_schedule_job
INSERT INTO eb_schedule_job? VALUES (1, 'BargainStopChangeTask', 'bargainStopChange', '', '0 0 0 */1 * ?', 0, '砍價活動結(jié)束狀態(tài)變化', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (2, 'BrokerageFrozenTask', 'brokerageFrozen', '', '0 0 */1 * * ?', 0, '傭金凍結(jié)期解凍處理', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (3, 'CouponOverdueTask', 'couponOverdue', '', '0 */1 * * * ?', 0, '優(yōu)惠券過期處理', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (4, 'IntegralFrozenTask', 'integralFrozen', '', '0 */1 * * * ?', 0, '積分凍結(jié)期解凍處理', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (5, 'OrderAutoCancelTask', 'autoCancel', '', '0 */1 * * * ?', 0, '系統(tǒng)自動取消未支付訂單', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (6, 'OrderAutoCompleteTask', 'autoComplete', '', '0 0 */1 * * ?', 0, '訂單自動完成處理', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (7, 'OrderCancelTask', 'userCancel', '', '0 */1 * * * ?', 0, '用戶取消訂單處理', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (8, 'OrderCompleteTask', 'orderComplete', '', '0 */1 * * * ?', 0, '用戶訂單完成處理', 0, '2021-12-01 10:55:06');
INSERT INTO eb_schedule_job? VALUES (9, 'OrderPaySuccessTask', 'orderPayAfter', '', '0 */1 * * * ?', 0, '訂單支付成功后置處理', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (10, 'OrderReceiptTask', 'orderReceipt', '', '0 */1 * * * ?', 0, '用戶確認收貨后置處理', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (11, 'OrderRefundTask', 'orderRefund', '', '0 */1 * * * ?', 0, '訂單退款處理', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (12, 'AutoUpdateCatTask', 'autoUpdateCat', '', '0 0 1 * * ?', 0, '自動更新自定義交易組件類目', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (13, 'PinkStatusChangeTask', 'pinkStatusChage', '', '0 */1 * * * ?', 0, '拼團狀態(tài)變化處理', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (14, 'ProductStockTask', 'stockOperation', '', '0 */1 * * * ?', 0, '操作商品庫存', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (15, 'StatisticsTask', 'statistics', '', '0 0 0 */1 * ?', 0, '統(tǒng)計定時任務(wù)', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (16, 'AsyncWeChatProgramTempMessage', 'init', '', '0 */1 * * * ?', 0, '小程序消費隊列消費', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (17, 'AsyncWeChatPublicTempMessage', 'init', '', '0 */1 * * * ?', 0, '公眾號消費隊列消費', 0, '2021-12-01 10:55:07');
INSERT INTO eb_schedule_job? VALUES (18, 'AutoDeleteLogTask', 'autoDeleteLog', '', '0 0 0 */1 * ?', 0, '自動刪除不需要的歷史日志', 0, '2022-01-05 15:03:18');
附件的后綴可改為.sql
