【python】数据库的连接

连接mysql

import pymysql


HOST = '127.0.0.1'
PORT = 3306
USERNAME = 'root'
PWD = '123456'
DATABASE = 't_d'


class SqlClient:
    """
    mysql的连接和使用
    """

    def __init__(self, host= HOST, port=PORT, user=USERNAME, password=PWD, db=DATABASE, charset='utf8'):
        self.host = host
        self.port = port
        self.user = user
        self.password = password
        self.db = db
        self.charset = charset
        self.conn = pymysql.connect(host=self.host,
                                    port=self.port,
                                    user=self.user,
                                    password=self.password,
                                    db=self.db,
                                    charset=self