Mybatis人数和次数的统计

1、mybatis 人数和次数统计sql

<select id="queryWebCladdifyOrderList" resultMap="BaseResultMap" parameterType="java.util.Map">

    select cc.urlgrp_name,sum(count) intCount,count(*) intPeopleNum from

    (select site_group_id,ip_address,count(*) from

<!-- 每天一个表，对所有要求的表进行统计-->

    <foreach collection="listTableName" item="tableName" open="(" separator="unioin all" close=")">
        select site_group_id,ip_address,capture_time from  ${tableName}
    </foreach>
     as aa
    where 1=1
    <!-- 主机精确查询 -->
    <if test="obj != null">
    <if test="obj.strName != null and obj.strName != ''">
        and  ip2str(ip_address) = #{obj.strName}
    </if>
    <if test="obj.beginTime != null and obj.beginTime != ''">
        and  capture_time <![CDATA[ >= ]]> #{obj.beginTime}
    </if>
    <if test="obj.endTime != null and obj.endTime != ''">
        and  capture_time <![CDATA[ <= ]]> #{obj.endTime}
    </if>
    <if test="obj.beginIp != null and obj.beginIp != ''">
        and  ip_address <![CDATA[ >= ]]> #{obj.beginIp}
    </if>
    <if test="obj.endIp != null and obj.endIp != ''">
        and  ip_address <![CDATA[ <= ]]> #{obj.endIp}
    </if>
    </if>
    
    group by site_group_id,ip_address) as bb
    left join tbl_urlgroup cc on cc.type=bb.site_group_id
    group by cc.urlgrp_name order by ${obj.orderType}
<include refid="page_sql" />

</select>

2、分页查询语句

     <sql id="page_sql" >
        <if test="pageSize!=null and offsetNum!=null">
            limit #{pageSize} offset #{offsetNum}
        </if>
    </sql>