Package com.bytedesk.kbase.taboo

Class TabooExcelListener

java.lang.Object

com.bytedesk.kbase.taboo.TabooExcelListener

All Implemented Interfaces:

com.alibaba.excel.event.Listener, com.alibaba.excel.read.listener.ReadListener<TabooExcel>

public class TabooExcelListener
extends Object
implements com.alibaba.excel.read.listener.ReadListener<TabooExcel>

Field Summary

Fields

Modifier and Type	Field	Description
private static final int	BATCH_COUNT	每隔5条存储数据库，实际使用中可以100条，然后清理list ，方便内存回收
private List<TabooEntity>	cachedDataList	缓存的数据
private final String	kbUid
private final String	orgUid
private final TabooRestService	tabooService

Constructor Summary

Constructors

Constructor	Description
TabooExcelListener()

Method Summary

Modifier and Type	Method	Description
void	doAfterAllAnalysed(com.alibaba.excel.context.AnalysisContext context)	所有数据解析完成了 都会来调用
void	invoke(TabooExcel data, com.alibaba.excel.context.AnalysisContext context)	这个每一条数据解析都会来调用
private void	saveData()	加上存储数据库

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.alibaba.excel.read.listener.ReadListener

extra, hasNext, invokeHead, onException

Field Details

tabooService

private final TabooRestService tabooService

kbUid

private final String kbUid

orgUid

private final String orgUid

BATCH_COUNT

private static final int BATCH_COUNT

每隔5条存储数据库，实际使用中可以100条，然后清理list ，方便内存回收

See Also:

• Constant Field Values

cachedDataList

private List<TabooEntity> cachedDataList

缓存的数据

Constructor Details

TabooExcelListener

public TabooExcelListener()

Method Details

invoke

public void invoke(TabooExcel data,
 com.alibaba.excel.context.AnalysisContext context)

这个每一条数据解析都会来调用

Specified by:

invoke in interface com.alibaba.excel.read.listener.ReadListener<TabooExcel>

doAfterAllAnalysed

public void doAfterAllAnalysed(com.alibaba.excel.context.AnalysisContext context)

所有数据解析完成了 都会来调用

Specified by:

doAfterAllAnalysed in interface com.alibaba.excel.read.listener.ReadListener<TabooExcel>

saveData

private void saveData()

加上存储数据库