streamlit
opencv-python
dlib
pymysql
pandas
plotly
pillow
streamlit-option-menu
numpy

# 安装依赖
pip install -r requirements.txt

-- 创建数据库
CREATE DATABASE face CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 使用数据库
USE face;

-- 创建用户表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    role ENUM('teacher', 'student') NOT NULL,
    name VARCHAR(100) NOT NULL,
    face_feature BLOB,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- 创建考勤记录表
CREATE TABLE attendance (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    attendance_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status ENUM('present', 'absent', 'late') DEFAULT 'present',
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- 插入默认管理员账户
INSERT INTO users (username, password, role, name) VALUES 
('admin', 'admin123', 'teacher', '系统管理员');

streamlit run app.py

FaceSign/
├── app.py                 # 主应用程序
├── dock_in.py            # 考勤签到模块
├── get_face.py           # 人脸录入模块
├── stu_statistics.py     # 学生统计模块
├── tea_statistics.py     # 教师统计模块
├── README.md             # 项目说明文档
├── requirements.txt      # 依赖包列表
├── data_dlib/           # Dlib模型文件目录
│   ├── dlib_face_recognition_resnet_model_v1.dat
│   └── shape_predictor_68_face_landmarks.dat
├── imgs/                # 用户头像存储目录
└── config/              # 配置文件目录(建议新增)

DatabaseConnection('localhost', 3306, 'root', 'your_password', 'face')