Mybatis的xml 循环in

最新推荐文章于 2023-07-28 11:32:15 发布

qq_34004088

最新推荐文章于 2023-07-28 11:32:15 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/qq_34004088/article/details/101514939

版权

java 中代码
parameterMap.put(“Names”, new String[]{“zhangsan”, “lisi”});

当ageChoose== 1时，age in(,),否则age=

<select id="countXXNum" parameterType="map" resultType="int">
       SELECT COUNT(xx) FROM ${@t_xx}
      <where>
          <if test="age!= null">
           <choose>
            <when test="ageChoose == 1">
               and t.age in
               <foreach collection="age" item="item" open="(" separator="," close=")" index="index">
                  #{item}
               </foreach>
            </when>
            <otherwise>
               and t.age = #{age}
            </otherwise>
          </choose>
      </if>
      </where>