}
}
Statement st = conn.createStatement(); if(st!=null&sql!=null){ }
while(rs.next()){ }
e.printStackTrace();
DBConnection.closeConnection(conn);
job.setId(rs.getString(\)); job.setTitle(rs.getString(\));
job.setCreateName(rs.getString(\)); job.setContext(rs.getString(\)); job.setMode(rs.getInt(\));
job.setRemindTo(rs.getString(\)); job.setState(rs.getString(\)); job.setCron(rs.getString(\));
job.setDateMode(rs.getString(\)); job.setWeek(rs.getInt(\)); job.setYear(rs.getInt(\)); job.setMonth(rs.getInt(\)); job.setDay(rs.getInt(\)); job.setHours(rs.getInt(\)); job.setMinutes(rs.getInt(\)); rs = st.executeQuery(sql);
}catch(Exception e){ }finally{
return job;
public boolean deleteJobById(String id){
String sql = \+id +\; boolean result = false;
Connection conn = DBConnection.initConnection(); if(id==null|id==\){ } try{
Statement st = conn.createStatement(); if(st!=null&sql!=null){ }
e.printStackTrace();
st.executeUpdate(sql); result = true; return result;
}catch(Exception e){ }finally{
}
}
DBConnection.closeConnection(conn);
return result;
public boolean updateJob(JobForm job){
boolean result = false; String sql = null; String quartzSql = null;
if(job.getId()!=null&job.getId()!=\){
sql = \+job.getId()+\ +\+job.getTitle()+\
+\+job.getCreateName()+\ +\+job.getContext()+\ +\+job.getMode()+\
+\+job.getRemindTo()+\ +\+job.getDateMode()+\ +\+job.getWeek()+\ +\+job.getYear()+\ +\+job.getMonth()+\ +\+job.getDay()+\ +\+job.getHours()+\ +\+job.getMinutes()+\
+\+job.getCron()+\+job.getId()+\; quartzSql = \
CRON_EXPRESSION='\+job.getCron()+\TRIGGER_NAME='\+job.getId()+\;
}else{ }
Connection conn = DBConnection.initConnection(); try{ }
return result;
Statement st = conn.createStatement(); if(st!=null&sql!=null){ }
e.printStackTrace(); result = false;
DBConnection.closeConnection(conn);
st.executeUpdate(sql); st.executeUpdate(quartzSql); result = true; return result;
}catch(Exception e){
}finally{
}
public boolean addJob(JobForm job){
boolean result = false; String sql = null;
if(job.getId()!=null&job.getId()!=\){
sql = \
job(id,title,createName,cron,mode,remindTo,context,dateMode,week,year,month,\+\ +
}
public String getRemindToNumber(String remindTo){
}
Connection conn = DBConnection.initConnection(); try{ }
return result;
Statement st = conn.createStatement(); if(st!=null&sql!=null){ }
e.printStackTrace(); result = false;
DBConnection.closeConnection(conn);
st.executeUpdate(sql); result = true;
\ +job.getId()+\ +job.getTitle()+\ +job.getCreateName()+\ +job.getCron()+\ +job.getMode()+\ +job.getRemindTo()+\
+job.getContext()+\ +job.getDateMode()+\ +job.getWeek()+\ +job.getYear()+\ +job.getMonth()+\ +job.getDay()+\ +job.getHours()+\ +job.getMinutes() +\;
}else{
return result;
}catch(Exception e){
}finally{
String result=\;
String[] remindToArray =remindTo.split(\); ResultSet resultSet=null; String str =\;
for(int i=0;i str=str+\;//加''是为了和for循环最后一个，进行配对 String sql = \whry_tel from cs_whry where whry_name in\+str; Connection conn = DBConnection.initConnection(); try{ Statement st = conn.createStatement(); resultSet = st.executeQuery(sql); while(resultSet.next()){ } result = result.substring(0, result.length()-1);//去掉最后的 result+=resultSet.getString(\)+\; str+=\+remindToArray[i]+\; 一个， }catch(Exception e){ } public boolean getJobFromQuatzById(String id){ } boolean reault=false; String sql = \ResultSet resultSet=null; Connection conn = DBConnection.initConnection(); try{ } return reault; Statement st = conn.createStatement(); resultSet = st.executeQuery(sql); while(resultSet.next()){ } e.printStackTrace(); DBConnection.closeConnection(conn); reault=true; } return result; e.printStackTrace(); DBConnection.closeConnection(conn); }finally{ JOB_NAME='\+id+\; }catch(Exception e){ }finally{ } 数据库： quratz自带数据库 JOB表用于存放定时任务的提醒内容，提醒时间，向谁提醒等内容 drop table if exists job; create table job(`id` varchar(100) not null,`title` varchar(100), `createName` varchar(45) not null ,`cron` varchar(15) default null, `mode` int(3) default null,`remindTo` text default null, `context` text default null,`dateMode` varchar(15),`week` varchar(15),`year` int(4),`month` int(2),`day` int(2),`hours` int(2), `minutes` int(2) )engine=MyISAM DEFAULT CHARSET=latin1; 执行定时任务 public class RemindJob implements Job{ } public RemindJob(){ } @Override public void execute(JobExecutionContext context) throws } JobDataMap data = context.getJobDetail().getJobDataMap(); String id = data.getString(\); RemindDao dao = new RemindDao(); JobPo job = dao.getJobById(id); //int mode = job.getMode(); String remindTo = job.getRemindTo(); String remindToNumber = dao.getRemindToNumber(remindTo); String msg = job.getContext()+job.getCreateName(); //发送短信 SendSms.sendSms(remindToNumber, msg); JobExecutionException { JSP使用了struts的标签和boostrap的样式 短信提醒列表 <%@ page language=\ import=\ pageEncoding=\%>