fix connection close

perryhsu

2020-08-28 d2e8f19b5c12f3a5f48e56852d05077ec2d6c273

fix connection close

 gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java

@@ -296,12 +296,13 @@
    }
    //根据维护区和机房名称查询电池组信息(电池组信息配置)<-------跨域----------->
    public List searchInform_ky(){
        Connection conn = DBUtil.getConn();
        String sql="select  distinct(StationId),StationId_ex,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp_YM,FbsDeviceIp_WG,FbsDeviceIp,"
                + "FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +
                 ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,battGuarantDayCount,SignalId,CInterFaceId,Load_curr,install_user,DisCurrMax,SignalName,Station_install,station_phone  " +
                 " From db_battinf.tb_battinf " +
                 " order by StationId  ";
        List<BattInf> list=DAOHelper.executeQueryLimit(sql,DBUtil.getConn(), null,new CallBack() {
        List<BattInf> list=DAOHelper.executeQueryLimit(sql,conn, null,new CallBack() {
            
            public List getResults(ResultSet rs) {
                List list = new ArrayList<BattInf>();
@@ -362,6 +363,11 @@
                return list;
            }
        });
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }
    //根据维护区和机房名称查询电池组信息(电池组信息配置)

 gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java

@@ -463,7 +463,11 @@
                return list;
            }
        });
		
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }
    

 gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java

@@ -322,6 +322,7 @@
    }
    //11.1FBS9100设备通信状态查询<-------跨域----------->
    public List serchByCondition_ky() {
        Connection conn = DBUtil.getConn();
        String sql="";
        String baseSql="select  distinct tb_fbs9100_state.num,tb_fbs9100_state.dev_ip,tb_fbs9100_state.dev_version,record_datetime,tb_fbs9100_state.dev_id,op_cmd,dev_datetime,dev_testtype,dev_testgroupnum," +
                "dev_workstate,dev_alarmstate,dev_res_test_state,dev_onlinevollow,dev_eachgroup_battsum,dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr," +
@@ -337,7 +338,7 @@
        //最后结果
        sql=baseSql+groupSql;
        //System.out.println(sql);
        List<Fbs9100_state> list=DAOHelper.executeQueryLimit(sql, DBUtil.getConn(), null, new CallBack() {
        List<Fbs9100_state> list=DAOHelper.executeQueryLimit(sql, conn, null, new CallBack() {
            List list=new ArrayList();
            public List getResults(ResultSet rs) {
                try {
@@ -384,6 +385,11 @@
                return list;
            }
        });
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }