Spring Batch 从数据库提取记录存放在text中

package com.yang.batch;

import java.sql.Date;

public class Module {

	private int id;
	private String moduleName;
	private String moduleSvnUrl;
	private int executeStruts;
	private Date lastExecuteDate; 
	private String moduleSvnStruts;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getModuleName() {
		return moduleName;
	}
	public void setModuleName(String moduleName) {
		this.moduleName = moduleName;
	}
	public String getModuleSvnUrl() {
		return moduleSvnUrl;
	}
	public void setModuleSvnUrl(String moduleSvnUrl) {
		this.moduleSvnUrl = moduleSvnUrl;
	}
	public int getExecuteStruts() {
		return executeStruts;
	}
	public void setExecuteStruts(int executeStruts) {
		this.executeStruts = executeStruts;
	}
	public String getModuleSvnStruts() {
		return moduleSvnStruts;
	}
	public void setModuleSvnStruts(String moduleSvnStruts) {
		this.moduleSvnStruts = moduleSvnStruts;
	}
	public Date getLastExecuteDate() {
		return lastExecuteDate;
	}
	public void setLastExecuteDate(Date lastExecuteDate) {
		this.lastExecuteDate = lastExecuteDate;
	}
	
	
}
<?xml version="1.0" encoding="UTF-8"?>
<bean:beans xmlns="http://www.springframework.org/schema/batch" xmlns:bean="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx-3.0.xsd 
	http://www.springframework.org/schema/aop 
	http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context-2.5.xsd 
	http://www.springframework.org/schema/batch 
	http://www.springframework.org/schema/batch/spring-batch-2.2.xsd">

	<job id="db2textJob">
		<step id="step_db2textJob">
			<tasklet transaction-manager="transactionManager">
				<chunk reader="jdbcItemReader" writer="textFileWriter" commit-interval="1" />
			</tasklet>
		</step>
	</job>

	<bean:bean id="jdbcItemReader" class="org.springframework.batch.item.database.JdbcCursorItemReader" scope="step">
		<bean:property name="dataSource" ref="dataSource" />
		<bean:property name="sql">
			<bean:value>
				SELECT id, moduleName, moduleSvnUrl, executeStruts, moduleSvnStruts 
				FROM tbl_module
			</bean:value>
		</bean:property>
		<bean:property name="rowMapper">
			<bean:bean class="org.springframework.jdbc.core.BeanPropertyRowMapper">
				<bean:property name="mappedClass" value="com.yang.batch.Module"/>
			</bean:bean>
		</bean:property>
	</bean:bean>

	<bean:bean id="textFileWriter" class="org.springframework.batch.item.file.FlatFileItemWriter" scope="step">
		<bean:property name="resource" value="file:src/outputTextFile.text" />
		<bean:property name="lineAggregator" ref="lineAggregator" />
	</bean:bean>

	<bean:bean id="lineAggregator" class="org.springframework.batch.item.file.transform.DelimitedLineAggregator">
		<bean:property name="delimiter" value="|" />
		<bean:property name="fieldExtractor">
			<bean:bean class="org.springframework.batch.item.file.transform.BeanWrapperFieldExtractor">
				<bean:property name="names">
					<bean:list>
						<bean:value>id</bean:value>
						<bean:value>moduleName</bean:value>
						<bean:value>moduleSvnUrl</bean:value>
						<bean:value>executeStruts</bean:value>
						<bean:value>lastExecuteDate</bean:value>
						<bean:value>moduleSvnStruts</bean:value>
					</bean:list>
				</bean:property>
			</bean:bean>
		</bean:property>
	</bean:bean>
</bean:beans>


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值