3.7.6在线代码生成器生成的代码.Excel导出功能不能正常使用

sinsign

在线代码生成器生成的代码，Excel导出功能不能正常使用。jeecg 3.7.6版本

file:///C:\Users\msi\AppData\Roaming\Tencent\Users\137379628\QQ\WinTemp\RichOle\D`53J(6`]~ZYWU]I8`BI7{T.png

file:///C:\Users\msi\AppData\Roaming\Tencent\Users\137379628\QQ\WinTemp\RichOle\L6CLHIQ9RV`8CL}Y6F_0Q8R.png

[2018-07-17 10:58:35] [ERROR] [org.jeecgframework.easypoi.service.EasypoiDictService:47] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select DISTINCT goodsId,goodscode,goods as TYPECODE , id,goodscode,goodsname as TYPENAME from goods order by goodsId,goodscode,goods]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecg376.goods' doesn't exist
[2018-07-17 10:58:35] [ERROR] [org.jeecgframework.poi.excel.export.ExcelExportServer:171]
java.lang.NullPointerException
        at org.jeecgframework.easypoi.service.EasypoiDictService.queryDict(EasypoiDictService.java:50)
        at org.jeecgframework.poi.excel.export.base.ExportBase.getExcelField(ExportBase.java:232)
        at org.jeecgframework.poi.excel.export.base.ExportBase.createExcelExportEntity(ExportBase.java:66)
        at org.jeecgframework.poi.excel.export.base.ExportBase.getAllExcelField(ExportBase.java:112)
        at org.jeecgframework.poi.excel.export.ExcelExportServer.createSheet(ExcelExportServer.java:135)
        at org.jeecgframework.poi.excel.ExcelExportUtil.exportExcel(ExcelExportUtil.java:62)
        at org.jeecgframework.poi.excel.view.JeecgSingleExcelView.renderMergedOutputModel(JeecgSingleExcelView.java:59)
        at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:267)
        at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1221)
        at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1005)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:952)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:152)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
[2018-07-17 10:58:35] [ERROR] [org.jeecgframework.poi.excel.export.ExcelExportServer:172]

但是。。。不用代码生成器生成代码 而是用online表单在线生成的表单，就正常  .

sinsign

救命啊

admin

自己排查下，这个默认生成是可以用的

sinsign

admin 发表于 2018-7-18 14:12
自己排查下，这个默认生成是可以用的

是这样的。有的表单可以。有的表单不可以。但确确实实都是用在线online生成的表单和配置好。然后直接点的生成代码。期间我什么都没改，全是自动生成的代码。也许是某个online表单的有些功能设置兼容性不好导致的


我录个bug视频上传给你看看。我有一半的表单存在这个问题