ibatis查询结果返回数组_ibatis返回map列表

ibatis返回map列表

1. resultClass="java.util.HashMap"

select t.vehicle_no from NETS2_T_PC_VEHICLE t

where t.nets_cust_id=#custId#

order by t.updated_date desc

2. dao： 使用_queryForList得到map列表，map存放的字段值都是大写

public String queryCustmerCarNoByCustId(String custId)

throws DAOException {

List list = (List)_queryForList("mobileMoneyUserinfo.queryCustmerCarNoByCustId", custId);

log.info("CustomerContactInfoDaoImpl.queryCustmerCarNoByCustId() list="+list);

if(list==null || list.isEmpty()){

return null;

}

Map map = list.get(0);

return (String)map.get("VEHICLE_NO");

}