mybatis 用map接受查询结果

浅浅的花香味﹌ 2023-07-20 13:46 14阅读 0赞

> 用map接受查询结果，再将结果整合成Java bean数据，主要数对数据进行处理，便于把某几个字段的数据拼接成bean的字段，或组装成list等

*  mybatis示例
    
        
          <select id="findEventKnows" parameterType="java.lang.Long" resultType="java.util.HashMap">
              SELECT
                  evt.id evtId,
                  setting.dispose_timea disposeTimea,
                  setting.dispose_timeb disposeTimeb,
                  setting.dispose_timec disposeTimec,
                  setting.verify_time verifyTime,
                  setting.check_time checkTime,
                  setting.closedstd closed,
                  setting.legalstd legal,
                  setting.evt_class_id evtClassId
              FROM
                  evt_t_class_setting setting
              LEFT JOIN evt_t_event evt ON (
                  evt.evt_class_id = setting.evt_class_id
              )
              WHERE
                  evt.id = #{evtId,jdbcType=BIGINT}
              AND evt.db_status = 1
          </select>
 *  Java bean
    
        @Data
          @ApiModel(value = "案件知识")
          public class EvtKnowVO { 
          
              @ApiModelProperty(value = "案件id")
              private Long evtId;
          
              @ApiModelProperty(value = "案件类别名称s")
              private String evtClassNames;
          
              @ApiModelProperty(value = "核实时限")
              private Integer verifyLimit;
          
              @ApiModelProperty(value = "核查时限")
              private Integer checkLimit;
          
              @ApiModelProperty(value = "默认处置部门")
              private List<String> defaultDept;
          
              @ApiModelProperty(value = "处置时限")
              private List<String> disposeLimitList;
          
              @ApiModelProperty(value = "立案标准")
              private String registerGuide;
          
              @ApiModelProperty(value = "结案标准")
              private String closeGuide;
          }
 *  Java代码：将查询到的disposeTimea字段数据拼接一下字符串，再组成list（disposeLimitList），放在bean里
    
        @Override
          public EvtKnowVO findEventKnows(Long evtId){ 
              EvtKnowVO evtKnowVO = new EvtKnowVO();
              Map<String, Object> map =  eventReadMapper.findEventKnows(evtId);
              if (null != map){ 
                  evtKnowVO.setCheckLimit((Integer) map.get("checkTime"));
                  evtKnowVO.setCloseGuide((String)map.get("closed"));
                  evtKnowVO.setRegisterGuide((String)map.get("legal"));
                  evtKnowVO.setEvtId((Long)map.get("evtId"));
                  evtKnowVO.setVerifyLimit((Integer)map.get("verifyTime"));
                  EvtClassParentInfoVO classVo = evtClassService.findParentInfoById((Long)map.get("evtClassId"));
                  EvtClassVO  evtClass = evtClassService.findEvtClassById((Long)map.get("evtClassId"));
                  evtKnowVO.setEvtClassNames(classVo.getParentClassName()+"/"+evtClass.getClassName());
                  List<String> limitList = new ArrayList<> ();
                  if (null != map.get("disposeTimea")){ 
                      limitList.add(BusinessConstants.ORDINARY_DISPOSAL_TIME+":"+(int)map.get("disposeTimea")+"时");
                  }
                  if (null != map.get("disposeTimeb")){ 
                      limitList.add(BusinessConstants.PROJECT_DISPOSAL_TIME+":"+(int)map.get("disposeTimeb")+"时");
                  }
                  if (null != map.get("disposeTimec")){ 
                      limitList.add(BusinessConstants.SPECIAL_DISPOSAL_TIME+":"+(int)map.get("disposeTimec")+"时");
                  }
                  evtKnowVO.setDisposeLimitList(limitList);
              }
              return evtKnowVO;
          }