1、数据库链接:加设置,&allowMultiQueries=true
2、mapper
<!--查询结果及总数量 mapper--> <resultMap id="data" type="java.util.LinkedHashMap"/>
<resultMap id="data" type="Bean"/>
<resultMap type="Long" id="nums" autoMapping="true"/>
<select id="list2" resultMap="data,nums">
SELECT SQL_CALC_FOUND_ROWS
a.id,
a.customer_id,
b.company_name
FROM
table_a a
JOIN table_b b ON a.company_code = b.company_code
WHERE
a. STATUS = 0
LIMIT 0, 2;
SELECT found_rows() AS nums;
</select>
3、Java
/**
* dao
* @return
*/
List<List<?>> list2();
/**
* service
* @return
*/
public List<List<?>> pageList(){
return dao.list2();
}
/**
* controller
* @return
*/
List<List<?>> pageList() {
List<List<?>> pageList = service.pageList();
List<Bean> data = (List<Bean>) pageList.get(0);
Long count = (Long) pageList.get(1).get(0);
return pageList;
}