学生信息管理系统

import requests

import sqlite3

# 从学工系统获取数据

def fetch_data_from_xuegong():

url = "http://xuegong.system/api/student"

response = requests.get(url)

return response.json()

# 存入本地数据库

def save_to_jiujiang_db(data):

conn = sqlite3.connect('jiujiang.db')

cursor = conn.cursor()

cursor.execute("CREATE TABLE IF NOT EXISTS students (id TEXT, name TEXT, major TEXT)")

for item in data:

cursor.execute("INSERT INTO students VALUES (?, ?, ?)",

(item['student_id'], item['name'], item['major']))

conn.commit()

conn.close()

# 主函数

if __name__ == "__main__":

data = fetch_data_from_xuegong()

save_to_jiujiang_db(data)