python连接到MySQL数据库

#-*- coding:utf-8 -*-

import pymysql

class pymysql_packing(object):
    def __init__(self, host='localhost', port=3306, user='root',
                 passwd='123', db='1database', charset='utf8'
                 ):
        self.host=host
        self.port=port
        self.user=user
        self.passwd=passwd
        self.db=db
        self.charset=charset

    def sql_connect(self):
        self.conn=pymysql.connect(host=self.host, port=self.port, user=self.user,
                                  passwd=self.passwd, charset=self.charset, db=self.db
                                  )

        self.cursor=self.conn.cursor()
        print("登录数据库%s成功"%(self.db))
        return self.cursor

    def close(self):
        self.conn.close()
        self.cursor.close()

    def update_sql(self, params, args):
        try:
            #连接数据库
            self.sql_connect()

            #业务部分
            self.cursor.execute(params, args=[])

            #获取执行结果
            result=self.cursor.fetchall()
            print(result)

            self.conn.commit()

            #
            self.close()

        except Exception as error1:
            print("error1",error1)