<select id="getData" resultMap="userMap" >
? ? SELECT id,name FROM user ? ? ? ?
</select>
?
<resultMap id="userMap" type="java.util.Map" >
? ? <result column="id" property="key" jdbcType="VARCHAR" />
? ? <result column="name" property="value" jdbcType="VARCHAR" />
</resultMap>

import org.apache.ibatis.session.SqlSession;
@Autowired
private SqlSession sqlSession;
public Map<String, String> getBasicInformationOfCompanyPersonnel(String status) throws Exception {
Map<String, Object> params = new HashMap<>();
?
? ? params.put("status", status);?
? ? MapResultHandler handler = new MapResultHandler();?
? ? Map result = handler.getMappedResults();?
? ? sqlSession.select("namespaceXml.getData",params,handler);?
? ? return result;
}

import org.apache.ibatis.session.ResultContext;
import org.apache.ibatis.session.ResultHandler;
public class MapResultHandler implements ResultHandler {?
? ? @SuppressWarnings("rawtypes")
? ? private final Map mappedResults = new HashMap();?
? ? @SuppressWarnings("unchecked")
? ? @Override
? ? public void handleResult(ResultContext context) {
? ? ? ? @SuppressWarnings("rawtypes")
? ? ? ? Map map = (Map) context.getResultObject();
? ? ? ? // xml配置里面的property的值，對應(yīng)的列
? ? ? ? mappedResults.put(map.get("key"), map.get("value"));
? ? }
?
? ? @SuppressWarnings("rawtypes")
? ? public Map getMappedResults() {
? ? ? ? return mappedResults;
? ? }
}

@MapKey("id")
public Map<String,User> getUserByName(String name);

<select id="getUserByName" resultType = "User">
? ? select * from user where name=#{param1}
</select>