net.sf.jsqlparser.parser.ParseException: Encountered 。。。

「爱情、让人受尽委屈。」 2023-07-17 04:54 58阅读 0赞

### Cause: java.lang.reflect.UndeclaredThrowableException] with root cause
    
    net.sf.jsqlparser.parser.ParseException: Encountered " <S_LONG> "1 "" at line 1, column 52.
    Was expecting one of:
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        "+" ...
        
    	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16395) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16248) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParser.RegularCondition(CCJSqlParser.java:5057) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParser.Condition(CCJSqlParser.java:4752) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:4713) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:4651) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:4622) ~[jsqlparser-1.0.jar:na]
    	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseCondExpression(CCJSqlParserUtil.java:114) ~[jsqlparser-1.0.jar:na]
    	at com.energy.common.data.MybatisDataInterceptor.intercept(MybatisDataInterceptor.java:124) ~[classes/:na]
    	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.4.6.jar:3.4.6]
    	at com.sun.proxy.$Proxy165.prepare(Unknown Source) ~[na:na]
    	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85) ~[mybatis-3.4.6.jar:3.4.6]
    	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.4.6.jar:3.4.6]
    	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) ~[mybatis-3.4.6.jar:3.4.6]
    	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.6.jar:3.4.6]
    	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.4.6.jar:3.4.6]
    	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:112) ~[pagehelper-5.0.3.jar:na]

参考 https://blog.csdn.net/weixin\_36146275/article/details/79355544

定位原因为：在sql语句中使用了IF函数，缺少sql解析工具的jar包

解决方案：在pom.xml文件中添加关于jsqlparser的依赖，注意必须使用0.9以上的版本，否则运行时会报错

<dependency>
        <groupId>com.github.jsqlparser</groupId>
        <artifactId>jsqlparser</artifactId>
        <version>1.4</version>
    </dependency>