学习笔记(17):python flask web开发入门与项目实战-对数据库进行增删改操作

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

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()

# #插入
# try:
#     insert = "insert into t_mail (name,mail) values('张飞','9393@gmail.com')"
#     cursor.execute(insert)
#     conn.commit()
# except Exception as ex:
#     print(ex)

# # 更新
# try:
#     update = "update t_mail set mail='0000@99.com' where name='张飞'"
#     cursor.execute(update)
#     conn.commit()
# except Exception as ex:
#     print(ex)

# 删除
try:
    delete = "delete from t_mail  where name='张飞'"
    cursor.execute(delete)
    conn.commit()
except Exception as ex:
    print(ex)

# 查询
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()