Python连接数据库的几种方式，抛粪引玉，有无大佬，求补全

1. 利用pymysql、MySQLdb等

import pymysql
conn = pymysql.Connect(
        host='localhost',
        port=3306,
        user='root',
        passwd='',
        db='',
        charset='utf8'
    )
    cur = conn.cursor()
    sql = "select * from user where userEmail='" + emailAddr + "' and password='"+password+"'"
    data = cur.execute(sql)
    conn.close()

import MySQLdb
# 连接MySQL数据库
conn = MySQLdb.connect(host='localhost', user='root', passwd='password', db='database_name')
# 执行查询语句
cursor = conn.cursor()
cursor.execute('SELECT * FROM table_name')
# 处理查询结果
for row in cursor.fetchall():
    print(row)
# 关闭连接
cursor.close()
conn.close()

2. 使用内置的sqlite3

import sqlite3
# 连接数据库
conn = sqlite3.connect('example.db')
# 执行查询语句
cursor = conn.execute('SELECT * FROM table_name')
# 处理查询结果
for row in cursor:
    print(row)
# 关闭连接
conn.close()

3. 记录一下Flask的另外一种连接

在app.py里面写

app = Flask(__name__)

app.config.from_object(config)
db.init_app(app)

在config.py里面写

import os

# 项目根路径
BASE_DIR = os.path.dirname(__file__)

# 数据库的配置信息
HOSTNAME = 'localhost'
PORT     = '3306'
NAME = ''
USERNAME = 'root'
PASSWORD = ''

DB_URI = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(USERNAME,PASSWORD,HOSTNAME,PORT,NAME)
SQLALCHEMY_DATABASE_URI = DB_URI
# 是否追踪数据库修改(开启后会触发一些钩子函数)  一般不开启, 会影响性能
SQLALCHEMY_TRACK_MODIFICATIONS = False

或者在main.py写

# 设置数据库连接地址
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root@127.0.0.1:3306/'
# 是否追踪数据库修改(开启后会触发一些钩子函数)  一般不开启, 会影响性能
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
# 是否显示底层执行的SQL语句
app.config['SQLALCHEMY_ECHO'] = True
db = SQLAlchemy(app)