How to custom Spring Batch DelimitedLineTokenizer？

最新推荐文章于 2024-08-20 18:34:05 发布

wyy6713

最新推荐文章于 2024-08-20 18:34:05 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： spring-batch

本文链接：https://blog.youkuaiyun.com/wyy6713/article/details/71173166

spring-batch 专栏收录该内容

0 篇文章

订阅专栏

本文介绍如何在Spring Batch中针对以$符号分隔的CSV文件，定制DelimitedLineTokenizer进行数据解析。内容涉及配置文件的修改和自定义分隔符的设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天在用spring batch分析csv文件的时候，由于csv文件是以$进行分割的，所以需要在配置文件中添加一个属性：

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:batch="http://www.springframework.org/schema/batch" 
    xmlns:task="http://www.springframework.org/schema/task"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/batch
        http://www.springframework.org/schema/batch/spring-batch-2.2.xsd
        http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd">

    <bean id="report" class="com.mkyong.model.Report" scope="prototype" />

    <batch:job id="reportJob">
        <batch:step id="step1">
            <batch:tasklet>
                <batch:chunk reader="cvsFileItemReader" writer="mysqlItemWriter"
                    commit-interval="2">
                </batch:chunk>
            </batch:tasklet>
        </batch:step>
    </batch:job>

    <bean id="cvsFileItemReader" class="org.springframework.batch.item.file.FlatFileItemReader">

        <!-- Read a csv file -->
        <property name="resource" value="classpath:cvs/report.csv" />

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

                <!-- split it -->
                <property name="lineTokenizer">
                    <bean
                        class="org.springframework.batch.item.file.transform.DelimitedLineTokenizer">
                        **<property name="delimiter" value="$"/>**
                        <property name="names" value="id,docnum,pubdate,appldate,classipcr,title,pabstract,applicant,address,inventor" />
                    </bean>
                </property>

                <property name="fieldSetMapper">

                    <!-- return back to reader, rather than a mapped object. -->
                    <!--
                        <bean class="org.springframework.batch.item.file.mapping.PassThroughFieldSetMapper" />
                    -->

                    <!-- map to an object -->
                    <bean
                        class="org.springframework.batch.item.file.mapping.BeanWrapperFieldSetMapper">
                        <property name="prototypeBeanName" value="report" />
                    </bean>

                </property>

            </bean>
        </property>

    </bean>

    <bean id="mysqlItemWriter"
        class="org.springframework.batch.item.database.JdbcBatchItemWriter">
        <property name="dataSource" ref="dataSource" />
        <property name="sql">
            <value>
            <![CDATA[        
                insert into patent_invention(id,docnum,pubdate,appldate,classipcr,title,pabstract,applicant,
                address,inventor) values (:id, :docnum, :pubdate, :appldate,:classipcr,:title,:pabstract,:applicant,:address,:inventor)
            ]]>
            </value>
        </property>
        <!-- It will take care matching between object property and sql name parameter -->
        <property name="itemSqlParameterSourceProvider">
            <bean
                class="org.springframework.batch.item.database.BeanPropertyItemSqlParameterSourceProvider" />
        </property>
    </bean>

</beans>