如何使用python链接数据库
1.使用PyMySQL库连接MYSQL数据库
from flask import Flask
import pymysql
app = Flask(__name__)
db = pymysql.connect(
host="127.0.0.1",
user="root",
password="root",
database="rebecca"
)
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
db.close()
if __name__ == "__main__":
app.run()
2.使用MySQL Connector/Python库连接MYSQL数据库
from flask import Flask
import mysql.connector
app = Flask(__name__)
db = mysql.connector.connect(
host="127.0.0.1",
user="root",
password="root",
database="rebecca"
)
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
db.close()
if __name__ == "__main__":
app.run()