pip install pymysql

#!/usr/bin/env python
# -*- coding: utf8 -*-
import pymysql

class MySQL():
    def __init__(self,host,user,password,db,port):
        self.db= pymysql.connect(host=host,user=user,password=password,db=db,port=port)
        self.cur = self.db.cursor()
        print(self.__class__.__name__+"对象已创建")
    
    def query(self,sql):
        #query
        try:
            self.cur.execute(sql)
            results = self.cur.fetchall()
            return results
        except Exception as e:
            raise e

    def execute(self,sql):
        #update,insert,delete
        try:
            self.cur.execute(sql)
            self.db.commit()
        except Exception as e:
            self.db.rollback()

    def __del__(self):
        self.db.close()
        print(self.__class__.__name__+"对象已释放")


if __name__ == '__main__':
    host = ""
    user = ""
    password = ""
    db = ""
    port = xxxx
    mysql = MySQL(host,user,password,db,port)
    query_sql = "xxxx"
    update_sql = "xxxx"
    results = mysql.query(query_sql)
    print(results)
    mysql.execute(update_sql)
    print("结束")