springboot 集成Quartz实现任务延迟执行和定时执行功能

废话不多说了，直接上代码；

1.项目结构图

2.在application.yml配置文件中加入下面配置：

quartz:#相关属性配置properties:org:quartz:scheduler:instanceName: clusteredSchedulerinstanceId: AUTOjobStore:class: org.quartz.impl.jdbcjobstore.JobStoreTXdriverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegatetablePrefix: QRTZ_isClustered: trueclusterCheckinInterval: 10000useProperties: falsethreadPool:class: org.quartz.simpl.SimpleThreadPoolthreadCount: 10threadPriority: 5threadsInheritContextClassLoaderOfInitializingThread: true#数据库方式job-store-type: jdbc

3，创建JobEntity类

package com.rtsm.zhjs.background.framework.quartz.entity;import lombok.Data;import lombok.EqualsAndHashCode;import lombok.experimental.Accessors;import java.io.Serializable;/*** <p>* * </p>* time: -03-29* @author EDZ*/@Data@EqualsAndHashCode(callSuper = false)@Accessors(chain = true)public class JobEntity implements Serializable {private static final long serialVersionUID = 1L;private String id;private String name;private String jobGroup;private String cron;private String parameter;/*** 延时时间*/private Integer delaySecond;/*** job的执行状态,这里我设置为1/0且只有该值为1才会执行该Job*/private Integer status = 1;public JobEntity(String id, String name, String jobGroup, Integer delaySecond, Integer status) {this.id = id;this.name = name;this.jobGroup = jobGroup;this.delaySecond = delaySecond;this.status = status;}public JobEntity() {}}

4.创建CallConfigJob类

