MyBatis将查询数据封装成map的写法

MyBatis将查询数据封装成map的写法

返回一条记录的map

public Map<String, Object> getEmployeeById(Integer id);

<select id="getEmployeeById" resultMap="map">
	select * from employee where id = #{id}
</select>

多条数据封装一个map

//@MapKey注解：告诉MyBatis封装这个map的时候使用哪个属性作为map的key
@MapKey("id")
public Map<Integer, Employee> getEmployeeByLastName(String lastName);

<-- 需要注意这里的resultType写的是javaBean实体类-->
<select id="getEmployeeByLastName" resultType="Employee">
	select * from employee where lastName like #{lastName}
</select>