From fa00382db413a8489d07983b66f0869305b51a9a Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期五, 11 一月 2019 11:35:54 +0800
Subject: [PATCH] 批量读取系统参数
---
gx_tieta/src/com/fgkj/dao/impl/ram/Server_stateImpl.java | 12 +++++++++++-
1 files changed, 11 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..3dd957e 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
@@ -4,6 +4,7 @@
import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
import com.fgkj.dao.BaseDAO;
@@ -31,6 +32,14 @@
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"));
+
+ sstate.setNote(DAOHelper.sdf.format(new Date()));
list.add(sstate);
}
} catch (SQLException e) {
@@ -68,7 +77,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