python pymysql 操作封装

import pymysql
import sys

class Mc:
    '''
    类Mc:把mysql的一些操作封装成类
    ExcQuery(sql):查找,返回类型:tuple
    ExcUpdate(sql):增删改,出错时输出错误信息
    用法:
    mc = Mc()
    sql = "SELECT * FROM `biaotiku`"
    data = mc.ExcQuery(sql)
    for i in data:
        print(i)

    sql="INSERT INTO `biaotiku` (`id`, `text`, `beizhu`) VALUES (NULL, 'test', '123')"
    mc.ExcUpdate(sql)
    '''

    def __init__(self, db_host="127.0.0.1", username="root", pw="root", dbname="yxry"):
        self.db_host = db_host
        self.username = username
        self.pw = pw
        self.dbname = dbname
        self.db = pymysql.connect(self.db_host, self.username, self.pw, self.dbname)
        self.cursor = self.db.cursor()

    def ExcQuery(self, sql):
        self.cursor.execute(sql)
        return self.cursor.fetchall()

    def ExcUpdate(self, sql):
        try:
            self.cursor.execute(sql)
            self.db.commit()
            print("数据库更新成功!")
        except:
            print("数据库更新失败!")
            print(sys.exc_info())

    def __del__(self):
        self.db.close()
        print("数据库已关闭!")

把把mysql的一些增删改查的操作封装成类,便于使用