学生管理:包括新增、修改、删除、查询学生信息等操作;代码
时间: 2023-07-10 09:33:19 浏览: 41
以下是Java语言实现学生管理的代码示例,包括新增、修改、删除、查询学生信息等操作:
```
import java.sql.*;
public class StudentManager {
private Connection conn;
public StudentManager() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "123456");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void addStudent(String name, int age, String gender, String major) {
String sql = "INSERT INTO students (name, age, gender, major) VALUES (?, ?, ?, ?)";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setInt(2, age);
pstmt.setString(3, gender);
pstmt.setString(4, major);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void updateStudent(int id, String name, int age, String gender, String major) {
String sql = "UPDATE students SET name = ?, age = ?, gender = ?, major = ? WHERE id = ?";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setInt(2, age);
pstmt.setString(3, gender);
pstmt.setString(4, major);
pstmt.setInt(5, id);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void deleteStudent(int id) {
String sql = "DELETE FROM students WHERE id = ?";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void showAllStudents() {
String sql = "SELECT * FROM students";
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String gender = rs.getString("gender");
String major = rs.getString("major");
System.out.println(id + "\t" + name + "\t" + age + "\t" + gender + "\t" + major);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
StudentManager manager = new StudentManager();
manager.addStudent("张三", 20, "男", "计算机科学");
manager.addStudent("李四", 21, "女", "软件工程");
manager.addStudent("王五", 19, "男", "信息安全");
manager.addStudent("赵六", 22, "女", "电子商务");
manager.showAllStudents();
manager.updateStudent(1, "张三丰", 21, "男", "计算机科学");
manager.deleteStudent(4);
manager.showAllStudents();
}
}
```
这个示例演示了如何使用Java语言和MySQL数据库实现学生管理的功能。在这个示例中,我们使用了JDBC连接MySQL数据库,并实现了添加学生、修改学生、删除学生和展示所有学生信息的功能。这个示例可以作为学生管理系统的基础框架。