spring 整合 quartz（二）

一 pox.xml 

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>xxxxx</groupId>
  <artifactId>jobs</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>jobs Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.5.RELEASE</spring.version>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.quartz-scheduler</groupId>
      <artifactId>quartz</artifactId>
      <version>2.2.1</version>
    </dependency>
    <dependency>
      <groupId>org.quartz-scheduler</groupId>
      <artifactId>quartz-jobs</artifactId>
      <version>2.2.1</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>1.7.21</version>
    </dependency>
    <!-- Spring dependencies -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>4.2.5.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.4</version>
    </dependency>
    <!-- 加入MyBatis 依赖 start -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.1</version>
    </dependency>
    <!-- 引用插件依赖：MyBatis整合Spring -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>
    <!-- oracle -->
    <dependency>
      <groupId>ojdbc14</groupId>
      <artifactId>ojdbc14</artifactId>
      <version>10.2.0.3.0</version>
    </dependency>
    <!-- httpclient -->
    <dependency>
      <groupId>org.apache.httpcomponents</groupId>
      <artifactId>httpclient</artifactId>
      <version>4.3.5</version>
    </dependency>
    <dependency>
      <groupId>org.apache.httpcomponents</groupId>
      <artifactId>httpmime</artifactId>
      <version>4.3.5</version>
    </dependency>
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.41</version>
    </dependency>
  </dependencies>

  <build>
    <finalName>jobs</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.0.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.7.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.20.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>
 二、system.properties

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@172.16.1.101:1522:xxx
validationQuery=SELECT 1 FROM DUAL
jdbc.username=xxx
jdbc.password=xx

#测试地址
#token_url=xxxxxxxxxxxxx
#detail_url=xxxxxxxxxxxx
#synchronizeNum=1000
三、quartz-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">

   <!-- 启动触发器的配置开始 -->
   <bean name="startQuertz" lazy-init="false" autowire="no"
      class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
      <property name="triggers">
         <list>
            <ref bean="myJobTrigger" />
            <ref bean="taskJobTrigger" />
         </list>
      </property>
   </bean>
   <!-- 启动触发器的配置结束 -->

   <!-- quartz-2.x的配置 -->
   <bean id="myJobTrigger"
      class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
      <property name="jobDetail">
         <ref bean="myJobDetail" />
      </property>
      <property name="cronExpression">
         <value>* * 2 * * ?</value>
      </property>
   </bean>
   <!-- 调度的配置结束 -->

   <bean id="taskJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
      <property name="jobDetail">
         <ref bean="myJobDetail" />
      </property>
      <property name="cronExpression">
         <value>0 45 9 8 11 ? 2018</value>
      </property>
   </bean>

   <!-- job的配置开始 -->
   <bean id="myJobDetail"
      class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
      <property name="targetObject">
         <ref bean="myJob" />
      </property>
      <property name="targetMethod">
         <value>execute</value>
      </property>
   </bean>
   <!-- job的配置结束 -->

   <!-- 工作的bean -->
   <bean id="myJob" class="com.xxx.jobs.Link" />

</beans>

四 mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
        <!-- 配置全局属性 -->
        <settings>
                <!-- 使用jdbc的getGeneratedKeys获取数据库自增主键值 -->
                <setting name="useGeneratedKeys" value="true" />

                <!-- 使用列别名替换列名 默认:true -->
                <setting name="useColumnLabel" value="true" />

                <!-- 开启驼峰命名转换:Table{create_time} -> Entity{createTime} -->
                <setting name="mapUnderscoreToCamelCase" value="true" />
                <setting name="logImpl" value="STDOUT_LOGGING"/>
        </settings>
</configuration>
五、log4j.properties

log4j.rootLogger=error,Console,FILE
# Console log config
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %10C{1} - %m%n
# File log config
log4j.appender.File=org.apache.log4j.RollingFileAppender
log4j.appender.File.File=/logs/jobs.log  
log4j.appender.File.Threshold=INFO
log4j.appender.File.MaxFileSize=100KB
log4j.appender.File.MaxBackupIndex=10
log4j.appender.File.layout=org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern=%d{HH:mm:ss} %-5p %10C{1} - %m%n

