com.diboot.components.controller

类 BaseExcelImportController

java.lang.Object

com.diboot.framework.controller.BaseController

com.diboot.framework.controller.BaseCrudController

com.diboot.components.controller.BaseExcelImportController

public abstract class BaseExcelImportController
extends com.diboot.framework.controller.BaseCrudController

Excel导入基类

版本:

2017/9/18

作者:

Mazc@dibo.ltd

字段概要

字段

限定符和类型	字段和说明
protected com.diboot.framework.service.BaseFileService	baseFileService
private static Map<String,List<ExcelColumn>>	excelColumnMap 获取Excel列的定义
protected ExcelColumnService	excelColumnService
protected com.diboot.framework.service.ExcelImportRecordService	excelImportRecordService
private static org.slf4j.Logger	logger
protected static String	PARAM_IMPORT_UUID

从类继承的字段 com.diboot.framework.controller.BaseController

asyncLogger, ERROR, isEnabledAccessLog, isEnabledOperationLog, KEY_PROMPT_MSG, metadataService, MODEL, MODEL_LIST, PARAM_ORDERBY, PARAM_PAGE, PARAM_PAGESIZE, REDIRECT_TO

构造器概要

构造器

构造器和说明
BaseExcelImportController()

方法概要

限定符和类型	方法和说明
protected String	afterCreated(javax.servlet.http.HttpServletRequest request, List<String[]> dataList)
protected void	attachMore4View(Object id, com.diboot.framework.model.BaseModel model, org.springframework.ui.ModelMap modelMap)
protected <T extends com.diboot.framework.model.BaseModel> List<T>	convert2ModelList(List<String[]> dataList, boolean isPreview) 将Excel数据转化为ModelList
protected void	enhanceModel(List<? extends com.diboot.framework.model.BaseModel> modelList) 附加其他属性到model
protected List<String[]>	extract2List(String excelFilePath) 提取excel内容到List
protected List<String>	extractInvalidList(List<String> inputList, Map<String,Object> realMap) 获取未能匹配的值，用于transform
protected abstract com.diboot.framework.service.BaseService	getBusinessService() 获取业务的service
private List<ExcelColumn>	getExcelColumnList(String modelClass) 加载表格列定义
protected abstract Class<?>	getModelClass() 获取Model类
protected com.diboot.framework.service.BaseService	getService()
String	listPaging(int pageIndex, javax.servlet.http.HttpServletRequest request, org.springframework.ui.ModelMap modelMap) 列表页处理
String	preview(javax.servlet.http.HttpServletRequest request, org.springframework.ui.ModelMap modelMap) 预览处理
String	previewSave(javax.servlet.http.HttpServletRequest request, org.springframework.ui.ModelMap modelMap) 预览保存
protected List<String[]>	saveExcelFiles(javax.servlet.http.HttpServletRequest request, com.diboot.framework.model.BaseModel model, String... fileInputName) 保存上传文件
protected List<String[]>	transform(List<ExcelColumn> excelColumns, List<String[]> dataList, boolean isPreview) 关联关系转换，如导入 员工姓名 转为 员工id
String	upload(javax.servlet.http.HttpServletRequest request, org.springframework.ui.ModelMap modelMap) 直接上传

从类继承的方法 com.diboot.framework.controller.BaseCrudController

afterCreated, afterDeleted, afterUpdated, attachMore, beforeCreate, beforeDelete, beforeUpdate, create, createPage, delete, getCustomPageSize, getRedirectUrlWithQueryParams, home, index, list, update, updatePage, viewPage

从类继承的方法 com.diboot.framework.controller.BaseController

addAdditionalPromptMsg, addFailResultMsg, addIntoSession, addResultMsg, addSuccessResultMsg, appendAdditionalCriteria, bindCriteria, bindError, bindErrors, bindResultMsg, buildJsonError, buildPagination, buildQueryCriteria, criteria2paramString, dumpParams, getBindingError, getBoolean, getBoolean, getDouble, getDouble, getFromSession, getInteger, getInteger, getLong, getLong, getLongList, getParamsMap, getString, getString, getStringArray, getStringList, getUrlPrefix, getViewPrefix, isContinue, newCriteria, redirectTo, view

