//xml里配置 count <resultMap id="count" type="java.lang.Long"> <result column="count" /> </resultMap>
<select id="staticsData" resultMap="BaseResultMap,count" parameterType="java.util.Map"> SELECT SQL_CALC_FOUND_ROWS t.`name` FROM tb t WHERE t.name is not NULL GROUP BY t.`name` DESC LIMIT #{startOff},#{pageSize}; SELECT FOUND_ROWS() as count; </select>
List<List<?>> staticsData(Map<String, Object> params);