首页 > 开发 > Java > 正文

Mybatis choose when用法实例代码

2024-07-13 10:09:16
字体:
来源:转载
供稿:网友

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用法实例代码,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对VeVb武林网网站的支持!


注:相关教程知识阅读请移步到JAVA教程频道。
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表