计算机毕业设计hadoop+spark+hive知识图谱音乐推荐系统 音乐数据分析可视化大屏 音乐爬虫 LSTM情感分析 大数据毕设 深度学习 机器学习 大数据毕业设计 人工智能_音乐数据分析与可视化毕设

核心算法代码分享如下：

from flask import Flask, request
import json
from flask_mysqldb import MySQL
 
# 创建应用对象
app = Flask(__name__)
app.config['MYSQL_HOST'] = 'bigdata'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = '123456'
app.config['MYSQL_DB'] = 'lvyou'
mysql = MySQL(app)  # this is the instantiation
 
 
@app.route('/renshu')
def price_datas():
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM renshu''')
    row_headers = [x[0] for x in cur.description]  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
@app.route('/riqi')
def price_data():
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM riqi''')
    row_headers = [x[0] for x in cur.description]  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
@app.route('/shengfengeshu')
def mileage_data():
    cur = mysql.connection.cursor()
    cur.execute('''select * from shengfengeshu''')
    row_headers = [x[1] for x in cur.description]  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
@app.route('/tianshu')
def spjine_data():
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM tianshu''')
    row_headers = [x[0] for x in cur.description]  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
@app.route('/wanfa10')
def wg_data():
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM wanfa10''')
    row_headers = [x[0] for x in cur.description]  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
@app.route('/zuozhe5')
def plzd_data():
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM zuozhe5''')
    row_headers = [x[1] for x in cur.description]  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
@app.route("/shengfengeshu")
def shengfengeshu():
    # file_path = "d:\\hadoop_spark_tour2024\\page\\riqi.json"
    # with open(file_path, "r", encoding='utf-8') as f:
    #     data = json.load(f)
    #     return json.dumps(data, ensure_ascii=False)
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM shengfengeshu''')
    #row_headers = [x[1] for x in cur.description]  # this will extract row headers
    row_headers = ['shengfen','geshu']  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
@app.route("/getmapcountryshowdata")
def getmapcountryshowdata():
    filepath = r"d:\\hadoop_spark_tour2024\\page\\data\\maps\\china.json"
    with open(filepath, "r", encoding='utf-8') as f:
        data = json.load(f)
        return json.dumps(data, ensure_ascii=False)
 
 
 
 
@app.route("/nbdata")
def nb_data7():
    # file_path = "d:\\hadoop_spark_tour2024\\page\\riqi.json"
    # with open(file_path, "r", encoding='utf-8') as f:
    #     data = json.load(f)
    #     return json.dumps(data, ensure_ascii=False)
    cur = mysql.connection.cursor()
    cur.execute('''SELECT * FROM riqi''')
    #row_headers = [x[1] for x in cur.description]  # this will extract row headers
    row_headers = ['yue','geshu']  # this will extract row headers
    rv = cur.fetchall()
    json_data = []
    print(json_data)
    for result in rv:
        json_data.append(dict(zip(row_headers, result)))
    return json.dumps(json_data, ensure_ascii=False)
 
 
if __name__ == "__main__":
    app.run(debug=True)