<select id="listAgentWithdrawApplyOrder" resultType="org.channel.entity.agent.AgentWithDrawApplyOrderDto"> select * from t_agent_withdraw_apply_order // where 标签会去掉 SQL 前面多余的 and <where> <if test="withdrawType != null "> // 如果 withdrawType == 1 则查询条件为 and F_withdraw_type = 0 // 如果 withdrawType == 2 则查询条件为 and F_withdraw_type = 5015 // 如果 withdrawType != 1 || withdrawType != 2 则查询条件为 and F_withdraw_type in(5005,5067,5089) <choose> <when test="withdrawType == 1"> and F_withdraw_type = 0 </when> <when test="withdrawType == 2"> and F_withdraw_type = 5015 </when> </choose> <otherwise> and F_withdraw_type in(5005,5067,5089) </otherwise> </if> </where> </select>