1.页面提供一个功能供用户设置自己的scheduler时间定时发送邮件,对应把存储信息存入到数据库.
2.封装job具体信息对象 JobInfoVo:
private Integer jobId; private String jobName; private String groupName; private String triggerName; private String triggerGroupName; private String cronExpression; private String targetObject; private String targetMethod; private Integer targetSubId; private Integer jobStatus; private String createId; private String updateId; private Timestamp createDate; private Timestamp updateDate;
3.封装获取job具体信息JobDao:
ArrayList<JobInfoVo> list = new ArrayList<>(); Connection con = null; Statement stmt = null; ResultSet rs = null; try { con = JDBCUtil.getConnection(); con.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED); stmt = con.createStatement(); rs = stmt.executeQuery(GET_ALL_JOBS_SQL); while (rs.next()) { JobInfoVo job = new JobInfoVo(); job.setJobId(rs.getInt(1