package com.rtsm.zhjs.background.framework.quartz.job;import com.rtsm.zhjs.background.modules.moodregister.dto.XqdjDto;import com.rtsm.zhjs.background.modules.moodregister.entity.XqdjZfxqjl;import com.rtsm.zhjs.background.modules.moodregister.mapper.XqdjZfxqjlMapper;import com.rtsm.zhjs.background.modules.moodregister.service.XqdjZfxqjlService;import lombok.extern.slf4j.Slf4j;import org.quartz.Job;import org.quartz.JobDataMap;import org.quartz.JobExecutionContext;import org.quartz.JobExecutionException;import org.springframework.beans.factory.annotation.Autowired;import org.ponent;import org.springframework.web.bind.annotation.RequestBody;import javax.annotation.Resource;import java.text.SimpleDateFormat;import java.util.Date;/*** 点名配置任务自动生成一条无心情的心情记录* @author WJH* @date /4/916:19*/@Slf4j@Componentpublic class CallConfigJob implements Job {@Autowiredprivate XqdjZfxqjlService xqdjZfxqjlService;@Overridepublic void execute(JobExecutionContext context) throws JobExecutionException {JobDataMap map = context.getJobDetail().getJobDataMap();if(map.get("saveTime")!=null){String time = map.get("saveTime").toString();XqdjDto xqdjDto = new XqdjDto();xqdjDto.setZfbh("");Date now = new Date();SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");xqdjDto.setPcbh(sdf.format(now)+" "+time+":00");xqdjZfxqjlService.insertData(xqdjDto);log.info("自动添加默认心情记录数据："+xqdjDto.toString());}}}

5.创建DynamicJob类

//package com.rtsm.zhjs.background.framework.quartz.job;////import com.rtsm.zhjs.background.entity.BjxtBjjl;//import com.rtsm.zhjs.background.framework.quartz.mapper.JobEntityMapper;//import com.rtsm.zhjs.background.service.BjxtBjjlService;//import lombok.extern.slf4j.Slf4j;//import org.quartz.*;//import org.springframework.beans.factory.annotation.Autowired;//import org.ponent;////import javax.annotation.Resource;/////**// * Created by EalenXie on /6/4 14:29// * :@DisallowConcurrentExecution : 此标记用在实现Job的类上面,意思是不允许并发执行.// * :注意org.quartz.threadPool.threadCount线程池中线程的数量至少要多个,否则@DisallowConcurrentExecution不生效// * :假如Job的设置时间间隔为3秒,但Job执行时间是5秒,设置@DisallowConcurrentExecution以后程序会等任务执行完毕以后再去执行,否则会在3秒时再启用新的线程执行// *///@DisallowConcurrentExecution//@Component//@Slf4j//public class DynamicJob implements Job {// @Resource// private JobEntityMapper jobEntityMapper;// @Autowired// private BjxtBjjlService bjxtBjjlService;// /**//* 核心方法,Quartz Job真正的执行逻辑.//* @param executorContext executorContext JobExecutionContext中封装有Quartz运行所需要的所有信息//* @throws JobExecutionException execute()方法只允许抛出JobExecutionException异常//*/// @Override// public void execute(JobExecutionContext executorContext) throws JobExecutionException {// JobDataMap mpa = executorContext.getJobDetail().getJobDataMap();// //删除jobEntity 数据// //this.jobEntityMapper.deleteById(mpa.get("jobId").toString());// //查询报警统计，判断报警状态是否已经被处理// BjxtBjjl bjxtBjjl = bjxtBjjlService.findStaBySbbh(mpa.getString("sbbh"));// if(bjxtBjjl.getCljg() == 0) {// mpa.replace("status",0);// }else if(bjxtBjjl.getCljg() == 1) {// mpa.replace("status",1);// }else {// mpa.replace("status",2);// }// log.info("定时任务"+executorContext.getJobDetail().getKey().getName()+" "+mpa);// }//}

6.创建PushClockJob类

package com.rtsm.zhjs.background.framework.quartz.job;import com.rtsm.mon.exception.BusinessException;import com.rtsm.zhjs.background.framework.quartz.entity.JobEntity;import com.rtsm.zhjs.background.framework.quartz.service.QuartzManager;import com.rtsm.zhjs.background.framework.socket.ClientSocket;import com.rtsm.zhjs.background.framework.socket.SocketType;import com.rtsm.zhjs.background.modules.rollcall.entity.JcglDmpz;import com.rtsm.zhjs.background.modules.rollcall.service.JcglDmpzService;import com.rtsm.zhjs.background.util.DateUtils;import com.rtsm.zhjs.background.util.UUIDUtils;import lombok.extern.slf4j.Slf4j;import org.quartz.*;import org.springframework.beans.factory.annotation.Autowired;import java.util.Date;import java.util.List;import static com.rtsm.zhjs.background.util.DateUtils.LONG_TIME_MINUTE_FORMAT;/*** @author syx* @date /4/410:51*/@Slf4jpublic class PushClockJob implements Job {@AutowiredJcglDmpzService jcglDmpzService;@AutowiredQuartzManager quartzManager;@Overridepublic void execute(JobExecutionContext context) throws JobExecutionException {//定时任务中查询配置时间log.info("begin pushclockJob");List<JcglDmpz> plans = jcglDmpzService.findAll();Date currentTime = new Date();//todo 获取所有客户端连接的key值String dateStr = DateUtils.dateToStr(currentTime,LONG_TIME_MINUTE_FORMAT);for (JcglDmpz plan : plans) {String startTime = plan.getKssj();//todo testString str = SocketType.ROLLCALL.EnumToJson();log.info("pushClockJob");ClientSocket.sendToAll(str);if (startTime.equalsIgnoreCase(dateStr) ) {//向所有监仓发送通知消息 sendToAllClientSocket.sendToAll(SocketType.ROLLCALL.EnumToJson());//获取点名时间间隔，提醒次数，新建一个定时任务，发送相同的点名信息String interval = plan.getJgzq();String reminders = plan.getTxcs();//todo 新建一个定时任务reminderJob(interval,reminders,SocketType.ROLLCALL.EnumToJson());}}}private void reminderJob(String interval,String reminders,String msg) {//新建一个jobEntityJobEntity jobEntity = new JobEntity(UUIDUtils.generateUuid(), UUIDUtils.generateUuid(), "rollcall", Integer.parseInt(interval), 1);JobDataMap jobDataMap = new JobDataMap();//新建一个jobtry {quartzManager.addSimpleJob(jobEntity,RemindJob.class,jobDataMap);} catch (SchedulerException e) {throw new BusinessException("","quartz调度异常");}}}

8.创建RemindJob类

package com.rtsm.zhjs.background.framework.quartz.job;import org.quartz.Job;import org.quartz.JobExecutionContext;import org.quartz.JobExecutionException;/*** 发送提醒* @author syx* @date /4/414:36*/public class RemindJob implements Job {@Overridepublic void execute(JobExecutionContext context) throws JobExecutionException {//发送消息给所有用户}}

9.创建TestJob类

package com.rtsm.zhjs.background.framework.quartz.job;import lombok.extern.slf4j.Slf4j;import org.quartz.Job;import org.quartz.JobExecutionContext;import org.quartz.JobExecutionException;/*** @author syx* @date /4/416:06*/@Slf4jpublic class TestJob implements Job {@Overridepublic void execute(JobExecutionContext context) throws JobExecutionException {System.out.println("hello world,java");log.info("Hello world,kkkk");}}

10.创建JobEntityMapper类

package com.rtsm.zhjs.background.framework.quartz.mapper;import com.rtsm.zhjs.background.framework.quartz.entity.JobEntity;import com.baomidou.mybatisplus.core.mapper.BaseMapper;import org.apache.ibatis.annotations.Mapper;/*** <p>* Mapper 接口* </p>* time: -03-29* @author EDZ*/@Mapperpublic interface JobEntityMapper extends BaseMapper<JobEntity> {}

11.提供对应的接口，接口可以根据自己的需求添加

package com.rtsm.zhjs.background.framework.quartz.service;import com.rtsm.zhjs.background.framework.quartz.entity.JobEntity;import org.quartz.Job;import org.quartz.JobDataMap;import org.quartz.SchedulerException;/*** @author EDZ* @date /3/2913:48*/public interface QuartzManager {public void addSimpleJob(JobEntity jobEntity,Class<? extends Job> c, JobDataMap jobDataMap) throws SchedulerException;public void subJob(JobEntity jobEntity);public void subJob(String name,String group);public void subJobByGroup(String group);public void addCronJob(JobEntity jobEntity,Class<? extends Job> c, JobDataMap jobDataMap) throws SchedulerException;public String getCorn();}

12.创建QuertzManagerImpl实现类

package com.rtsm.zhjs.background.framework.quartz.service.impl;import com.rtsm.zhjs.background.framework.quartz.entity.JobEntity;import com.rtsm.zhjs.background.framework.quartz.service.QuartzManager;import org.quartz.*;import org.quartz.impl.matchers.GroupMatcher;import org.springframework.scheduling.quartz.SchedulerFactoryBean;import org.ponent;import javax.annotation.Resource;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.Set;/*** 定时任务管理* @author EDZ* @date /3/2913:51*/@Componentpublic class QuartzManagerImpl implements QuartzManager {/* @Resourceprivate JobEntityMapper jobEntityMapper;*/@Resourceprivate SchedulerFactoryBean factory;/*** jobEntity* @param jobEntity 任务实体* @param job 执行任务* @param dataMap 保存的参数* @throws SchedulerException*/@Overridepublic void addSimpleJob(JobEntity jobEntity,Class<? extends Job> job,JobDataMap dataMap) throws SchedulerException {Scheduler schd=factory.getScheduler();//多少秒之后执行Date startTime = new Date(System.currentTimeMillis()+jobEntity.getDelaySecond()*1000);dataMap.put("jobName",jobEntity.getName());dataMap.put("jobGroup",jobEntity.getJobGroup());dataMap.put("jobId",jobEntity.getId());JobDetail jobDetail = JobBuilder.newJob(job).withIdentity(jobEntity.getName(),jobEntity.getJobGroup()).setJobData(dataMap).build();Trigger trigger = TriggerBuilder.newTrigger().withIdentity(TriggerKey.triggerKey("trigger"+jobEntity.getName(), "trigger"+jobEntity.getJobGroup())).startAt(startTime).build();// jobEntity.setParameter(dataMap.toString());// jobEntityMapper.insert(jobEntity);//两者组成一个计划任务注册到schedulerif(jobEntity.getStatus()!=0){schd.scheduleJob(jobDetail,trigger);}}/*** 移除任务* @param jobEntity*/@Overridepublic void subJob(JobEntity jobEntity) {Scheduler schd=factory.getScheduler();try {//this.jobEntityMapper.deleteById(jobEntity.getId());schd.deleteJob(JobKey.jobKey(jobEntity.getName(),jobEntity.getJobGroup()));} catch (SchedulerException e) {e.printStackTrace();}}@Overridepublic void subJob(String name, String group) {Scheduler schd=factory.getScheduler();try {//this.jobEntityMapper.deleteById(jobEntity.getId());schd.deleteJob(JobKey.jobKey(name,group));} catch (SchedulerException e) {e.printStackTrace();}}/*** 根据分组删除定时任务* @param group*/@Overridepublic void subJobByGroup(String group) {try {Scheduler schd=factory.getScheduler();GroupMatcher<JobKey> matcher = GroupMatcher.groupEquals(group);Set<JobKey> jobkeySet = schd.getJobKeys(matcher);List<JobKey> jobkeyList = new ArrayList<JobKey>();jobkeyList.addAll(jobkeySet);schd.deleteJobs(jobkeyList);} catch (SchedulerException e) {e.printStackTrace();}}@Overridepublic void addCronJob(JobEntity jobEntity, Class<? extends Job> job, JobDataMap dataMap) throws SchedulerException {Scheduler schd=factory.getScheduler();dataMap.put("jobName",jobEntity.getName());dataMap.put("jobGroup",jobEntity.getJobGroup());dataMap.put("jobId",jobEntity.getId());JobDetail jobDetail = JobBuilder.newJob(job).withIdentity(jobEntity.getName(),jobEntity.getJobGroup()).setJobData(dataMap).build();Trigger trigger = TriggerBuilder.newTrigger().withIdentity(jobEntity.getName(),jobEntity.getJobGroup()).withSchedule(CronScheduleBuilder.cronSchedule(jobEntity.getCron())//失效后启动不执行错过任务.withMisfireHandlingInstructionDoNothing()).startNow().build();jobEntity.setParameter(dataMap.toString());// jobEntityMapper.insert(jobEntity);//两者组成一个计划任务注册到schedulerif(jobEntity.getStatus()!=0){schd.scheduleJob(jobDetail,trigger);}// if(!schd.isShutdown()){// schd.start();//启动调度器// }}@Overridepublic String getCorn() {return null;}}

13.对应的sql建立数据库表语句

/*Navicat MySQL Data TransferSource Server : locSource Server Version : 50716Source Host : localhost:3306Source Database : alarmTarget Server Type : MYSQLTarget Server Version : 50716File Encoding : 65001Date: -04-04 18:05:41*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for bjxt_bjjl-- ----------------------------DROP TABLE IF EXISTS `bjxt_bjjl`;CREATE TABLE `bjxt_bjjl` (`id` char(32) NOT NULL COMMENT '主键',`sbbh` varchar(64) DEFAULT NULL COMMENT '设备编号',`wzbh` char(32) DEFAULT NULL COMMENT '位置信息',`ms` tinyint(4) DEFAULT NULL COMMENT '模式 0:逐层转递 1：全局广播',`clr` char(32) DEFAULT NULL COMMENT '处理人',`cljg` tinyint(4) DEFAULT NULL COMMENT '处理结果,0:等待处理 1：处理中 2：处理完成',`bjrbh` char(32) DEFAULT NULL COMMENT '报警人编号',`bjsy` varchar(1024) DEFAULT NULL COMMENT '报警事由',`sc` tinyint(4) DEFAULT NULL COMMENT '删除标志位，0否1是',`cjsj` datetime NOT NULL COMMENT '创建时间',`gxsj` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',`scsj` datetime DEFAULT NULL COMMENT '删除时间',`cjr` varchar(50) DEFAULT NULL COMMENT '创建人',`bz` varchar(1024) DEFAULT NULL COMMENT '备注',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='报警记录表';-- ------------------------------ Records of bjxt_bjjl-- ----------------------------INSERT INTO `bjxt_bjjl` VALUES ('120', '123654741', '25487142', '0', '干警A', '0', '02254822', '被老犯打了01', '1', '-04-01 11:36:15', '-04-01 11:38:25', '-04-01 11:36:21', '罪犯A', '处理顺利');INSERT INTO `bjxt_bjjl` VALUES ('121', '1546552', '54657', '0', '干警B', '0', '45635325', '被老犯打了02', '1', '-04-01 11:36:15', '-04-01 11:41:52', '-04-01 11:36:21', '罪犯B', '处理顺利');INSERT INTO `bjxt_bjjl` VALUES ('122', '515466251', '653653767676765', '0', '干警C', '0', '45265737', '被老犯打了03', '1', '-04-01 11:36:15', '-04-01 11:41:52', '-04-01 11:36:21', '罪犯C', '处理顺利');INSERT INTO `bjxt_bjjl` VALUES ('123', '151541515', '654657637763615', '0', '干警D', '0', '735677658', '被老犯打了04', '1', '-04-01 11:36:15', '-04-01 11:41:52', '-04-01 11:36:21', '罪犯D', '处理顺利');INSERT INTO `bjxt_bjjl` VALUES ('2FlmDvr8', 'QWER', '040103012202', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 17:53:39', '-04-04 17:53:38', null, '-04-04T17:53:38.935', null);INSERT INTO `bjxt_bjjl` VALUES ('2XD1T5s9', '25234', '3453', null, 'gadget', null, null, '4534', '1', '-04-01 15:49:39', '-04-01 17:01:21', null, '法式风格', null);INSERT INTO `bjxt_bjjl` VALUES ('5WDx848Q', 'QWER', '040103012202', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 17:36:59', '-04-04 17:36:59', null, '-04-04T17:36:59.389', null);INSERT INTO `bjxt_bjjl` VALUES ('5YL5WQvD', 'QWER', '040103012202', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 17:31:19', '-04-04 17:31:18', null, '-04-04T17:31:18.648', null);INSERT INTO `bjxt_bjjl` VALUES ('95p3P7FF', '1234', '01', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 16:48:47', '-04-04 16:48:47', null, '-04-04T16:48:47.239', null);INSERT INTO `bjxt_bjjl` VALUES ('DWA3U3O9', '32254343', '54353', '1', '李四', null, null, '有人打架斗殴', '0', '-04-01 15:53:20', '-04-01 17:01:13', null, '纽曼考虑过', null);INSERT INTO `bjxt_bjjl` VALUES ('eJvpwow6', 'QWER', '040103012202', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 16:19:43', '-04-04 16:19:43', null, '-04-04T16:19:43.248', null);INSERT INTO `bjxt_bjjl` VALUES ('JL2eHJA0', 'QWER', '040103012202', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 17:47:17', '-04-04 17:47:16', null, '-04-04T17:47:16.616', null);INSERT INTO `bjxt_bjjl` VALUES ('RAU9Zz9q', 'abcdefgh', '01015245852487', '0', null, null, 'abcd', '监狱着火了', '1', '-04-02 11:11:52', '-04-02 11:11:51', null, '罪犯A', null);INSERT INTO `bjxt_bjjl` VALUES ('RXR1psRI', 'QWER', '040103012202', '0', null, '0', 'abcd', '监狱着火了', '1', '-04-04 17:33:23', '-04-04 17:33:23', null, '-04-04T17:33:23.083', null);INSERT INTO `bjxt_bjjl` VALUES ('trd0ARsP', 'ABCDEFGH', '01015245852487', '0', null, null, 'abcd', '监狱着火了', '1', '-04-02 11:10:30', '-04-02 11:10:29', null, '罪犯A', null);INSERT INTO `bjxt_bjjl` VALUES ('yN0lGihH', '5224285234111', '2548752365214752', '1', null, null, null, '房间着火了', '0', '-04-01 15:55:27', '-04-01 15:55:27', null, '罪犯F', null);-- ------------------------------ Table structure for bjxt_bjsb-- ----------------------------DROP TABLE IF EXISTS `bjxt_bjsb`;CREATE TABLE `bjxt_bjsb` (`id` char(32) NOT NULL COMMENT '主键',`mc` varchar(255) DEFAULT NULL COMMENT '名称',`sbbh` varchar(64) DEFAULT NULL COMMENT '设备编号',`wzbh` char(32) DEFAULT NULL COMMENT '位置编号',`ip` varchar(50) DEFAULT NULL COMMENT 'IP地址',`port` varchar(50) DEFAULT NULL COMMENT '设备端口',`sc` tinyint(4) NOT NULL COMMENT '删除标志位',`cjsj` datetime NOT NULL COMMENT '创建时间',`gxsj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',`scsj` datetime NOT NULL COMMENT '删除时间',`cjr` varchar(255) NOT NULL COMMENT '创建人',`ismark` tinyint(4) DEFAULT NULL COMMENT '是否是管理专用设备,0:不是 1：楼层干警管理设备2：监区管理设备3：指挥中心管理设备',`glwzbh` varchar(50) DEFAULT NULL COMMENT '管理的位置编码',`glwzxx` varchar(100) DEFAULT NULL COMMENT '管理的位置信息',PRIMARY KEY (`id`),UNIQUE KEY `unique_sbbh` (`sbbh`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='报警设备表';-- ------------------------------ Records of bjxt_bjsb-- ----------------------------INSERT INTO `bjxt_bjsb` VALUES ('0000000003', null, '324532', '2345345', '127.0.0.1', '10086', '0', '-04-03 15:05:02', '-04-03 15:05:04', '-04-03 15:05:06', 'wjh', '3', '02', null);INSERT INTO `bjxt_bjsb` VALUES ('00000000033', null, 'QWER', '040103012202', '127.0.0.1', '10086', '0', '-04-03 17:57:20', '-04-03 20:55:14', '-04-03 17:57:25', 'wjh', '0', null, null);INSERT INTO `bjxt_bjsb` VALUES ('000000000678', '', '134234', '1234324', '127.0.0.1', '10086', '0', '-04-03 15:05:02', '-04-03 15:05:04', '-04-03 15:05:06', 'wjh', '3', '01', '');INSERT INTO `bjxt_bjsb` VALUES ('00000001', null, '28374', '050382837482', '127.0.0.1', '10086', '0', '-04-03 15:02:17', '-04-03 15:02:19', '-04-03 15:03:30', 'wjh', '1', '040103', null);INSERT INTO `bjxt_bjsb` VALUES ('00000002', '', '128374', '9082430834019834', '127.0.0.1', '10086', '0', '-04-03 15:04:04', '-04-03 15:04:07', '-04-03 15:04:09', 'wjh', '2', '0401', '');INSERT INTO `bjxt_bjsb` VALUES ('00000asdf', '', 'asdf', 'asdf', '127.0.0.1', '10086', '0', '-04-03 15:02:17', '-04-03 15:02:19', '-04-03 15:03:30', 'wjh', '1', '0101040103', '');INSERT INTO `bjxt_bjsb` VALUES ('1', null, '0001', '10101011', '192.168.0.0.127', '3306', '0', '-04-01 13:40:46', '-04-03 10:21:20', '-04-01 13:41:10', 'syx', '1', null, null);INSERT INTO `bjxt_bjsb` VALUES ('219837489213', null, '1234', '0101040103012202', '127.0.0.1', '10086', '0', '-04-04 13:43:39', '-04-04 13:44:30', '-04-04 13:43:42', 'wjh', '0', null, null);INSERT INTO `bjxt_bjsb` VALUES ('asdfdsfg', '', 'asdfedrg', '9082430834019834', '127.0.0.1', '10086', '0', '-04-03 15:04:04', '-04-03 15:04:07', '-04-03 15:04:09', 'wjh', '2', '01010401', '');-- ------------------------------ Table structure for bjxt_bjsz-- ----------------------------DROP TABLE IF EXISTS `bjxt_bjsz`;CREATE TABLE `bjxt_bjsz` (`id` varchar(32) NOT NULL COMMENT '主键',`cdms` tinyint(4) NOT NULL COMMENT '传递模式0:逐级传递1:全局传递',`wzxx` varchar(32) DEFAULT NULL COMMENT '位置信息',`wzbm` varchar(32) DEFAULT NULL COMMENT '位置编码',`lcgj` tinyint(4) DEFAULT NULL COMMENT '是否传递到楼层干警 0：是 1：否',`lcgj_zssj` int(3) DEFAULT NULL COMMENT '楼层干警阻塞时间（min）',`jqgl` tinyint(4) DEFAULT NULL COMMENT '是否传递到监区管理 0：是 1：否',`jqgl_zssj` int(3) DEFAULT NULL COMMENT '监区管理阻塞时间',`kg` tinyint(4) DEFAULT NULL COMMENT '是否开启本条设置',`sc` tinyint(4) DEFAULT NULL COMMENT '删除标志位，0：删除 1：未删除',`cjsj` datetime DEFAULT NULL COMMENT '创建时间',`gxsj` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',`scsj` datetime DEFAULT NULL COMMENT '删除时间',`cjr` varchar(255) DEFAULT NULL COMMENT '创建人',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='报警设置';-- ------------------------------ Records of bjxt_bjsz-- ----------------------------INSERT INTO `bjxt_bjsz` VALUES ('16c53706f199439d8a642bd60ca66db7', '0', '所有位置', '0', '1', '5', '1', '5', '1', null, '-04-02 14:03:07', '-04-02 14:03:08', null, null);INSERT INTO `bjxt_bjsz` VALUES ('7e34c5164d6b427694aa02fffb6473cc', '0', '第二关押点生活区监舍楼1号楼第3层22号监舍第2个监控点', '040103012202', '1', '1', '1', '1', '1', null, '-03-29 17:57:01', '-03-29 17:57:01', null, null);INSERT INTO `bjxt_bjsz` VALUES ('bff84ba9a9254056bad17ba887084863', '1', '第1关押点', '01', '1', '1', '1', '1', '1', null, '-04-02 14:01:15', '-04-02 14:01:16', null, null);INSERT INTO `bjxt_bjsz` VALUES ('e159bbb79da0442fa72d89dfb573a44c', '0', '第2关押点', '02', '1', '1', '1', '1', '1', null, '-04-02 14:00:43', '-04-02 14:00:44', null, null);-- ------------------------------ Table structure for bjxt_wgsb-- ----------------------------DROP TABLE IF EXISTS `bjxt_wgsb`;CREATE TABLE `bjxt_wgsb` (`id` char(32) NOT NULL COMMENT '主键',`sbbh` varchar(255) DEFAULT NULL COMMENT '设备编码',`wzbh` char(32) DEFAULT NULL COMMENT '位置信息',`sc` tinyint(4) DEFAULT NULL COMMENT '删除标志位，0否1是',`cjsj` datetime NOT NULL COMMENT '创建时间',`gxsj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',`scsj` datetime DEFAULT NULL COMMENT '删除时间',`cjr` varchar(255) DEFAULT NULL COMMENT '创建人',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='lora网关设备';-- ------------------------------ Records of bjxt_wgsb-- ------------------------------ ------------------------------ Table structure for dlwz_cslx-- ----------------------------DROP TABLE IF EXISTS `dlwz_cslx`;CREATE TABLE `dlwz_cslx` (`id` char(32) NOT NULL,`csbh` varchar(64) NOT NULL COMMENT '2位场所类型编码',`csmc` varchar(255) NOT NULL,`bz` varchar(255) DEFAULT NULL,`sc` tinyint(4) DEFAULT NULL,`cjsj` datetime NOT NULL,`gxsj` datetime DEFAULT NULL,`scsj` datetime DEFAULT NULL,`cjr` varchar(64) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of dlwz_cslx-- ----------------------------INSERT INTO `dlwz_cslx` VALUES ('1', '01', '监舍', '123', '1', '-03-29 14:07:11', '-03-29 14:07:13', '-03-29 14:33:21', '1');INSERT INTO `dlwz_cslx` VALUES ('72722a4fd85a4fd890013b3df6832628', '02', '医院', '123', '1', '-03-29 14:33:16', '-03-29 14:33:16', '-03-29 14:33:23', null);INSERT INTO `dlwz_cslx` VALUES ('b1243cf6221846ca83fea6eb391908b4', '02', '街道', '街道2', '0', '-04-02 09:56:08', '-04-02 09:58:25', null, null);INSERT INTO `dlwz_cslx` VALUES ('c87c441cab3c41cab88a980e4310d828', '01', '医院', 'hospital', '0', '-03-29 14:34:06', '-03-29 14:50:46', null, null);-- ------------------------------ Table structure for dlwz_dlxx-- ----------------------------DROP TABLE IF EXISTS `dlwz_dlxx`;CREATE TABLE `dlwz_dlxx` (`id` char(32) NOT NULL,`dlbh` varchar(64) NOT NULL COMMENT '关押点编号 + 区域编码 + 子区域编码 + 楼栋编号 + 楼层编号 + 场所编码 + 场所编号 + 场所内监控点编号',`dlmc` varchar(255) NOT NULL,`csbh` varchar(64) NOT NULL COMMENT '2位场所类型编码',`zqybh` varchar(64) NOT NULL COMMENT '2位区域内子区域编码',`qybh` varchar(64) NOT NULL COMMENT '2位区域编码',`gydbh` varchar(64) NOT NULL COMMENT '2位关押点编码\r\n 无关押点单位（监狱管理局、管理分局），编码为00\r\n 其他由监狱单位顺序编码',`bz` varchar(255) DEFAULT NULL,`sc` tinyint(4) DEFAULT NULL,`cjsj` datetime NOT NULL,`gxsj` datetime DEFAULT NULL,`scsj` datetime DEFAULT NULL,`cjr` varchar(64) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of dlwz_dlxx-- ----------------------------INSERT INTO `dlwz_dlxx` VALUES ('1', '1', '1', '1', '1', '1', '1', '1', '1', '-04-01 14:05:06', '-04-01 14:05:08', '-04-01 16:52:26', '1');INSERT INTO `dlwz_dlxx` VALUES ('3eb2b515cf5a4f17944b3e0d2ec39f63', '0303010101010101', '医院', '01', '01', '03', '03', '医院', '1', '-04-02 11:06:05', '-04-02 11:06:05', '-04-02 15:46:29', null);INSERT INTO `dlwz_dlxx` VALUES ('522ff160a6ce4e369e1272aca52faa30', '01010101', '教学楼', '01', '02', '02', '02', '教学楼', '1', '-04-01 16:43:03', '-04-01 16:43:03', '-04-02 11:05:41', null);INSERT INTO `dlwz_dlxx` VALUES ('62c57641ca2d4485927f40db61d852d1', '01010101', '1号监区3栋', '01', '02', '02', '02', '1号监区3栋', '1', '-04-01 16:41:55', '-04-01 16:41:55', '-04-02 11:05:43', null);INSERT INTO `dlwz_dlxx` VALUES ('7b8c49aa45364fcd831652ebd5212805', '04030201', '', '02', '02', '03', '04', '地理名称3', '1', '-04-02 11:39:21', '-04-02 11:52:32', '-04-02 11:53:11', null);INSERT INTO `dlwz_dlxx` VALUES ('7f3da6d16b4948609ac8470c5c072112', '05010101', '公共区域', '02', '05', '01', '02', '公共区域', '1', '-04-02 15:48:45', '-04-02 15:48:45', '-04-03 09:24:57', null);INSERT INTO `dlwz_dlxx` VALUES ('91ba858c33424b128fb3ba2d77080d84', '030303010101', '街道', '02', '03', '03', '03', '街道', '1', '-04-02 10:55:17', '-04-02 10:55:17', '-04-02 15:46:30', null);INSERT INTO `dlwz_dlxx` VALUES ('b276f9f3df7844bf8a25a677dabf0c30', '030204010102', '和平街', '02', '04', '02', '03', '和平街', '0', '-04-03 09:24:07', '-04-03 09:40:37', null, null);INSERT INTO `dlwz_dlxx` VALUES ('d62c340a27cf441eb6c7b26ae1f91c75', '040203010103', '医院', '02', '03', '02', '04', '2号医院', '1', '-04-01 17:45:28', '-04-02 10:37:18', '-04-02 11:05:40', null);-- ------------------------------ Table structure for dlwz_gyd-- ----------------------------DROP TABLE IF EXISTS `dlwz_gyd`;CREATE TABLE `dlwz_gyd` (`id` char(32) NOT NULL,`gydbh` varchar(64) NOT NULL COMMENT '2位关押点编码\r\n 无关押点单位（监狱管理局、管理分局），编码为00\r\n 其他由监狱单位顺序编码',`gydmc` varchar(255) NOT NULL,`bz` varchar(255) DEFAULT NULL,`sc` tinyint(4) DEFAULT NULL,`cjsj` datetime NOT NULL,`gxsj` datetime DEFAULT NULL,`scsj` datetime DEFAULT NULL,`cjr` varchar(64) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of dlwz_gyd-- ----------------------------INSERT INTO `dlwz_gyd` VALUES ('1', '01', '1', '1', '1', '-03-27 14:14:31', '-03-27 14:14:33', '-03-27 20:17:50', '123');INSERT INTO `dlwz_gyd` VALUES ('232c007eac064227b18045a9d20e7691', '01', 'fsd', 'fds', '0', '-04-04 10:09:09', '-04-04 10:09:09', null, null);INSERT INTO `dlwz_gyd` VALUES ('38a6dafc67d141f6ba36b88f0b6acdf6', '32', 'we', 'wre', '0', '-04-04 10:15:05', '-04-04 10:15:05', null, null);INSERT INTO `dlwz_gyd` VALUES ('405a256cb24046a7aa00c707940e70a5', '02', '1号监区', '102', '0', '-03-27 20:17:55', '-03-29 15:38:40', null, null);INSERT INTO `dlwz_gyd` VALUES ('46d05331f96c4b39ab23ea811120e03f', '25', '发生的方式', '发多少', '0', '-04-04 10:22:25', '-04-04 10:22:25', null, null);INSERT INTO `dlwz_gyd` VALUES ('5f29f5848cf94f0aaab5a78f7380cb31', '01', '222222', '0', '1', '-03-27 15:19:12', '-03-27 15:24:33', '-03-27 15:28:22', null);INSERT INTO `dlwz_gyd` VALUES ('8d814b4806f742279c6a08483c322d28', '02', '02', '02', '1', '-03-27 20:16:45', '-03-27 20:16:45', '-03-27 20:17:48', null);INSERT INTO `dlwz_gyd` VALUES ('91fe38a4f3574d9d801a45147ccd3723', '51', '发多少', '发多少', '0', '-04-04 10:27:38', '-04-04 10:27:38', null, null);INSERT INTO `dlwz_gyd` VALUES ('9480c4622e2b47a4ae21f79b65935dc6', '05', '3号关押点', '3号关押点', '1', '-04-02 19:23:41', '-04-02 19:26:22', '-04-02 19:41:33', null);INSERT INTO `dlwz_gyd` VALUES ('9780e277244f4f3c8c8d9b880f9f81a5', '08', 'we', 'ew', '0', '-04-04 10:10:17', '-04-04 10:10:17', null, null);INSERT INTO `dlwz_gyd` VALUES ('998cb96a0ac9422484aeea6162618de5', '05', '3号关押点', '3号关押点', '0', '-04-03 20:26:24', '-04-03 20:26:24', null, null);INSERT INTO `dlwz_gyd` VALUES ('9b5fab8b08364b58800db4bf19b9f907', '66', '哈哈', 'haha', '0', '-04-04 10:43:17', '-04-04 10:43:17', null, null);INSERT INTO `dlwz_gyd` VALUES ('a0686aba6a604b69a66ce665dcf2f2cf', '03', '', '', '1', '-04-01 18:08:35', '-04-01 18:08:35', '-04-01 18:09:27', null);INSERT INTO `dlwz_gyd` VALUES ('bd2b48bc98014964994f521e0cab4254', '06', '关押点', '关押点', '0', '-04-04 09:37:59', '-04-04 09:37:59', null, null);INSERT INTO `dlwz_gyd` VALUES ('c086574d8971462fad8902f6a85df976', '1', '02', '', '1', '-04-02 09:14:33', '-04-02 09:14:33', '-04-02 09:14:44', null);INSERT INTO `dlwz_gyd` VALUES ('c7e1f4837f184ce88eeddd947c045bba', '22', 'ewq', 'ewq', '0', '-04-04 10:11:40', '-04-04 10:11:40', null, null);INSERT INTO `dlwz_gyd` VALUES ('cfe5bc00081b4b8c8befaf0db9061228', '00', 'fds', 'fds', '0', '-04-04 09:59:31', '-04-04 09:59:31', null, null);INSERT INTO `dlwz_gyd` VALUES ('ddfbce149e4b44cfa9d979ade257f7d8', '33', '关押点3', '关押点3', '0', '-04-04 10:17:46', '-04-04 10:17:46', null, null);INSERT INTO `dlwz_gyd` VALUES ('dede5c95f33548a094693489a588ed5f', '50', '发多少', '发多少', '0', '-04-04 10:26:05', '-04-04 10:26:05', null, null);INSERT INTO `dlwz_gyd` VALUES ('e0dd4b3a8e924a53b65c2dc0477d86ec', '03', '2号监区', '2号监区', '0', '-04-01 18:15:07', '-04-01 18:15:07', null, null);INSERT INTO `dlwz_gyd` VALUES ('e0eae5e30a7c4ea4a097ff2f2baf063a', '80', '发多少', 'fsd', '0', '-04-04 10:28:16', '-04-04 10:28:16', null, null);INSERT INTO `dlwz_gyd` VALUES ('e7ef8afed189433cae341bd80b9ef533', '10', '10', '10', '1', '-03-27 20:17:58', '-03-27 20:17:58', '-03-27 20:18:00', null);INSERT INTO `dlwz_gyd` VALUES ('f958c7061cab40259b619c76b2c6e764', '04', '医院', '01', '0', '-04-02 09:21:46', '-04-02 09:21:46', null, null);-- ------------------------------ Table structure for dlwz_qylx-- ----------------------------DROP TABLE IF EXISTS `dlwz_qylx`;CREATE TABLE `dlwz_qylx` (`id` char(32) NOT NULL,`qybh` varchar(64) NOT NULL COMMENT '2位区域编码',`qymc` varchar(255) NOT NULL,`bz` varchar(64) DEFAULT NULL,`sc` tinyint(4) DEFAULT NULL,`cjsj` datetime NOT NULL,`gxsj` datetime DEFAULT NULL,`scsj` datetime DEFAULT NULL,`cjr` varchar(64) DEFAULT NULL,PRIMARY KEY (`id`),KEY `qybh` (`qybh`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of dlwz_qylx-- ----------------------------INSERT INTO `dlwz_qylx` VALUES ('260935ef38924604956e0e095f118753', '01', '生活区', '生活区', '0', '-04-02 15:46:43', '-04-02 15:46:43', null, null);INSERT INTO `dlwz_qylx` VALUES ('2fe119ee56ff45568f2efbfd943b4dd1', '01', '监管区', '监管区', '1', '-03-29 18:08:20', '-03-29 18:08:20', '-04-02 15:46:15', null);INSERT INTO `dlwz_qylx` VALUES ('6a35636dd9dd4c4cac2b364467cc5504', '03', '劳改区', '劳改区', '0', '-04-02 20:22:56', '-04-02 20:23:02', null, null);INSERT INTO `dlwz_qylx` VALUES ('a0b5da9ceb2f42c9b1f09edb1d16b994', '03', '劳改区', '区域1', '1', '-04-02 09:39:00', '-04-02 20:23:02', '-04-02 15:46:13', null);INSERT INTO `dlwz_qylx` VALUES ('a2c9c6d163784352817aab77ebfa2877', '02', '劳作区', '劳作区', '0', '-04-02 15:46:52', '-04-02 15:46:52', null, null);INSERT INTO `dlwz_qylx` VALUES ('d8a60abef03f41c38fe2e8844db4d0bc', '03', '劳改区', '劳改区', '1', '-04-02 19:47:49', '-04-02 20:23:02', '-04-02 20:22:46', null);INSERT INTO `dlwz_qylx` VALUES ('fc020d5232be4c16bf420fa09bbfe3db', '02', '生活区', '生活区', '1', '-04-01 10:57:43', '-04-01 10:57:43', '-04-02 10:17:42', null);-- ------------------------------ Table structure for dlwz_zqylx-- ----------------------------DROP TABLE IF EXISTS `dlwz_zqylx`;CREATE TABLE `dlwz_zqylx` (`id` char(32) NOT NULL,`zqybh` varchar(64) NOT NULL,`zqymc` varchar(255) NOT NULL,`qybh` varchar(64) NOT NULL,`bz` varchar(255) DEFAULT NULL,`sc` tinyint(4) DEFAULT NULL,`cjsj` datetime NOT NULL,`gxsj` datetime DEFAULT NULL,`scsj` datetime DEFAULT NULL,`cjr` varchar(64) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='2位区域内子区域编码';-- ------------------------------ Records of dlwz_zqylx-- ----------------------------INSERT INTO `dlwz_zqylx` VALUES ('06c6d0a6508f4c7286c77f8507cff67f', '02', '周界', '02', '周界', '0', '-04-02 15:47:57', '-04-02 15:47:57', null, null);INSERT INTO `dlwz_zqylx` VALUES ('1f39cb81401b445f802700866bae8332', '03', '后勤区', '01', '后勤区', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('2366b5c8fd314dbdbf4bf14cbf14976b', '03', '1号区', '03', '1号区', '1', '-04-02 20:13:46', '-04-02 20:13:46', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('278137af85034b70a4178871a3015588', '03', '内公共区域', '02', '内公共区域', '0', '-04-02 15:47:57', '-04-02 15:47:57', null, null);INSERT INTO `dlwz_zqylx` VALUES ('2f3aad21d95044bfb0bcb30649dbeef1', '03', '1号区', '03', '1号区', '1', '-04-02 20:17:14', '-04-02 20:17:14', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('3d87bb0553574fbe840104fdda2af63b', '01', '医院1', '03', '医院1', '1', '-04-02 10:23:36', '-04-02 10:23:36', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('41273b83a3d748169393c95c823678b7', '05', '内公共区域', '01', '内公共区域', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('436c0b1b30e94e358740d30a274ec542', '06', '道路', '01', '道路', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('4cee7e6e498d4dfc843a91280b0171a8', '08', '武警', '01', '武警', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('4e61d1fe2d444722b4f86f9974a317ea', '02', '医院3', '03', '医院3', '1', '-04-02 10:26:39', '-04-02 10:26:39', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('5c0552ff138b438d90167d280f79e0b9', '03', '医院2', '03', '医院2', '1', '-04-02 10:25:20', '-04-02 10:25:20', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('6a09bef297c04202a8fdca3a69ba056b', '01', '医院2', '03', '医院2', '1', '-04-02 10:26:39', '-04-02 10:26:39', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('6ec9557d414c4bb9b5cdcb6b8e9c6a96', '04', '监舍楼', '01', '监舍楼', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('6f02e38634f84375be141a900df23370', '02', '医院3', '03', '医院3', '1', '-04-02 10:23:36', '-04-02 10:23:36', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('6ffc475bb42d4a0ab20f12bc2184008d', '02', '医务楼', '01', '医务楼', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('739d700d849c404da8181b238db71636', '03', '1号区', '03', '1号区', '1', '-04-02 20:14:59', '-04-02 20:14:59', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('78f1f90f318d4ab69cac9280be5f1050', '03', '1号区', '03', '1号区', '1', '-04-02 20:17:18', '-04-02 20:17:18', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('83e9b5d3cda946f8ad50721fd842c29e', '03', '1号地区', '03', '1号地区', '1', '-04-02 20:23:02', '-04-02 20:23:02', '-04-02 20:23:04', null);INSERT INTO `dlwz_zqylx` VALUES ('905f4177c22c437981aa54faa9708817', '03', '医院1', '03', '医院1', '1', '-04-02 10:26:39', '-04-02 10:26:39', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('964669647b0f49dd9854d965c98755a2', '01', '教学楼', '01', '教学楼', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('a1d62630147f4ea58132347e8a5bd6d5', '02', '医院3', '03', '医院3', '1', '-04-02 10:25:20', '-04-02 10:25:20', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('aac280379ab44996ae44eef468d2ed49', '02', '医院2', '03', '医院2', '1', '-04-02 10:26:53', '-04-02 10:26:53', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('ae622900f4bb42f18048c9439722f14a', '03', '医院1', '03', '医院1', '1', '-04-02 10:26:53', '-04-02 10:26:53', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('b2f23e3f46014ca2ba90687c9728da4b', '05', '厂房', '02', '厂房', '0', '-04-02 15:47:57', '-04-02 15:47:57', null, null);INSERT INTO `dlwz_zqylx` VALUES ('b489e9e76da64310aa77144774c942e9', '03', '医院2', '03', '医院2', '1', '-04-02 10:23:37', '-04-02 10:23:37', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('be766eead6474db5a1f87696b0f4e479', '01', '医院1', '03', '医院1', '1', '-04-02 10:25:20', '-04-02 10:25:20', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('c125955c443844d38aeefb93e323b62c', '01', '厂区', '02', '厂区', '0', '-04-02 15:47:57', '-04-02 15:47:57', null, null);INSERT INTO `dlwz_zqylx` VALUES ('ca4d25b6eb11485ab8f7e082660876ea', '04', '道路', '02', '道路', '0', '-04-02 15:47:57', '-04-02 15:47:57', null, null);INSERT INTO `dlwz_zqylx` VALUES ('d6ad0990f80049e09d1bb252313b9bf3', '07', '周界', '01', '周界', '0', '-04-02 15:47:27', '-04-02 15:47:27', null, null);INSERT INTO `dlwz_zqylx` VALUES ('d70cf7da4a4d4c94a5cc0f9253ba0371', '06', '武警', '02', '武警', '0', '-04-02 15:47:57', '-04-02 15:47:57', null, null);INSERT INTO `dlwz_zqylx` VALUES ('effec1f835804084a7c0a5092f142e5f', '01', '医院3', '03', '医院3', '1', '-04-02 10:26:53', '-04-02 10:26:53', '-04-02 20:23:02', null);INSERT INTO `dlwz_zqylx` VALUES ('fe8338b55afd45db8b3642033b8bea09', '01', 'A区域', '03', 'A区域', '1', '-04-02 19:58:34', '-04-02 19:58:34', '-04-02 20:23:02', null);-- ------------------------------ Table structure for job_entity-- ----------------------------DROP TABLE IF EXISTS `job_entity`;CREATE TABLE `job_entity` (`id` varchar(50) NOT NULL,`name` varchar(255) DEFAULT NULL,`job_group` varchar(255) DEFAULT NULL,`cron` varchar(255) DEFAULT NULL,`parameter` varchar(255) NOT NULL,`delay_second` int(6) DEFAULT NULL,`description` varchar(255) DEFAULT NULL,`status` tinyint(3) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of job_entity-- ------------------------------ ------------------------------ Table structure for qrtz_blob_triggers-- ----------------------------DROP TABLE IF EXISTS `qrtz_blob_triggers`;CREATE TABLE `qrtz_blob_triggers` (`SCHED_NAME` varchar(120) NOT NULL,`TRIGGER_NAME` varchar(200) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,`BLOB_DATA` blob,PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_blob_triggers-- ------------------------------ ------------------------------ Table structure for qrtz_calendars-- ----------------------------DROP TABLE IF EXISTS `qrtz_calendars`;CREATE TABLE `qrtz_calendars` (`SCHED_NAME` varchar(120) NOT NULL,`CALENDAR_NAME` varchar(200) NOT NULL,`CALENDAR` blob NOT NULL,PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_calendars-- ------------------------------ ------------------------------ Table structure for qrtz_cron_triggers-- ----------------------------DROP TABLE IF EXISTS `qrtz_cron_triggers`;CREATE TABLE `qrtz_cron_triggers` (`SCHED_NAME` varchar(120) NOT NULL,`TRIGGER_NAME` varchar(200) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,`CRON_EXPRESSION` varchar(120) NOT NULL,`TIME_ZONE_ID` varchar(80) DEFAULT NULL,PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_cron_triggers-- ------------------------------ ------------------------------ Table structure for qrtz_fired_triggers-- ----------------------------DROP TABLE IF EXISTS `qrtz_fired_triggers`;CREATE TABLE `qrtz_fired_triggers` (`SCHED_NAME` varchar(120) NOT NULL,`ENTRY_ID` varchar(95) NOT NULL,`TRIGGER_NAME` varchar(200) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,`INSTANCE_NAME` varchar(200) NOT NULL,`FIRED_TIME` bigint(13) NOT NULL,`SCHED_TIME` bigint(13) NOT NULL,`PRIORITY` int(11) NOT NULL,`STATE` varchar(16) NOT NULL,`JOB_NAME` varchar(200) DEFAULT NULL,`JOB_GROUP` varchar(200) DEFAULT NULL,`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_fired_triggers-- ------------------------------ ------------------------------ Table structure for qrtz_job_details-- ----------------------------DROP TABLE IF EXISTS `qrtz_job_details`;CREATE TABLE `qrtz_job_details` (`SCHED_NAME` varchar(120) NOT NULL,`JOB_NAME` varchar(200) NOT NULL,`JOB_GROUP` varchar(200) NOT NULL,`DESCRIPTION` varchar(250) DEFAULT NULL,`JOB_CLASS_NAME` varchar(250) NOT NULL,`IS_DURABLE` varchar(1) NOT NULL,`IS_NONCONCURRENT` varchar(1) NOT NULL,`IS_UPDATE_DATA` varchar(1) NOT NULL,`REQUESTS_RECOVERY` varchar(1) NOT NULL,`JOB_DATA` blob,PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_job_details-- ------------------------------ ------------------------------ Table structure for qrtz_locks-- ----------------------------DROP TABLE IF EXISTS `qrtz_locks`;CREATE TABLE `qrtz_locks` (`SCHED_NAME` varchar(120) NOT NULL,`LOCK_NAME` varchar(40) NOT NULL,PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_locks-- ----------------------------INSERT INTO `qrtz_locks` VALUES ('schedulerFactoryBean', 'STATE_ACCESS');INSERT INTO `qrtz_locks` VALUES ('schedulerFactoryBean', 'TRIGGER_ACCESS');-- ------------------------------ Table structure for qrtz_paused_trigger_grps-- ----------------------------DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;CREATE TABLE `qrtz_paused_trigger_grps` (`SCHED_NAME` varchar(120) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_paused_trigger_grps-- ------------------------------ ------------------------------ Table structure for qrtz_scheduler_state-- ----------------------------DROP TABLE IF EXISTS `qrtz_scheduler_state`;CREATE TABLE `qrtz_scheduler_state` (`SCHED_NAME` varchar(120) NOT NULL,`INSTANCE_NAME` varchar(200) NOT NULL,`LAST_CHECKIN_TIME` bigint(13) NOT NULL,`CHECKIN_INTERVAL` bigint(13) NOT NULL,PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_scheduler_state-- ----------------------------INSERT INTO `qrtz_scheduler_state` VALUES ('schedulerFactoryBean', 'huhu1554339789846', '1554349792620', '7500');-- ------------------------------ Table structure for qrtz_simple_triggers-- ----------------------------DROP TABLE IF EXISTS `qrtz_simple_triggers`;CREATE TABLE `qrtz_simple_triggers` (`SCHED_NAME` varchar(120) NOT NULL,`TRIGGER_NAME` varchar(200) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,`REPEAT_COUNT` bigint(7) NOT NULL,`REPEAT_INTERVAL` bigint(12) NOT NULL,`TIMES_TRIGGERED` bigint(10) NOT NULL,PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_simple_triggers-- ------------------------------ ------------------------------ Table structure for qrtz_simprop_triggers-- ----------------------------DROP TABLE IF EXISTS `qrtz_simprop_triggers`;CREATE TABLE `qrtz_simprop_triggers` (`SCHED_NAME` varchar(120) NOT NULL,`TRIGGER_NAME` varchar(200) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,`STR_PROP_1` varchar(512) DEFAULT NULL,`STR_PROP_2` varchar(512) DEFAULT NULL,`STR_PROP_3` varchar(512) DEFAULT NULL,`INT_PROP_1` int(11) DEFAULT NULL,`INT_PROP_2` int(11) DEFAULT NULL,`LONG_PROP_1` bigint(20) DEFAULT NULL,`LONG_PROP_2` bigint(20) DEFAULT NULL,`DEC_PROP_1` decimal(13,4) DEFAULT NULL,`DEC_PROP_2` decimal(13,4) DEFAULT NULL,`BOOL_PROP_1` varchar(1) DEFAULT NULL,`BOOL_PROP_2` varchar(1) DEFAULT NULL,PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_simprop_triggers-- ------------------------------ ------------------------------ Table structure for qrtz_triggers-- ----------------------------DROP TABLE IF EXISTS `qrtz_triggers`;CREATE TABLE `qrtz_triggers` (`SCHED_NAME` varchar(120) NOT NULL,`TRIGGER_NAME` varchar(200) NOT NULL,`TRIGGER_GROUP` varchar(200) NOT NULL,`JOB_NAME` varchar(200) NOT NULL,`JOB_GROUP` varchar(200) NOT NULL,`DESCRIPTION` varchar(250) DEFAULT NULL,`NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,`PREV_FIRE_TIME` bigint(13) DEFAULT NULL,`PRIORITY` int(11) DEFAULT NULL,`TRIGGER_STATE` varchar(16) NOT NULL,`TRIGGER_TYPE` varchar(8) NOT NULL,`START_TIME` bigint(13) NOT NULL,`END_TIME` bigint(13) DEFAULT NULL,`CALENDAR_NAME` varchar(200) DEFAULT NULL,`MISFIRE_INSTR` smallint(2) DEFAULT NULL,`JOB_DATA` blob,PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of qrtz_triggers-- ----------------------------