学生信息管理系统

CREATE TABLE student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

gender ENUM('M', 'F') NOT NULL,

birthdate DATE NOT NULL,

class_id INT NOT NULL,

FOREIGN KEY (class_id) REFERENCES class(id)

);

@RestController

public class StudentController {

@Autowired

private StudentService studentService;

@GetMapping("/students")

public List getStudents() {

return studentService.getAllStudents();

}

}