mysql数据库操作,python封装

import pymysql

class ConnSql(object):
    """
    操作数据库
    """

    def __init__(self, host, port, user, password, database):
        # 连接数据库
        self.connect = pymysql.connect(host=host,
                                       port=int(port),
                                       user=user,
                                       password=password,
                                       database=database)

        # 创建游标
        self.cur = self.connect.cursor()

    def execute(self, sql):
        """
        执行sql
        :param sql:
        :return:
        """
        self.connect.ping()
        self.cur.execute(sql)

    def commit(self):
        self.connect.commit()

    def result(self):
        """
        执行结果
        :return:
        """
        results = self.cur.fetchall()
        return results

    def close(self):
        """
        关闭连接
        :return:
        """
        self.cur.close()
        self.connect.close()

    def rollback(self):
        """
        回滚
        :return:
        """
        self.connect.rollback()