import paramiko #引用封装SSH连接方式的工具包
#返回一个连接
#host：ip地址  username：用户名  pwd 密码
def get_connection(host,username,pwd):
    try:
      client = paramiko.SSHClient()
      client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
      client.connect(host,22,username,pwd)
      return client
    except Exception as e:
      return None

def __get_dbconn(self):
        try:
           
            _config = configparser.ConfigParser()
            _config.read(self._configPath)
            host = _config.get("dbconfig","host")  #主机IP地址
            dbusername = _config.get("dbconfig","dbusername") #数据库用户名
            dbuserpwd = _config.get("dbconfig","dbuserpwd") #数据库用户密码
            dbname = _config.get("dbconfig","dbname") #数据库名称
            db = pymysql.connect(host,dbusername,dbuserpwd,dbname)
            return db
        except Exception as e:
            return None

 def get_serverList(self,sqltext):
        db = self.__get_dbconn()
        if db is None:
            return 0  #0表示连接数据库失败
        else :
            try:
                cursor = db.cursor()
                cursor.execute(sqltext) #执行sql语句
                results = cursor.fetchall() #读取全部结果
                return results
            except Exception as e:
                return -1 # -1 表示读取数据失败，有可能SQL语句不对
            finally :
                db.close()

from flask_sqlalchemy import SQLAlchemy  #python3 的写法
app = Flask(__name__)
app.config[\'SQLALCHEMY_DATABASE_URI\'] = \'mysql+pymysql://woodpecker:woodpecker@localhost/woodpecker\'
app.config[\'SQLALCHEMY_TRACK_MODIFICATIONS\'] = False  #是否
app.config[\'SQLALCHEMY_COMMIT_ON_TEARDOWN\'] = True
db = SQLAlchemy(app)

<ul id="serverlist" class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu1">
         {% for group in groupList  %}
             <li><a role="menuitem" href="#" >{{ group.groupname }}</a></li>
             <li class="divider"></li>
         {% else %}
             <li><a role="menuitem" href="#">读取服务器分组失败</a></li>
         {% endfor %}
    </ul>

def index():
    groupList = Group.query.all()
    return render_template(\'index.html\', groupList=groupList)

var data = {\'ip\':ip};   //ip是传到后台的参数
        $.ajax({
            type:\'post\',
            async:false,
            url:"/get_sys_info",  //接收参数的后台路由函数
            data:data,
            success:function (result) {
                drawchart(result,ip) //此函数是接收到返回的结果后做前台处理的
                ;}
      });

@app.route(\'/get_sys_info\', methods=[\'POST\',\'GET\'])
def getSysInfo():
    ip = request.form.get("ip")
    .......

 //给服务器列表的下拉框每个li元素添加点击事件
    window.onload = function () {
         var obj_lis = document.getElementById("serverlist").getElementsByTagName("li");
         for(var i=0;i<obj_lis.length;i++)
         {
            obj_lis[i].onclick = function()
            {
                getiplist(this.innerText);
            }
         }
    }
    //根据选择的分组设置btn的现实，并读取当前分组下的ip列表
    function getiplist(groupname)
    {
        var btn=document.getElementById("dropdownMenu1");
        //直接给btn.innerText = groupname,表示下来的倒三角不显示
        btn.innerHTML=groupname+"<span class=\"caret\"></span>";
        getipList(groupname)
    }

 //添加ip地址到ul中
      function addIPToUL(data){
          delIPFromUL();
          var ip_str = String(data);
          var ips = ip_str.split(",");
               //alert(ips[0]);
          for(var i=0;i<ips.length;i++)
          {
              var li = document.createElement("li");
              li.setAttribute("class","list-group-item");
              li.innerText=ips[i];
              li.onclick=getSysInfo;
              document.getElementById("iplist").appendChild(li);
          }
      }

//选择新分组之后需要清空当前的ip地址
      function delIPFromUL() {
          var obj_ul = document.getElementById("iplist");
          var obj_lis = document.getElementById("iplist").getElementsByTagName("li");
          var cnt = obj_lis.length;
          //alert(cnt);
          if(cnt>0) {
              for (var i=cnt-1;i>=0;i--){
              var m_li=obj_lis[i];
              obj_ul.removeChild(m_li);
             }
          }
      }

 setInterval(function () {
        //alert("开始执行");
        getSysInfo();
    }, 60000);

 <div id="chart_cpu"  style="height: 50%;width: 50%;background: white;float: left"></div>

//CPU显示
        var options_cpu ={
            chart:{
                type:\'line\'
            },
            title:{
                text:\'CPU使用情况\'
            },
            subtitle:{
              text:ip
            },
            xAxis:{
                type:"datetime",
                dateTimeLabelFormat:{
                    day:\'%H:%M\'
                },
                labels:{
                    overflow:\'justify\'
                },
                categories:data["time"]
            },
            yAxis:{
                title:{
                    text:\'百分比(%)\'
                }
            },
            legend:{
                layout: "vertical",
                align:\'left\',
                verticalAlign: "middle"
            },
            credits:{
                enabled:false
            },
            series:[{
                name:\'sy\',
                data:data["sy"]
            },
                {
                    name:\'us\',
                data:data["us"]
                },
                {
                    name:\'total\',
                data:data["totalcpu"]
                }]
        };
        $(\'#chart_cpu\').highcharts(options_cpu);
  

@app.route(\'/get_sys_info\', methods=[\'POST\',\'GET\'])
def getSysInfo():
    ip = request.form.get("ip")
    #倒序排列去除最近10条数据
    sysinfos = SysInfo.query.filter_by(serverip=ip.strip()).order_by(SysInfo.id.desc()).limit(10).all()
    #重新处理成正序
    sysinfolist = []
    for i in range(len(sysinfos)-1, 0, -1):
        sysinfolist.append(sysinfos[i])
    print(sysinfolist[0].id)
    cpudic = getCPUinfoList(sysinfolist)
    memdic = getMeminfoList(sysinfolist)
    sysinfodic = dict(cpudic, **memdic)
    sysinfodic = jsonify(sysinfodic)
    return sysinfodic

<div id="mainchart" style="height: 80%;width:87%;background: #8c8c8c;position: absolute;margin-left: 13%">
        <div id="chart_cpu"  style="height: 50%;width: 50%;background: white;float: left"></div>
        <div id="chart_mem" style="height: 50%;width: 50%;background:beige;float: right" ></div>
        <div id="chart_disk"  style="height: 50%;width: 50%;background: beige;float: left;text-align: center;font-size: 30px">磁盘使用情况</div>
        <div id="chart_io" style="height: 50%;width: 50%;background:white;float: right;text-align: center;font-size: 30px" >硬盘/网络IO情况</div>
    </div>