打造高效校园服务：师生一站式网上办事大厅与大模型训练

# 导入必要的库

import sqlite3

# 连接到SQLite数据库（或者你可以换成MySQL）

conn = sqlite3.connect('school_db.sqlite')

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS requests (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

type TEXT NOT NULL,

status TEXT DEFAULT 'pending'

)

''')

# 插入一条请求记录

cursor.execute("INSERT INTO requests (name, type) VALUES (?, ?)", ('张三', '请假'))

conn.commit()

# 查询所有待处理的请求

cursor.execute("SELECT * FROM requests WHERE status='pending'")

pending_requests = cursor.fetchall()

print("Pending Requests:", pending_requests)

# 关闭连接

conn.close()

]]>

import torch

import torch.nn as nn

from sklearn.model_selection import train_test_split

# 模拟一些数据

data = [

[1, 10], [2, 20], [3, 30], [4, 40], [5, 50]

] # 第一列是月份，第二列是请假人数

labels = [15, 25, 35, 45, 55]

X_train, X_test, y_train, y_test = train_test_split(data, labels, test_size=0.2)

class SimpleModel(nn.Module):

def __init__(self):

super(SimpleModel, self).__init__()

self.fc = nn.Linear(2, 1)

def forward(self, x):

return self.fc(x)

统一消息

model = SimpleModel()

criterion = nn.MSELoss()

optimizer = torch.optim.Adam(model.parameters(), lr=0.01)

for epoch in range(100):

inputs = torch.tensor(X_train).float()

targets = torch.tensor(y_train).float()

outputs = model(inputs)

loss = criterion(outputs, targets)

optimizer.zero_grad()

loss.backward()

optimizer.step()

if (epoch+1) % 10 == 0:

print(f'Epoch [{epoch+1}/100], Loss: {loss.item():.4f}')

# 测试模型

with torch.no_grad():

test_inputs = torch.tensor(X_test).float()

predictions = model(test_inputs)

print("Predictions:", predictions)

]]>