序
由于想自己扩展quartz的job以及trigger的查询方法，改为支持分页的，所以这里对着一些api查看下相应的表映射。
job
scheduler.getJobKeys(GroupMatcher.anyJobGroup());
scheduler.getJobDetail(JobKey.jobKey(name,group));
quartz-2.3.0-sources.jar!/org/quartz/impl/jdbcjobstore/StdJDBCDelegate.java
String SELECT_JOBS_IN_GROUP_LIKE = "SELECT " + COL_JOB_NAME + ", " + COL_JOB_GROUP
+ " FROM " + TABLE_PREFIX_SUBST + TABLE_JOB_DETAILS + " WHERE "
+ COL_SCHEDULER_NAME + " = " + SCHED_NAME_SUBST
+ " AND " + COL_JOB_GROUP + " LIKE ?";
直接查job_details表
trigger
scheduler.getTriggerKeys(GroupMatcher.triggerGroupEquals(group));
scheduler.getTrigger(TriggerKey.triggerKey(name,group));
quartz-2.3.0-sources.jar!/org/quartz/impl/jdbcjobstore/StdJDBCDelegate.java
String SELECT_TRIGGERS_IN_GROUP_LIKE = "SELECT "
+ COL_TRIGGER_NAME + ", " + COL_TRIGGER_GROUP + " FROM " + TABLE_PREFIX_SUBST + TABLE_TRIGGERS
+ " WHERE " + COL_SCHEDULER_NAME + " = " + SCHED_NAME_SUBST
+ " AND " + COL_TRIGGER_GROUP + " LIKE ?";
查TRIGGERS表
TRIGGERS表
- QRTZ_TRIGGERS
trigger信息的总表
- QRTZ_SIMPLE_TRIGGERS
simple trigger类型的详情表，通过trigger_name与总表关联
- QRTZ_CRON_TRIGGERS
cron trigger类型的详情表，通过trigger_name与总表关联
- QRTZ_BLOG_TRIGGERS
用户用JDBC自定义的Trigger类型的详情表
