mybatis xml mapper 文件中 if-else 写法

https://www.cnblogs.com/pangguoming/p/8434541.html

mybaits 中没有else要用chose when otherwise 代替

范例一

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

<!--批量插入用户--> < insert  id="insertBusinessUserList" parameterType="java.util.List">      insert into `business_user` (`id` , `user_type` , `user_login` )      values      < foreach  collection="list" index="index" item="item" separator=",">          < trim  prefix="(" suffix=")" suffixOverrides=",">              < choose >                  < when  test="item.id != null and item.id !=''">                      #{item.id,jdbcType=CHAR},                  </ when >                  < otherwise >                      '',                  </ otherwise >              </ choose >              < choose >                  < when  test="item.userType != null and item.userType !=''">                      #{item.userType,jdbcType=VARCHAR},                  </ when >                  < otherwise >                      '',                  </ otherwise >              </ choose >          </ trim >      </ foreach > </ insert >

 

其中choose为一个整体 
when是if 
otherwise是else

范例二：

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14

< select  id="selectSelective" resultMap="xxx" parameterType="xxx">      select      < include  refid="Base_Column_List"/>      from xxx      where del_flag=0      < choose >          < when  test="xxx !=null and xxx != ''">              and xxx like concat(concat('%', #{xxx}), '%')          </ when >          < otherwise >              and xxx like '**%'          </ otherwise >      </ choose > </ select >

 

 下面就是MyBatis中的if....else...表示方法

1 2 3 4 5 6 7 8

< choose >      < when  test="">          //...      </ when >      < otherwise >          //...      </ otherwise > </ choose >