JFinalUIBV4项目启动时加载不到新增的xxx.sql.xml文件

我新增一个一个项目管理功能,也添加了相对应的东西
project.java

image.png

image.png

以下是controller

image.png

以下是service

image.png

现在只是查询数据,所以还没有用到service

以下是project.sql.xml

image.png

最后报错信息为

业务逻辑代码遇到异常Exception = com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'t(*) null',expect NULL, actual NULL pos 20, line 1, column 16, token NULL : select count(*) null at com.jfinal.plugin.activerecord.DbPro.paginate(DbPro.java:551) at com.platform.mvc.base.BaseService.paging(BaseService.java:88) at com.platform.mvc.base.BaseController.paging(BaseController.java:681) at com.platform.mvc.base.BaseController.paging(BaseController.java:671) at com.platform.project.ProjectController.index(ProjectController.java:15) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.jfinal.aop.Invocation.invoke(Invocation.java:73) at com.jfinal.i18n.I18nInterceptor.intercept(I18nInterceptor.java:104) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.jfinal.plugin.activerecord.tx.TxByActionKeyRegex.intercept(TxByActionKeyRegex.java:61) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.jfinal.plugin.activerecord.tx.TxByActionKeys.intercept(TxByActionKeys.java:57) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.jfinal.plugin.activerecord.tx.TxByMethodRegex.intercept(TxByMethodRegex.java:61) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.jfinal.plugin.activerecord.tx.TxByMethods.intercept(TxByMethods.java:57) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.platform.interceptor.ParamPkgInterceptor.intercept(ParamPkgInterceptor.java:77) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.platform.interceptor.AuthInterceptor.intercept(AuthInterceptor.java:226) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.platform.interceptor.XSSInterceptor.intercept(XSSInterceptor.java:24) at com.jfinal.aop.Invocation.invoke(Invocation.java:67) at com.jfinal.core.ActionHandler.handle(ActionHandler.java:75) at com.platform.handler.GlobalHandler.handle(GlobalHandler.java:87) at com.jfinal.ext.handler.UrlSkipHandler.handle(UrlSkipHandler.java:46) at com.jfinal.plugin.druid.DruidStatViewHandler.handle(DruidStatViewHandler.java:75) at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'t(*) null',expect NULL, actual NULL pos 20, line 1, column 16, token NULL : select count(*) null at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:725) at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:253) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:473) at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:929) at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:473) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342) at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:350) at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:63) at com.sun.proxy.$Proxy10.prepareStatement(Unknown Source) at com.jfinal.plugin.activerecord.DbPro.query(DbPro.java:93) at com.jfinal.plugin.activerecord.DbPro.doPaginate(DbPro.java:504) at com.jfinal.plugin.activerecord.DbPro.paginate(DbPro.java:486) at com.jfinal.plugin.activerecord.DbPro.paginate(DbPro.java:549) ... 48 more Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'t(*) null',expect NULL, actual NULL pos 20, line 1, column 16, token NULL at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:280) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:385) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:93) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:89) at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620) at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574) at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712) ... 64 more

最后我调试了以下,我的project.sql.xml文件没有被加载进来,不知道怎么解决,因此特来求助,谢谢

评论区

热门反馈

扫码入社