学生信息管理系统

public class Student {

private String id;

private String name;

private int age;

// Getters and Setters

public String getId() { return id; }

多系统账号统一管理

public void setId(String id) { this.id = id; }

public String getName() { return name; }

public void setName(String name) { this.name = name; }

public int getAge() { return age; }

public void setAge(int age) { this.age = age; }

}

public class StudentDAO {

public List getAllStudents() {

List students = new ArrayList<>();

try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "password")) {

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("SELECT * FROM student");

while (rs.next()) {

Student student = new Student();

student.setId(rs.getString("id"));

student.setName(rs.getString("name"));

student.setAge(rs.getInt("age"));

students.add(student);

}

} catch (SQLException e) {

e.printStackTrace();

}

return students;

}

}

]]>