package com.zskk.task; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.jfinal.kit.PropKit; import com.jfinal.plugin.activerecord.Db; import com.jfinal.plugin.activerecord.Record; import com.jfinal.plugin.cron4j.ITask; import com.zskk.service.DataService; import com.zskk.service.ServiceFactory; import com.zskk.service.ThreadPoolService; public class PrintTask implements ITask { @Override public void run() { // TODO Auto-generated method stub DataService dService = ServiceFactory.getService(DataService.class); List records = Db.use("print").find("select top 80 * from IMAGEVIEW where ADDTIME >? order by ADDTIME desc",parseStringToDate1()); for (Record record : records) { try { if (record == null) { continue; } Map annex_params = new HashMap<>(); annex_params.put("institution_id", PropKit.get("institution_id")); annex_params.put("type", "2"); annex_params.put("code", record.getStr("CHECKID")); //附件类型1.mp4 2.pdf 3.jpeg 4.png annex_params.put("annex_class_code", "4"); annex_params.put("exam_datetime", parseStringToDate(record.getStr("ADDTIME"))); dService.saveAnnex(annex_params, record.getStr("IMGURL")); } catch (Exception e) { // TODO: handle exception continue; } } } @Override public void stop() { // TODO Auto-generated method stub } /** * 日期字符串格式转换 * @param dateStr * @return */ private String parseStringToDate(String dateStr) { if (dateStr == null) { return ""; } SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date = null; String timeString = null; try { date = sdf.parse(dateStr); SimpleDateFormat sdf2= new SimpleDateFormat("yyyyMMdd"); timeString = sdf2.format(date); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } return timeString; } /** * 日期字符串格式转换 * * @param dateStr * @return */ private String parseStringToDate1() { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date = new Date(); String timeString = null; Long i = date.getTime(); Long j = i - 43200000; Date newdate = new Date(j); timeString = sdf.format(newdate); return timeString; } }