From db7908a1783169130799652dd7253198ace964ac Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期二, 25 十二月 2018 13:47:15 +0800
Subject: [PATCH] server_state中加5列
---
gx_tieta/src/com/fgkj/dao/impl/ram/Server_stateImpl.java | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Server_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Server_stateImpl.java
index 1354eaa..75fbab8 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Server_stateImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Server_stateImpl.java
@@ -31,6 +31,12 @@
sstate.setFree_disc_space(rs.getLong("free_disc_space"));
sstate.setDb_conn_max(rs.getInt("db_conn_max"));
sstate.setDb_conn_count(rs.getInt("db_conn_count"));
+
+ sstate.setApp_conn_max(rs.getInt("app_conn_max"));
+ sstate.setApp_busy_conn_cnt(rs.getInt("app_busy_conn_cnt"));
+ sstate.setApp_idle_conn_cnt(rs.getInt("app_idle_conn_cnt"));
+ sstate.setServer_cpu_rate(rs.getFloat("server_cpu_rate"));
+ sstate.setServer_network_rate(rs.getFloat("server_network_rate"));
list.add(sstate);
}
} catch (SQLException e) {
@@ -68,7 +74,8 @@
}
//鏌ヨ绯荤粺鐨刢pu,鍐呭瓨浣跨敤鐜�
public List searchAll() {
- String sql="select num,server_version,server_datetime,max_mem,total_mem,free_men,total_disc_space,free_disc_space,db_conn_max,db_conn_count from db_ram_db.tb_server_state";
+ String sql="select num,server_version,server_datetime,max_mem,total_mem,free_men,total_disc_space,free_disc_space,db_conn_max,db_conn_count"
+ + ",app_conn_max,app_busy_conn_cnt,app_idle_conn_cnt,server_cpu_rate,server_network_rate from db_ram_db.tb_server_state";
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new Server_stateImpl());
return list;
}
--
Gitblit v1.9.1