手动limit 1

whycxzp

2022-10-14 db9706ac43703c2a31cc30d832209a0b04f13643

手动limit 1

 src/main/resources/mapper/StationInfoMapper.xml

@@ -36,6 +36,6 @@
        select distinct station_id,station_name from db_res_meter.tb_station_info where station_name1=#{stationName1}
    </select>
    <select id="getByFileId" resultType="com.whyc.pojo.StationInfo">
        SELECT si.* FROM db_res_meter.tb_battgroup_info bi,tb_station_info si where bi.station_id = si.station_id and bi.file_id = #{fileId}
        SELECT si.* FROM db_res_meter.tb_battgroup_info bi,tb_station_info si where bi.station_id = si.station_id and bi.file_id = #{fileId} limit 1
    </select>
</mapper>