From 05a193e45d3bd4c0d7355ed56d898de5822e8049 Mon Sep 17 00:00:00 2001
From: whyclxw <http://whyclxw@118.89.139.230:10101/r/~whyclxw/IdeaTest.git>
Date: 星期四, 25 三月 2021 16:43:56 +0800
Subject: [PATCH] 添加初始话
---
Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java | 40 +++++++++++++++++++++++++++++++++++++++-
1 files changed, 39 insertions(+), 1 deletions(-)
diff --git a/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java b/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java
index d536b6f..334a4a3 100644
--- a/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java
+++ b/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java
@@ -52,7 +52,19 @@
sql.close_con();
}
}
-
+ //插入负载默认数据
+ public static void insertDynamicload(MysqlConnPool conn_pool, Dynamicload_State_rt state) {
+ String sql_str = " replace into " + Sql_Mysql.Tb_Dynamicload_State_Rt_Table + "(dev_id) values("+state.getDev_id()+")";
+ Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
+ try {
+ //System.out.println(sql_str);
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
//加载负载实时数据
public static void updateDynamicload(MysqlConnPool conn_pool, Dynamicload_State_rt state) {
String sql_str = " UPDATE " + Sql_Mysql.Tb_Dynamicload_State_Rt_Table
@@ -97,6 +109,19 @@
sql.close_con();
}
}
+ //插入4MW电源默认数据
+ public static void insert4MWPower(MysqlConnPool conn_pool, Electric_state state) {
+ String sql_str = " replace into " + Sql_Mysql.Tb_Electric_State_Table + "(electric_id) values("+state.getElectric_id()+")";
+ Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
+ try {
+ //System.out.println(sql_str);
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
//加载4MW电源实时数据
public static void update4MWPower(MysqlConnPool conn_pool, Electric_state state) {
String sql_str = " update "+ Sql_Mysql.Tb_Electric_State_Table +" "
@@ -126,6 +151,19 @@
sql.close_con();
}
}
+ //插入2MW电源默认数据
+ public static void insert2MWPower(MysqlConnPool conn_pool, Electric_State_2kw state) {
+ String sql_str = " replace into " + Sql_Mysql.Tb_Electric2mw_State_Table + "(electric2KW_id) values("+state.getElectric2KW_id()+")";
+ Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
+ try {
+ //System.out.println(sql_str);
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
//加载2MW电源实时数据
public static void update2MWPower(MysqlConnPool conn_pool, Electric_State_2kw state) {
String sql_str = " UPDATE "+Sql_Mysql.Tb_Electric2mw_State_Table +
--
Gitblit v1.9.1