Python连接操作My sql数据库

#coding=utf-8
#连接数据库测试
import  pymysql

def OpenMysql(host,user,password,db):
    db = pymysql.connect(host=host, user=user, password=password, db=db,
                         cursorclass=pymysql.cursors.DictCursor)
    return db
def Select_All(db):
    cur = db.cursor()
    sql_dict = {}
    # 查询操作
    sql = "select * from jz2_low"
    try:
        cur.execute(sql)
        result = cur.fetchall()
        return result
    except Exception as e:
        print("查询全部数据错误", e)
    finally:
        db.close()
def RunSqlShell(db,shell):
    cur = db.cursor()
    sql_dict = {}
    # 查询操作
    sql = shell
    try:
        cur.execute(sql)
        result = cur.fetchall()
        return result
    except Exception as e:
        print("RunShellError：", e)
    finally:
        db.close()

在想调用的地方引入使用

import OpenMysql,Select_All、
 db = OpenMysql("192.168.10.229", "root", "123456", "perforamance")
 result = Select_All(db)

这里与本篇文章无关

喜欢二次元动漫的小伙伴可以微信扫一扫关注一下哟，点赞关注，鼓励一下博主呦