devbox
不正经
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Maven 项目依赖问题解决--ZipException: invalid LOC header (bad signature)_zipexception: unexpected record signature: 0x622f2

作者：不正经 | 2024-06-03 20:16:44

赞

踩

zipexception: unexpected record signature: 0x622f2123
报错日志 
  1. 六月 09, 2018 6:38:46 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
  2. 警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:PocketScoreWeb' did not find a matching property.
  3. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  4. 信息: Server version:        Apache Tomcat/8.5.31
  5. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  6. 信息: Server built:          Apr 27 2018 20:24:25 UTC
  7. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  8. 信息: Server number:         8.5.31.0
  9. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  10. 信息: OS Name:               Windows 7
  11. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  12. 信息: OS Version:            6.1
  13. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  14. 信息: Architecture:          amd64
  15. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  16. 信息: Java Home:             F:\soft\Java\jdk1.8.0_144\jre
  17. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  18. 信息: JVM Version:           1.8.0_144-b01
  19. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  20. 信息: JVM Vendor:            Oracle Corporation
  21. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  22. 信息: CATALINA_BASE:         F:\study\project\server\.metadata\.plugins\org.eclipse.wst.server.core\tmp0
  23. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  24. 信息: CATALINA_HOME:         F:\soft\apache-tomcat-8.5.31
  25. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  26. 信息: Command line argument: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:51632
  27. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  28. 信息: Command line argument: -Dcatalina.base=F:\study\project\server\.metadata\.plugins\org.eclipse.wst.server.core\tmp0
  29. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  30. 信息: Command line argument: -Dcatalina.home=F:\soft\apache-tomcat-8.5.31
  31. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  32. 信息: Command line argument: -Dwtp.deploy=F:\study\project\server\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps
  33. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  34. 信息: Command line argument: -Djava.endorsed.dirs=F:\soft\apache-tomcat-8.5.31\endorsed
  35. 六月 09, 2018 6:38:46 下午 org.apache.catalina.startup.VersionLoggerListener log
  36. 信息: Command line argument: -Dfile.encoding=UTF-8
  37. 六月 09, 2018 6:38:46 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
  38. 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [F:\soft\Java\jdk1.8.0_144\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;F:/soft/Java/jdk1.8.0_144/bin/../jre/bin/server;F:/soft/Java/jdk1.8.0_144/bin/../jre/bin;F:/soft/Java/jdk1.8.0_144/bin/../jre/lib/amd64;.;F:\soft\Java\jdk1.8.0_144\bin;F:\soft\Java\jdk1.8.0_144\lib;C:\ProgramData\Oracle\Java\javapath;F:\soft\Java\jdk1.8.0_144\bin;F:\soft\Java\jdk1.8.0_144\jre\bin;C:\Software\apache-maven-3.5.0\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Program Files (x86)\Tesseract-OCR;F:\soft\Git\cmd;F:\soft\nodejs\;C:\Users\Administrator\AppData\Roaming\npm;F:\soft\eclipseneon;;.]
  39. 六月 09, 2018 6:38:47 下午 org.apache.coyote.AbstractProtocol init
  40. 信息: Initializing ProtocolHandler ["http-nio-8080"]
  41. 六月 09, 2018 6:38:47 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
  42. 信息: Using a shared selector for servlet write/read
  43. 六月 09, 2018 6:38:47 下午 org.apache.coyote.AbstractProtocol init
  44. 信息: Initializing ProtocolHandler ["ajp-nio-8009"]
  45. 六月 09, 2018 6:38:47 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
  46. 信息: Using a shared selector for servlet write/read
  47. 六月 09, 2018 6:38:47 下午 org.apache.catalina.startup.Catalina load
  48. 信息: Initialization processed in 1719 ms
  49. 六月 09, 2018 6:38:47 下午 org.apache.catalina.core.StandardService startInternal
  50. 信息: Starting service [Catalina]
  51. 六月 09, 2018 6:38:47 下午 org.apache.catalina.core.StandardEngine startInternal
  52. 信息: Starting Servlet Engine: Apache Tomcat/8.5.31
  53. 六月 09, 2018 6:38:48 下午 org.apache.catalina.core.ContainerBase startInternal
  54. 严重: A child container failed during start
  55. java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[]]
  56. 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
  57. 	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
  58. 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:941)
  59. 	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:872)
  60. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  61. 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1421)
  62. 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1411)
  63. 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  64. 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  65. 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  66. 	at java.lang.Thread.run(Thread.java:748)
  67. Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[]]
  68. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
  69. 	... 6 more
  70. Caused by: org.apache.catalina.LifecycleException: Failed to start component [org.apache.catalina.webresources.StandardRoot@6e9d3c2]
  71. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
  72. 	at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:4907)
  73. 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5042)
  74. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  75. 	... 6 more
  76. Caused by: org.apache.catalina.LifecycleException: Failed to initialize component [org.apache.catalina.webresources.JarResourceSet@43734660]
  77. 	at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:112)
  78. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140)
  79. 	at org.apache.catalina.webresources.StandardRoot.startInternal(StandardRoot.java:724)
  80. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  81. 	... 9 more
  82. Caused by: java.lang.IllegalArgumentException: java.util.zip.ZipException: invalid LOC header (bad signature)
  83. 	at org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.initInternal(AbstractSingleArchiveResourceSet.java:142)
  84. 	at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
  85. 	... 12 more
  86. Caused by: java.util.zip.ZipException: invalid LOC header (bad signature)
  87. 	at java.util.zip.ZipFile.read(Native Method)
  88. 	at java.util.zip.ZipFile.access$1400(ZipFile.java:60)
  89. 	at java.util.zip.ZipFile$ZipFileInputStream.read(ZipFile.java:734)
  90. 	at java.util.zip.ZipFile$ZipFileInflaterInputStream.fill(ZipFile.java:434)
  91. 	at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158)
  92. 	at sun.misc.IOUtils.readFully(IOUtils.java:65)
  93. 	at java.util.jar.JarFile.getBytes(JarFile.java:425)
  94. 	at java.util.jar.JarFile.getManifestFromReference(JarFile.java:193)
  95. 	at java.util.jar.JarFile.getManifest(JarFile.java:180)
  96. 	at org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.initInternal(AbstractSingleArchiveResourceSet.java:140)
  97. 	... 13 more
  98.  
  99. 六月 09, 2018 6:38:48 下午 org.apache.catalina.core.ContainerBase startInternal
  100. 严重: A child container failed during start
  101. java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost]]
  102. 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
  103. 	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
  104. 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:941)
  105. 	at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
  106. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  107. 	at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
  108. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  109. 	at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:793)
  110. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  111. 	at org.apache.catalina.startup.Catalina.start(Catalina.java:681)
  112. 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  113. 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  114. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  115. 	at java.lang.reflect.Method.invoke(Method.java:498)
  116. 	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
  117. 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)
  118. Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost]]
  119. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
  120. 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1421)
  121. 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1411)
  122. 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  123. 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  124. 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  125. 	at java.lang.Thread.run(Thread.java:748)
  126. Caused by: org.apache.catalina.LifecycleException: A child container failed during start
  127. 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:949)
  128. 	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:872)
  129. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  130. 	... 6 more
  131.  
  132. 六月 09, 2018 6:38:48 下午 org.apache.catalina.startup.Catalina start
  133. 严重: The required Server component failed to start so Tomcat is unable to start.
  134. org.apache.catalina.LifecycleException: Failed to start component [StandardServer[8005]]
  135. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
  136. 	at org.apache.catalina.startup.Catalina.start(Catalina.java:681)
  137. 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  138. 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  139. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  140. 	at java.lang.reflect.Method.invoke(Method.java:498)
  141. 	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
  142. 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)
  143. Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardService[Catalina]]
  144. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
  145. 	at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:793)
  146. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  147. 	... 7 more
  148. Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina]]
  149. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
  150. 	at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
  151. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  152. 	... 9 more
  153. Caused by: org.apache.catalina.LifecycleException: A child container failed during start
  154. 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:949)
  155. 	at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
  156. 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  157. 	... 11 more
  158.  
  159. 六月 09, 2018 6:38:48 下午 org.apache.coyote.AbstractProtocol pause
  160. 信息: Pausing ProtocolHandler ["http-nio-8080"]
  161. 六月 09, 2018 6:38:48 下午 org.apache.coyote.AbstractProtocol pause
  162. 信息: Pausing ProtocolHandler ["ajp-nio-8009"]
  163. 六月 09, 2018 6:38:48 下午 org.apache.catalina.core.StandardService stopInternal
  164. 信息: Stopping service [Catalina]
  165. 六月 09, 2018 6:38:48 下午 org.apache.coyote.AbstractProtocol destroy
  166. 信息: Destroying ProtocolHandler ["http-nio-8080"]
  167. 六月 09, 2018 6:38:48 下午 org.apache.coyote.AbstractProtocol destroy
  168. 信息: Destroying ProtocolHandler ["ajp-nio-8009"]


