mybaits 注解 返回Map

 第一种 、以Map<key,Bean>方式返回

注解

mapper接口如下

@MapKey("sn")//应该是bean属性，用到get方法
@ResultType(LbsDTO.class)设置value bean.class
@Select("select * from LBS where elaId = #{elaId}")
Map<String, LbsDTO> selectMapByElaId(int elaId);

 结果：

XML形式

mapper

	@MapKey("deviceTypeName")
	Map<String, SenType> selectAllMapKeyName();

 xml

  <resultMap id="BaseResultMap" type="com.feinno.env.db.bean.SenType">
    <id column="ID" jdbcType="INTEGER" property="id" />
    <result column="DEVICE_TYPE_NAME" jdbcType="VARCHAR" property="deviceTypeName" />
    <result column="IMG_URL" jdbcType="VARCHAR" property="imgUrl" />
    <result column="HIGH_LEGEND" jdbcType="DOUBLE" property="highLegend" />
    <result column="LOW_LEGEND" jdbcType="DOUBLE" property="lowLegend" />
    <result column="CREATED_TIME" jdbcType="BIGINT" property="createdTime" />
    <result column="CREATOR" jdbcType="VARCHAR" property="creator" />
    <result column="MODIFIED_TIME" jdbcType="BIGINT" property="modifiedTime" />
    <result column="MODIFIER" jdbcType="VARCHAR" property="modifier" />
  </resultMap>
  <sql id="Base_Column_List">
    ID, DEVICE_TYPE_NAME, IMG_URL, HIGH_LEGEND, LOW_LEGEND, CREATED_TIME, CREATOR, MODIFIED_TIME, 
    MODIFIER
  </sql>  
<select id="selectAllMapKeyName" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from SEN_TYPE
  </select>

结果

 

第二种、以Map<key,Map<key,value>>形式返回

mapper接口如下

@MapKey("id")//设置key
@Select("select * from USER where eId = #{eId}")
Map<String, Map<String,Object>> selectMapByEId(int eId);

 结果

​​​​{154711925668={updatedTime=1547119267023, swVersion=001, mac=52:54:00:FC:7D:D2, hwVersion=01, spaceId=3, onTime=1547119256702, elaId=1, x=11.55, y=0.0, createdTime=1547119267023, z=-1.29, id=1, sn=154711925668, status=1}, 
154712370184={updatedTime=1547123704841, swVersion=001, onTime=1547123701875, elaId=1, createdTime=1547123704841, id=20, sn=154712370184, mac=52:54:00:CF:50:6F, hwVersion=01, status=1}}

第三种、以List<Map<key,value>> 形式返回

mapper接口如下

	@Select("select * from LBS where elaId = #{elaId}")
	List<Map<String, Object>> selectMapListByElaId(int elaId);

结果：

[{updatedTime=1547119267023, swVersion=001, mac=52:54:00:FC:7D:D2, hwVersion=01, spaceId=3, onTime=1547119256702, elaId=1, x=11.55, y=0.0, createdTime=1547119267023, z=-1.29, id=1, sn=154711925668, status=1},
{updatedTime=1547123703844, swVersion=001, mac=52:54:00:03:21:12, hwVersion=01, spaceId=5, onTime=1547123701872, elaId=1, x=10.0, y=0.0, createdTime=1547123703844, z=0.0, id=2, sn=154712370184, status=1}, 
{updatedTime=1547123703929, swVersion=001, mac=52:54:00:00:D9:53, hwVersion=01, onTime=1547123701872, elaId=1, x=0.0, y=0.0, createdTime=1547123703929, z=0.0, id=3, sn=154712370184, status=1}]

注意：前两种外层Key重复会被覆盖，所以前两种查到2条数据，第三种查到3条。