java - 在 Spring Batch Flatfile Reader 中跳过页脚和页眉记录

Question

我有一个 Spring 批处理作业来读取 CSV 文件，该文件有标题和预告片。要跳过页眉只需跳过第一行，但如何跳过页脚记录呢？

这是我的读者简化:

<bean id="flatFileItemReader" class="org.springframework.batch.item.file.FlatFileItemReader"
        scope="step">

        <property name="resource" value="file:#{jobParameters[file]}" />
        <property name="linesToSkip" value="1" />
        <property name="lineMapper">

            <bean class="org.springframework.batch.item.file.mapping.DefaultLineMapper">

                <property name="fieldSetMapper">

                    <bean class="ben.Mapper" />
                </property>

                <property name="lineTokenizer">

                    <bean
                        class="org.springframework.batch.item.file.transform.DelimitedLineTokenizer">
                        <property name="delimiter" value="," />
                    </bean>
                </property>

            </bean>

        </property>

    </bean>

Answer 1

试试这个:

public class SkipFooterLineMapper extends DefaultLineMapper<XXX> {

    @Override
    public XXX mapLine(String line, int lineNumber) throws Exception {
        // skip the footer as footer like this: T~2952
        if(line != null && line.split("~").length == 2) {  
            return null;
        }
        return super.mapLine(line, lineNumber);
    }

}

FlatFileItemReader<XXX> bean = new FlatFileItemReader<>();
bean.setResource(new FileSystemResource(pathToFile));

// skip the header
bean.setLinesToSkip(1);
bean.setLineMapper(lineMapper());