import pymysql
class Mysql_api:
    def __init__(self, user, password, host, port, db):
        # print(user, password, host, port, db)
        self.conn = pymysql.connect(host=host, port=port, user=user, password=password, db=db, charset='utf8mb4', )
        self.c = self.conn.cursor()

    def run(self, sql):
        self.c.execute(sql)
        data = self.c.fetchall()
        return data

    def end(self):
        self.c.close()
        self.conn.close()

# @app.route('/hd', methods=['GET'])
def hd():
    gw = Mysql_api('root', '数据库密码', 'ip地址', 3306, '库名')
    sql = "select * from app01_webinfo "
    wz = gw.run(sql)
    print(wz)


if __name__ == '__main__':
    hd()