From 2f10da83d8087ed1b47b8edc9ff29ca5248f504d Mon Sep 17 00:00:00 2001
From: Administrator <Administrator@192.168.10.26>
Date: 星期一, 15 十月 2018 14:31:52 +0800
Subject: [PATCH] 基站统计
---
gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java | 11 +++++++++--
1 files changed, 9 insertions(+), 2 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..0a540cc 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 (" +
@@ -248,7 +248,14 @@
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationId()}, new BattMap_informationImpl());
return list;
}
-
+ //鍦板浘涓婃牴鎹満鎴垮悕绉版煡璇㈢粡绾害
+ public List serchTudeByStationName(Object obj){
+ BattMap_information binformation=(BattMap_information) obj;
+ String sql="select num, StationId,StationName,address,longitude,latitude,information from web_site.tb_battmap_information " +
+ " where StationName like ?";
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationName()}, new BattMap_informationImpl());
+ return list;
+ }
public static void main(String[] args) {
BattMap_informationImpl bimpl=new BattMap_informationImpl();
Batt_Maint_Dealarm bmd=new Batt_Maint_Dealarm();
--
Gitblit v1.9.1