log4j.appender.FILE=org.apache.log4j.RollingFileAppender  
log4j.appender.FILE.Append=true  
log4j.appender.FILE.File=/logs/jobs.log  
log4j.appender.FILE.Threshold=INFO  
log4j.appender.FILE.layout=org.apache.log4j.PatternLayout  
log4j.appender.FILE.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} [%5p] - %c -%F(%L) -%m%n  
log4j.appender.FILE.MaxFileSize=10MB

六、applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
      xmlns:context="http://www.springframework.org/schema/context"
      xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
   <!--1 引入属性文件，在配置中占位使用 -->
   <context:property-placeholder location="classpath:system.properties" />

   <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
      <property name="location" value="classpath:system.properties" />
   </bean>
   <bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource">
      <property name="driverClassName" value="${jdbc.driver}" />
      <property name="url" value="${jdbc.url}" />
      <property name="username" value="${jdbc.username}" />
      <property name="password" value="${jdbc.password}" />
      <property name="initialSize" value="2" />
      <property name="maxActive" value="50" />
      <property name="maxIdle" value="20" />
      <property name="minIdle" value="10" />
      <property name="maxWait" value="1000" />
      <property name="poolPreparedStatements" value="true" />

      <property name="logAbandoned" value="true" />

      <property name="removeAbandoned" value="true" />

      <property name="removeAbandonedTimeout" value="60000" />

      <property name="timeBetweenEvictionRunsMillis" value="60000" />


      <property name="numTestsPerEvictionRun" value="10" />


      <property name="minEvictableIdleTimeMillis" value="60000" />
   </bean>


   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

      <property name="dataSource" ref="datasource"></property>
      <property name="configLocation" value="classpath:mybatis-config.xml" />

      <property name="typeAliasesPackage" value="com.xxx.entity"></property>

      <property name="mapperLocations" value="classpath:mapper/*Mapper.xml"></property>
   </bean>


   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

      <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>

      <property name="basePackage" value="com.xxx.dao"></property>
   </bean>


   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="datasource"></property>
   </bean>

   <context:component-scan base-package="com.xxx">
      <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
   </context:component-scan>

 <!--引入定时任务配置-->
   <import resource="classpath:quartz-config.xml" />
</beans>

七、mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--命名空间应该是对应接口的包名+接口名 -->
<mapper namespace="com.xxx.dao.MobileDao">

    <select id="list" parameterType="map" resultType="Mobile">
        <![CDATA[
         SELECT *
        FROM (SELECT row_number() over(PARTITION BY 1 ORDER BY s.creation_date asc) rn,
                s.mobile
              FROM Mobile s
              where s.xxx is not null
         ) qyv
       WHERE   qyv.rn > #{startIndex}
         AND qyv.rn <= #{endIndex}
        ]]>

    </select>

    <select id="getTotal" resultType="Integer">
        select count(1) from Mobile s  where s.mobile is not null
    </select>


    <insert id="add" parameterType="Mobile">
         insert into Mobile(mobile,last_login_date,last_refresh_time) values (#{mobile},to_date(#{lastLoginDate}, 'yyyy-mm-dd hh24:mi:ss'),sysdate)
    </insert>

    <select id="delAll">
        delete  from Mobile s
    </select>
</mapper>

八 jobs

public class Link implements Job {
    Logger log = Logger.getLogger(Job.class);

    public UserService userService;

    @Autowired
public MobileService mobileService;

    @Value("${token_url}")
    private String tokenUrl;

    @Value("${detail_url}")
    private String detail_url;

    @Value("${synchronizeNum}")
    private Integer synchronizeNum;

    @Autowired
public void setUserService(UserService userService) {
        this.userService = userService;
    }

    private SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    public Link() {
    }
    @Override
public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {

    }

   public void execute(){

        try {
            log.error("开始时间****************************************"+simpleDateFormat.format(new Date()));
            long start=System.currentTimeMillis();
            long end=System.currentTimeMillis();

           Long f = (System.currentTimeMillis() - start) / (1000 * 60);

if(f>20){

                start=System.currentTimeMillis();
      }

        }catch (Exception e){
            log.error("同步最后时间报错->{}" + e);
        }
       log.error("结束时间****************************************"+simpleDateFormat.format(new Date()));
    }

}
九、web.xml

<!DOCTYPEweb-appPUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
  <display-name>jobs</display-name>
  <!-- Spring config start -->
<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>

  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
</web-app>

Mobile