pymysql 有这段代码就够了

这是基于pymysql的一个工具类,增删改查只需要调用对应的方法就可以了。

import pymysql   
import traceback    # 导入异常处理包

class py_util:
    def __init__(self,host, user, password,database,port): # 初始化参数
        self.__host = host  
        self.__user = user
        self.__password = password
        self.__database = database
        self.__port = port
    def __open(self):
        self.__conn = pymysql.connect(   # 建立连接
            host=self.__host,
            port=self.__port,
            user=self.__user,
            password=self.__password,
            database=self.__database,
            charset="utf8"
        )
        self.__cursors = self.__conn.cursor()
    def __close(self):     # 关闭连接
        self.__cursors.close()
        self.__conn.close()

    def cud(self,sql,params):   # 增删改
        try:
            self.__open()
            self.__cursors.execute(sql, params)
            self.__conn.commit()
            self.__close()
        except Exception as e:
            traceback.print_exc()   # 输出异常信息

    def r(self,sql,params):  # 查
        try:
            self.__open()
            self.__cursors.execute(sql,params)
            result = self.__cursors.fetchall()
            self.__close()
            return result
        except Exception as e:
            traceback.print_exc()    # 输出异常信息