- python使用pymysql访问数据库
import pymysql
class SQL:
# 记录访问数据库的账户信息
__account = {
'user': '',
'password': ''
}
def __init__(self, _account: dict):
if 'user' in _account and 'password' in _account:
self.__account['user'] = _account['user']
self.__account['password'] = _account['password']
# 连接数据库
def __get_connect(self):
# 返回连接对象
return pymysql.connect(
host='************.**.tencentcdb.com',