设为首页 加入收藏

TOP

MapperScheduler.xml
2019-01-27 04:08:24 】 浏览:83
Tags:MapperScheduler.xml

insert into da_qrtz_scheduler

(job_name,

trigger_id,

trigger_type,

trigger_expression,

created_by,

created_date,

updated_by,

updated_date)

values(

#{job_name, jdbcType = VARCHAR},

#{trigger_id, jdbcType = VARCHAR},

#{trigger_type, jdbcType = NUMERIC},

#{trigger_expression, jdbcType = VARCHAR},

#{created_by, jdbcType = VARCHAR},

sysdate,

#{created_by, jdbcType = VARCHAR},

sysdate

)

insert into DA_QRTZ_LOG

(

job_name,

trigger_id,

start_time,

end_time,

seconds_costed,

created_by,

created_date,

updated_by,

updated_date)

values(

#{job_name, jdbcType = VARCHAR},

#{trigger_id, jdbcType = VARCHAR},

#{start_time, jdbcType = TIMESTAMP},

#{end_time, jdbcType = TIMESTAMP},

#{seconds_costed, jdbcType = VARCHAR},

#{created_by, jdbcType = VARCHAR},

sysdate,

#{created_by, jdbcType = VARCHAR},

sysdate

)

delete from da_qrtz_scheduler where trigger_id = #{trigger_id, jdbcType = NUMERIC}


编程开发网
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇JDBC的介绍与使用 下一篇MySQL的进阶部分解析