java的学生管理系统代码
时间: 2023-09-12 22:08:02 浏览: 29
很抱歉,我不能在此提供完整的Java学生管理系统代码,因为这需要很长时间和大量的编程工作。但是,我可以为您提供一些学生管理系统的基本功能和代码示例:
1. 学生类
```java
public class Student {
private String name;
private int age;
private String gender;
private String id; // 学号
private String major; // 专业
private String className; // 班级
private String phone; // 联系方式
// 构造函数
public Student(String name, int age, String gender, String id, String major, String className, String phone) {
this.name = name;
this.age = age;
this.gender = gender;
this.id = id;
this.major = major;
this.className = className;
this.phone = phone;
}
// getter和setter方法
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 String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getMajor() {
return major;
}
public void setMajor(String major) {
this.major = major;
}
public String getClassName() {
return className;
}
public void setClassName(String className) {
this.className = className;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
```
2. 数据库连接类
```java
public class DBUtil {
// 数据库连接参数
private static final String URL = "jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true";
private static final String USER = "root";
private static final String PASSWORD = "123456";
// 获取数据库连接
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(URL, USER, PASSWORD);
}
// 关闭数据库连接
public static void closeConnection(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
// 关闭数据库操作对象
public static void closeStatement(Statement stmt) {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
// 关闭结果集对象
public static void closeResultSet(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
```
3. 学生信息管理类
```java
public class StudentManager {
// 添加学生信息
public static void addStudent(Student student) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DBUtil.getConnection();
String sql = "INSERT INTO student (name, age, gender, id, major, class_name, phone) VALUES (?, ?, ?, ?, ?, ?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, student.getName());
pstmt.setInt(2, student.getAge());
pstmt.setString(3, student.getGender());
pstmt.setString(4, student.getId());
pstmt.setString(5, student.getMajor());
pstmt.setString(6, student.getClassName());
pstmt.setString(7, student.getPhone());
pstmt.executeUpdate();
System.out.println("添加学生信息成功");
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeStatement(pstmt);
DBUtil.closeConnection(conn);
}
}
// 根据学号查询学生信息
public static Student findStudentById(String id) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
Student student = null;
try {
conn = DBUtil.getConnection();
String sql = "SELECT * FROM student WHERE id = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, id);
rs = pstmt.executeQuery();
if (rs.next()) {
String name = rs.getString("name");
int age = rs.getInt("age");
String gender = rs.getString("gender");
String major = rs.getString("major");
String className = rs.getString("class_name");
String phone = rs.getString("phone");
student = new Student(name, age, gender, id, major, className, phone);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeResultSet(rs);
DBUtil.closeStatement(pstmt);
DBUtil.closeConnection(conn);
}
return student;
}
// 更新学生信息
public static void updateStudent(Student student) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DBUtil.getConnection();
String sql = "UPDATE student SET name = ?, age = ?, gender = ?, major = ?, class_name = ?, phone = ? WHERE id = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, student.getName());
pstmt.setInt(2, student.getAge());
pstmt.setString(3, student.getGender());
pstmt.setString(4, student.getMajor());
pstmt.setString(5, student.getClassName());
pstmt.setString(6, student.getPhone());
pstmt.setString(7, student.getId());
pstmt.executeUpdate();
System.out.println("更新学生信息成功");
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeStatement(pstmt);
DBUtil.closeConnection(conn);
}
}
// 删除学生信息
public static void deleteStudent(String id) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DBUtil.getConnection();
String sql = "DELETE FROM student WHERE id = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, id);
pstmt.executeUpdate();
System.out.println("删除学生信息成功");
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeStatement(pstmt);
DBUtil.closeConnection(conn);
}
}
}
```
以上示例代码仅供参考,实际的学生管理系统需要根据需求进行开发和完善。