我们提供招生管理系统招投标所需全套资料,包括招生系统介绍PPT、招生管理系统产品解决方案、
招生管理系统产品技术参数,以及对应的标书参考文件,详请联系客服。
CREATE TABLE students (
student_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
gender ENUM('M', 'F'),
birth_date DATE,
major VARCHAR(100)
);
CREATE TABLE teachers (
teacher_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
department VARCHAR(100)
);
CREATE TABLE scores (
score_id INT PRIMARY KEY AUTO_INCREMENT,
student_id INT,
course_name VARCHAR(100),
score DECIMAL(5, 2),
FOREIGN KEY (student_id) REFERENCES students(student_id)
);
@RestController
@RequestMapping("/students")
public class StudentController {
@Autowired
private StudentService studentService;
@PostMapping
public ResponseEntity
studentService.addStudent(student);
return ResponseEntity.ok("Student added successfully!");
}
}