帮我用java和mysql语言写一个学生信息管理系统

好的，下面是一个简单的基于Java和MySQL的学生信息管理系统的示例代码：

首先，您需要创建一个名为“Student”的Java类来表示学生，包含学生的姓名，年龄，性别和学号等属性：

public class Student {
    private String name;
    private int age;
    private String gender;
    private String studentId;

    public Student(String name, int age, String gender, String studentId) {
        this.name = name;
        this.age = age;
        this.gender = gender;
        this.studentId = studentId;
    }

    public String getName() {
        return name;
    }

    public int getAge() {
        return age;
    }

    public String getGender() {
        return gender;
    }

    public String getStudentId() {
        return studentId;
    }
}

然后，您需要创建一个名为“StudentManager”的Java类来管理学生信息，包括添加，删除和查询学生信息等操作。该类将使用JDBC API与MySQL数据库进行交互：

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class StudentManager {
    private Connection connection;

    public StudentManager(String url, String user, String password) throws SQLException {
        connection = DriverManager.getConnection(url, user, password);
    }

    public void addStudent(Student student) throws SQLException {
        PreparedStatement statement = connection.prepareStatement(
                "INSERT INTO students (name, age, gender, student_id) VALUES (?, ?, ?, ?)");
        statement.setString(1, student.getName());
        statement.setInt(2, student.getAge());
        statement.setString(3, student.getGender());
        statement.setString(4, student.getStudentId());
        statement.executeUpdate();
    }

    public void deleteStudent(String studentId) throws SQLException {
        PreparedStatement statement = connection.prepareStatement(
                "DELETE FROM students WHERE student_id = ?");
        statement.setString(1, studentId);
        statement.executeUpdate();
    }

    public List<Student> searchStudents(String keyword) throws SQLException {
        List<Student> students = new ArrayList<>();
        PreparedStatement statement = connection.prepareStatement(
                "SELECT * FROM students WHERE name LIKE ? OR student_id LIKE ?");
        statement.setString(1, "%" + keyword + "%");
        statement.setString(2, "%" + keyword + "%");
        ResultSet resultSet = statement.executeQuery();
        while (resultSet.next()) {
            String name = resultSet.getString("name");
            int age = resultSet.getInt("age");
            String gender = resultSet.getString("gender");
            String studentId = resultSet.getString("student_id");
            Student student = new Student(name, age, gender, studentId);
            students.add(student);
        }
        return students;
    }

    public void close() throws SQLException {
        connection.close();
    }
}

最后，您可以编写一个简单的Java Swing界面来使用学生管理器类，实现学生信息的添加，删除和查询等操作：

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.List;

public class StudentManagementUI {
    private StudentManager studentManager;
    private JFrame frame;
    private JTextField nameField;
    private JTextField ageField;
    private JTextField genderField;
    private JTextField idField;
    private JTextArea resultArea;

    public StudentManagementUI(StudentManager studentManager) {
        this.studentManager = studentManager;
        frame = new JFrame("学生信息管理系统");
        frame.setSize(600, 400);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        JPanel panel = new JPanel();
        panel.setLayout(new GridLayout(5, 2));

        panel.add(new JLabel("姓名:"));
        nameField = new JTextField();
        panel.add(nameField);

        panel.add(new JLabel("年龄:"));
        ageField = new JTextField();
        panel.add(ageField);

        panel.add(new JLabel("性别:"));
        genderField = new JTextField();
        panel.add(genderField);

        panel.add(new JLabel("学号:"));
        idField = new JTextField();
        panel.add(idField);

        JButton addButton = new JButton("添加");
        addButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String name = nameField.getText();
                int age = Integer.parseInt(ageField.getText());
                String gender = genderField.getText();
                String id = idField.getText();
                Student student = new Student(name, age, gender, id);
                try {
                    studentManager.addStudent(student);
                    resultArea.setText("添加成功");
                } catch (SQLException ex) {
                    resultArea.setText("添加失败: " + ex.getMessage());
                }
            }
        });
        panel.add(addButton);

        JButton deleteButton = new JButton("删除");
        deleteButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String id = idField.getText();
                try {
                    studentManager.deleteStudent(id);
                    resultArea.setText("删除成功");
                } catch (SQLException ex) {
                    resultArea.setText("删除失败: " + ex.getMessage());
                }
            }
        });
        panel.add(deleteButton);

        JButton searchButton = new JButton("查询");
        searchButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String keyword = idField.getText();
                try {
                    List<Student> students = studentManager.searchStudents(keyword);
                    StringBuilder builder = new StringBuilder();
                    for (Student student : students) {
                        builder.append("姓名: ").append(student.getName())
                                .append(", 年龄: ").append(student.getAge())
                                .append(", 性别: ").append(student.getGender())
                                .append(", 学号: ").append(student.getStudentId())
                                .append("\n");
                    }
                    resultArea.setText(builder.toString());
                } catch (SQLException ex) {
                    resultArea.setText("查询失败: " + ex.getMessage());
                }
            }
        });
        panel.add(searchButton);

        resultArea = new JTextArea();
        JScrollPane scrollPane = new JScrollPane(resultArea);
        frame.add(panel, BorderLayout.NORTH);
        frame.add(scrollPane, BorderLayout.CENTER);
        frame.setVisible(true);
    }

    public static void main(String[] args) throws SQLException {
        String url = "jdbc:mysql://localhost:3306/test?useSSL=false";
        String user = "root";
        String password = "password";
        StudentManager studentManager = new StudentManager(url, user, password);
        new StudentManagementUI(studentManager);
    }
}

请注意，这只是一个简单的示例代码，您可以根据自己的需求进行修改和扩展。