Mybatis choose when用法实例代码

Mybatis choose when用法实例代码

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

mapper.xml:

select

a.city_id as CITYID,

a.level1_maintain_unit_id as CITYID,

a.county_id as CITYID,

</otherwise>

AOjcyZQm sum(ONUNUM) as ONUNUM,

sum(ONTNUM) as ONTNUM

from new_olt_upopt_sp_month_${tableDate} a

where 1 = 1

and a.city_id = '0001'

<![CDATA[and a.gather_time >= ${startDate}]]>

<![CDATA[and a.gather_time <= ${endDate}]]>

group by

a.city_id

a.level1_maintain_unit_id

a.county_id

having a.county_id in

(select city_id from tab_city

where city_id= #{cityId} or parent_id=#{cityId})

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

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。