How to parse the or syntax of criteria in MyBatis

What this article shares to you is about how to carry on the or syntax analysis of criteria in MyBatis, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Or (or query) syntax for MyBatis criteria

Among them

TInnetstoragebDao inherits TInnetstoragebMapper

Example/criteria and or query

According to the principle of not writing sql in xml, I learned a new posture today.

Use example to complete and or query

Public List queryCountryName () {SmsCountryExample example = new SmsCountryExample (); Criteria criteria = example.createCriteria (); / / splicing and condition, if there are multiple, you can write criteria.andIdIsNotNull () .andNameIsNotNull () directly after it; / / concatenate or condition, if multiple or must be written in this way, not example.or () .andIdEqualTo (1); example.or () .andIdEqualTo (2); return smsCountryMapper.selectByExample (example) } the above is how to analyze the or syntax of criteria in MyBatis. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.