学生信息管理系统

<?php

// 学工系统数据处理示例代码

class StudentWorkSystem {

private $dbHost = "localhost";

private $dbUser = "root";

private $dbPass = "password";

private $dbName = "student_work_system";

public function __construct() {

$this->connectDB();

}

private function connectDB() {

$conn = new mysqli($this->dbHost, $this->dbUser, $this->dbPass, $this->dbName);

if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}

return $conn;

}

public function addStudent($name, $id, $department) {

$conn = $this->connectDB();

$sql = "INSERT INTO students (name, id, department) VALUES ('$name', '$id', '$department')";

if ($conn->query($sql) === TRUE) {

echo "新记录插入成功";

} else {

echo "Error: " . $sql . "
" . $conn->error;

}

$conn->close();

}

public function getStudents() {

$conn = $this->connectDB();

$sql = "SELECT * FROM students";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {

echo "姓名: " . $row["name"]. " - ID: " . $row["id"]. " - 系别: " . $row["department"]. "
";

}

} else {

echo "0 结果";

}

$conn->close();

}

}

// 示例调用

$sWS = new StudentWorkSystem();

$sWS->addStudent('张三', '123456', '计算机科学');

$sWS->getStudents();

?>