基于实习就业管理系统的浙江高校实践

CREATE TABLE Student (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50),

major VARCHAR(50),

resume TEXT

);

CREATE TABLE Company (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50),

industry VARCHAR(50)

);

CREATE TABLE Job (

id INT PRIMARY KEY AUTO_INCREMENT,

company_id INT,

title VARCHAR(50),

description TEXT,

FOREIGN KEY (company_id) REFERENCES Company(id)

);

public List matchJobs(List students, List jobs) {

List matched = new ArrayList<>();

for (Student student : students) {

for (Job job : jobs) {

if (student.getMajor().equals(job.getRequiredMajor())) {

matched.add(student);

break;

}

}

}

return matched;

}