基于教材管理平台的学生教材分配与管理系统的实现

@RestController

public class StudentController {

@Autowired

private StudentService studentService;

@GetMapping("/students/{id}/textbooks")

public List getStudentTextbooks(@PathVariable Long id) {

return studentService.getStudentTextbooks(id);

}

@PostMapping("/students/{id}/assign-textbook")

public ResponseEntity assignTextbook(@PathVariable Long id, @RequestBody Textbook textbook) {

if (studentService.assignTextbook(id, textbook)) {

return ResponseEntity.ok("教材分配成功");

} else {

return ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).body("教材分配失败");

}

}

}

]]>

CREATE TABLE students (

id BIGINT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

grade INT NOT NULL

);

CREATE TABLE textbooks (

id BIGINT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(100) NOT NULL,

author VARCHAR(50) NOT NULL

oauth2单点登录

);

CREATE TABLE student_textbooks (

student_id BIGINT NOT NULL,

textbook_id BIGINT NOT NULL,

FOREIGN KEY (student_id) REFERENCES students(id),

FOREIGN KEY (textbook_id) REFERENCES textbooks(id)

);

]]>