定义类：通过python连接MySQL数据库获取数据

import pymysql

class Personss:
    def __init__(self):
        self.conn = pymysql.Connection(
            host="localhost", # 主机名 IP地址
            user="root", # 账户
            password="xxxx", # 密码
            port=3306, # 端口
    )
p2 = Personss()
conn = p2.conn

# 选择
conn.select_db("testdb")

# 获取游标
cursor = conn.cursor()

# 执行SQL
cursor.execute("select * from regions")

# 通过游标获取执行结果
result = cursor.fetchall()
print(result)

cursor.close()