import pandas as pd
import sqlite3
# 读取Excel文件
df = pd.read_excel('student_loan_data.xlsx')
# 连接SQLite数据库（假设数据库名为school_system.db）
conn = sqlite3.connect('school_system.db')
cursor = conn.cursor()
# 插入数据
for index, row in df.iterrows():
cursor.execute("INSERT INTO student_loans (student_id, name, loan_amount, status) VALUES (?, ?, ?, ?)",
(row['student_id'], row['name'], row['loan_amount'], row['status']))
# 提交事务
conn.commit()
# 关闭连接
conn.close()
import pandas as pd
import mysql.connector
# 读取Excel文件
df = pd.read_excel('student_loan_data.xlsx')
# 连接MySQL数据库
conn = mysql.connector.connect(
host="localhost",
user="root",
password="your_password",
database="school_system"
)
cursor = conn.cursor()
# 批量插入数据
insert_query = "INSERT INTO student_loans (student_id, name, loan_amount, status) VALUES (%s, %s, %s, %s)"
values = [(row['student_id'], row['name'], row['loan_amount'], row['status']) for index, row in df.iterrows()]
cursor.executemany(insert_query, values)
# 提交事务
conn.commit()
# 关闭连接
conn.close()
import requests
data = {
'student_id': '20210101',
'amount': 5000,
'type': 'government'
}
response = requests.post('https://api.studentloan.gov/apply', json=data)
if response.status_code == 200:
print("申请成功")
else:
print("申请失败:", response.text)
本站部分内容及素材来源于互联网，由AI智能生成，如有侵权或言论不当，联系必删！