具体看这几行就行了


出现问题的原委：

首先需要弄一份excel导入导出功能，用poi去实现，项目结构具体如下

B依赖C ，C依赖A（图好像描述错了，看这里描述为准），之前poi包是放在C中去依赖，所以，闹出了很多问题

问题一：C中原来有个poi-3.15包，现在不知情的情况下（整个项目中途接手），现在在B的导入导出Excel中增加了

poi-3.17包

poi-ooxml-3.17包

poi-ooxml-schemas-3.17包

发现只能<scope>provided<scope>情况能把整个web跑起来，但是运行时，却发现ClassNoFoundException

无奈改成<scope>compile<scope>，可以跑，但是，一跑起来就报文章开头上边的错误

问题二： 查看pom.xml,发现Dependency Hierarchy有如下的冲突，orimitted complict  with...（好像是这样，忘记截图了），就是

jar冲突了，原来poi-ooxml已经包含了三个jar中其余的两个

结果保留下边的配置在A中

  1. <dependency>
  2.         <groupId>org.apache.poi</groupId>
  3.         <artifactId>poi-ooxml</artifactId>
  4.         <version>3.15</version>
  5. </dependency>

问题三：就是所有问题都存在，把三个jar包丢进tomcat的lib中，是可以跑起来的，但是报错了

 就是运行到下边代码的最后一行，我导入的是xlsx2010格式的excel，报XSSFWorkbook，没有实现org.apache.poi.ss.usermodel.Workbook接口 
  1.         org.apache.poi.ss.usermodel.Workbook workBook = null;
  2.         if (is2010)
  3.             workBook = new XSSFWorkbook(is); //2010
  4.         else 
  5.             workBook = new HSSFWorkbook(is); //2003-2007
  6.         
  7.         if (workBook.getNumberOfSheets() < 1) throw new RuntimeException("excel没有表格存在");

