基于在线实习管理系统的科学化设计与实现

// 学生信息插入操作

public boolean addStudent(String studentID, String name, String major) {

String query = "INSERT INTO students (student_id, name, major) VALUES (?, ?, ?)";

try (PreparedStatement pstmt = connection.prepareStatement(query)) {

pstmt.setString(1, studentID);

pstmt.setString(2, name);

pstmt.setString(3, major);

return pstmt.executeUpdate() > 0;

} catch (SQLException e) {

e.printStackTrace();

return false;

}

}

// 查询所有学生的函数

public List getAllStudents() {

List students = new ArrayList<>();

String query = "SELECT * FROM students";

try (Statement stmt = connection.createStatement();

ResultSet rs = stmt.executeQuery(query)) {

while (rs.next()) {

Student student = new Student(

rs.getString("student_id"),

rs.getString("name"),

rs.getString("major")

);

students.add(student);

}

} catch (SQLException e) {

e.printStackTrace();

}

return students;

}

数据共享平台

]]>