// 课程类

public class Course {

private String courseId;

private String courseName;

private String teacherId;

private String classroomId;

private String startTime;

private String endTime;

// 构造函数、getter和setter...

}

// 教师类

public class Teacher {

private String teacherId;

private String name;

private String department;

// 构造函数、getter和setter...

}

// 教室类

public class Classroom {

private String classroomId;

private String location;

private int capacity;

// 构造函数、getter和setter...

}

-- 课程表

CREATE TABLE courses (

course_id VARCHAR(10) PRIMARY KEY,

course_name VARCHAR(50),

teacher_id VARCHAR(10),

classroom_id VARCHAR(10),

start_time TIME,

end_time TIME,

FOREIGN KEY (teacher_id) REFERENCES teachers(teacher_id),

FOREIGN KEY (classroom_id) REFERENCES classrooms(classroom_id)

);

-- 教师表

CREATE TABLE teachers (

teacher_id VARCHAR(10) PRIMARY KEY,

name VARCHAR(50),

department VARCHAR(50)

);

-- 教室表

CREATE TABLE classrooms (

classroom_id VARCHAR(10) PRIMARY KEY,

location VARCHAR(100),

capacity INT

);

public boolean isConflict(Course newCourse, List existingCourses) {

for (Course existing : existingCourses) {

if (newCourse.getClassroomId().equals(existing.getClassroomId())) {

// 检查时间是否重叠

if (isTimeOverlap(newCourse.getStartTime(), newCourse.getEndTime(),

existing.getStartTime(), existing.getEndTime())) {

return true;

}

}

}

return false;

}

private boolean isTimeOverlap(String start1, String end1, String start2, String end2) {

// 将时间字符串转换为时间对象进行比较

// 这里简化处理，实际应使用DateTime API

return !end1.equals(start2) && !start1.equals(end2);

}