|
|
本帖最后由 zkw1813133460 于 2018-5-18 22:56 编辑
情景：minidao自定义sql查询数据，页面动态列，查询数据生成。调用TagUtil.datagrid方法。加载多次。初次加载3此。录入条件查询加载2次。
下列代码为初次加载报错代码。确认sql语句无误。
版本：3.7.3，3.7.5都有此错误。3.7.2使用TagUtil.datagrid2方法初次加载2此，录入条件查询加载1次。不报错。正常显示。- 打印几次------1===10
- 打印几次------1===10
- 打印几次------0===10
- org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select techown_report.ID as ID, techown_api.apiname as apiname, t_s_base_user.realname as sale, techown_api.accountname as accountname, techown_customer.customershort as customershort, techown_api.price as price, industry.typename as industryclassification, account.typename as accounttype, billingway.typename as billingway, paymentway.typename as paymentway from techown_report LEFT JOIN techown_api on techown_report.name=techown_api.apiname LEFT JOIN techown_customer on techown_api.customerid=techown_customer.id LEFT JOIN t_s_base_user on t_s_base_user.id=techown_customer.sale LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='industry') as industry on techown_api.industryclassification=industry.typecode LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='account') as account on techown_api.accounttype=account.typecode LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='billingway') as billingway on techown_api.billingway=billingway.typecode LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='paymentway') as paymentway on techown_api.paymentway=paymentway.typecode where 1=1 and accountname like ? and customershort like ? GROUP BY techown_report.name ORDER BY techown_report.name LIMIT ?,?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
- at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.getReturnMinidaoResult(MiniDaoHandler.java:337)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.invoke(MiniDaoHandler.java:106)
- at com.sun.proxy.$Proxy163.getAccountDetails(Unknown Source)
- at com.jeecg.details.controller.TechownAccountDetailsController.datagrid(TechownAccountDetailsController.java:74)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
- 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.doPost(FrameworkServlet.java:863)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- 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:193)
- [2018-05-18 22:40:26] [ERROR] [org.jeecgframework.core.common.exception.GlobalExceptionResolver:86] 全局处理异常捕获:
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
- at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
- at com.mysql.jdbc.Util.getInstance(Util.java:386)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2708)
- at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2705)
- at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:625)
- at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:99)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
- at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:211)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
- at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1372)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.getReturnMinidaoResult(MiniDaoHandler.java:337)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.invoke(MiniDaoHandler.java:106)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at com.sun.proxy.$Proxy163.getAccountDetails(Unknown Source)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at com.jeecg.details.controller.TechownAccountDetailsController.datagrid(TechownAccountDetailsController.java:74)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
- at com.mysql.jdbc.Util.getInstance(Util.java:386)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2708)
- at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2705)
- at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:99)
- at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:211)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
- 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.doPost(FrameworkServlet.java:863)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
- at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
- ... 62 more
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- 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:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- 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:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
- at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:625)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1372)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- 打印几次------0===10
- org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select techown_report.ID as ID, techown_api.apiname as apiname, t_s_base_user.realname as sale, techown_api.accountname as accountname, techown_customer.customershort as customershort, techown_api.price as price, industry.typename as industryclassification, account.typename as accounttype, billingway.typename as billingway, paymentway.typename as paymentway from techown_report LEFT JOIN techown_api on techown_report.name=techown_api.apiname LEFT JOIN techown_customer on techown_api.customerid=techown_customer.id LEFT JOIN t_s_base_user on t_s_base_user.id=techown_customer.sale LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='industry') as industry on techown_api.industryclassification=industry.typecode LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='account') as account on techown_api.accounttype=account.typecode LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='billingway') as billingway on techown_api.billingway=billingway.typecode LEFT JOIN (select t_s_type.typecode,t_s_type.typename from t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='paymentway') as paymentway on techown_api.paymentway=paymentway.typecode where 1=1 and accountname like ? and customershort like ? GROUP BY techown_report.name ORDER BY techown_report.name LIMIT ?,?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
- at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.getReturnMinidaoResult(MiniDaoHandler.java:337)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.invoke(MiniDaoHandler.java:106)
- at com.sun.proxy.$Proxy163.getAccountDetails(Unknown Source)
- at com.jeecg.details.controller.TechownAccountDetailsController.datagrid(TechownAccountDetailsController.java:74)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
- 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.doPost(FrameworkServlet.java:863)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- [2018-05-18 22:46:04] [ERROR] [org.jeecgframework.core.common.exception.GlobalExceptionResolver:86] 全局处理异常捕获:
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
- at com.mysql.jdbc.Util.getInstance(Util.java:386)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
- at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2708)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2705)
- at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
- at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:99)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:211)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
- at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:625)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.getReturnMinidaoResult(MiniDaoHandler.java:337)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
- at org.jeecgframework.minidao.aop.MiniDaoHandler.invoke(MiniDaoHandler.java:106)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
- at com.sun.proxy.$Proxy163.getAccountDetails(Unknown Source)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)
- at com.jeecg.details.controller.TechownAccountDetailsController.datagrid(TechownAccountDetailsController.java:74)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1372)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
- 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.doPost(FrameworkServlet.java:863)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:119)
- at java.lang.Thread.run(Thread.java:748)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at com.mysql.jdbc.Util.getInstance(Util.java:386)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
- at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2708)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
- at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
- at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:625)
- at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2705)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
- at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:99)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
- at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:211)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)
- at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)
- ... 62 more
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1372)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2018-05-18 22:48:29] [INFO] [org.jeecgframework.web.graphreport.service.impl.core.GraphReportServiceImpl:72] -------------动态报表功能--------querySql--SELECT t.* FROM ( select a.userid, count(*) ct, sum(case when right(logcontent, 4) in ('登录成功', 'cess') then 1 else 0 end) login_count from t_s_log a where 1=1 group by a.userid ) t order by ct desc
- 打印几次------1===10
- 打印几次------1===10
- /**
- * easyui AJAX请求数据
- *
- * @param request
- * @param response
- * @param dataGrid
- * @param
- */
- @RequestMapping(params = "datagrid")
- public void datagrid(TechownAccountDetailsEntity techownAccountDetailsEntity, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
- //查询所有账号信息
- Integer pageNumber = dataGrid.getPage();
- Integer pageSize = dataGrid.getRows();
- Integer beginLimit = (pageNumber - 1) * pageSize;
- Integer endLimit = pageSize;
- System.out.println("打印几次------" + pageNumber + "===" + pageSize);
- List<Map<String, Object>> list = techownAccountDetailsDao.getAccountDetails("%" + techownAccountDetailsEntity.getAccountname() + "%", "%" + techownAccountDetailsEntity.getCustomershort() + "%", beginLimit, endLimit);
- List<String> dates = getMonthBetweenDate(techownAccountDetailsEntity.getDate_begin(), techownAccountDetailsEntity.getDate_end());
- Map<String, Map<String, Object>> extMap = new HashMap<String, Map<String, Object>>();
- for (int i = 0; i < list.size(); i++) {
- Map<String, Object> map = list.get(i);
- if (dates != null) {
- for (int j = 0; j < dates.size(); j++) {
- Integer each = techownAccountDetailsDao.getEachApiSendByDate(list.get(i).get("apiname").toString(), dates.get(j));
- map.put(dates.get(j), each == null ? 0 : each);
- }
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
- String begin = sdf.format(techownAccountDetailsEntity.getDate_begin() == null ? new Date() : techownAccountDetailsEntity.getDate_begin());
- String end = sdf.format(techownAccountDetailsEntity.getDate_end() == null ? new Date(): techownAccountDetailsEntity.getDate_end());
- Integer summonth = techownAccountDetailsDao.getSumApiSendByDate(list.get(i).get("apiname").toString(), begin, end);
- map.put("summonth", summonth == null ? 0 : summonth);
- }
- extMap.put(list.get(i).get("ID").toString(), map);
- }
- dataGrid.setTotal(techownAccountDetailsDao.getAccountDetailsCount("%" + techownAccountDetailsEntity.getAccountname() + "%", "%" + techownAccountDetailsEntity.getCustomershort() + "%"));
- TagUtil.datagrid2(response, dataGrid, extMap);
- }
此图片为使用TagUtil.datagrid方法加载数据
附上TagUtil.datagrid2和TagUtil.datagrid方法- /**
- * 控件类型：easyui 3.7.2版本方法
- * 返回datagrid JSON数据
- *
- * @param response
- * @param dataGrid
- * @param extMap 数据列表的扩展
- */
- public static void datagrid2(HttpServletResponse response, DataGrid dg, Map<String, Map<String, Object>> extMap) {
- response.setContentType("application/json");
- response.setHeader("Cache-Control", "no-store");
- JSONObject object = TagUtil.getJson(dg);
- JSONArray r = object.getJSONArray("rows");
- r.clear();
- for (Map.Entry<String, Map<String, Object>> map : extMap.entrySet()) {
- JSONObject o = new JSONObject();
- o.putAll(extMap.get(map.getKey()));
- r.add(o);
- }
- PrintWriter pw = null;
- try {
- pw = response.getWriter();
- pw.write(object.toString());
- pw.flush();
- } catch (IOException e) {
- e.printStackTrace();
- } finally {
- try {
- pw.close();
- object.clear();
- dg.clear();
- dg = null;
- System.gc();
- extMap = null;
- } catch (Exception e2) {
- // TODO: handle exception
- }
- }
- }
- /**
- * 控件类型：easyui
- * 返回datagrid JSON数据
- * @param response
- * @param dataGrid
- * @param extMap 数据列表的扩展
- */
- public static void datagrid(HttpServletResponse response,DataGrid dg,Map<String,Map<String,Object>> extMap) {
- response.setContentType("application/json");
- response.setHeader("Cache-Control", "no-store");
- JSONObject object = TagUtil.getJson(dg);
- JSONArray r = object.getJSONArray("rows");
- for (Object object2 : r) {
- JSONObject o =(JSONObject) object2;
- o.putAll(extMap.get(o.get("id")));
- }
- PrintWriter pw = null;
- try {
- pw=response.getWriter();
- pw.write(object.toString());
- pw.flush();
- } catch (IOException e) {
- e.printStackTrace();
- }finally{
- try {
- pw.close();
- object.clear();
- dg.clear();
- dg = null;
- System.gc();
- extMap = null;
- } catch (Exception e2) {
- // TODO: handle exception
- }
- }
- }
|
|
窥视卡
雷达卡
发表于 2018-5-18 22:53:29
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡
楼主
发表于 2018-5-19 16:07:10
