Python操控MySql

来源：互联网发布：php类与对象person 编辑：程序博客网时间：2024/06/10 12:51

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)

0 0