– Start
点击此处观看本系列配套视频。
假设我们有如下分隔符文件(people_20170711.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" />
<property name="password" value="123456" />
</bean>
&l