Spring Batch 例子: 导入定长文件到数据库

– Start
点击此处观看本系列配套视频。

---

假设我们有如下定长文件(people_20170716.txt)

header
1       zhangsan                       
2       lisi                           
3       wangwu                         
footer

需要导入如下表中

CREATE TABLE PEOPLE
(
    ID    NUMBER(8,0), 
    NAME  VARCHAR2(30)
);

来看看如何配置这个 job 吧

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:batch="http://www.springframework.org/schema/batch"
	xsi:schemaLocation="http://www.springframework.org/schema/batch 
		http://www.springframework.org/schema/batch/spring-batch.xsd
		http://www.springframework.org/schema/beans 
		http://www.springframework.org/schema/beans/spring-beans.xsd">
	
	<!-- 定义  dataSource -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
	    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
	    <property name="url" value="jdbc:oracle:thin:@localhost:1521:xe" />
	    <property name="username" value="hr" />
	    &