[日记]SSM一对多

Service

 List<Map<String,Object>> selectStaticSalaryByStaff(Integer id);

Controller

    @GetMapping("history")
    public ArrayList<Object> selectByStaff(Integer id){
        List<Map<String,Object>> listMap =iSalaryService.selectByStaff(id);
        ArrayList<Object>arrayList=new ArrayList<>();
        for (Map<String,Object> map:listMap){
            Set<String> set = map.keySet();
            Iterator<String> it = set.iterator();
            while (it.hasNext()) {
                Object key = it.next();
                Object value = map.get(key);
                map.put((String) key,value);
            }
            System.out.println(map);
            arrayList.add(map);
        }
        return arrayList;
    }

*Mapper.xml

  <select id="selectByStaff" resultType="java.util.Map" parameterType="java.lang.Integer">
      SELECT a.`id`,b.`staffName`,c.`stationName`,c.`staticSalary`,a.`staffPrize`,a.`staffTotalSalary`,a.`create_time`,a.`update_time`
        FROM salary a,staff b,station c
            WHERE a.`staffID`=b.`id`AND a.`staffStaionID`=c.`id`
                AND b.`id`=#{id,jdbcType=INTEGER}
  </select>

测试结果