python使用pymysql连接数据库进行sql语句增删改查

模块 pip install pymysql

#引用模块
import pymysql

class Mysqlconnect:
    __conn = None
    __cursor = None

    @classmethod
    def __connsql(cls):
        if cls.__conn is None:
            cls.__conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='root', database='tpshop2.0')
            return cls.__conn

    @classmethod
    def __takecursor(cls):
        if cls.__cursor is None:
            cls.__cursor = cls.__connsql().cursor()
        return cls.__cursor

    @classmethod
    def out_sql(cls, sql):
        try:
            cursor = cls.__takecursor()
            cursor.execute(sql)
            if sql.lower().find('select') != -1:
                # print('查询操作')
                return cursor.fetchall()
            else:
                # print('增删改操作')
                cls.__conn.commit()
                return '影响数据行列{}'.format(cursor.rowcount)
        except Exception as e:
            cls.__conn.rollback()
            return '异常：%s' % e
        finally:
            cls.__close()

    @classmethod
    def __close(cls):
        if cls.__cursor:
            cls.__cursor.close()
            cls.__cursor = None
        if cls.__conn:
            cls.__conn.close()
            cls.__conn = None

修改对应的地址 端口 账户 密码 库名

直接调用out_sql(cls, sql)就可以了 sql填写sql语句