微客导航 » 文章资讯 » Mybatis choose when用法实例代码

Mybatis choose when用法实例代码

2024-02-18 09:45:03 555

mybatischoosewhen的用法实现代码如下所示：

mapper.xml:


select


a.city_idasCITYID,




a.level1_maintain_unit_idasCITYID,


a.county_idasCITYID,




sum(ONUNUM)asONUNUM,
sum(ONTNUM)asONTNUM
fromnew_olt_upopt_sp_month_${tableDate}a
where1=1

anda.city_id='0001'

=${startDate}]]>

groupby


a.city_id




a.level1_maintain_unit_id


a.county_id
havinga.county_idin
(selectcity_idfromtab_city
wherecity_id=#{cityId}orparent_id=#{cityId})

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

返回顶部
3162201930
czq8825@qq.com

Mybatis choose when用法实例代码

热门推荐

随机推荐