电子商务网站建设与管理a卷答案,厦门网站备案,公司注册资金最低多少,湖南省博物馆网站建设1、背景
前端返回一个实体类#xff0c;实体类里还有集合。要对集合外的属性查询#xff0c;还要对集合批量查询#xff0c;并且属性可能为空。返回给前端的结果是个实体类#xff0c;实体类里有集合。
2、前端实体类
public class AppletSyncDiseaseInfoBO {// 病害信息…1、背景
前端返回一个实体类实体类里还有集合。要对集合外的属性查询还要对集合批量查询并且属性可能为空。返回给前端的结果是个实体类实体类里有集合。
2、前端实体类
public class AppletSyncDiseaseInfoBO {// 病害信息同步接口/*** 组织id*/private Integer organizationId;/*** 最后一次同步时间病害更新时间小于此时间的不同步可为空*/private String lastSyncTime;/*** 返回结果中的坐标系WGS84等待约定*/private String coordinate;/*** 路面类型:沥青A,水泥D*/private char roadSurface;/*** 病害集合*/private ListAppletDiseaseInfoBO disease;
}public class AppletDiseaseInfoBO {/*** 病害类型*/private String proType;/*** 筛选上限为空则不做筛选*/private Double upperLimit;/*** 筛选下限为空则不做筛选*/private Double lowerLimit;}3、返回给前端的实体类
public class AppletDiseaseInfoVO {/*** 组织id*/private Integer organizationId;/*** 接口调用结果返回时间*/private String nowTime;/*** 返回结果中的坐标系WGS84等待约定*/private String coordinate;ListAppletDiseaseVO problem;
}public class AppletDiseaseVO extends AppletDiseaseBO {/*** 病害id*/private Integer proId;/*** 识别任务id*/private Integer subId;/*** 图片id*/private Integer picId;/*** 病害类型*/private String proType;/*** 病害名称*/private String proName;/*** 经度*/private Double lon;/*** 纬度*/private Double lat;/*** 道路id*/private Integer roadId;/*** 道路区间id*/private Integer roadIntervalId;/*** 道路方向上行U下行D*/private char roadDirection;/*** 桩号*/private Integer chainage;/*** 桩号偏移量*/private Double chainageOffset;/*** 影响面积或长度*/private Double proDestroy;/*** 原始图片地址*/private String picUrl;/*** 病害发现时间*/private String findTime;
}4、sql语句 resultMap idsyncDiseaseInfoMap typecom.jzsk.presentation.pojo.vo.AppletSyncDiseaseInfoVOresult columnorganization_id propertyorganizationId/-- 以下就是映射到集合里collection propertyproblem javaTypejava.util.List resultMapproblemsMap//resultMapresultMap idproblemsMap typecom.jzsk.presentation.pojo.bo.AppletDiseaseBOresult columnproId propertyproId/result columnrec_sub_id propertysubId/result columnpicId propertypicId/result columnpro_type propertyproType/result columnpro_name propertyproName/result columngps_lon propertylon/result columngps_lat propertylat/result columnroad_id propertyroadId/result columninterval_id propertyroadIntervalId/result columnroad_direction propertyroadDirection/result columnchainage propertychainage/result columnchainage_offset propertychainageOffset/result columnpro_destroy propertyproDestroy/result columnphoto_name propertyphotoName/result columnoutput_path propertyoutputPath/result columnreported_time propertyfindTime/result columnis_review propertyisReview//resultMapselect idsyncDiseaseInfo parameterTypecom.jzsk.presentation.pojo.bo.AppletSyncDiseaseInfoBOresultMapsyncDiseaseInfoMapSELECTrrp.organization_id,rrp.id as proId,rrp.rec_sub_id,cp.id AS picId,rrp.pro_type,rrp.pro_name,rrp.gps_lon,rrp.gps_lat,rl.road_id,rs.interval_id,rl.road_direction,rrp.chainage,rrp.chainage_offset,rrp.pro_destroy,rr.photo_name,rs.output_path,rs.reported_time,rs.lane,rr.is_reviewFROMrec_result_problem rrp-- 连表的时候 先去查出子表 加快检索效率 LEFT JOIN (SELECT rresult.id,rresult.photo_name,rresult.is_review FROM rec_result rresult WHERE rresult.organization_id #{organizationId}) AS rr ON rrp.rec_result_id rr.idLEFT JOIN (SELECT rsubmit.id,rsubmit.interval_id,rsubmit.output_path,rsubmit.reported_time,rsubmit.lane,rsubmit.pavement_type,rsubmit.locus_id FROM rec_submit rsubmit WHERE rsubmit.organization_id #{organizationId}) AS rs ON rrp.rec_sub_id rs.idLEFT JOIN (SELECT rlocus.road_id,rlocus.id,rlocus.road_direction FROM road_locus rlocus WHERE rlocus.organization_id #{organizationId}) AS rl ON rl.id rs.locus_idLEFT JOIN (SELECT ctask.interval_id,ctask.id FROM capture_task ctask WHERE ctask.organization_id #{organizationId}) AS ct ON ct.interval_id rs.interval_idLEFT JOIN (SELECT cphoto.task_id,cphoto.id FROM capture_photo cphoto WHERE cphoto.organization_id #{organizationId}) AS cp ON cp.task_id ct.idWHERErrp.organization_id #{organizationId}if testlastSyncTime ! null and lastSyncTime ! AND rrp.create_time gt; #{lastSyncTime}/ifif testroadSurface ! null and roadSurface ! AND rs.pavement_type #{roadSurface}/if-- 判断传入的集合是否为空-- 如果传入的是数组 就用 if testdisease ! null and disease.length 0if testdisease ! null and disease.size() 0ANDforeach collectiondisease itemdiseaseInfo open( close) separator OR -- separator OR 和 这个括号是精髓-- 比如你传入(A) OR (B) 这里就会取结果的并集-- 如果不加括号 只是 A OR B ,那么满足一个条件就会返回数据(if testdiseaseInfo.proType ! null and diseaseInfo.proType ! rrp.pro_type #{diseaseInfo.proType}/ifif testdiseaseInfo.upperLimit ! nullAND rrp.pro_destroy lt; #{diseaseInfo.upperLimit}/ifif testdiseaseInfo.lowerLimit ! nullAND rrp.pro_destroy gt; #{diseaseInfo.lowerLimit}/if)/foreach/if/select5、其他
如果你只是传入一个集合进行查询
mapper接口要加 parm()注解
5.1、maapper层接口
ResultSectionBO querySectionChainageBySubId(Param(idList) ListInteger idList);5.2、sql语句 select idquerySectionChainageBySubId resultTypecom.jzsk.presentation.pojo.bo.ResultSectionBOSELECT MIN(chainage*1000chainage_offset) AS minChainage,MAX(chainage*1000chainage_offset) AS maxChainageFROM REC_RESULT WHERE is_delNif testidList ! null and idList.size 0AND rec_sub_id INforeach collectionidList indexindex itemitem open( separator, close)#{item}/foreach/if/select
文章转载自： http://www.morning.sgmgz.cn.gov.cn.sgmgz.cn http://www.morning.c7624.cn.gov.cn.c7624.cn http://www.morning.diuchai.com.gov.cn.diuchai.com http://www.morning.madamli.com.gov.cn.madamli.com http://www.morning.nuobeiergw.cn.gov.cn.nuobeiergw.cn http://www.morning.rdlrm.cn.gov.cn.rdlrm.cn http://www.morning.hpggl.cn.gov.cn.hpggl.cn http://www.morning.tsdjj.cn.gov.cn.tsdjj.cn http://www.morning.snbq.cn.gov.cn.snbq.cn http://www.morning.nkddq.cn.gov.cn.nkddq.cn http://www.morning.hxbjt.cn.gov.cn.hxbjt.cn http://www.morning.gtxrw.cn.gov.cn.gtxrw.cn http://www.morning.hjrjy.cn.gov.cn.hjrjy.cn http://www.morning.hcbky.cn.gov.cn.hcbky.cn http://www.morning.cljmx.cn.gov.cn.cljmx.cn http://www.morning.pybqq.cn.gov.cn.pybqq.cn http://www.morning.ymwny.cn.gov.cn.ymwny.cn http://www.morning.ljdhj.cn.gov.cn.ljdhj.cn http://www.morning.china-cj.com.gov.cn.china-cj.com http://www.morning.sxlrg.cn.gov.cn.sxlrg.cn http://www.morning.qsmmq.cn.gov.cn.qsmmq.cn http://www.morning.xskbr.cn.gov.cn.xskbr.cn http://www.morning.rjxwq.cn.gov.cn.rjxwq.cn http://www.morning.yhywr.cn.gov.cn.yhywr.cn http://www.morning.rwls.cn.gov.cn.rwls.cn http://www.morning.bsqkt.cn.gov.cn.bsqkt.cn http://www.morning.lokext.com.gov.cn.lokext.com http://www.morning.lgkbn.cn.gov.cn.lgkbn.cn http://www.morning.qtrlh.cn.gov.cn.qtrlh.cn http://www.morning.mtrz.cn.gov.cn.mtrz.cn http://www.morning.lfdmf.cn.gov.cn.lfdmf.cn http://www.morning.rjljb.cn.gov.cn.rjljb.cn http://www.morning.lssfd.cn.gov.cn.lssfd.cn http://www.morning.wfpmt.cn.gov.cn.wfpmt.cn http://www.morning.srmdr.cn.gov.cn.srmdr.cn http://www.morning.hmtft.cn.gov.cn.hmtft.cn http://www.morning.xbtlt.cn.gov.cn.xbtlt.cn http://www.morning.rmtxp.cn.gov.cn.rmtxp.cn http://www.morning.npmpn.cn.gov.cn.npmpn.cn http://www.morning.qichetc.com.gov.cn.qichetc.com http://www.morning.gltmz.cn.gov.cn.gltmz.cn http://www.morning.qbgff.cn.gov.cn.qbgff.cn http://www.morning.xinxianzhi005.com.gov.cn.xinxianzhi005.com http://www.morning.ggnjq.cn.gov.cn.ggnjq.cn http://www.morning.mnkz.cn.gov.cn.mnkz.cn http://www.morning.kczkq.cn.gov.cn.kczkq.cn http://www.morning.qrpx.cn.gov.cn.qrpx.cn http://www.morning.lfbsd.cn.gov.cn.lfbsd.cn http://www.morning.rzrbw.cn.gov.cn.rzrbw.cn http://www.morning.lsnnq.cn.gov.cn.lsnnq.cn http://www.morning.phnbd.cn.gov.cn.phnbd.cn http://www.morning.bmncq.cn.gov.cn.bmncq.cn http://www.morning.rwlns.cn.gov.cn.rwlns.cn http://www.morning.zwgbz.cn.gov.cn.zwgbz.cn http://www.morning.bnfrj.cn.gov.cn.bnfrj.cn http://www.morning.pynzj.cn.gov.cn.pynzj.cn http://www.morning.dhwyl.cn.gov.cn.dhwyl.cn http://www.morning.qyfqx.cn.gov.cn.qyfqx.cn http://www.morning.yntsr.cn.gov.cn.yntsr.cn http://www.morning.kqblk.cn.gov.cn.kqblk.cn http://www.morning.pxwzk.cn.gov.cn.pxwzk.cn http://www.morning.jkfyt.cn.gov.cn.jkfyt.cn http://www.morning.njntp.cn.gov.cn.njntp.cn http://www.morning.tgnr.cn.gov.cn.tgnr.cn http://www.morning.wjtwn.cn.gov.cn.wjtwn.cn http://www.morning.xbwqg.cn.gov.cn.xbwqg.cn http://www.morning.51meihou.cn.gov.cn.51meihou.cn http://www.morning.bwttj.cn.gov.cn.bwttj.cn http://www.morning.dbdmr.cn.gov.cn.dbdmr.cn http://www.morning.nxzsd.cn.gov.cn.nxzsd.cn http://www.morning.kllzy.com.gov.cn.kllzy.com http://www.morning.mrbzq.cn.gov.cn.mrbzq.cn http://www.morning.pphbn.cn.gov.cn.pphbn.cn http://www.morning.wmmjw.cn.gov.cn.wmmjw.cn http://www.morning.tgyzk.cn.gov.cn.tgyzk.cn http://www.morning.nnttr.cn.gov.cn.nnttr.cn http://www.morning.cwpny.cn.gov.cn.cwpny.cn http://www.morning.rqnml.cn.gov.cn.rqnml.cn http://www.morning.pfkrw.cn.gov.cn.pfkrw.cn http://www.morning.szoptic.com.gov.cn.szoptic.com
