From e96ae5524e6fda4922f9da4ab5fea887eaf25e6e Mon Sep 17 00:00:00 2001 From: 星伟 <星伟@192.168.10.25> Date: 星期三, 26 九月 2018 09:23:16 +0800 Subject: [PATCH] 修改首页地图上机房的经纬度 --- gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java index a9032e1..ad27d5a 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java @@ -130,7 +130,7 @@ //9.1鏌ヨ宸茬粡娣诲姞鐗╃悊淇℃伅鐨勬満鎴�(鐢ㄦ埛绠$悊鐨�) public List serchInBattMapByUid(Object obj) { User_inf uinf=(User_inf) obj; - String sql="select tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId " + + String sql="select distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId " + " from web_site.tb_battmap_information,db_battinf.tb_battinf " + " where tb_battmap_information.StationId=db_battinf.tb_battinf.StationId " + " and tb_battmap_information.StationId in (" + -- Gitblit v1.9.1