python数据库教程_python基础教程Python数据库封装实现代码示例解析

import pymysql

查 所数据

def get_all(sql):

conn = pymysql.connect(host="localhost", user="root", password="root", database="db6")

cur = conn.cursor(cursor=pymysql.cursors.DictCursor)

cur.execute(sql)

res = cur.fetchall()

cur.close()

conn.close()

return res

查 一行数据

def get_one(sql,args):

conn = pymysql.connect(host="localhost", user="root", password="root", database="db6")

cur = conn.cursor(cursor=pymysql.cursors.DictCursor)

cur.execute(sql,args)

res = cur.fetchone()

cur.close()

conn.close()

return res

增 删 改 都要提交 commit

def get_mif(sql,args):

conn = pymysql.connect(host="localhost", user="root", password="root", database="db6")

cur = conn.cursor(cursor=pymysql.cursors.DictCursor)

cur.execute(sql,args)

conn.commit()

cur.close()

conn.close()

增 删 改 都要提交 commit

添加并且带返回值

def get_create(sql,args):

conn = pymysql.connect(host="localhost", user="root", password="root", database="db6")

cur = conn.cursor(cursor=pymysql.cursors.DictCursor)

cur.execute(sql,args)

conn.commit()

cur.close()

conn.close()

return cur.lastrowid

# python插入记录后取得主键id的方法(cursor.lastrowid和conn.insert_id())

增 删 改 都要提交 commit

批量加入 以元祖的形式传参数 就是添加几次次提交一次

def mul_mode(sql, args):

conn = pymysql.connect(host="localhost", user="root", password="root", database="db6")

cur = conn.cursor(cursor=pymysql.cursors.DictCursor)

# self.cursor.executemany("insert into user (id,name) values (%s,%s)",[(1,"aaa"),(2,"bbb"),(3,"ccc")]) 传参方式

cur.executemany(sql, args)

conn.commit()

cur.close()

conn.close()