数据库----根据不同查询条件，统计不同记录数

weixin_42802934

于 2020-10-27 11:07:55 发布

阅读量487

点赞数

文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/weixin_42802934/article/details/109289126

版权

sql语句：

select         
sum(case when (level_ = 0) then 1 else 0 end) as systemApp,
sum(case when (level_ = 1) then 1 else 0 end) as businessApp,
sum(case when (status = 1) then 1 else 0 end) as onlineApp
from mams_app_app;

mybatis：
以map返回：resultType=“java.util.HashMap”
入参参数：list

<!-- 根据应用级别、应用状态统计系统应用、业务应用、上线应用个数 -->
<select id="countByLevelOrStatus" resultType="java.util.HashMap" parameterType="list">
    select       
	sum(case when (level_ = 0) then 1 else 0 end) as systemApp,
	sum(case when (level_ = 1) then 1 else 0 end) as businessApp,
	sum(case when (status = 1) then 1 else 0 end) as onlineApp
	from mams_app_app
    <if test="list!= null and list.size() &gt; 0">
		where mams_app_app.user_id in
		<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
               	#{item}
    	</foreach>
	</if>

</select>