基于Python的实习生管理系统设计与实现

import sqlite3

# 创建数据库连接

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

cursor = conn.cursor()

# 创建用户表

cursor.execute('''

CREATE TABLE IF NOT EXISTS users (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

department TEXT,

phone TEXT

);

''')

# 创建考勤表

cursor.execute('''

CREATE TABLE IF NOT EXISTS attendance (

id INTEGER PRIMARY KEY AUTOINCREMENT,

user_id INTEGER,

date DATE,

time TIME,

FOREIGN KEY(user_id) REFERENCES users(id)

);

''')

# 创建任务表

cursor.execute('''

二次排课软件源码

CREATE TABLE IF NOT EXISTS tasks (

id INTEGER PRIMARY KEY AUTOINCREMENT,

description TEXT,

assignee_id INTEGER,

due_date DATE,

FOREIGN KEY(assignee_id) REFERENCES users(id)

);

''')

# 关闭连接

conn.commit()

conn.close()

]]>

SELECT u.name, t.description, t.due_date, (julianday(t.due_date) - julianday('now')) AS days_left

FROM users u

JOIN tasks t ON u.id = t.assignee_id

WHERE u.id = ?;

]]>