flask读取数据库(mysql)并展示表格（讲解获取表头的方法）【附上flask好看点的helloworld】

叁歲伎倆 2022-04-05 07:42 1135阅读 0赞

## 简述 ##

为了网页的好看，最好还是用bootstrap

### 文章目录 ###

*   *  简述
     *  好看点的helloworld
     *  链接数据库
     *  结合在html上和flask上
     *   *  html代码修改

## 好看点的helloworld ##

anyway,先看初始版本的 **helloworld**

*  **/template/index.html**
 *  来自于bootstrap官网

*  **./app.py**

from flask import Flask, render_template
    
    app = Flask(__name__)
    
    
    @app.route('/')
    def hello_world():
        return render_template('index.html')
    
    
    if __name__ == '__main__':
        app.run()

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExOTk5MDQxMg_size_16_color_FFFFFF_t_70]

## 链接数据库 ##

这里我推荐使用pymysql  
因为这个在不同平台上都可以使用，而且安装也没什么坑。

pip install pymysql

*  链接的示范
    
     *  conn是一个连接器
     *  host是url
     *  user是用户
     *  password是密码
     *  db是数据库（也就是show databases;可以看到的）
     *  charset主要是为了设置为可以看中文

import pymysql
    
    
    conn = pymysql.connect(
        host='127.0.0.1',
        user='root',
        password='1234',
        db='library_management_system',
        charset='utf8'
    )

## 结合在html上和flask上 ##

### html代码修改 ###

*  **/templates/index.html**

<!doctype html>
    <html lang="en">
    <head>
        
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    
        
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    
        <title>Hello, world!</title>
    </head>
    <body>
    <div class="row">
        <div class="col-md-6 col-sm-12 col-xs-12">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <h3>Students</h3>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <table class="table table-striped table-bordered table-hover">
                            <thead>
                            <tr>
                                {% for i in labels %}
                                    <td>{
       { i }}</td>
                                {% endfor %}
                            </tr>
                            </thead>
                            <tbody>
                            {% for i in content %}
                                <tr>
                                    {% for j in i %}
                                        <td>{
       { j }}</td>
                                    {% endfor %}
                                </tr>
                            {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
    
        </div>
    
    </div>
    
    
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
    </body>
    </html>

*  **[app.py][]**

from flask import Flask, render_template
    import pymysql
    
    app = Flask(__name__)
    
    conn = pymysql.connect(
        host='127.0.0.1',
        user='root',
        password='1234',
        db='jxgl',
        charset='utf8'
    )
    
    
    @app.route('/')
    def hello_world():
        cur = conn.cursor()
    
        # get annual sales rank
        sql = "select * from student"
        cur.execute(sql)
        content = cur.fetchall()
    
    	# 获取表头
        sql = "SHOW FIELDS FROM student"
        cur.execute(sql)
        labels = cur.fetchall()
        labels = [l[0] for l in labels]
    
        return render_template('index.html', labels=labels, content=content)
    
    
    if __name__ == '__main__':
        app.run()

*  效果:

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExOTk5MDQxMg_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExOTk5MDQxMg_size_16_color_FFFFFF_t_70]: /images/20220405/c0e0eac5ea9b48b5b85757fcf7abe139.png
[app.py]: http://app.py
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExOTk5MDQxMg_size_16_color_FFFFFF_t_70 1]: /images/20220405/bfae6f4292754f1a87b59f46eeee2c46.png