Flask中Python连接mysql_python flask mysql 连接字符串

import pymysql
import pprint
 
def get_conn():
    return pymysql.connect(
        host='127.0.0.1',
        user = 'root',
        password='root',
        database='itcast'
    )
 
 
def query_data(sql):
    conn = get_conn()
    try:
        cursor = conn.cursor(pymysql.cursors.DictCursor)
        cursor.execute(sql)
        return cursor.fetchall()
    finally:
        conn.close()
 
 
def insert_or_update(sql):
    conn = get_conn()
    try:
        cursor = conn.cursor()
        cursor.execute(sql)
        conn.commit()
    finally:
        conn.close()
 
 
 
if __name__ == '__main__':
    sql = "select * from dept"
    datas = query_data(sql)
    pprint.pprint(datas)