update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

 src/main/java/com/fgkj/mapper/impl/ram/Server_stateMapper.java

@@ -1,31 +1,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{

   public boolean add(Object obj);
   @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);

   public boolean update(Object obj);
   @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);

   public boolean del(Object obj);
   @Delete("delete from db_ram_db.tb_server_state where num=#{num}")
   public int del(Server_state state);

    //查询系统的cpu,内存使用率
   public List searchAll();
   @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();

   public List serchByCondition(Object obj);

   /*public static void main(String[] args) {
      Server_stateImpl si=new Server_stateImpl();
      Server_state ss=new Server_state();
      ss.setNum(1);
      //List<Server_state> list=si.serchByCondition(ss);
		
      List<Server_state> list=si.searchAll();
      System.out.println(list.size());
      for(Server_state h:list){
         System.out.println(h);
      }
   }*/
   @Select("select * from db_ram_db.tb_server_state where num=#{num}")
   public List<Server_state> serchByCondition(Server_state state);

}