sql查询添加别名的注意事项--(坑)

以组合名作为别名,结果用map接收


<select id='getXXX' resultType="java.util.map">
select xx as testName, yy as greatBe from t_table
</select>

Map<String,Object> resultMap = mapper.getXXX();

resultMap.get("testName").toString(); -- 会报空指针异常

debug发现 resultMap中,数据格式是{“testname”:"aaa","greatbe":"bbb"}

原文地址:https://www.cnblogs.com/niew/p/14709086.html