java课后服务的信息管理功能

一、系统功能概述 java源码 java毕业设计

课后服务信息管理系统主要实现以下功能：慕代码 www.mudaima.com

学生信息管理
课程信息管理
教师信息管理
排课管理
考勤管理
成绩管理
家长端查询功能

二、核心功能实现代码示例

1. 实体类设计

学生实体类(Student.java)

public class Student {
    private Integer id;
    private String name;
    private String gender;
    private Integer age;
    private String parentName;
    private String parentPhone;
    private String className;
    // getters and setters
}

课程实体类(Course.java)

public class Course {
    private Integer id;
    private String courseName;
    private String teacherId;
    private String teacherName;
    private String classroom;
    private String weekDay;
    private String timeSlot;
    private Integer maxStudents;
    // getters and setters
}

2. DAO层实现

学生DAO接口(StudentDao.java)

public interface StudentDao {
    int addStudent(Student student);
    int deleteStudent(Integer id);
    int updateStudent(Student student);
    Student getStudentById(Integer id);
    List<Student> getAllStudents();
    List<Student> getStudentsByClass(String className);
}

使用JDBC实现学生DAO(StudentDaoImpl.java)

public class StudentDaoImpl implements StudentDao {
    private JdbcTemplate jdbcTemplate;
    
    @Override
    public int addStudent(Student student) {
        String sql = "INSERT INTO student(name, gender, age, parent_name, parent_phone, class_name) VALUES(?,?,?,?,?,?)";
        return jdbcTemplate.update(sql, student.getName(), student.getGender(), 
                student.getAge(), student.getParentName(), student.getParentPhone(), student.getClassName());
    }
    // 其他方法实现...
}

3. 服务层实现

课后服务管理服务(AfterSchoolService.java)

@Service
public class AfterSchoolService {
    @Autowired
    private StudentDao studentDao;
    @Autowired
    private CourseDao courseDao;
    @Autowired
    private AttendanceDao attendanceDao;
    
    // 学生管理
    public boolean registerStudent(Student student) {
        return studentDao.addStudent(student) > 0;
    }
    
    // 课程管理
    public List<Course> getAvailableCourses() {
        return courseDao.getAvailableCourses();
    }
    
    // 考勤管理
    public boolean recordAttendance(Integer studentId, Integer courseId, Date date, String status) {
        Attendance attendance = new Attendance();
        attendance.setStudentId(studentId);
        attendance.setCourseId(courseId);
        attendance.setDate(date);
        attendance.setStatus(status);
        return attendanceDao.addAttendance(attendance) > 0;
    }
}

4. 控制器层实现

学生控制器(StudentController.java)

@RestController
@RequestMapping("/api/student")
public class StudentController {
    @Autowired
    private AfterSchoolService afterSchoolService;
    
    @PostMapping("/register")
    public ResponseEntity<String> registerStudent(@RequestBody Student student) {
        if(afterSchoolService.registerStudent(student)) {
            return ResponseEntity.ok("学生注册成功");
        }
        return ResponseEntity.badRequest().body("学生注册失败");
    }
    
    @GetMapping("/list")
    public ResponseEntity<List<Student>> getAllStudents() {
        return ResponseEntity.ok(afterSchoolService.getAllStudents());
    }
}

三、数据库设计示例

-- 学生表
CREATE TABLE student (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    gender CHAR(1),
    age INT,
    parent_name VARCHAR(50),
    parent_phone VARCHAR(20),
    class_name VARCHAR(50)
);

-- 课程表
CREATE TABLE course (
    id INT PRIMARY KEY AUTO_INCREMENT,
    course_name VARCHAR(100) NOT NULL,
    teacher_id INT,
    teacher_name VARCHAR(50),
    classroom VARCHAR(50),
    week_day VARCHAR(10),
    time_slot VARCHAR(50),
    max_students INT
);

-- 选课表
CREATE TABLE student_course (
    student_id INT,
    course_id INT,
    PRIMARY KEY (student_id, course_id),
    FOREIGN KEY (student_id) REFERENCES student(id),
    FOREIGN KEY (course_id) REFERENCES course(id)
);

-- 考勤表
CREATE TABLE attendance (
    id INT PRIMARY KEY AUTO_INCREMENT,
    student_id INT,
    course_id INT,
    date DATE,
    status VARCHAR(10), -- present/absent/late
    FOREIGN KEY (student_id) REFERENCES student(id),
    FOREIGN KEY (course_id) REFERENCES course(id)
);

四、前端页面示例(使用Thymeleaf)

学生列表页面(student-list.html)

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <title>学生列表</title>
</head>
<body>
    <h1>课后服务学生列表</h1>
    <table border="1">
        <tr>
            <th>ID</th>
            <th>姓名</th>
            <th>性别</th>
            <th>年龄</th>
            <th>班级</th>
            <th>家长姓名</th>
            <th>家长电话</th>
        </tr>
        <tr th:each="student : ${students}">
            <td th:text="${student.id}"></td>
            <td th:text="${student.name}"></td>
            <td th:text="${student.gender}"></td>
            <td th:text="${student.age}"></td>
            <td th:text="${student.className}"></td>
            <td th:text="${student.parentName}"></td>
            <td th:text="${student.parentPhone}"></td>
        </tr>
    </table>
</body>
</html>