How to generate dynamic SQL using if test in MyBatis
You can use if test statements in MyBatis to generate dynamic SQL. When you use the if test statement, it is often null or not.
SELECT * FROM TBL WHERE COMPANY = #{company} <if test="cd != null"> AND CD = #{cd} </if>
If there are multiple conditions, use the logical conjunction or disjunction of and and or. When comparing with a numerical value, write as follows.
<if test="cd == 1">
When comparing to a string, enclose the string in single quotes.
<if test="cd == '01'">
When comparing with a boolean, use = as shown below.
<if test="isNew">
コメント