3.修复电源通信程序，电源历史数据存储中的循环删除功能-[旧版程序在执行过程中很容易执行过程中超时停止]

DELL

2024-02-28 8c0ae356eb450db85721f9422a62339c751a90ac

 IEC61850_ForPowerSupply_ForNW/src/com/power/datasave/PowerDataSave_SQL.java

@@ -107,14 +107,14 @@
                         " from information_schema.tables " + 

                         " where table_schema='db_pwrdev_data_history' " + 

                         " AND TABLE_NAME like 'tb_pwrdev_historydata_%' " + 

                         " AND UPDATE_TIME <= '"+Com.getDateTimeFormat(deldate, Com.DTF_YMDhms)+"';" ;

                         " AND CREATE_TIME <= '"+Com.getDateTimeFormat(deldate, Com.DTF_YMDhms)+"';" ;

      

      String sql_delete_strs = " DROP TABLE IF EXISTS ";

      

      Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());

      ResultSet res = null;

      int count = 0;

      res = sql.sqlMysqlQuery(sql_select_strs);

      res = sql.sqlMysqlTotalQuery(sql_select_strs);

      try {

         while(res.next()) {

            if(count > 0) {

@@ -126,7 +126,7 @@
            count++;

         }

         if(count > 0) {

            sql.sqlMysqlExecute(sql_delete_strs);

            sql.sqlMysqlTotalExecute(sql_delete_strs);

         }

         

         res.close();