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,
     
   
  
     
   sum(ONUNUM) as ONUNUM, 
   sum(ONTNUM) as onTNUM
      from new_olt_upopt_sp_month_${tableDate} a
      where 1 = 1
 
 and a.city_id = '0001'
 
 = ${startDate}]]>
   
  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用法实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对考高分网网站的支持！