How to use multiple if conditions in mybatis
Most people don't understand the knowledge points of this article "how to use multiple if conditional judgment in mybatis", so Xiaobian summarizes the following contents for everyone. The contents are detailed, the steps are clear, and they have certain reference value. I hope everyone can gain something after reading this article. Let's take a look at this article "how to use multiple if conditional judgment in mybatis".
mybatis multiple if conditional judgment
it is noted
When specifying a condition, the condition needs to add the toString() method
mybatis common judgment syntax (tags)
As java development, we commonly use if and switch statements to judge. In fact, there are corresponding labels in MyBatis for dynamically generating sql statements.
1. if judged AND b.STATUS_CODE = #{statusCode, jdbcType=VARCHAR}
In general, many program ape friends will add WHERE 1=1 statement before the tag, but in fact, only need to add tags to wrap all statements like the above code, and the keyword and or in front of the statement:
MyBatis will automatically determine that all conditions are not met, do not add where statement;
If there are multiple judgment sentences and more than one condition is satisfied, the first satisfied (if the first has the and or keyword) and or keyword will be deleted;
2. Choose judgment CASE WHEN statusCode IN (1,6) THEN 1 ELSE 2 END,createTime DESC createTime DESC auditTime downloadCount browseCount is666Count DESC
The above code uses the label nesting feature for complex conditional judgments.
The choose judgment has the same effect as the if else statement, which plays the role of executing different branch logic according to conditions.
Otherwise, the function of the last else in multiple if else is the same. When the above conditions are not satisfied, the logic in otherwise is executed.
The above is the content of this article about "how to use multiple if conditions in mybatis". I believe everyone has a certain understanding. I hope the content shared by Xiaobian will be helpful to everyone. If you want to know more relevant knowledge, please pay attention to the industry information channel.
