How to deal with multiple intervals of mybatis
In this article, the editor introduces in detail "how to deal with multiple intervals of mybatis", the content is detailed, the steps are clear, and the details are handled properly. I hope this article "how to deal with multiple intervals of mybatis" can help you solve your doubts.
Mybatis multiple interval processing
As shown in the figure: to realize the query conditions for different intervals of the number of vehicles
Train of thought
a. Front-end pass array with "1-5" String type values in the array
b. Double foreach loop parsing for back-end mybatis
The backend code is as follows:
And ((sfi.count_cargo > = # {item2} and sfi.count_cargo)
