pymysql封装增删改查

import pymysql

class Mysql_Connect:
    def __init__(self,host:str,port:int,user:str,pwd:str,db:str):
        self.host = host
        self.port = port
        self.user = user
        self.pwd = pwd
        self.db = db

    def connect(self):  #链接数据库
        db = pymysql.connect(
            host = self.host,
            port = self.port,
            user = self.user,
            password= self.pwd,
            db = self.db
      )   #连接数据库
        cursor = db.cursor()  #创建游标对象
        return cursor,db


    def execute_func(self,sql,cursor,db):  #执行sql语句
        try:
            cursor.execute(sql)  # 执行sql语句
            res = cursor.fetchall()
            print(res,'创建表的时候是看不见该数据的，展示所有表的时候可以')
            cursor.close()  # 关闭游标
            db.close()  # 管不数据库的连接
            print(f"{sql}语句执行完成")
            return
        except Exception as e:
            print(f"execute_func执行{sql}语句错误",e)
            return None

    def insert_update_delete(self,sql,cursor,db):
        try:
            cursor.execute(sql) #执行sql语局
            db.commit()
            cursor.close()
            db.close()
            print(f'{sql}语句执行状态为:成功')
        except Exception as e:
            print(f"{sql}语句执行状态为：失败")

    def select_statement(self,sql,cursor,db):
        try:
            cursor.execute(sql)
            res = cursor.fetchall() #查询结果  元组类型
            cursor.close()
            db.close()
            return res  #返回查询结果
        except:
            pass
if __name__ == '__main__':
    create_connect = Mysql_Connect(host="localhost",pwd="123",port=3306,user="root",db='pymysql_1')
    cursor,db = create_connect.connect()

    #创建数据库
    # create_connect.execute_func(sql="create database pymysql_1;",cursor=cursor,db=db)  #创建数据库

    #创建表
    sql = 'create table banji1(id int primary key AUTO_INCREMENT,b_name varchar(20));'
    # sql = 'show tables;'
    create_connect.execute_func(sql=sql,cursor=cursor,db=db)

    #插入语句
    # sql = 'insert into banji(b_name) values ("小米2");'
    # create_connect.insert_into(sql=sql,cursor=cursor,db=db)

    #删除语句
    # sql = 'delete from banji where id = 7;'
    # create_connect.insert_update_delete(sql=sql,cursor=cursor,db=db)

    # 修改语句
    # sql = 'update banji set b_name = "小米" where b_name = "小米2";'
    # create_connect.insert_update_delete(sql=sql, cursor=cursor, db=db)

    # 查询语句
    # sql = 'select * from banji;'
    # create_connect.select_statement(sql=sql, cursor=cursor, db=db)