python3的连接数据库代码:
我用的是本地服务器的mysql来进行连接。
# encoding=utf-8
import pymysql
# db= pymysql.connect(
# host='root',
# passwd='#####',
# db="excel",
# charset='utf8')
db = pymysql.connect("localhost","#####","######",charset='utf8')#里面分别是用户名和密码
cursor = db.cursor()
cursor.execute("use excel")
try:
sql = "select * from test"
cursor.execute(sql)
data = cursor.fetchall()
for re in data:
num = re[0]
name = re[1]
sex = re[2]
print(num,name,sex)
except:
print("unable to get data")
try:
sql = "insert into test values(1613200012,'yang','man')"
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close();