pycharm 操作mysql

import pymysql

class Mysql_Python:
    def __init__(self,host,port,user,password,database):
        self.host = host
        self.port = port
        self.user = user
        self.password = password
        self.database = database
    def coonect(self):
        db = pymysql.connect(host=self.host,port=self.port,user=self.user,password=self.password,database=self.database)
        cursor = db.cursor()
        return db,cursor

    def select(self,cursor,sql_str):
        try:
            cursor.execute(sql_str)  # 执行SQL语句
            results = cursor.fetchall()  # 获取所有记录列表
            return results
        except:
             print("Error: unable to fetch data")
             print("失败")

    def insert(self,db,cursor,sql_str):
        try:
            cursor.execute(sql_str)  # 执行sql语句
            db.commit()  # 提交到数据库执行
            print("成功")
        except:
            db.rollback()  # 如果发生错误则回滚
            print("失败")

    def delete(self,db,cursor,sql_str):
        try:
            cursor.execute(sql_str)  # 执行SQL语句
            db.commit()  # 提交修改
            print("成功")
        except:
            db.rollback()  # 发生错误时回滚# 关闭连接
            print("失败")

    def updata(self,db,cursor,sql_str):
        try:
            cursor.execute(sql_str)  # 执行SQL语句
            db.commit()  # 提交修改
            print("成功")
        except:
            db.rollback()  # 发生错误时回滚# 关闭连接
            print("失败")

    def close(self,db,cursor):
        cursor.close()
        db.close()