數(shù)據(jù)導(dǎo)出為Excel的接口報java.io.IOException: UT010029: Stream is closed錯誤
實(shí)習(xí)時導(dǎo)師讓寫一個平臺信息導(dǎo)出為Excel的功能，寫完之后發(fā)現(xiàn)文件正常導(dǎo)出，但控制臺一直報
Stream is closed錯誤。在網(wǎng)上找了大半天，都說是使用OutputStream時關(guān)閉了流導(dǎo)致的，這也確實(shí)是可能導(dǎo)致報錯的原因之一，但我并未手動關(guān)閉OutputStream，排查半天，問了旁邊大佬才知道文件下載接口不能有返回值。。。。。。。。。。因?yàn)榻涌诒徽{(diào)用后response會自動關(guān)閉ServletOutputStream,而return時會再次自動關(guān)閉OutputStream，就會導(dǎo)致Stream is closed問題。
以下為問題記錄（讀者可忽略）
導(dǎo)出文件正常：
報錯信息：
java.io.IOException: UT010029: Stream is closed
at io.undertow.servlet.spec.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:138)
at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2171)
at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1184)
at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:1009)
at org.springblade.core.tool.jackson.AbstractReadWriteJackson2HttpMessageConverter.writeInternal(AbstractReadWriteJackson2HttpMessageConverter.java:116)
at org.springblade.core.tool.jackson.MappingApiJackson2HttpMessageConverter.writeInternal(MappingApiJackson2HttpMessageConverter.java:73)
at org.springframework.http.converter.AbstractGenericHttpMessageConverter.write(AbstractGenericHttpMessageConverter.java:104)
at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:290)
at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.handleReturnValue(RequestResponseBodyMethodProcessor.java:183)
at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:78)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:135)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.springblade.core.log.filter.LogTraceFilter.doFilter(LogTraceFilter.java:39)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springblade.core.boot.request.BladeRequestFilter.doFilter(BladeRequestFilter.java:58)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1423)
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
at java.lang.Thread.run(Thread.java:750)
報錯接口如下：
@GetMapping("/exportExcel")
@ApiOperationSupport(order = 10)
@ApiOperation(value = "導(dǎo)出數(shù)據(jù)為Excel表格", notes = "導(dǎo)出數(shù)據(jù)為Excel表格")
public R exportExcel(@ApiParam(value = "表單id", required = true) @RequestParam Long formId,
@ApiParam(value = "數(shù)據(jù)列表ids", required = true) @RequestParam String ids,
HttpServletResponse response) {
List<Map<String, Object>> data;
List<Long> longIds = Func.toLongList(ids);
//通過表單id，獲取表單配置
FormEntity formEntity = formService.getById(formId);
if (null == formEntity) {
return R.fail("未查詢到表單");
// throw new ServiceException("未查詢到表單");
}
// 標(biāo)題字段name
Set<String> title;
// 導(dǎo)出的字段列表
List<FormFieldDTO> formLabels;
try {
Long modelId = formEntity.getModelId();
ModelBase model = modelBaseService.getById(modelId);
String tableName = model.getName();
Integer type = model.getType();
// 獲取當(dāng)前表單的字段信息
List<FormFieldDTO> formFields = formService.getFormFieldsInfoByFormId(formId);
Set<String> fieldSet = formFields.stream()
.filter(item -> item.getModelFieldId() != null)
.map(FormFieldDTO::getName)
.collect(Collectors.toSet());
// 更換數(shù)據(jù)源
Long dataSourceId = model.getSourceId();
if (dataSourceId != null) {
DynamicDataSourceContextHolder.push(dataSourceId.toString());
}
// 獲取當(dāng)前表單的所有字段
List<Map<String, Object>> fieldsList = baseSqlService.getAllFields(tableName, type);
Set<String> allFields = fieldsList.get(0).keySet();
// 求公共字段
fieldSet.retainAll(allFields);
// 獲取公共字段對應(yīng)的name
formLabels = formFields.stream().filter(item -> fieldSet.contains(item.getName())).collect(Collectors.toList());
// 判斷數(shù)據(jù)庫表中是否存在status字段
if (allFields.contains("status")){
fieldSet.add("status");
}
// 提取字段名
// 通過IFNULL函數(shù)解決mybatis映射Map時忽略控制字段問題
title = fieldSet;
String fields = String.join(",", fieldSet);
data = baseSqlService.queryFieldsByIds(tableName, fields, longIds);
} catch (Exception e) {
return R.fail(e.toString());
// e.printStackTrace();
// return;
} finally {
// 將數(shù)據(jù)源切換回來
DynamicDataSourceContextHolder.clear();
}
// 結(jié)果數(shù)據(jù)匹配中文信息
List<Map<String, Object>> recordsWrapper = BaseListRecordsWrapper.build().wrapper(data, formEntity.getStyleJson());
// 獲取表單列表中不存在的字段名
// **此處需要創(chuàng)建新的HashSet對象，否則removeAll會刪除原信息值**
Set<String> recordFields = new HashSet<>(recordsWrapper.get(0).keySet());
recordFields.removeAll(title);
recordFields.forEach(item -> {
FormFieldDTO formFieldDTO = new FormFieldDTO();
formFieldDTO.setName(item);
if ("statusName".equals(item)) {
formFieldDTO.setLabel("狀態(tài)");
} else if ("create_user_name".equals(item)){
formFieldDTO.setLabel("創(chuàng)建人");
} else {
formFieldDTO.setLabel(item);
}
formLabels.add(formFieldDTO);
});
// 剔除原有的status，僅導(dǎo)出statusName即可
if (recordFields.contains("statusName")){
recordsWrapper.forEach(item -> item.remove("status"));
title.remove("status");
}
if (recordFields.contains("create_user_name")){
recordsWrapper.forEach(item -> item.remove("create_user"));
title.remove("create_user");
}
// 將多出的字段添加至標(biāo)題（如statusName）
title.addAll(recordFields);
Date date = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
try {
ExportUtil.writeExcel(response, recordsWrapper, dateFormat.format(date), "默認(rèn)頁", title, formLabels);
} catch (IOException e) {
log.error(e.toString());
}
return R.success("下載成功！");
}
}
修改后：
@GetMapping("/exportExcel")
@ApiOperationSupport(order = 10)
@ApiOperation(value = "導(dǎo)出數(shù)據(jù)為Excel表格", notes = "導(dǎo)出數(shù)據(jù)為Excel表格")
public void exportExcel(@ApiParam(value = "表單id", required = true) @RequestParam Long formId,
@ApiParam(value = "數(shù)據(jù)列表ids", required = true) @RequestParam String ids,
HttpServletResponse response) {
List<Map<String, Object>> data;
List<Long> longIds = Func.toLongList(ids);
//通過表單id，獲取表單配置
FormEntity formEntity = formService.getById(formId);
if (null == formEntity) {
throw new ServiceException("未查詢到表單");
}
// 標(biāo)題字段name
Set<String> title;
// 導(dǎo)出的字段列表
List<FormFieldDTO> formLabels;
try {
Long modelId = formEntity.getModelId();
ModelBase model = modelBaseService.getById(modelId);
String tableName = model.getName();
Integer type = model.getType();
// 獲取當(dāng)前表單的字段信息
List<FormFieldDTO> formFields = formService.getFormFieldsInfoByFormId(formId);
Set<String> fieldSet = formFields.stream()
.filter(item -> item.getModelFieldId() != null)
.map(FormFieldDTO::getName)
.collect(Collectors.toSet());
// 更換數(shù)據(jù)源
Long dataSourceId = model.getSourceId();
if (dataSourceId != null) {
DynamicDataSourceContextHolder.push(dataSourceId.toString());
}
// 獲取當(dāng)前表單的所有字段
List<Map<String, Object>> fieldsList = baseSqlService.getAllFields(tableName, type);
Set<String> allFields = fieldsList.get(0).keySet();
// 求公共字段
fieldSet.retainAll(allFields);
// 獲取公共字段對應(yīng)的name
formLabels = formFields.stream().filter(item -> fieldSet.contains(item.getName())).collect(Collectors.toList());
// 判斷數(shù)據(jù)庫表中是否存在status字段
if (allFields.contains("status")){
fieldSet.add("status");
}
// 提取字段名
// 通過IFNULL函數(shù)解決mybatis映射Map時忽略控制字段問題
title = fieldSet;
String fields = String.join(",", fieldSet);
data = baseSqlService.queryFieldsByIds(tableName, fields, longIds);
} catch (Exception e) {
e.printStackTrace();
return;
} finally {
// 將數(shù)據(jù)源切換回來
DynamicDataSourceContextHolder.clear();
}
// 結(jié)果數(shù)據(jù)匹配中文信息
List<Map<String, Object>> recordsWrapper = BaseListRecordsWrapper.build().wrapper(data, formEntity.getStyleJson());
// 獲取表單列表中不存在的字段名
// **此處需要創(chuàng)建新的HashSet對象，否則removeAll會刪除原信息值**
Set<String> recordFields = new HashSet<>(recordsWrapper.get(0).keySet());
recordFields.removeAll(title);
recordFields.forEach(item -> {
FormFieldDTO formFieldDTO = new FormFieldDTO();
formFieldDTO.setName(item);
if ("statusName".equals(item)) {
formFieldDTO.setLabel("狀態(tài)");
} else if ("create_user_name".equals(item)){
formFieldDTO.setLabel("創(chuàng)建人");
} else {
formFieldDTO.setLabel(item);
}
formLabels.add(formFieldDTO);
});
// 剔除原有的status，僅導(dǎo)出statusName即可
if (recordFields.contains("statusName")){
recordsWrapper.forEach(item -> item.remove("status"));
title.remove("status");
}
if (recordFields.contains("create_user_name")){
recordsWrapper.forEach(item -> item.remove("create_user"));
title.remove("create_user");
}
// 將多出的字段添加至標(biāo)題（如statusName）
title.addAll(recordFields);
Date date = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
try {
ExportUtil.writeExcel(response, recordsWrapper, dateFormat.format(date), "默認(rèn)頁", title, formLabels);
} catch (IOException e) {
log.error(e.toString());
}
}
再次調(diào)用接口已無報錯：文章來源：http://www.zghlxwxcb.cn/news/detail-793404.html
文章來源地址http://www.zghlxwxcb.cn/news/detail-793404.html
到了這里，關(guān)于【Spring】數(shù)據(jù)導(dǎo)出為Excel的接口報java.io.IOException: UT010029: Stream is closed錯誤的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
