基于quartz的定时任务(4)

response) throws ServletException, IOException{

}

//暂停定时任务

public ActionForward pauseJobAction(ActionMapping

JobForm jobForm = (JobForm)form; String id = jobForm.getId(); if(id!=null){ }

return null;

boolean result = QuartzManager.resumeJob(id); if(result){ }

response.sendRedirect(\);

mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{

}

//语言转换成cron

public String StringToCron(JobForm form){

String dateMode = form.getDateMode(); String cron=\;

if(dateMode.equals(\详细\)){ cron=\+form.getMinutes()+\+form.getHours()+\

}else if(dateMode.equals(\每日\)){ cron=\+form.getMinutes()+\+form.getHours()+\; }else if(dateMode.equals(\每周\)){ cron=\+form.getMinutes()+\+form.getHours()+\}else if(dateMode.equals(\每月\)){ cron=\+form.getMinutes()+\+form.getHours()+\}else if(dateMode.equals(\)){ }

return cron;

cron=form.getCron();

JobForm jobForm = (JobForm)form; String id = jobForm.getId(); if(id!=null){ }

return null;

boolean result = QuartzManager.pauseJob(id); if(result){ }

response.sendRedirect(\);

\+form.getDay()+\+form.getMonth()+\+form.getYear();

\+form.getWeek()+\;

\+form.getDay()+\;

}

public List formatJob(List list){

for(int i=0;i

JobPo job = list.get(i); switch (job.getWeek()){ case 1: }

String dateMode = job.getDateMode(); if(dateMode.equals(\详细\)){

job.setDateStr(job.getDateMode()+\+job.getYear()+\年job.setWeekStr(\星期一\); break;

job.setWeekStr(\星期二\); break;

job.setWeekStr(\星期三\); break;

job.setWeekStr(\星期四\); break;

job.setWeekStr(\星期五\); break;

job.setWeekStr(\星期六\); break;

job.setWeekStr(\星期天\); break;

case 2:

case 3:

case 4:

case 5:

case 6:

case 7:

\+job.getMonth()+\月\+job.getDay()+\日 \+job.getHours()+\+job.getMinutes());

}else if(dateMode.equals(\每日\)){ job.setDateStr(job.getDateMode()+\

}else if(dateMode.equals(\每周\)){ job.setDateStr(job.getDateMode()+\+job.getWeekStr()+\}else if(dateMode.equals(\每月\)){

\+job.getHours()+\+job.getMinutes());

\+job.getHours()+\+job.getMinutes());

job.setDateStr(job.getDateMode()+\+job.getDay()+\日

\+job.getHours()+\+job.getMinutes());

}else if(dateMode.equals(\)){ }

job.setDateStr(job.getDateMode()+\+job.getCron());

}

}

String state = job.getState(); if(state==null){

job.setState(\已失效\);

}else if(state.equals(\)){ job.setState(\运行中\);

}else if(state.equals(\)){ job.setState(\暂停\); }else if(state.equals(\)){ job.setState(\已失效\); }

return list;

返回json数据用于制作树

public class RemindToAction extends MappingDispatchAction{

public ActionForward getRemindToAction(ActionMapping mapping, }

HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {

ActionForm form,

Gson gson = new Gson();

List jsons = new ArrayList(); RemindToDao dao = new RemindToDao();

List numbers = new ArrayList();//存放成员 List departments = new ArrayList();//存放组织，组departments=dao.getDepartments();//获取组织 numbers = dao.getNumbers(); String department=\;

for (int i = 0; i < departments.size(); i++) {

department=departments.get(i);

int personid=addJson(jsons, department); for(int j=0;j

}

if(numbers.get(j).getGroup().equals(department)){

织分1级

addJson(jsons,numbers.get(j).getName(),personid);

}

String jsonString = gson.toJson(jsons); response.setCharacterEncoding(\); response.getWriter().write(jsonString); return null;

//新建一个根节点，并且加入到原来的list中。返回新生成根目录的id public int addJson(List json,String rootName){ }

//新建一个节点，并且加入到原来的list中,其中pid为指定的pid

public void addJson(List json,String rootName,int pid){ }

public void addJson(List json,String rootName,String }

int i = json.size()+1;

WhryTree treeNode = new WhryTree(); treeNode.setId(i); treeNode.setpId(pid); treeNode.setName(rootName); treeNode.setTel(tel); json.add(treeNode); int i = json.size()+1;

WhryTree treeNode = new WhryTree(); treeNode.setId(i); treeNode.setpId(pid); treeNode.setName(rootName); json.add(treeNode); int i = json.size()+1;

WhryTree treeNode = new WhryTree(); treeNode.setId(i); treeNode.setpId(0);

treeNode.setName(rootName); json.add(treeNode); return i;

tel,int pid){

数据操作

public class RemindDao {

private static ResultSet rs=null;

public List getAllJob(String createName){

+\

+\as state FROM job List jobs = new ArrayList(); String sql = \

job.id,job.title,job.createName,job.cron,job.mode,job.remindTo\

.minutes\

left join qrtz_job_details on qrtz_job_details.JOB_NAME=job.id left join qrtz_triggers on job.id =qrtz_triggers.TRIGGER_NAME where

createName='\+createName+\;

}

public JobPo getJobById(String id){

JobPo job = new JobPo(); String sql = \

Connection conn = DBConnection.initConnection(); try{ }

return jobs;

Statement st = conn.createStatement(); if(st!=null&sql!=null){ }

while(rs.next()){ }

e.printStackTrace();

DBConnection.closeConnection(conn);

JobPo job =new JobPo();

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.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(\)); jobs.add(job);

rs = st.executeQuery(sql);

}catch(Exception e){ }finally{

job.id,job.title,job.createName,job.cron,job.mode,job.remindTo,job.context,qrtz_triggers.TRIGGER_STATE as

state,job.dateMode,job.week,job.year,job.month,job.day,job.hours,job.minutes FROM job left join qrtz_job_details on

qrtz_job_details.JOB_NAME=job.id left join qrtz_triggers on job.id =qrtz_triggers.TRIGGER_NAME where\+

\+id+\;

Connection conn = DBConnection.initConnection(); try{