ibatis 查询结果 解析

下面是XML 文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="visitorinfo">
	<select id="getallinfo" parameterMap="getallinfo_map" resultMap="java.util.Map">
		<include refid="getallinfo1" />
		<!-- -->
	</select>
	<sql id="getallinfo1">
		select count(v.webcount) zero,
		count(case
		when
		v.webcount
		&gt;= 1 then
		v.webcount
		end) one,
		count(case
		when v.webcount
		&gt;= 3 and
		v.clientcount
		&gt;= 1 then
		v.webcount
		end)
		two,
		max(c.company),max(v.comid),max(v.entertime),min(v.endtime)
		from
		visitorinfo v, company c
		where v.chatstart &gt;= to_date('2012-1-31
		13:53:10',
		'YYYY-MM-DDHH24:MI:SS')
		and v.endtime &lt;=
		to_date('2012-10-31 13:53:10',
		'YYYY-MM-DDHH24:MI:SS')
		and v.comid =
		c.comid group by v.comid

	</sql>
</mapper>

 dao

 @Override
 public List<?> getallvisitorinfo() {
  // TODO Auto-generated method stub
  return this.sqlSessionTemplate.selectList("getallinfo");
 }

 

输出结果：

 

 

{ENTERTIME)=2012-08-17 17:19:04.0, COMID)=143937}, 2, 2, {ENDTIME)=2012-07-26 11:39:11.0}, 6, {COMPANY)=北京喜洋洋花店}]
{MAX(V={ENTERTIME)=2012-10-03 20:31:16.0, COMID)=138282}, ONE=0, TWO=0, MIN(V={ENDTIME)=2012-09-09 00:15:42.0}, ZERO=2, MAX(C={COMPANY)=天德毛毡制品厂}}
[{ENTERTIME)=2012-10-03 20:31:16.0, COMID)=138282}, 0, 0, {ENDTIME)=2012-09-09 00:15:42.0}, 2, {COMPANY)=天德毛毡制品厂}]。。。。。。。。。。。。}