查询多列得到map与查询得到po对象

public List<Map<String, Object>> queryMatInfo(Long customer_id, List<String> matCodes) {
    try {
         Map<String, Object> params = new HashMap<String, Object>();
         String sql = "select mat_id, mat_code from wms_base_material where customer_id = :customer_id and mat_code in (:matCodes)";
         params.put("customer_id", customer_id);
         params.put("matCodes", matCodes);
         List<Map<String, Object>> list = jdbcTemplate.queryForList(sql, params);
         return list;
    } catch (Exception e) {
         log.error(e);
         return new ArrayList<Map<String, Object>>();
    }
}

      

List<Map<String, Object>> whList = warehouseDao.queryWhList(header.getEx_wh_code());

Map<String, Object> map = whList.get(0);

wh_id = (Long)map.get("wh_id");

public List<RivCheckL> queryByExpressOrderNo(String expressOrderNo) {
         String sql = " select * from riv_check_l chl right join riv_pack_case_l pcl on chl.CHL_PCL_ID = pcl.PCL_ID"
                    + " where pcl.PCL_EXPRESS_ORDER_NO = :expressOrderNo";
         MapSqlParameterSource map = new MapSqlParameterSource();
         map.addValue("expressOrderNo", expressOrderNo);
         List<RivCheckL> result = jdbcTemplate.query(sql, map,  new BeanPropertyRowMapper<RivCheckL>(RivCheckL.class));
         return result;
}