server_state中加5列

81041

2018-12-25 db7908a1783169130799652dd7253198ace964ac

server_state中加5列

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Server_stateImpl.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dto/ram/Server_state.class

Binary files differ

 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 @@
    }

    //查询系统的cpu,内存使用率

    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;

    }


 gx_tieta/src/com/fgkj/dto/ram/Server_state.java

@@ -14,6 +14,13 @@
    private Long free_disc_space;

    private Integer db_conn_max;

    private Integer db_conn_count;

	
    private int app_conn_max;       //主程序数据库连接池最大连接数

    private int app_busy_conn_cnt;  //主程序数据库连接池正在使用的连接数

    private int app_idle_conn_cnt;  //主程序数据库连接池空余连接数

    private float server_cpu_rate;  //服务器cpu使用率

    private float server_network_rate;//服务器网络使用率

	
    public Server_state() {

        super();

        // TODO Auto-generated constructor stub

@@ -79,15 +86,44 @@
    public void setDb_conn_count(Integer db_conn_count) {

        this.db_conn_count = db_conn_count;

    }

    public int getApp_conn_max() {

        return app_conn_max;

    }

    public void setApp_conn_max(int app_conn_max) {

        this.app_conn_max = app_conn_max;

    }

    public int getApp_busy_conn_cnt() {

        return app_busy_conn_cnt;

    }

    public void setApp_busy_conn_cnt(int app_busy_conn_cnt) {

        this.app_busy_conn_cnt = app_busy_conn_cnt;

    }

    public int getApp_idle_conn_cnt() {

        return app_idle_conn_cnt;

    }

    public void setApp_idle_conn_cnt(int app_idle_conn_cnt) {

        this.app_idle_conn_cnt = app_idle_conn_cnt;

    }

    public float getServer_cpu_rate() {

        return server_cpu_rate;

    }

    public void setServer_cpu_rate(float server_cpu_rate) {

        this.server_cpu_rate = server_cpu_rate;

    }

    public float getServer_network_rate() {

        return server_network_rate;

    }

    public void setServer_network_rate(float server_network_rate) {

        this.server_network_rate = server_network_rate;

    }

    @Override

    public String toString() {

        return "Server_state [num=" + num + ", server_version="

                + server_version + ", server_datetime=" + server_datetime

                + ", max_mem=" + max_mem + ", total_mem=" + total_mem

                + ", free_men=" + free_men + ", total_disc_space="

                + total_disc_space + ", free_disc_space=" + free_disc_space

                + ", db_conn_max=" + db_conn_max + ", db_conn_count="

                + db_conn_count + "]";

        return "Server_state [num=" + num + ", server_version=" + server_version + ", server_datetime="

                + server_datetime + ", max_mem=" + max_mem + ", total_mem=" + total_mem + ", free_men=" + free_men

                + ", total_disc_space=" + total_disc_space + ", free_disc_space=" + free_disc_space + ", db_conn_max="

                + db_conn_max + ", db_conn_count=" + db_conn_count + ", app_conn_max=" + app_conn_max

                + ", app_busy_conn_cnt=" + app_busy_conn_cnt + ", app_idle_conn_cnt=" + app_idle_conn_cnt

                + ", server_cpu_rate=" + server_cpu_rate + ", server_network_rate=" + server_network_rate + "]";

    }