你可以帮我写个根据连接地址用户名密码动态连接mysql的工具类吗
时间: 2023-08-01 17:07:53 浏览: 39
当然可以,以下是一个示例代码:
```python
import mysql.connector
class MySQLConnector:
def __init__(self, host, user, password):
self.host = host
self.user = user
self.password = password
self.connection = None
def connect(self):
self.connection = mysql.connector.connect(
host=self.host,
user=self.user,
password=self.password
)
def execute_query(self, query):
if not self.connection:
self.connect()
cursor = self.connection.cursor()
cursor.execute(query)
result = cursor.fetchall()
cursor.close()
return result
```
使用方法:
```python
connector = MySQLConnector(host='localhost', user='root', password='password')
result = connector.execute_query('SELECT * FROM my_table')
print(result)
```
需要注意的是,这只是一个简单的示例,实际使用时还需要考虑连接池、异常处理等问题。