Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about how to solve the problem of errors when mybatis executes the grammar. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

The sql statement as above is written in the mybatis configuration file. Mybatis checks the syntax at execution time and fails. The reason is that OR condition is used in conjunction with AND condition.

I don't know why mybatis reported an error when executing this syntax, but I have no problem putting it directly in DBMS.

The solution is to add parentheses.

This divides the OR conditional join and the AND conditional join into two parts.

The above is the editor for you to share how to solve the mybatis implementation of the grammar will report errors, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.