mybatis choose when的用法实现代码如下所示：

mapper.xml:

<select id="query" resultType="map" parameterType="map">
    select 
      <choose>
        <when test="cityId == '00' ">
            a.city_id as CITYID,
        </when>
        <otherwise>
          <choose>
            <when test="cityId == '0001' and statsDimension==1">
              a.level1_maintain_unit_id as CITYID,
            </when>
            <otherwise>
              a.county_id as CITYID,
            </otherwise>
          </choose>
         </otherwise>
     </choose>
          sum(ONUNUM) as ONUNUM, 
          sum(ONTNUM) as ONTNUM
      from new_olt_upopt_sp_month_${tableDate} a
      where 1 = 1
        <if test="cityId == '0001' and statsDimension==1">
        and a.city_id = '0001'
        </if>
        <![CDATA[and a.gather_time >= ${startDate}]]>
        <![CDATA[and a.gather_time <= ${endDate}]]>  
         group by
    <choose>
        <when test="cityId == '00' ">
            a.city_id
        </when>
        <otherwise>
          <choose>
            <when test="cityId == '0001' and statsDimension==1">
              a.level1_maintain_unit_id
            </when>
            <otherwise>
              a.county_id
              having a.county_id in 
                (select city_id from tab_city 
                  where city_id= #{cityId} or parent_id=#{cityId})
            </otherwise>
          </choose>
         </otherwise>
     </choose>      
  </select>

以上所述是小编给大家介绍的Mybatis choose when用法实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对呐喊教程网站的支持！

声明：本文内容来源于网络，版权归原作者所有，内容由互联网用户自发贡献自行上传，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任。如果您发现有涉嫌版权的内容，欢迎发送邮件至：notice#yiidian.com（发邮件时，请将#更换为@）进行举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。