场景描述：某高校希望为其学工管理系统添加学生请假功能，并计划与一家专业软件开发公司（简称“厂家”）合作完成此项目。以下是双方技术人员之间的对话记录。
CREATE TABLE LeaveApplication (
id INT AUTO_INCREMENT PRIMARY KEY,
student_name VARCHAR(50) NOT NULL,
class_name VARCHAR(20),
contact_info VARCHAR(30),
reason TEXT,
status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$studentName = $_POST['student_name'];
$className = $_POST['class_name'];
$contactInfo = $_POST['contact_info'];
$reason = $_POST['reason'];
// 连接数据库
$conn = new mysqli("localhost", "root", "", "school_system");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO LeaveApplication (student_name, class_name, contact_info, reason)
VALUES ('$studentName', '$className', '$contactInfo', '$reason')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}
$conn->close();
}
?>
通过这次合作，不仅增强了学工管理系统的实用性，还展示了跨部门协作的重要性。
]]>