医院科研管理系统

import requests

import json

import mysql.connector

def fetch_data_from_yuncheng():

url = "https://yuncheng.com/api/experiments"

response = requests.get(url)

return response.json()

def save_to_database(data):

conn = mysql.connector.connect(host='localhost', user='root', password='password', database='research_system')

cursor = conn.cursor()

for record in data:

cursor.execute("INSERT INTO experiment_records (timestamp, device_id, result) VALUES (%s, %s, %s)",

(record['timestamp'], record['device_id'], record['result']))

conn.commit()

cursor.close()

conn.close()

if __name__ == "__main__":

data = fetch_data_from_yuncheng()

save_to_database(data)

]]>