From abbe39a2e93415bff7014cf2134a47103f85dbff Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期一, 28 十二月 2020 14:40:13 +0800
Subject: [PATCH] 添加关闭sql连接
---
Central_Monitor/src/com/data/Comm/Central_Data_Task_SQL.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/Central_Monitor/src/com/data/Comm/Central_Data_Task_SQL.java b/Central_Monitor/src/com/data/Comm/Central_Data_Task_SQL.java
index 056a869..fe7656c 100644
--- a/Central_Monitor/src/com/data/Comm/Central_Data_Task_SQL.java
+++ b/Central_Monitor/src/com/data/Comm/Central_Data_Task_SQL.java
@@ -29,6 +29,8 @@
sql.sqlMysqlExecute(" CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_MW_Motor);
} catch (SQLException e) {
sql.logger.error(e.toString(),e);
+ } finally {
+ sql.close_con();
}
}
@@ -42,6 +44,8 @@
sql.sqlMysqlExecute(" CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_MW_Motor_History);
} catch (SQLException e) {
sql.logger.error(e.toString(),e);
+ } finally {
+ sql.close_con();
}
}
@@ -82,6 +86,8 @@
sql.sqlMysqlExecute(sql_str);
} catch (SQLException e) {
sql.logger.error(e.toString(), e);
+ } finally {
+ sql.close_con();
}
}
@@ -108,6 +114,8 @@
sql.sqlMysqlExecute(sql_str);
} catch (SQLException e) {
sql.logger.error(e.toString(), e);
+ } finally {
+ sql.close_con();
}
}
@@ -138,6 +146,8 @@
sql.sqlMysqlExecute(sql_str);
} catch (SQLException e) {
sql.logger.error(e.toString(), e);
+ } finally {
+ sql.close_con();
}
}
}
--
Gitblit v1.9.1