Package com.bytedesk.kbase.faq

Class FaqExcelListener

java.lang.Object

com.bytedesk.kbase.faq.FaqExcelListener

All Implemented Interfaces:

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

public class FaqExcelListener
extends Object
implements com.alibaba.excel.read.listener.ReadListener<FaqExcel>

Field Summary

Fields

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

Constructor Summary

Constructors

Constructor	Description
FaqExcelListener()

Method Summary

Modifier and Type	Method	Description
void	doAfterAllAnalysed(com.alibaba.excel.context.AnalysisContext context)	所有数据解析完成了 都会来调用
void	invoke(FaqExcel 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

faqService

private final FaqRestService faqService

uploadType

private final String uploadType

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<FaqEntity> cachedDataList

缓存的数据

Constructor Details

FaqExcelListener

public FaqExcelListener()

Method Details

invoke

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

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

Specified by:

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

doAfterAllAnalysed

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

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

Specified by:

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

saveData

private void saveData()

加上存储数据库