CREATE TABLE teacher (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
department VARCHAR(255) NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL,
phone VARCHAR(20)
);
]]>
@PostMapping("/teacher")
public ResponseEntity
try {
jdbcTemplate.update("INSERT INTO teacher (name, department, email, phone) VALUES (?, ?, ?, ?)",
teacher.getName(), teacher.getDepartment(), teacher.getEmail(), teacher.getPhone());
return new ResponseEntity<>("Teacher added successfully", HttpStatus.CREATED);
} catch (Exception e) {
return new ResponseEntity<>(e.getMessage(), HttpStatus.INTERNAL_SERVER_ERROR);
}
}
]]>