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"}