python封装连接数据库_Python数据库封装实现代码示例解析

Django中(原生mysql封装)

1.函数封装

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"