插入语句不可直接插入空值,需要进行判断操作
insert into
test
(
apple
<if test="reason_code != null">,reason_code</if>)values(
#{apple}
<if test="reason_code != null">, #{reason_code}</if>
)
jobconfig.xnl
<!-- 测试 -->
<job id="testJob">
<step id="testStep">
<tasklet>test
<chunk reader="testUpdateReader" writer="testUpdateWriter" commit-interval="1" />
</tasklet>
</step>
</job>
ifp-batch-action.xml
<!-- Test-->
<bean id="testUpdateReader" class="com.mars.TestReader" scope="step" >
</bean>
<bean id="testUpdateWriter" class="com.mars.TestUpdateWriter" >
</bean>
quartz-config.xml
<!--测试 -->
<bean id="testJobDetail" class="org.springframework.scheduling.quartz.JobDetailFactoryBean">
<property name="jobClass" value="org.springframework.batch.sample.quartz.JobLauncherDetails" />
<property name="group" value="quartz-batch" />
<property name="jobDataAsMap">
<map>
<entry key="jobName" value="testJob" />
<entry key="jobLocator" value-ref="jobRegistry" />
<entry key="jobLauncher" value-ref="jobLauncher" />
</map>
</property>
</bean>
<bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
<property name="triggers">
<bean id="cronTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
<property name="jobDetail" ref="testJobDetail" />
<property name="cronExpression" value="0 0 0 * * * *" />
</bean>
</property>
</bean>
注:
CronTrigger配置完整格式为: [秒] [分] [小时] [日] [月] [周] [年]