设为首页 加入收藏

TOP

MapperScheduler.xml
2019-01-27 04:08:24 】 浏览:35
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的进阶部分解析

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

array(4) { ["type"]=> int(8) ["message"]=> string(24) "Undefined variable: jobs" ["file"]=> string(32) "/mnt/wp/cppentry/do/bencandy.php" ["line"]=> int(214) }