学习笔记(16):python flask web开发入门与项目实战-获取数据库数据

立即学习:https://edu.csdn.net/course/play/27093/355774?utm_source=blogtoedu

python获取数据库数据三部

1、创建数据库的表

2、安装pymysql模块

3、编写代码获取

{

①导入pymaysql库

②初始化

③建立连接，获取浮标

④执行语句

⑤fetchall

}

 

如

from flask import Flask
import pymysql

app = Flask(__name__)

cnn = pymysql.install_as_MySQLdb()

conn = pymysql.Connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    password='123456',
    db='flask_python',
)

cursor = conn.cursor()
mysql = "select * from t_mail"
cursor.execute(mysql)
result = cursor.fetchall()
for k in result:
    print(k[0])
    print(k[1])


@app.route('/')
def hello_world():
    return 'Hello World!'


if __name__ == '__main__':
    app.run()