mybatis部分语法速查自用

choose-when

<choose>
		<when test="state == null">
			and type = 1
		</when>
		<when test="state != null">
			and type = 2
		</when>
		<otherwise>
			and type = 3
		</otherwise>
</choose>

加标签
<choose>
    <when test="param.moneyChargeDescList != null and param.moneyChargeDescList.size() > 0">
        AND(
        <trim prefixOverrides="or">
            <if test="param.moneyChargeDescList.contains('a')">
                (TEMP.process_type = 10 or TEMP.process_type is null)
            </if>
            <if test="param.moneyChargeDescList.contains('b')">
                or (TEMP.money_charge = 20 AND TEMP.process_type IN (20, 40))
            </if>
            <if test="param.moneyChargeDescList.contains('c')">
                or (TEMP.process_type = 30 or TEMP.process_type = 50)
            </if>
        </trim>
        )
    </when>
    <otherwise>
        AND NOT (TEMP.money_charge = 10 AND TEMP.process_type IN (20, 40))
    </otherwise>
</choose>