解决方法，就是不要把XSSFWorkbook和HSSFWorkbook都用Workbook来接收，分开两个方法去实现，效果也能实现

但是导出的war包，解压缩后，没有发现三个jar都是3.17版本，有个是3.15（存在于C中，原先项目的依赖pom.xml）

========================================================================

开始解决问题：

首先新建一个仓库目录（otherRepository201806091944）

其次，新建一个settings.xml，这个配置，从原来旧的里头拷贝，修改仓库地址指向新的仓库目录


这是基于eclipse Neon.2 Release (4.6.2)版的，IDEA也是在settings里头改maven，或者在默认的settings里头改全局的

改完后，alt+f5更新下库，或者项目选择要更新的，右键

所有的maven 配置清单pom.xml里头的依赖就会下载下来，入股，下载下来的jar没有存在，就去旧的里头复制粘贴过来

回到本文开始报错的Maven 项目依赖问题解决--ZipException: invalid LOC header (bad signature)

我的问题就解决了。


写完这篇文章，感觉逻辑阐述还是有点问题，下次努力，各位看官挑重点能帮助到你的看，忽略瑕疵。

nutz更加方便快捷的实现方式:还没完全实现通：https://github.com/nutzam/nutzmore/tree/master/nutz-integration-json4excel

下边是所需的jar依赖，可能还需要poi-ooxml-3.17   /  poi-ooxml-3.15包

  1. <dependency>
  2.             <groupId>org.nutz</groupId>
  3.             <artifactId>nutz-integration-json4excel</artifactId>
  4.             <version>1.r.66-SNAPSHOT</version>
  5.             <scope>provided</scope>
  6.  </dependency>

