Lexical error at line 1, column 107. Encountered: "\uff0c" (65292), after : ""

问题:
查询数据突然返回以下异常信息
message: "org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is net.sf.jsqlparser.parser.TokenMgrError: Lexical error at line 1, column 107.Encountered: "\uff0c" (65292), after : """
原因:
动态拼装SQL语句多了个中文逗号,导致SQL无法正常解析
【Lexical error at line 1, column 107. Encountered: "\uff0c" (65292), after : ""】Lexical error at line 1, column 107. Encountered: "\uff0c" (65292), after : ""
文章图片

    推荐阅读