pymysql是Python中操作MySQL的模块,其使用方法和MySQLdb几乎相同。2.7用MySQLdb,3.0用pymysql
下载安装pymysql 命令: pip3 install pymysql
导入pymysql
import pymysql
该函数用来连接数据库
def conn_db():
# 创建链接
conn = pymysql.connect(host=’127.0.0.1’, port=3306, user=’root’, db=’firstDjango’, charset=’utf8’)# password =’密码’
# 创建游标
cur = conn.cursor()
return (conn,cur)
该方法执行sql语句
def exe_query(cur, sql):
cur.execute(sql)
return cur
更新语句,可执行update,insert语句
def exeUpdate(cur, sql):
sta = cur.execute(sql)
return (sta)
查询语句
def exeQuery(cur, sql):
cur.execute(sql)
return (cur)
关闭所有链接
def connClose(conn, cur):
# 关闭游标
cur.close()
# 关闭连接
conn.close()
调用链接数据库的函数
conn, cur = conn_db()
查询现有数据, 并打印
query = exe_query(cur,’select * from book’)
for ee in query:
print(ee)
update = exeUpdate(cur, “insert into book values(12, ‘周六’, ‘朝日’)”)
提交,不然无法保存新建或者修改的数据
conn.commit()
if update == 1:
print(“插入成功”)
query2 = exe_query(cur, ‘select * from book’)
for ee in query2:
print(ee)
else:
print(‘插入失败’)
connClose(conn,cur)