基于Java实现智慧校园平台的核心功能开发

CREATE TABLE Student (

id INT PRIMARY KEY AUTO_INCREMENT,

student_id VARCHAR(20) NOT NULL UNIQUE,

name VARCHAR(50) NOT NULL,

major VARCHAR(50)

);

Class.forName("com.mysql.cj.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/school";

String user = "root";

String password = "password";

Connection conn = DriverManager.getConnection(url, user, password);

public List getStudentCourses(String studentId) {

List courses = new ArrayList<>();

String sql = "SELECT * FROM Course WHERE student_id = ?";

try (PreparedStatement stmt = conn.prepareStatement(sql)) {

stmt.setString(1, studentId);

大学排课软件

ResultSet rs = stmt.executeQuery();

while (rs.next()) {

Course course = new Course(rs.getString("course_name"), rs.getString("teacher"));

courses.add(course);

}

} catch (SQLException e) {

e.printStackTrace();

}

return courses;

}

String sql = "INSERT INTO Student (student_id, name, major) VALUES (?, ?, ?)";

try (PreparedStatement stmt = conn.prepareStatement(sql)) {

stmt.setString(1, "20230001");

stmt.setString(2, "Alice Smith");

stmt.setString(3, "Computer Science");

stmt.executeUpdate();

}