mybatis xml中的if else

来源：互联网发布：软件开发迭代编辑：程序博客网时间：2024/06/15 05:40

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

<!--批量插入用户--><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

阅读全文

0 0