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

Editor to share with you how to use EntityWrapper in, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The in usage of EntityWrapper EntityWrapper wrapper = new EntityWrapper (); wrapper.eq ("is_valid", 1); wrapper.in ("life_name", "ge,edu,career"); List userLabelList = userLabelService.selectList (wrapper)

The second parameter of in can be either a string or a list, but note that there can be no spaces between "," in the string, otherwise the statement will look like this.

Mybatis-plus EntityWrapper in

Environment:

SpringBoot+mybatis

Source code:

/ *

* IN conditional statement, which currently adapts to mysql and oracle *

* * @ param column field name * @ param value matching value collection * @ return this * / public Wrapper in (String column, Collection value) {return in (true, column, value);} / *

* IN conditional statement, which currently adapts to mysql and oracle *

* * @ param column field name * @ param value matching value set * @ return this * / public Wrapper in (boolean condition, String column, Collection value) {if (condition & & CollectionUtils.isNotEmpty (value)) {sql.WHERE (in_Expression (column, value, false), value.toArray () } return this;}

If condition is not passed, it is equivalent to: condition: true

If the value passed in is not empty, it is equivalent to changing the in query statement to splicing.

For example, / / Code @ Override public List selectByCaseIdSet (Set idSet) {EntityWrapper wrapper = new EntityWrapper (); wrapper.in (! CollectionUtils.isEmpty (idSet), "id", idSet); return this.selectList (wrapper) } / * if idSet is empty, sql: select * from user * if idSet is not empty, sql: select * from user where id in (idSet) * * / above is all the content of this article "how to use EntityWrapper's in". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.