From aa890874f3f6ee7e88134493dc29705bc6fd89a3 Mon Sep 17 00:00:00 2001 From: 81041 <81041@192.168.10.25> Date: 星期一, 22 十月 2018 16:24:27 +0800 Subject: [PATCH] 修改 --- gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java index 22b9fb4..38f8ff1 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java @@ -622,7 +622,7 @@ " and db_user.tb_user_inf.uid=? )"; baseSql+=userSql; //鏈烘埧缁存姢鍖洪�夋嫨 - String stationSql=" AND db_battinf.tb_battinf.stationname like ? AND db_battinf.tb_battinf.stationname1 like ? "; + String stationSql=" AND db_battinf.tb_battinf.stationname like ? AND db_battinf.tb_battinf.stationname1 like ? AND db_battinf.tb_battinf.stationname2 like ? "; baseSql+=stationSql; //鐢垫睜鐘舵�� String stateSqlT=" AND batt_state=? "; @@ -638,7 +638,7 @@ String limitSql=" limit ?,?"; sql=baseSql+endSql+limitSql; //System.out.println(sql); - List<Batt_State> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%" + List<Batt_State> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%" ,binf.getNum(),(page.getPageCurr() - 1)*page.getPageSize(), page.getPageSize()}, new CallBack() { -- Gitblit v1.9.1