在Python中，你可以创建一个MySQL连接类，通常会继承自`mysql-connector-python`库中的`mysql.connector.connection.MySQLConnection`基础类。封装这个类可以帮助管理数据库连接、执行查询以及关闭连接等操作。下面是一个简单的例子：
import mysql.connectorclass MysqlDBConnection(mysql.connector.Connection):
def __init__(self, host='localhost', user='username', password='password', database='dbname'):
super().__init__()
self.host = host
self.user = user
self.password = password
self.database = database
self.connect() def connect(self):
try:
self.connect(host=self.host, user=self.user, password=self.password, database=self.database)
print("Connected to MySQL")
except mysql.connector.Error as err:
print(f"Error connecting to MySQL: {err}") def execute_query(self, query):
cursor
