<select id="selectStation" resultType="Select_Static" parameterType="java.util.Map"> SELECT s.`name`,s.location addr,r.comstatus,r.id , (SELECT COUNT(1) FROM icloud_hst_#{icloud_hst_date}.hst_event_#{station_id} h,static_ied i,static_dgt d WHERE h.deviceID = i.id AND i.station_id = #{station_id} AND d.warning = 1 AND h.varID = d.id AND h.knowFlag = 0 AND h.updateDT LIKE CONCAT(#{updateDT},'%')) notice FROM static_user u,static_station s,real_station r WHERE u.owner_id = s.owner_id AND s.id = r.id AND u.owner_id = #{owner_id} </select>
mapper查询两个库的书写
最新推荐文章于 2023-03-12 15:14:40 发布