update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
package com.fgkj.mapper.impl.ram;
 
import com.fgkj.dto.ram.Server_state;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
public interface Server_stateMapper{
 
    @Insert("insert into db_ram_db.tb_server_state(server_version,server_datetime,max_mem,total_mem," +
            "free_men,total_disc_space,free_disc_space,db_conn_max,db_conn_count) "+
            "values(#{server_version},#{server_datetime},#{max_mem},#{total_mem},"+
            "#{free_men},#{total_disc_space},#{free_disc_space},#{db_conn_max},#{db_conn_count})")
    public int add(Server_state state);
 
    @Update("update db_ram_db.tb_server_state set 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} where num=#{num}")
    public int update(Server_state state);
 
    @Delete("delete from db_ram_db.tb_server_state where num=#{num}")
    public int del(Server_state state);
 
    //查询系统的cpu,内存使用率
    @Select("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")
    public List<Server_state> searchAll();
 
    @Select("select * from db_ram_db.tb_server_state where num=#{num}")
    public List<Server_state> serchByCondition(Server_state state);
 
}