Java请假系统表单设计与数据存储解析

@PostMapping("/leave/submit")
public String submitLeave(@RequestParam String name,
                          @RequestParam String studentId,
                          @RequestParam String className,
                          @RequestParam String leaveType,
                          @RequestParam LocalDate startDate,
                          @RequestParam LocalDate endDate,
                          @RequestParam String reason,
                          @RequestParam String contact) {
    LeaveRecord record = new LeaveRecord();
    record.setName(name);
    record.setStudentId(studentId);
    // ...设置其他字段
    leaveService.save(record);
    return "success";
}

public class LeaveRecord {
    private Long id;
    private String name;
    private String studentId;
    private String className;
    private String leaveType;
    private LocalDate startDate;
    private LocalDate endDate;
    private String reason;
    private String contact;
    private LocalDateTime applyTime; // 提交时间
    // 构造方法、getter/setter省略
}

CREATE TABLE leave_record (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    student_id VARCHAR(20) UNIQUE NOT NULL,
    class_name VARCHAR(50),
    leave_type VARCHAR(10),
    start_date DATE,
    end_date DATE,
    reason TEXT,
    contact VARCHAR(15),
    apply_time DATETIME DEFAULT CURRENT_TIMESTAMP
);

public interface LeaveRecordRepository extends JpaRepository {
}