How to use the in of EntityWrapper
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!
