### 基于Python和MySQL的毕业生就业管理系统代码示例 以下是一个基于Python和MySQL实现的毕业生就业管理系统的完整代码示例，涵盖了系统的主要功能模块，包括用户登录、招聘信息管理、应聘信息管理和就业意向管理等。 #### 系统架构概述 该系统采用B/S结构，使用Python作为后端开发语言，结合Django框架进行开发[^1]。数据库选用MySQL以存储系统中的各类数据，如用户信息、招聘岗位信息、应聘记录等[^1]。 #### 数据库设计 以下是系统中涉及的主要表结构： 1. **用户表 (users)**： - id (主键) - username (用户名) - password (密码) - role (角色：学生、企业、管理员) 2. **招聘信息表 (job_listings)**： - id (主键) - company_name (公司名称) - position_title (职位名称) - description (职位描述) - requirements (职位要求) 3. **应聘信息表 (applications)**： - id (主键) - user_id (外键，关联用户表) - job_id (外键，关联招聘信息表) - application_date (申请日期) - status (申请状态) 4. **就业意向表 (employment_intentions)**： - id (主键) - user_id (外键，关联用户表) - intention (就业意向描述) #### 后端代码示例 ##### Django模型定义 ```python from django.db import models class User(models.Model): ROLE_CHOICES = [ ('student', 'Student'), ('company', 'Company'), ('admin', 'Admin') ] username = models.CharField(max_length=50, unique=True) password = models.CharField(max_length=50) role = models.CharField(max_length=10, choices=ROLE_CHOICES) class JobListing(models.Model): company_name = models.CharField(max_length=100) position_title = models.CharField(max_length=100) description = models.TextField() requirements = models.TextField() class Application(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) job = models.ForeignKey(JobListing, on_delete=models.CASCADE) application_date = models.DateField(auto_now_add=True) status = models.CharField(max_length=20, default='Pending') class EmploymentIntention(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) intention = models.TextField() ``` ##### 登录接口 ```python from django.http import JsonResponse from .models import User def login(request): if request.method == 'POST': username = request.POST.get('username') password = request.POST.get('password') try: user = User.objects.get(username=username, password=password) return JsonResponse({'success': True, 'role': user.role}) except User.DoesNotExist: return JsonResponse({'success': False, 'message': 'Invalid credentials'}) ``` ##### 招聘信息发布接口 ```python from django.http import JsonResponse from .models import JobListing def post_job(request): if request.method == 'POST': company_name = request.POST.get('company_name') position_title = request.POST.get('position_title') description = request.POST.get('description') requirements = request.POST.get('requirements') job = JobListing.objects.create( company_name=company_name, position_title=position_title, description=description, requirements=requirements ) return JsonResponse({'success': True, 'job_id': job.id}) ``` #### 前端代码示例 ##### 登录页面 ```html <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>登录</title> </head> <body> <h2>登录</h2> <form id="loginForm"> <input type="text" id="username" placeholder="用户名" required> <input type="password" id="password" placeholder="密码" required> <button type="submit">登录</button> </form> <script> document.getElementById('loginForm').addEventListener('submit', function(event) { event.preventDefault(); const username = document.getElementById('username').value; const password = document.getElementById('password').value; fetch('/api/login/', { method: 'POST', headers: { 'Content-Type': 'application/x-www-form-urlencoded' }, body: `username=${encodeURIComponent(username)}&password=${encodeURIComponent(password)}` }) .then(response => response.json()) .then(data => { if (data.success) { alert(`登录成功，角色为：${data.role}`); } else { alert(data.message); } }); }); </script> </body> </html> ``` #### 系统部署 系统部署时需确保MySQL数据库已正确配置，并通过Django的`migrate`命令完成数据库表的创建[^3]。同时，需配置Web服务器（如Nginx）与Django应用的连接，以支持高并发访问需求[^3]。 #### 数据库初始化脚本 以下为MySQL数据库初始化脚本示例： ```sql CREATE DATABASE employment_system; USE employment_system; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, password VARCHAR(50) NOT NULL, role ENUM('student', 'company', 'admin') NOT NULL ); CREATE TABLE job_listings ( id INT AUTO_INCREMENT PRIMARY KEY, company_name VARCHAR(100) NOT NULL, position_title VARCHAR(100) NOT NULL, description TEXT NOT NULL, requirements TEXT NOT NULL ); CREATE TABLE applications ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, job_id INT NOT NULL, application_date DATE NOT NULL, status VARCHAR(20) DEFAULT 'Pending', FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (job_id) REFERENCES job_listings(id) ); CREATE TABLE employment_intentions ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, intention TEXT NOT NULL, FOREIGN KEY (user_id) REFERENCES users(id) ); ```