Package com.bytedesk.team.member

Class MemberExcelListener

java.lang.Object

com.bytedesk.team.member.MemberExcelListener

All Implemented Interfaces:

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

public class MemberExcelListener
extends Object
implements com.alibaba.excel.read.listener.ReadListener<MemberExcel>

Field Summary

Fields

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

Constructor Summary

Constructors

Constructor	Description
MemberExcelListener()

Method Summary

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

memberService

private final MemberRestService memberService

orgUid

private final String orgUid

BATCH_COUNT

private static final int BATCH_COUNT

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

See Also:

• Constant Field Values

cachedDataList

private List<MemberEntity> cachedDataList

缓存的数据

Constructor Details

MemberExcelListener

public MemberExcelListener()

Method Details

invoke

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

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

Specified by:

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

doAfterAllAnalysed

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

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

Specified by:

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

saveData

private void saveData()

加上存储数据库