Jboss下载xls文件直接打开

本文介绍如何通过配置web.xml中的mime-mapping元素来实现特定文件类型的直接下载功能,而不是在浏览器中打开。这对于.xls等文件尤其有用,确保用户能够直接下载而非预览。

<mime-mapping>    
                <extension>xls</extension>    
                <mime-type>application/octet-stream</mime-type>    
</mime-mapping>

 

web.xml保存以上内容,即可不会打开,直接下载。

"D:\Program Files\Java\jdk1.8.0_341\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:61671,suspend=y,server=n "-javaagent:C:\Users\CHENWA~1\AppData\Local\Temp\captureAgent8jars\debugger-agent.jar=file:///C:/Users/CHENWA~1/AppData/Local/Temp/capture5276736573713696330.props" -Dvisualgc.id=29936704522800 -Dkotlinx.coroutines.debug.enable.creation.stack.trace=false -Ddebugger.agent.enable.coroutines=true -Dkotlinx.coroutines.debug.enable.flows.stack.trace=true -Dkotlinx.coroutines.debug.enable.mutable.state.flows.stack.trace=true -Dfile.encoding=UTF-8 -classpath "D:\Program Files\Java\jdk1.8.0_341\jre\lib\charsets.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\deploy.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\access-bridge-64.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\cldrdata.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\dnsns.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\jaccess.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\jfxrt.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\localedata.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\nashorn.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\sunec.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\sunjce_provider.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\sunmscapi.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\sunpkcs11.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\ext\zipfs.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\javaws.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\jce.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\jfr.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\jfxswt.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\jsse.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\management-agent.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\plugin.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\resources.jar;D:\Program Files\Java\jdk1.8.0_341\jre\lib\rt.jar;D:\Java_workspace\boot_mybatis\target\classes;D:\apache-maven-3.9.6\repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\1.3.0\mybatis-spring-boot-starter-1.3.0.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-starter\1.5.6.RELEASE\spring-boot-starter-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot\1.5.6.RELEASE\spring-boot-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-starter-logging\1.5.6.RELEASE\spring-boot-starter-logging-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\apache-maven-3.9.6\repository\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\apache-maven-3.9.6\repository\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\apache-maven-3.9.6\repository\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\apache-maven-3.9.6\repository\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\apache-maven-3.9.6\repository\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-starter-jdbc\1.5.6.RELEASE\spring-boot-starter-jdbc-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\apache\tomcat\tomcat-jdbc\8.5.16\tomcat-jdbc-8.5.16.jar;D:\apache-maven-3.9.6\repository\org\apache\tomcat\tomcat-juli\8.5.16\tomcat-juli-8.5.16.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-jdbc\4.3.10.RELEASE\spring-jdbc-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-tx\4.3.10.RELEASE\spring-tx-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\1.3.0\mybatis-spring-boot-autoconfigure-1.3.0.jar;D:\apache-maven-3.9.6\repository\org\mybatis\mybatis\3.4.4\mybatis-3.4.4.jar;D:\apache-maven-3.9.6\repository\org\mybatis\mybatis-spring\1.3.1\mybatis-spring-1.3.1.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-starter-thymeleaf\1.5.6.RELEASE\spring-boot-starter-thymeleaf-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\thymeleaf\thymeleaf-spring4\2.1.5.RELEASE\thymeleaf-spring4-2.1.5.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\thymeleaf\thymeleaf\2.1.5.RELEASE\thymeleaf-2.1.5.RELEASE.jar;D:\apache-maven-3.9.6\repository\ognl\ognl\3.0.8\ognl-3.0.8.jar;D:\apache-maven-3.9.6\repository\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\apache-maven-3.9.6\repository\org\unbescape\unbescape\1.1.0.RELEASE\unbescape-1.1.0.RELEASE.jar;D:\apache-maven-3.9.6\repository\nz\net\ultraq\thymeleaf\thymeleaf-layout-dialect\1.4.0\thymeleaf-layout-dialect-1.4.0.jar;D:\apache-maven-3.9.6\repository\org\codehaus\groovy\groovy\2.4.12\groovy-2.4.12.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-starter-web\1.5.6.RELEASE\spring-boot-starter-web-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-starter-tomcat\1.5.6.RELEASE\spring-boot-starter-tomcat-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\apache\tomcat\embed\tomcat-embed-core\8.5.16\tomcat-embed-core-8.5.16.jar;D:\apache-maven-3.9.6\repository\org\apache\tomcat\embed\tomcat-embed-el\8.5.16\tomcat-embed-el-8.5.16.jar;D:\apache-maven-3.9.6\repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.16\tomcat-embed-websocket-8.5.16.jar;D:\apache-maven-3.9.6\repository\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\apache-maven-3.9.6\repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\apache-maven-3.9.6\repository\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\apache-maven-3.9.6\repository\com\fasterxml\classmate\1.3.3\classmate-1.3.3.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-web\4.3.10.RELEASE\spring-web-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-aop\4.3.10.RELEASE\spring-aop-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-beans\4.3.10.RELEASE\spring-beans-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-context\4.3.10.RELEASE\spring-context-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-webmvc\4.3.10.RELEASE\spring-webmvc-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-expression\4.3.10.RELEASE\spring-expression-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\springframework\spring-core\4.3.10.RELEASE\spring-core-4.3.10.RELEASE.jar;D:\apache-maven-3.9.6\repository\mysql\mysql-connector-java\5.1.35\mysql-connector-java-5.1.35.jar;D:\apache-maven-3.9.6\repository\com\fasterxml\jackson\core\jackson-core\2.8.9\jackson-core-2.8.9.jar;D:\apache-maven-3.9.6\repository\com\fasterxml\jackson\core\jackson-databind\2.8.9\jackson-databind-2.8.9.jar;D:\apache-maven-3.9.6\repository\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\apache-maven-3.9.6\repository\com\fasterxml\jackson\datatype\jackson-datatype-joda\2.8.9\jackson-datatype-joda-2.8.9.jar;D:\apache-maven-3.9.6\repository\joda-time\joda-time\2.9.9\joda-time-2.9.9.jar;D:\apache-maven-3.9.6\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.8.9\jackson-module-parameter-names-2.8.9.jar;D:\apache-maven-3.9.6\repository\com\github\pagehelper\pagehelper-spring-boot-starter\1.1.2\pagehelper-spring-boot-starter-1.1.2.jar;D:\apache-maven-3.9.6\repository\com\github\pagehelper\pagehelper-spring-boot-autoconfigure\1.1.2\pagehelper-spring-boot-autoconfigure-1.1.2.jar;D:\apache-maven-3.9.6\repository\com\github\pagehelper\pagehelper\5.0.3\pagehelper-5.0.3.jar;D:\apache-maven-3.9.6\repository\com\github\jsqlparser\jsqlparser\1.0\jsqlparser-1.0.jar;D:\apache-maven-3.9.6\repository\com\alibaba\druid-spring-boot-starter\1.1.0\druid-spring-boot-starter-1.1.0.jar;D:\apache-maven-3.9.6\repository\com\alibaba\druid\1.1.0\druid-1.1.0.jar;D:\Program Files\Java\jdk1.8.0_341\lib\jconsole.jar;D:\Program Files\Java\jdk1.8.0_341\lib\tools.jar;D:\apache-maven-3.9.6\repository\org\springframework\boot\spring-boot-autoconfigure\1.5.6.RELEASE\spring-boot-autoconfigure-1.5.6.RELEASE.jar;D:\apache-maven-3.9.6\repository\org\apache\poi\poi\5.2.3\poi-5.2.3.jar;D:\apache-maven-3.9.6\repository\commons-codec\commons-codec\1.10\commons-codec-1.10.jar;D:\apache-maven-3.9.6\repository\org\apache\commons\commons-collections4\4.4\commons-collections4-4.4.jar;D:\apache-maven-3.9.6\repository\org\apache\commons\commons-math3\3.6.1\commons-math3-3.6.1.jar;D:\apache-maven-3.9.6\repository\commons-io\commons-io\2.11.0\commons-io-2.11.0.jar;D:\apache-maven-3.9.6\repository\com\zaxxer\SparseBitSet\1.2\SparseBitSet-1.2.jar;D:\apache-maven-3.9.6\repository\org\apache\poi\poi-ooxml\5.2.3\poi-ooxml-5.2.3.jar;D:\apache-maven-3.9.6\repository\org\apache\poi\poi-ooxml-lite\5.2.3\poi-ooxml-lite-5.2.3.jar;D:\apache-maven-3.9.6\repository\org\apache\xmlbeans\xmlbeans\5.1.1\xmlbeans-5.1.1.jar;D:\apache-maven-3.9.6\repository\xml-apis\xml-apis\1.4.01\xml-apis-1.4.01.jar;D:\apache-maven-3.9.6\repository\org\apache\commons\commons-compress\1.21\commons-compress-1.21.jar;D:\apache-maven-3.9.6\repository\com\github\virtuald\curvesapi\1.07\curvesapi-1.07.jar;D:\apache-maven-3.9.6\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;D:\apache-maven-3.9.6\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\apache-maven-3.9.6\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\apache-maven-3.9.6\repository\cn\hutool\hutool-all\5.8.11\hutool-all-5.8.11.jar;D:\apache-maven-3.9.6\repository\org\apache\logging\log4j\log4j-api\2.23.1\log4j-api-2.23.1.jar;D:\apache-maven-3.9.6\repository\org\apache\logging\log4j\log4j-core\2.23.1\log4j-core-2.23.1.jar;D:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2025.1.1.1\lib\idea_rt.jar" com.example.util.Main Connected to the target VM, address: '127.0.0.1:61671', transport: 'socket' Exception in thread "main" org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:296) at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:749) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:322) at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:59) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:290) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:286) at com.example.util.ExcelParserUtil.parseExcelAndInsertData(ExcelParserUtil.java:29) at com.example.util.Main.main(Main.java:11) Disconnected from the target VM, address: '127.0.0.1:61671
最新发布
10-24
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值