从类继承的方法 java.lang.Object

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

字段详细资料

logger

private static final org.slf4j.Logger logger

baseFileService

@Autowired
protected com.diboot.framework.service.BaseFileService baseFileService

excelColumnService

@Autowired
protected ExcelColumnService excelColumnService

excelImportRecordService

@Autowired
protected com.diboot.framework.service.ExcelImportRecordService excelImportRecordService

PARAM_IMPORT_UUID

protected static final String PARAM_IMPORT_UUID

另请参阅:

常量字段值

excelColumnMap

private static Map<String,List<ExcelColumn>> excelColumnMap

获取Excel列的定义

构造器详细资料

BaseExcelImportController

public BaseExcelImportController()

方法详细资料

getModelClass

protected abstract Class<?> getModelClass()

获取Model类

返回:

getBusinessService

protected abstract com.diboot.framework.service.BaseService getBusinessService()

获取业务的service

返回:

listPaging

public String listPaging(int pageIndex,
                         javax.servlet.http.HttpServletRequest request,
                         org.springframework.ui.ModelMap modelMap)
                  throws Exception

列表页处理

覆盖:

listPaging 在类中 com.diboot.framework.controller.BaseCrudController

参数:

pageIndex -

request -

modelMap -

返回:

抛出:

Exception

preview

public String preview(javax.servlet.http.HttpServletRequest request,
                      org.springframework.ui.ModelMap modelMap)
               throws Exception

预览处理

参数:

request -

modelMap -

返回:

抛出:

Exception

previewSave

public String previewSave(javax.servlet.http.HttpServletRequest request,
                          org.springframework.ui.ModelMap modelMap)
                   throws Exception

预览保存

参数:

request -

modelMap -

返回:

抛出:

Exception

upload

public String upload(javax.servlet.http.HttpServletRequest request,
                     org.springframework.ui.ModelMap modelMap)
              throws Exception

直接上传

参数:

request -

modelMap -

返回:

抛出:

Exception

enhanceModel

protected void enhanceModel(List<? extends com.diboot.framework.model.BaseModel> modelList)
                     throws Exception

附加其他属性到model

参数:

modelList -

抛出:

Exception

afterCreated

protected String afterCreated(javax.servlet.http.HttpServletRequest request,
                              List<String[]> dataList)
                       throws Exception

抛出:

Exception

attachMore4View

protected void attachMore4View(Object id,
                               com.diboot.framework.model.BaseModel model,
                               org.springframework.ui.ModelMap modelMap)
                        throws Exception

覆盖:

attachMore4View 在类中 com.diboot.framework.controller.BaseCrudController

抛出:

Exception

getExcelColumnList

private List<ExcelColumn> getExcelColumnList(String modelClass)
                                      throws Exception

加载表格列定义

抛出:

Exception

extract2List

protected List<String[]> extract2List(String excelFilePath)
                               throws Exception

提取excel内容到List

参数:

excelFilePath -

返回:

抛出:

Exception

transform

protected List<String[]> transform(List<ExcelColumn> excelColumns,
                                   List<String[]> dataList,
                                   boolean isPreview)
                            throws Exception

关联关系转换，如导入 员工姓名 转为 员工id

参数:

excelColumns -

dataList -

返回:

抛出:

Exception

convert2ModelList

protected <T extends com.diboot.framework.model.BaseModel> List<T> convert2ModelList(List<String[]> dataList,
                                                                                     boolean isPreview)
                                                                              throws Exception

将Excel数据转化为ModelList

参数:

dataList -

返回:

抛出:

Exception

saveExcelFiles

protected List<String[]> saveExcelFiles(javax.servlet.http.HttpServletRequest request,
                                        com.diboot.framework.model.BaseModel model,
                                        String... fileInputName)
                                 throws Exception

保存上传文件

参数:

request -

model -

fileInputName -

返回:

抛出:

Exception

extractInvalidList

protected List<String> extractInvalidList(List<String> inputList,
                                          Map<String,Object> realMap)

获取未能匹配的值，用于transform

参数:

inputList -

realMap -

返回:

getService

protected com.diboot.framework.service.BaseService getService()

指定者:

getService 在类中 com.diboot.framework.controller.BaseCrudController