1.配置spring.xml
openRateScheduledService :定时任务类
cron="0 49 12 * * ?" ：时间设置
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:task="http://www.springframework.org/schema/task" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.0.xsd"> <task:executor id="taskExecutor" pool-size="10" /> <task:scheduled-tasks > <task:scheduled ref="openRateScheduledService" method="doTask" cron="0 49 12 * * ?"/> </task:scheduled-tasks> </beans>
2.配置web.xml
classpath:spring/applicationContext-quartz.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> <display-name>dapail</display-name> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/classes/spring/applicationContext-*.xml</param-value> </context-param> <context-param> <param-name>contextConfigLocation</param-name> <param-value> classpath:spring/applicationContext-core-spec.xml classpath:spring/applicationContext-quartz.xml classpath:spring/applicationContext-dao.xml classpath:spring/applicationContext-service.xml classpath:spring/applicationContext-transaction.xml classpath:spring/applicationContext-redis.xml </param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <servlet> <servlet-name>mvc-dispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring/mvc-dispatcher.xml</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>mvc-dispatcher</servlet-name> <url-pattern>*.action</url-pattern> </servlet-mapping> <filter> <filter-name>CharacterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <context-param> <param-name>spring.profiles.active</param-name> <param-value>dev</param-value> </context-param> <context-param> <param-name>spring.profiles.default</param-name> <param-value>dev</param-value> </context-param> <context-param> <param-name>spring.liveBeansView.mbeanDomain</param-name> <param-value>dev</param-value> </context-param> </web-app>
3.Java
package com.dapail.manager.service.task; import java.math.BigDecimal; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.HashMap; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.dapail.common.IResult; import com.dapail.common.ResultData; import com.dapail.manager.cache.CmdCache; import com.dapail.manager.mapper.WorkerMapper; import com.dapail.util.MLogger; /** * 开机率统计 * * @author Administrator * */ @Service public class OpenRateScheduledService { // 指令 @Autowired private CmdCache cmdCache; @Autowired private WorkerMapper workerMapper; // 每天凌晨两点执行 记录所有账户 上一天的机器使用率 public void doTask() { long begin = System.currentTimeMillis(); MLogger.info("/" + begin + "t_stats_open_rate start"); // 往前推一天 Calendar c1 = Calendar.getInstance(); int paDay = c1.get(Calendar.DATE); c1.set(Calendar.DATE, paDay - 1); String daytime = new SimpleDateFormat("yyyyMMdd").format(c1.getTime()); String cmdKey = daytime; // 循环账户 t_ratio List<Object> acc = workerMapper.getAccountList(); IResult accRes = new ResultData(acc); for (int i = 0; i < accRes.size(); i++) { // 账户类别 String account_type = accRes.get(i).get("ACCOUNT_TYPE").toString(); // 账户id String account_id = accRes.get(i).get("ACCOUNT_ID").toString(); // 账户下机器列表 List<Object> maAccList = workerMapper.getRatioByAccId(account_id); IResult maAccIR = new ResultData(maAccList); // 名下所有机器 int accAllNum = maAccIR.size(); // 当日开机率 String openPercent = "0"; if (maAccIR.size()>0) { String[] machineId = new String[maAccIR.size()]; // 账户下机器列表 for (int j = 0; j < maAccIR.size(); j++) { // 机器id machineId[j] = maAccIR.get(j).get("MACHINE_ID").toString(); } MLogger.info("/机器列表：t_stats_open_rate start+machineId：" + machineId + ""); // 当日 机器数加1 List<String> ma = cmdCache.getMaOpenTime(cmdKey, machineId); int maOpenNum = 0; for (int j = 0; j < ma.size(); j++) { if (ma.get(j) != null && ma.get(j).equals("")) { maOpenNum = maOpenNum + 1; } } BigDecimal maOpenNumb1 = new BigDecimal(String.valueOf(maOpenNum)); BigDecimal accAllNumb2 = new BigDecimal(String.valueOf(accAllNum)); // 小数点保留0位 openPercent = String.format("%.0f", maOpenNumb1.divide(accAllNumb2, 2, BigDecimal.ROUND_HALF_UP).doubleValue() * 100); } Map<String, Object> map = new HashMap<String, Object>(); // 经销商 if (account_type.equals("3")) { account_type = "2"; } // 棋牌室 if (account_type.equals("2")) { account_type = "1"; } map.put("other_id", account_id); map.put("type", account_type); map.put("open_time", daytime); map.put("open_rate", openPercent); map.put("open_details", ""); map.put("timestamps", System.currentTimeMillis() / 1000); // 插入一条 MLogger.info("/插入一条：t_stats_open_rate start+account_id：" + account_id + "+account_type：" + account_type + "+daytime：" + daytime + "+openPercent：" + openPercent + ""); workerMapper.insertStateOpen(map); } // 执行数据库操作了哦... long end = System.currentTimeMillis(); MLogger.info("/" + end + "t_stats_open_rate start"); } }