附上excel导入参考demo，逻辑关联一般，还没完全测试通过，可以使用，具体可以拿来参考下

  1. package cn.wizzer.app.web.modules.controllers.platform.cms;
  2.  
  3. import java.io.InputStream;
  4. import java.util.Date;
  5. import java.util.LinkedList;
  6. import java.util.List;
  7.  
  8. import javax.servlet.http.HttpServletRequest;
  9.  
  10. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  11. import org.apache.poi.ss.usermodel.Cell;
  12. import org.apache.poi.ss.usermodel.Row;
  13. import org.apache.poi.ss.usermodel.Sheet;
  14. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  15. import org.apache.shiro.authz.annotation.RequiresAuthentication;
  16. import org.nutz.dao.Dao;
  17. import org.nutz.dao.Sqls;
  18. import org.nutz.dao.entity.Record;
  19. import org.nutz.dao.sql.Sql;
  20. import org.nutz.ioc.loader.annotation.Inject;
  21. import org.nutz.ioc.loader.annotation.IocBean;
  22. import org.nutz.lang.Strings;
  23. import org.nutz.lang.random.R;
  24. import org.nutz.lang.util.NutMap;
  25. import org.nutz.log.Log;
  26. import org.nutz.log.Logs;
  27. import org.nutz.mvc.adaptor.WhaleAdaptor;
  28. import org.nutz.mvc.annotation.AdaptBy;
  29. import org.nutz.mvc.annotation.At;
  30. import org.nutz.mvc.annotation.Ok;
  31. import org.nutz.mvc.annotation.POST;
  32. import org.nutz.mvc.annotation.Param;
  33. import org.nutz.mvc.impl.AdaptorErrorContext;
  34. import org.nutz.mvc.upload.TempFile;
  35. import org.nutz.mvc.upload.UploadAdaptor;
  36.  
  37. import com.alibaba.druid.util.StringUtils;
  38.  
  39. import cn.wizzer.app.cms.modules.models.ChangXinYunModel;
  40. import cn.wizzer.app.cms.modules.services.ChangXinYunService;
  41. import cn.wizzer.app.sys.modules.services.SysMenuService;
  42. import cn.wizzer.app.web.commons.base.Globals;
  43. import cn.wizzer.app.web.commons.slog.annotation.SLog;
  44. import cn.wizzer.app.web.modules.controllers.httputils.HttpClient4;
  45. import cn.wizzer.framework.base.Result;
  46. import cn.wizzer.framework.page.datatable.DataTableColumn;
  47. import cn.wizzer.framework.page.datatable.DataTableOrder;
  48. import cn.wizzer.framework.util.DateUtil;
  49.  
  50. /**
  51.  * Created by William 2018年6月5日09:55:33
  52.  */
  53. @IocBean
  54. @At("/platform/changxinyun")
  55. public class ChangXinYunController {
  56.     @SuppressWarnings("unused")
  57. 	private static final Log log = Logs.get();
  58.    
  59.     @Inject
  60.     private SysMenuService menuService;
  61.     
  62.     @Inject
  63.     private ChangXinYunService changXinYunService;
  64.     
  65.     @Inject
  66.     private Dao dao;
  67.     //dao.create(ChangXinYunModel.class, true);
  68.  
  69.     @At({"", "/index/","/index/?"})
  70.     @Ok("beetl:/changxinyun/index.html")
  71.     @RequiresAuthentication
  72.     public void index() {
  73.     }
  74.     
  75.     @At
  76.    	@Ok("json:full")
  77.    	@RequiresAuthentication
  78.    	public Object data(@Param("name") String name,@Param("length") int length, @Param("start") int start, @Param("draw") int draw, @Param("::order") List<DataTableOrder> order, @Param("::columns") List<DataTableColumn> columns,
  79.    			HttpServletRequest req) {
  80.    		String whereName = "";
  81.    		if (!Strings.isBlank(name)){
  82.    			whereName = "and t.title LIKE '%"+name+"%' or kolName like '%"+name+"%'";
  83.    		}
  84.    		String sqlCount ="SELECT t.* from YZF_ChangXinYun t order by orderBy desc";// WHERE type='0'"+whereName+"ORDER BY isTop DESC"; 
  85.    		Sql sql = Sqls.create(sqlCount);
  86.    		NutMap re = changXinYunService.data(length, start, draw,sql,sql);
  87.    		@SuppressWarnings("rawtypes")
  88.    		LinkedList dataList = (LinkedList) re.get("data");
  89.    		for (int i=0;i<dataList.size();i++) {
  90.    			Record record =  (Record) dataList.get(i);
  91.    				//map.keySet()返回的是所有key的值
  92.    			String str = record.getString("id");//得到每个key多对用value的值
  93.    			Sql sqlCount2 = Sqls.create("select count(*) as putScore from YZF_ChangXinYun");// WHERE leaveRoomDate IS NULL and roomId='"+str+"'");
  94.    			sqlCount2.setCallback(Sqls.callback.integer());
  95.    			int putScore=dao.execute(sqlCount2).getInt();
  96.    			record.put("putscore", putScore);
  97.    		}
  98.    		req.setAttribute("lists", re);
  99.    		System.out.println("re:"+re);
  100.    		return re;
  101.    	}
  102.     
  103.     @At
  104. 	@Ok("beetl:/changxinyun/add.html")
  105. 	@RequiresAuthentication
  106. 	@AdaptBy(type = WhaleAdaptor.class)
  107. 	public void add(HttpServletRequest req) {
  108. //		//		美女与嘉宾列表
  109. //		List<Member> memberList = changXinYunService.query(Cnd.where("ship","in","1,5"));
  110. //		req.setAttribute("list1", memberList);
  111. //		//		房间管理员列表
  112. //		List<Member> memberList2 = changXinYunService.query(Cnd.where("ship","=","3"));
  113. //		req.setAttribute("list2", memberList2);
  114. //		//		赛事列表
  115. //		List<GameMatchMain> re= changXinYunService.query(Cnd.where("isHot", "=", 1).orderBy("ABS(id)","desc"));
  116. //		//   专家列表
  117. //		List<Member> memberList4 = changXinYunService.query(Cnd.where("ship","=","1"));
  118. //		req.setAttribute("list4", memberList4);
  119. //		GameMatchMain gGameMatchMain=new GameMatchMain();
  120. //		gGameMatchMain.setId("100");
  121. //		gGameMatchMain.setMatchName("热门比赛");
  122. //		re.add(0, gGameMatchMain);
  123. //		req.setAttribute("list3", re);
  124. 	}
  125.     
  126.     @At
  127. 	@Ok("json")
  128. 	@SLog(tag = "新建测试", msg = "")
  129. 	@AdaptBy(type = WhaleAdaptor.class)
  130. 	public Object addDo(@Param("path") String path,@Param("key") String[] key,@Param("value") String[] value,@Param("methodName") String methodName,@Param("..") ChangXinYunModel chxyun,HttpServletRequest req) {
  131. 		System.out.println("");
  132. 		//String tokenString = HttpClient4.doPost(path,"");
  133. 		String result = HttpClient4.doGet(path);
  134.     	try {
  135. //			room.setIsTop(StringUtils.isEmpty(isTopChoice) ? 0 : 1);
  136. //			RongCloud rongCloud = RongCloud.getInstance(); 
  137. //			// 创建聊天室方法 
  138. //			ChatRoomInfo[] chatroomCreateChatRoomInfo = {new ChatRoomInfo(room.getId(),room.getTitle())};
  139. //			CodeSuccessResult chatroomCreateResult = rongCloud.chatroom.create(chatroomCreateChatRoomInfo);
  140. //			System.out.println("chatroomCreateResult:  " + chatroomCreateResult.toString());
  141. //			if (chatroomCreateResult.getCode()==200 ){
  142. //				room=addPushAndLive(room,room.getRoomMasterId()+(new Date().getTime()/1000));
  143. //				//				创建数据库本地房间
  144. //				room.setBanState(0);
  145. //				room.setQuizType(0);
  146. //				room.setType(0);
  147. //				room.setDelFlag(false);
  148. //				room.setMatchId("0264A18B938647D7ADFE1D70853D73D6");
  149. //				room=roomService.insert(room);
  150. //				
  151. //				//清除缓存赛事首页房间缓存
  152. //				RoomListCache roomListCache=RoomListCache.instanct;
  153. //				Integer isTop=room.getIsTop();
  154. //				
  155. //				if(isTop==1){
  156. //				String id=room.getId();
  157. //				String sqlCount ="UPDATE room_room SET isTop='0' WHERE type='0' AND id<>'"+id+"';";
  158. //				Sql sql = Sqls.create(sqlCount);
  159. //				dao.execute(sql);
  160. //				
  161. //				}
  162. //				roomListCache.clear();
  163. //				return Result.success("system.success");
  164. //			}
  165. 			return Result.success("success:"+result,result);			
  166. 		} catch (Exception e) {
  167. 			return Result.error("system.error");
  168. 		}
  169.  
  170. 	}
  171.     
  172.     
  173.     @At
  174.     @Ok("beetl:/changxinyun/importExcel.html")
  175.    	@SLog(tag = "新建测试", msg = "")
  176.    	@AdaptBy(type = WhaleAdaptor.class)
  177.    	public void doImportExcel() {
  178.     }
  179.     
  180. 	@AdaptBy(type = UploadAdaptor.class, args = {"ioc:videoExcel"})
  181.     @POST
  182.     @At
  183.     @Ok("json")
  184.     @RequiresAuthentication
  185.     public Object dealWithExcel(@Param("Filedata") TempFile tf, HttpServletRequest req, AdaptorErrorContext err) {
  186.     	try {
  187.     		if (err != null && err.getAdaptorErr() != null)  return NutMap.NEW().addv("code", 1).addv("msg", "上传文件不合法");
  188.     		if (tf == null) return Result.error("请选择要上传的excelwenj");
  189.  
  190. 			String f = Globals.AppUploadPath + "/image/" + DateUtil.format(new Date(), "yyyyMMdd") + "/" + R.UU32() + tf.getSubmittedFileName().substring(tf.getSubmittedFileName().indexOf("."));
  191. 			InputStream in = tf.getInputStream();
  192. 			String suffix = f.substring(f.lastIndexOf("."));
  193. 			
  194. 			if (StringUtils.isEmpty(suffix) || suffix.indexOf("xlsx") == -1)  
  195. 				//2003-2007版本的excel
  196. 				readExcel(in,false); 	 
  197. 			else 
  198. 				 //2010版excel
  199. 				readExcel(in,true);       	
  200. 			
  201.  
  202. 			return Result.success("上传成功", Globals.AppBase+f);
  203.     			
  204.     	} catch (Exception e) {
  205.     		
  206.     		e.printStackTrace();
  207.     		return Result.error("系统错误");
  208.     		
  209.     	}
  210.     	
  211.     }
  212.  
  213.     /**
  214.      * 插入数据对象到数据库中
  215.      * @param order
  216.      * @param name
  217.      * @param pid
  218.      * @param phone
  219.      * @return
  220.      */
  221.     private ChangXinYunModel doChangXinYunModel(int order,String name,String pid,String phone) {
  222.     	ChangXinYunModel cxyModel = new ChangXinYunModel();
  223. 		cxyModel.setOrderBy(order);
  224. 		cxyModel.setName(name);
  225. 		cxyModel.setPid(pid);
  226. 		cxyModel.setPhone(phone);
  227. 		StringBuilder sb =  new StringBuilder();
  228. 		sb.append("https://api.--------?");
  229. 		sb.append("name="+name+"&");
  230. 		sb.append("pid="+pid+"&");
  231. 		sb.append("phone="+phone+"&");
  232. 		sb.append("type="+1+"&");
  233. 		String token = "cqixikuf5nkfmewd";
  234. 		sb.append("token="+token);
  235. 		String result = HttpClient4.doGet(sb.toString());
  236. 		cxyModel.setToken(token);
  237. 		cxyModel.setMethodName("GET");
  238. 		cxyModel.setOpAt(Integer.parseInt(System.currentTimeMillis()/1000+""));
  239. 		cxyModel.setPath(sb.toString());
  240. 		cxyModel.setRequestAt(""+System.currentTimeMillis());
  241. 		cxyModel.setResult(result);
  242. 		cxyModel.setDelFlag(false);
  243. 		cxyModel.setBank_card("");
  244. 		cxyModel.setComment("三要素认证");
  245. 		cxyModel.setHead("");
  246. 		cxyModel.setOtherInfo("");
  247. 		cxyModel.setPhone(phone);
  248. 		cxyModel.setPid(pid);
  249. 		dao.insert(cxyModel);
  250.     	return cxyModel;
  251.     }
  252.     
  253.     @SuppressWarnings("deprecation")
  254. 	private String getValue(Cell cell) {
  255.     	if (cell.getCellType() == Cell.CELL_TYPE_BOOLEAN)
  256.     		return String.valueOf(cell.getBooleanCellValue()); // 返回布尔类型的值 
  257.     	else if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) 
  258.     		return String.valueOf(cell.getNumericCellValue()); // 返回数值类型的值 
  259.     	else 
  260.     		return String.valueOf(cell.getStringCellValue());  // 返回字符串类型的值 
  261.     }
  262.     
  263.     @SuppressWarnings("resource")
  264. 	private void readExcel(InputStream in,boolean is2010) throws Exception {
  265.     	InputStream is = in;
  266.     	org.apache.poi.ss.usermodel.Workbook workBook = null;
  267.     	if (is2010)
  268.     		workBook = new XSSFWorkbook(is); //2010
  269.     	else 
  270.     		workBook = new HSSFWorkbook(is); //2003-2007
  271.     	
  272.     	if (workBook.getNumberOfSheets() < 1) throw new RuntimeException("excel没有表格存在");
  273.  
  274.     	// 循环工作表Sheet
  275.     	for (int numSheet = 0; numSheet < workBook.getNumberOfSheets(); numSheet++) {
  276.     		Sheet sheet = workBook.getSheetAt(numSheet);
  277.     		if (sheet == null) {
  278.     			continue;
  279.     		}
  280.     		
  281.     		//校验表头  序号 姓名 身份证 手机号
  282.     		if (sheet.getLastRowNum() < 1) throw new RuntimeException(sheet.getSheetName() + ",不存在数据");
  283.     		Row headRow = sheet.getRow(0);
  284.     		
  285.     		if (headRow.getCell(0) == null || StringUtils.isEmpty(getValue(headRow.getCell(0))) || !getValue(headRow.getCell(0)).trim().equals("序号")) throw new RuntimeException("表头第一列必须为[序号]");
  286.     		if (headRow.getCell(1) == null || StringUtils.isEmpty(getValue(headRow.getCell(1))) || !getValue(headRow.getCell(1)).trim().equals("姓名")) throw new RuntimeException("表头第一列必须为[姓名]");
  287.     		if (headRow.getCell(2) == null || StringUtils.isEmpty(getValue(headRow.getCell(2))) || !getValue(headRow.getCell(2)).trim().equals("身份证")) throw new RuntimeException("表头第一列必须为[身份证]");
  288.     		if (headRow.getCell(3) == null || StringUtils.isEmpty(getValue(headRow.getCell(3))) || !getValue(headRow.getCell(3)).trim().equals("手机号")) throw new RuntimeException("表头第一列必须为[手机号]");
  289.  
  290.     		//校验表格数据必须大于1条
  291.     		if (sheet.getLastRowNum() < 2) throw new RuntimeException(sheet.getSheetName() + ",没有需要导入的数据");
  292.     		
  293.     		// 循环行Row
  294.     		for (int rowNum = 3; rowNum <= sheet.getLastRowNum(); rowNum++) {
  295.     			Row row = sheet.getRow(rowNum);
  296.     			if (row == null) {
  297.     				continue;
  298.     			}
  299.     			
  300.     			//init Model
  301.     			doChangXinYunModel((int)Double.parseDouble(getValue(row.getCell(0))), getValue(row.getCell(1)), getValue(row.getCell(2)), getValue(row.getCell(3)));
  302.     		}
  303.     	}
  304. 	}
  305.  
  306. }














声明：本文内容由网友自发贡献，转载请注明出处：【wpsshop】
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号