python3连接数据库

1. 连接数据库代码

#!/usr/sbin/env python3
import pymysql
conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", passwd="", charset="utf8", db="flask")
cursor = conn.cursor()
cursor.execute("select * from user")
result = cursor.fetchone()
cursor.close()
conn.close()
print(result)

　　

 

2.使用连接池（模块：dbutils）

#!/usr/sbin/env python3
import pymysql
from dbutils.pooled_db import PooledDB
POOL = PooledDB(
        creator=pymysql,
        maxconnections=10,
        mincached=2,
        maxcached=3,
        blocking=True,
        setsession=[],
        ping=0,
       host="127.0.0.1", port=3306, user="root", passwd="", charset="utf8", db="flask"
        )

conn = POOL.connection()
cursor = conn.cursor()
cursor.execute("select * from user")
result = cursor.fetchone()
cursor.close()
conn.close()
print(result)