学生信息管理系统

CREATE TABLE Student (

StudentID INT PRIMARY KEY,

Name VARCHAR(50),

Major VARCHAR(50),

Email VARCHAR(100)

);

CREATE TABLE Course (

CourseID INT PRIMARY KEY,

CourseName VARCHAR(100),

Credits INT

);

CREATE TABLE Score (

StudentID INT,

CourseID INT,

Score DECIMAL(5,2),

FOREIGN KEY (StudentID) REFERENCES Student(StudentID),

FOREIGN KEY (CourseID) REFERENCES Course(CourseID)

);

@RestController

public class StudentController {

@Autowired

private StudentService studentService;

@GetMapping("/students/{studentId}")

public ResponseEntity getStudent(@PathVariable("studentId") int studentId) {

Student student = studentService.getStudentById(studentId);

if (student == null) {

return ResponseEntity.notFound().build();

} else {

return ResponseEntity.ok(student);

}

}

}