Flask 全部查询 data

# 数据库信息在 WEB 页面展示

## 新建 servers 蓝图定义

```python
from flask import Blueprint
from flask import render_template
import tool_db
import json
#导入 JSON
#导入 TOOL-db
servers = Blueprint("servers", __name__)

@servers.route('/index')
def index():
    #return "Servers!"
    return render_template("servers.html")
```

## 注册到 APP.py

```python
from servers import servers
app.register_blueprint(servers,url_prefix='/servers')
```

## HTML 展示

```html
{% extends "base.html" %}
{% block head %}
    <title>服务器管理</title>
{% endblock %}
{% block body %}
    <div class="container">
        <div class="row">
            <div class="col">
                <table class="table table-bordered table-hover">
                    <thead>
                        <th>服务器名</th>
                        <th>服务器IP</th>
                        <th>服务器端口</th>
                        <th>服务器用户</th>
                    </thead>
                    <tbody id="tbodycontent">
                    </tbody>
                </table>
            </div>
        </div>
    </div>
// insert js code
{% endblock %}

```

## 得到后台数据

```js
<script type="text/javascript">
    $(document).ready(function () {
        $.ajax({
            url: '/servers/getall',
            type: 'GET',
            cache: false,
            success: function (data) {
                allresult = JSON.parse(data);
                $("#tbodycontent").html("");
                for (i = 0 ; i < allresult.length; i++){
                    tmpone = '<tr>'
                    tmpone = tmpone + '<td>'+ allresult[i]['name'] +'</td>'
                    tmpone = tmpone + '<td>'+ allresult[i]['ip'] +'</td>'
                    tmpone = tmpone + '<td>'+ allresult[i]['port'] +'</td>'
                    tmpone = tmpone + '<td>'+ allresult[i]['user'] +'</td>'
                    tmpone = tmpone + '</tr>'
                    $("#tbodycontent").append( tmpone );
                }
            }
        });
    });
</script>

```

---

done