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

Today, the editor will share with you the relevant knowledge of mybatis dynamic SQL if test writing and rules. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article. Let's take a look at it.

Test Writing of mybatis dynamic SQL if using the most common scenarios of dynamic SQL

Is part of the conditional inclusion of the where clause.

For example:

SELECT * FROM BLOG WHERE state = 'ACTIVE' AND title like # {title}

The expression of test is based on the expression of OGNL, and the grammar rules are also the grammar rules of OGNL.

Official Manual of Grammar rules

OGNL official expression manual: https://commons.apache.org/proper/commons-ognl/language-guide.html

For instance

The figure above is part of the official guidance, which mainly shows that it cannot be used in test

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.