java-jfinal——使用quartz定时器

jfinal使用quartz定时器

jfinalconfig

QuartzPlugin quartz = new QuartzPlugin();
me.add(quartz);

quartz依赖

<dependency>
    <groupId>org.quartz-scheduler</groupId>
    <artifactId>quartz</artifactId>
    <version>2.3.0</version>
</dependency>

task.properties

quartz.job=com.dy.task.DictionariesTask

#cron定时任务时间
#quartz.cron=0/10 * * * * ?
#1点执行
quartz.cron=0 0 1 * * ?

task类

package com.dy.task;

import com.alibaba.fastjson.JSONObject;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;
import com.util.MapToRecord;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import java.util.Date;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

public class DictionariesTask implements Job {

    @Override
    public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {

        String sql = "select dictionariesKey,dictionariesValue,remark from dictionaries";
        List<Record> dictionariesList = Db.find(sql);

        String typeAttributeListSql = "select id,attributeName,showname from device_typeattribute";
        List<Record> typeAttributeList = Db.find(typeAttributeListSql);
//        Record record  = new Record();
        Record record;//dictionariesList
        Record record2;//typeAttributeList

        for (int i = 0; i < dictionariesList.size(); i++) { //循环每条记录
            record = dictionariesList.get(i);
            Object dictionariesKey = record.get("dictionariesKey");
            Object dictionariesValue = record.get("dictionariesValue");

            for (int j = 0; j < typeAttributeList.size(); j++) {//循环每条记录
                record2 = typeAttributeList.get(j);
                Object attributeName = record2.get("attributeName");
                Object id = record2.get("id");
                if (dictionariesKey.equals(attributeName)) {
                    Record record3 = new Record();//插入
                    Date date = new Date();
                    record3.set("upTime", date);
                    record3.set("showname", dictionariesValue);
                    record3.set("id", id);
                    Db.update("device_typeattribute", "id", record3);
                }
            }

        }

    }

}