1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103

public class ClassMate {
    private String name;
    private String sex;
    private String address;
    private String homephone;
    private String city;
    private String company;
    private String duty;
    private String salary;
    private String contact;
    private String homeaddress;

    public ClassMate(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }

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

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getHomephone() {
        return homephone;
    }

    public void setHomephone(String homephone) {
        this.homephone = homephone;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getCompany() {
        return company;
    }

    public void setCompany(String company) {
        this.company = company;
    }

    public String getDuty() {
        return duty;
    }

    public void setDuty(String duty) {
        this.duty = duty;
    }

    public String getSalary() {
        return salary;
    }

    public void setSalary(String salary) {
        this.salary = salary;
    }

    public String getContact() {
        return contact;
    }

    public void setContact(String contact) {
        this.contact = contact;
    }

    public String getHomeaddress() {
        return homeaddress;
    }

    public void setHomeaddress(String homeaddress) {
        this.homeaddress = homeaddress;
    }

    @Override
    public String toString() {
        return "ClassMate [name=" + name + ", sex=" + sex + ", address=" + address + ", homephone=" + homephone
                + ", city=" + city + ", company=" + company + ", duty=" + duty + ", salary=" + salary + ", contact="
                + contact + ", homeaddress=" + homeaddress + "]";
    }
}

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108

public ClassMateInfo() {
        this.setLayout(new java.awt.GridBagLayout());

        // 创建 DefaultComboBoxModel
        DefaultComboBoxModel<String> model = new DefaultComboBoxModel<>();

        // 创建标题
        JLabel titleLabel = new JLabel("同学基本信息");
        titleLabel.setFont(new Font("微软雅黑", Font.BOLD, 20)); // 设置字体和大小
        titleLabel.setHorizontalAlignment(SwingConstants.CENTER);

        JLabel[] labels = {
                new JLabel("姓名"), new JLabel("性别"), new JLabel("居住地址"),
                new JLabel("家庭地址"), new JLabel("所在城市"),
                new JLabel("所在公司"), new JLabel("职务"), new JLabel("薪水")
        };

        // 创建 JTextField 和 JComboBox
        nameinput = new JComboBox<String>(model);
        sexyinput = new JTextField(15);
        addressinput = new JTextField(15);
        homeaddressinput = new JTextField(15);
        cityinput = new JTextField(15);
        companyinput = new JTextField(15);
        dutyinput = new JTextField(15);
        salaryinput = new JTextField(15);
        JTextField[] textFields = { sexyinput, addressinput, homeaddressinput, cityinput, companyinput, dutyinput,
                salaryinput };

        Dimension commonSize = new Dimension(150, nameinput.getPreferredSize().height);

        // 设置所有 JTextField 和 JComboBox 的宽度一致
        for (JTextField textField : textFields) {
            textField.setPreferredSize(commonSize);
        }
        nameinput.setPreferredSize(commonSize);

        // 添加组件到面板
        GridBagConstraints gbc = new GridBagConstraints();
        gbc.insets = new Insets(5, 5, 5, 5); // 设置间距

        // 添加标题
        gbc.gridx = 0;
        gbc.gridy = 0;
        gbc.gridwidth = 4; // 跨 4 列
        gbc.anchor = GridBagConstraints.CENTER; // 居中对齐
        gbc.insets = new Insets(20, 5, 15, 5); // 上方间距增加，向上移动
        add(titleLabel, gbc);

        // 添加左侧标签和控件
        for (int i = 0; i < labels.length; i++) {
            gbc.gridwidth = 1; // 单独占 1 列
            gbc.insets = new Insets(5, 5, 5, 5); // 恢复默认间距

            // 添加 JLabel (右对齐)
            gbc.gridx = (i < 4) ? 0 : 2; // 左列或右列
            gbc.gridy = (i < 4) ? i + 1 : i - 3;
            gbc.anchor = GridBagConstraints.EAST; // 右对齐
            add(labels[i], gbc);

            // 添加输入控件 (左对齐)
            gbc.gridx = (i < 4) ? 1 : 3; // 左列或右列对应的控件
            gbc.anchor = GridBagConstraints.WEST; // 左对齐
            if (i == 0) { // 第一行为 JComboBox (姓名)
                add(nameinput, gbc);
            } else {
                add(textFields[i - 1], gbc);
            }
        }

        // 从数据库加载数据并填充到控件
        Vector<ClassMate> classMateData = classMateStore.getClassMate(conn, SQL_QUERY);
        for (ClassMate mate : classMateData) {
            nameinput.addItem(mate.getName()); // 填充姓名到 JComboBox
        }

        // 添加 JComboBox 选择事件监听器
        nameinput.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String selectedName = (String) nameinput.getSelectedItem();
                if (selectedName != null) {
                    for (ClassMate mate : classMateData) {
                        if (mate.getName().equals(selectedName)) {
                            sexyinput.setText(mate.getSex());
                            addressinput.setText(mate.getAddress());
                            homeaddressinput.setText(mate.getHomeaddress());
                            cityinput.setText(mate.getCity());
                            companyinput.setText(mate.getCompany());
                            dutyinput.setText(mate.getDuty());
                            salaryinput.setText(String.valueOf(mate.getSalary()));
                            break;
                        }
                    }
                }
            }
        });
    }

    public static void main(String[] args) {
        JFrame frame = new JFrame("同学基本信息");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(600, 400);
        frame.setLocationRelativeTo(null);
        frame.add(new ClassMateInfo());
        frame.setVisible(true);
    }
}

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105

public class ClassMateCommunication extends JPanel {

    private static final long serialVersionUID = 4L;
    private static final String SQL_QUERY = "SELECT * FROM classmate";
    private ClassMateStore classMateStore = new ClassMateStore();
    private Connection conn = classMateStore.getConnection();
    private JComboBox<String> comboBox;
    private JTextField homephoneField;
    private JTextField contactField;

    public ClassMateCommunication() {
        this.setLayout(new java.awt.GridBagLayout());

        // 创建组件
        JLabel nameLabel = new JLabel("姓名：");
        comboBox = new JComboBox<>();
        JLabel homephoneLabel = new JLabel("家庭电话号码：");
        homephoneField = new JTextField(15);
        JLabel contactLabel = new JLabel("个人电话号码：");
        contactField = new JTextField(15);
        JButton closeButton = new JButton("关闭此窗口");

        // 加载数据
        Vector<ClassMate> classMateData = loadClassMateData();

        // 添加组件
        addComponent(nameLabel, 0, 0, 1, GridBagConstraints.EAST);
        addComponent(comboBox, 1, 0, 2, GridBagConstraints.WEST);
        addComponent(homephoneLabel, 0, 1, 1, GridBagConstraints.EAST);
        addComponent(homephoneField, 1, 1, 2, GridBagConstraints.WEST);
        addComponent(contactLabel, 0, 2, 1, GridBagConstraints.EAST);
        addComponent(contactField, 1, 2, 2, GridBagConstraints.WEST);
        addComponent(closeButton, 1, 3, 1, GridBagConstraints.CENTER);

        // 按钮事件
        closeButton.addActionListener(e -> {
            this.removeAll();
            this.revalidate();
            this.repaint();
        });

        // 下拉框事件监听
        comboBox.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String selectedName = (String) comboBox.getSelectedItem();
                if (selectedName != null) {
                    for (ClassMate mate : classMateData) {
                        if (mate.getName().equals(selectedName)) {
                            homephoneField.setText(mate.getHomephone());
                            contactField.setText(mate.getContact());
                            break;
                        }
                    }
                }
            }
        });
    }

    /**
     * 添加组件的辅助方法，简化 GridBagConstraints 的设置
     *
     * @param component 组件
     * @param gridx     横坐标
     * @param gridy     纵坐标
     * @param gridwidth 占用的列数
     * @param anchor    对齐方式
     */
    private void addComponent(Component component, int gridx, int gridy, int gridwidth, int anchor) {
        GridBagConstraints gbc = new GridBagConstraints();
        gbc.gridx = gridx;
        gbc.gridy = gridy;
        gbc.gridwidth = gridwidth;
        gbc.insets = new Insets(5, 5, 5, 5); // 设置间距
        gbc.anchor = anchor;
        gbc.fill = GridBagConstraints.HORIZONTAL; // 横向填充
        add(component, gbc);
    }

    /**
     * 加载同学数据到下拉框
     */
    private Vector<ClassMate> loadClassMateData() {
        Vector<ClassMate> classMateData = new Vector<>();
        try {
            classMateData = classMateStore.getClassMate(conn, SQL_QUERY);
            for (ClassMate mate : classMateData) {
                comboBox.addItem(mate.getName());
            }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "加载数据失败：" + ex.getMessage(), "错误", JOptionPane.ERROR_MESSAGE);
        }
        return classMateData;
    }

    public static void main(String[] args) {
        JFrame frame = new JFrame("AdapterClass");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(600, 400);
        frame.setLocationRelativeTo(null);
        frame.add(new ClassMateCommunication());
        frame.setVisible(true);
    }

}

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184

public class ClassMateFind {
    static JPanel panel;
    private JTextField nameInput, addressInput, homeAddressInput, sexyInput, cityInput, companyInput, dutyInput,
            salaryInput, searchTextField;
    private JLabel titleLabel;

    public ClassMateFind() {
        panel = new JPanel();
        GridBagLayout gridbag = new GridBagLayout();
        panel.setLayout(gridbag);

        // Title label
        titleLabel = new JLabel("同学查询结果信息");
        titleLabel.setFont(new Font("微软雅黑", Font.BOLD, 20)); // Font settings
        titleLabel.setHorizontalAlignment(SwingConstants.CENTER);

        // Labels for student information
        JLabel[] labels = {
                new JLabel("姓名"), new JLabel("性别"), new JLabel("居住地址"),
                new JLabel("家庭地址"), new JLabel("所在城市"),
                new JLabel("所在公司"), new JLabel("职务"), new JLabel("薪水")
        };

        // Creating JTextFields for input
        nameInput = new JTextField(15);
        addressInput = new JTextField(15);
        homeAddressInput = new JTextField(15);
        sexyInput = new JTextField(15);
        cityInput = new JTextField(15);
        companyInput = new JTextField(15);
        dutyInput = new JTextField(15);
        salaryInput = new JTextField(15);
        JTextField[] textFields = { sexyInput, addressInput, homeAddressInput, cityInput, companyInput, dutyInput,
                salaryInput };

        // Set all JTextFields with the same size
        Dimension commonSize = new Dimension(150, nameInput.getPreferredSize().height);
        for (JTextField textField : textFields) {
            textField.setPreferredSize(commonSize);
        }

        // Adding components to the panel using GridBagLayout
        GridBagConstraints gbc = new GridBagConstraints();
        gbc.insets = new Insets(5, 5, 5, 5); // Padding for components

        // Title label
        gbc.gridx = 0;
        gbc.gridy = 0;
        gbc.gridwidth = 4; // Title spans across 4 columns
        gbc.anchor = GridBagConstraints.CENTER;
        gbc.insets = new Insets(20, 5, 15, 5); // Top padding
        addComponent(titleLabel, gbc);

        // Labels and input fields
        for (int i = 0; i < labels.length; i++) {
            gbc.gridwidth = 1;
            gbc.insets = new Insets(5, 5, 5, 5); // Default padding

            // Add labels (aligned to the right)
            gbc.gridx = (i < 4) ? 0 : 2; // Left or right column
            gbc.gridy = (i < 4) ? i + 1 : i - 3;
            gbc.anchor = GridBagConstraints.EAST;
            addComponent(labels[i], gbc);

            // Add input fields (aligned to the left)
            gbc.gridx = (i < 4) ? 1 : 3; // Corresponding input fields
            gbc.anchor = GridBagConstraints.WEST;
            if (i == 0) { // First field is the name input
                addComponent(nameInput, gbc);
            } else {
                addComponent(textFields[i - 1], gbc);
            }
        }

        JLabel titleLabel1 = new JLabel("查询系统");
        titleLabel1.setFont(new Font("微软雅黑", Font.BOLD, 20)); // Font settings
        titleLabel1.setHorizontalAlignment(SwingConstants.CENTER);
        gbc.gridx = 0;
        gbc.gridy = 9; // Place it below the existing input fields
        gbc.gridwidth = 4;
        gbc.anchor = GridBagConstraints.CENTER;
        addComponent(titleLabel1, gbc);

        // Adding the new "按姓名查询" label and text field for searching
        JLabel searchLabel = new JLabel("按姓名查询：");
        searchTextField = new JTextField(15);

        gbc.gridx = 0;
        gbc.gridy = 10; // Place it below the existing input fields
        gbc.gridwidth = 1;
        gbc.anchor = GridBagConstraints.WEST;
        addComponent(searchLabel, gbc);

        gbc.gridx = 1;
        gbc.gridy = 10;
        gbc.gridwidth = 2; // Spanning 2 columns for the search field
        gbc.anchor = GridBagConstraints.WEST;
        addComponent(searchTextField, gbc);

        // Adding the search button next to the search text field
        JButton searchButton = new JButton("查询");
        searchButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                queryClassmateInfo(searchTextField.getText());
            }
        });

        gbc.gridx = 3;
        gbc.gridy = 10;
        gbc.gridwidth = 1;
        gbc.anchor = GridBagConstraints.WEST;
        addComponent(searchButton, gbc);

    }

    // Method to add components to the panel
    private void addComponent(Component c, GridBagConstraints constraints) {
        panel.add(c, constraints);
    }

    // Simulate querying the classmate info and updating text fields
    private void queryClassmateInfo(String name) {
        // Creating an instance of ClassMateStore to interact with the database
        ClassMateStore store = new ClassMateStore();
        Connection conn = store.getConnection();

        if (conn == null) {
            JOptionPane.showMessageDialog(panel, "无法连接到数据库", "数据库连接错误", JOptionPane.ERROR_MESSAGE);
            return;
        }

        // SQL query to fetch the classmate data based on the name input
        String query = "SELECT * FROM classmate WHERE name = ?";

        try (PreparedStatement stmt = conn.prepareStatement(query)) {
            stmt.setString(1, name); // Set the input name as parameter
            ResultSet rs = stmt.executeQuery();

            if (rs.next()) {
                // Populate the JTextFields with the data from the database
                nameInput.setText(rs.getString("name"));
                addressInput.setText(rs.getString("address"));
                homeAddressInput.setText(rs.getString("homeaddress"));
                sexyInput.setText(rs.getString("sex"));
                cityInput.setText(rs.getString("city"));
                companyInput.setText(rs.getString("company"));
                dutyInput.setText(rs.getString("duty"));
                salaryInput.setText(rs.getString("salary"));
            } else {
                // If no result found
                JOptionPane.showMessageDialog(panel, "未找到该同学信息", "查询结果", JOptionPane.INFORMATION_MESSAGE);
                resetFields();
            }
        } catch (SQLException e) {
            e.printStackTrace();
            JOptionPane.showMessageDialog(panel, "查询失败: " + e.getMessage(), "数据库错误", JOptionPane.ERROR_MESSAGE);
        }
    }

    private void resetFields() {
        addressInput.setText("");
        homeAddressInput.setText("");
        sexyInput.setText("");
        cityInput.setText("");
        companyInput.setText("");
        dutyInput.setText("");
        salaryInput.setText("");
        nameInput.setText(""); // Clear the name field
    }

    public static void main(String[] args) {
        JFrame frame = new JFrame("同学查询系统");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(600, 500); // Increased size for extra components
        frame.setLocationRelativeTo(null);

        // Initialize and add ClassMateFind panel
        ClassMateFind classMateFind = new ClassMateFind();
        frame.add(classMateFind.panel);

        frame.setVisible(true);
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

public class ClassMateStore {
    public Vector<ClassMate> getClassMate(Connection conn, String sql) {
        Vector<ClassMate> v = new Vector<>();
        try (Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery(sql)) {
            while (rs.next()) {
                ClassMate classMate = new ClassMate(rs.getString("name"));
                classMate.setSex(rs.getString("sex"));
                classMate.setAddress(rs.getString("address"));
                classMate.setHomeaddress(rs.getString("homeaddress"));
                classMate.setCity(rs.getString("city"));
                classMate.setCompany(rs.getString("company"));
                classMate.setDuty(rs.getString("duty"));
                classMate.setSalary(rs.getString("salary"));
                classMate.setContact(rs.getString("contact"));
                classMate.setHomephone(rs.getString("homephone"));
                v.add(classMate);
            }
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return v;
    }

    public ClassMate getObject(Connection conn, String name) {
        ClassMate classMate = null;
        try (Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery("select * from classmate where name='" + name + "'")) {
            while (rs.next()) {
                classMate = new ClassMate(rs.getString("name"));
                classMate.setSex(rs.getString("sex"));
                classMate.setAddress(rs.getString("address"));
                classMate.setHomeaddress(rs.getString("homeaddress"));
                classMate.setCity(rs.getString("city"));
                classMate.setCompany(rs.getString("company"));
                classMate.setDuty(rs.getString("duty"));
                classMate.setSalary(rs.getString("salary"));
                classMate.setContact(rs.getString("contact"));
                classMate.setHomephone(rs.getString("homephone"));
            }
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return classMate;
    }

    public Connection getConnection() {
        String url = "jdbc:mysql://localhost:3306/combook?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
        String user = "root";
        String password = "root";
        try {
            Class.forName("com.mysql.cj.jdbc.Driver"); // 更新驱动类名
            return DriverManager.getConnection(url, user, password);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        return null;
    }
}

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200

public class AddClassMate extends JPanel {

    private static final long serialVersionUID = 1L;
    private JTextField[] textFields;
    private DefaultComboBoxModel<String> model;

    public AddClassMate() {
        this.setLayout(new java.awt.GridBagLayout());

        model = new DefaultComboBoxModel<>();

        // 创建标题
        JLabel titleLabel = new JLabel("添加同学信息");
        titleLabel.setFont(new Font("微软雅黑", Font.BOLD, 20));
        titleLabel.setHorizontalAlignment(SwingConstants.CENTER);

        // 定义标签和输入框
        String[] labelNames = {
                "姓名", "性别", "居住地址", "家庭地址", "移动电话",
                "所在城市", "所在公司", "职务", "薪水", "家庭电话"
        };

        JLabel[] labels = new JLabel[labelNames.length];
        textFields = new JTextField[labelNames.length];

        for (int i = 0; i < labelNames.length; i++) {
            labels[i] = new JLabel(labelNames[i] + "：");
            textFields[i] = new JTextField(15);
        }

        JButton addButton = new JButton("添加同学信息");

        // 布局组件
        GridBagConstraints gbc = new GridBagConstraints();

        // 添加标题
        gbc.gridx = 0;
        gbc.gridy = 0; // 位于第 0 行
        gbc.gridwidth = 5; // 跨越 4 列，确保它占据整个窗口宽度
        gbc.anchor = GridBagConstraints.CENTER; // 居中对齐
        gbc.fill = GridBagConstraints.HORIZONTAL; // 水平方向填充
        gbc.insets = new Insets(10, 0, 25, 0); // 上下间距，增强美观
        add(titleLabel, gbc);

        for (int i = 0; i < labels.length; i++) {
            gbc.insets = new Insets(5, 5, 5, 5);
            gbc.fill = GridBagConstraints.NONE;
            gbc.gridwidth = 1; // 单独占 1 列
            // 添加 JLabel (右对齐)
            gbc.gridx = (i < 5) ? 0 : 2; // 左列或右列
            gbc.gridy = (i < 5) ? i + 1 : i - 4;
            gbc.anchor = GridBagConstraints.EAST; // 右对齐
            add(labels[i], gbc);

            // 添加输入控件 (左对齐)
            gbc.gridx = (i < 5) ? 1 : 4; // 左列或右列对应的控件
            gbc.anchor = GridBagConstraints.WEST; // 左对齐
            add(textFields[i], gbc);
        }

        // 添加按钮
        gbc.gridx = 0;
        gbc.gridy = labelNames.length + 1;
        gbc.gridwidth = 2;
        gbc.anchor = GridBagConstraints.CENTER;
        add(addButton, gbc);

        // 添加按钮事件监听
        addButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (validateInputs()) {
                    addClassMateToDatabase();
                }
            }
        });
    }

    /**
     * 将同学信息保存到数据库
     */
    private void addClassMateToDatabase() {
        String[] values = getTextFieldValues();
        ClassMateService service = new ClassMateService();
        if (service.addClassMate(values)) {
            updateClassMateInfo(values);
            JOptionPane.showMessageDialog(this, "添加成功！", "成功", JOptionPane.INFORMATION_MESSAGE);
            // ((JFrame) SwingUtilities.getWindowAncestor(this)).dispose(); // 关闭当前窗口
        } else {
            JOptionPane.showMessageDialog(this, "添加失败，请重试。", "失败", JOptionPane.ERROR_MESSAGE);
        }
    }

    private String[] getTextFieldValues() {
        String[] values = new String[textFields.length];
        for (int i = 0; i < textFields.length; i++) {
            values[i] = textFields[i].getText().trim();
        }
        String temp = values[4];
        values[4] = values[5];
        values[5] = values[6];
        values[6] = values[7];
        values[7] = values[8];
        values[8] = temp;
        return values;
    }

    private void updateClassMateInfo(String[] values) {

        // 确保 ClassMateInfo 中的组件已初始化
        if (ClassMateInfo.nameinput == null) {
            ClassMateInfo.nameinput = new JComboBox<>(model);
        }
        if (ClassMateInfo.addressinput == null) {
            ClassMateInfo.addressinput = new JTextField();
        }
        if (ClassMateInfo.sexyinput == null) {
            ClassMateInfo.sexyinput = new JTextField();
        }
        if (ClassMateInfo.homeaddressinput == null) {
            ClassMateInfo.homeaddressinput = new JTextField();
        }
        if (ClassMateInfo.companyinput == null) {
            ClassMateInfo.companyinput = new JTextField();
        }
        if (ClassMateInfo.dutyinput == null) {
            ClassMateInfo.dutyinput = new JTextField();
        }
        if (ClassMateInfo.salaryinput == null) {
            ClassMateInfo.salaryinput = new JTextField();
        }
        if (ClassMateInfo.cityinput == null) {
            ClassMateInfo.cityinput = new JTextField();
        }

        ClassMate classmate = new ClassMate(values[0]);
        classmate.setName(values[0]);
        classmate.setSex(values[1]);
        classmate.setAddress(values[2]);
        classmate.setHomeaddress(values[3]);
        classmate.setCity(values[4]);
        classmate.setCompany(values[5]);
        classmate.setDuty(values[6]);
        classmate.setSalary(values[7]);
        classmate.setContact(values[8]);
        classmate.setHomephone(values[9]);

        Vector<ClassMate> classmateVector = new Vector<>();
        classmateVector.add(classmate);

        ClassMateInfo.nameinput.addItem(values[0]);
        ClassMateInfo.nameinput.setSelectedItem(values[0]);
        ClassMateInfo.addressinput.setText(values[2]);
        ClassMateInfo.sexyinput.setText(values[1]);
        ClassMateInfo.homeaddressinput.setText(values[3]);
        ClassMateInfo.companyinput.setText(values[5]);
        ClassMateInfo.dutyinput.setText(values[6]);
        ClassMateInfo.salaryinput.setText(values[7]);
        ClassMateInfo.cityinput.setText(values[4]);

    }

    private boolean validateInputs() {
        for (JTextField textField : textFields) {
            if (textField.getText().trim().isEmpty()) {
                JOptionPane.showMessageDialog(this, "请填写所有必填项！", "输入错误", JOptionPane.WARNING_MESSAGE);
                return false;
            }
        }
        return true;
    }

    public static void main(String[] args) {
        JFrame frame = new JFrame("添加同学信息");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(600, 400);
        frame.setLocationRelativeTo(null);
        frame.add(new AddClassMate());
        frame.setVisible(true);
    }
}

class ClassMateService {
    private static final String INSERT_SQL = "INSERT INTO classmate (name, sex, address, homeAddress, city, company,  duty, salary, contact, homePhone) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    public boolean addClassMate(String... values) {
        try (Connection conn = new ClassMateStore().getConnection();
                PreparedStatement stmt = conn.prepareStatement(INSERT_SQL)) {

            for (int i = 0; i < values.length; i++) {
                stmt.setString(i + 1, values[i]);
            }

            return stmt.executeUpdate() > 0;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

public class DelClassMate {

    public DelClassMate() {
        String name = ClassMateInfo.nameinput.getSelectedItem().toString();
        ClassMateStore classMateStore = new ClassMateStore();
        try (Connection conn = classMateStore.getConnection();
                PreparedStatement stmt = conn.prepareStatement("delete from classmate where name = ?")) {
            stmt.setString(1, name);
            int rowsAffected = stmt.executeUpdate();
            if (rowsAffected > 0) {
                JOptionPane.showMessageDialog(null, "删除成功", "成功", JOptionPane.INFORMATION_MESSAGE);
            } else {
                JOptionPane.showMessageDialog(null, "删除失败，请重试。", "失败", JOptionPane.ERROR_MESSAGE);
            }
        } catch (Exception e) {
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, "数据库操作失败，请重试。", "失败", JOptionPane.ERROR_MESSAGE);
        } finally {
            ClassMateInfo.nameinput.removeItem(name);
        }
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

public class UpdateClassMate {
    ClassMateStore classMateStore = new ClassMateStore();
    Connection conn = classMateStore.getConnection();

    public UpdateClassMate() {
        try (PreparedStatement pstmt = conn.prepareStatement(
                "UPDATE classmate SET sex = ?, address = ?, homeaddress = ?, city = ?, company = ?, duty = ?, salary = ? WHERE name = ?")) {

            String sex = ClassMateInfo.sexyinput.getText();
            String name = ClassMateInfo.nameinput.getSelectedItem().toString();
            String address = ClassMateInfo.addressinput.getText();
            String homeaddress = ClassMateInfo.homeaddressinput.getText();
            String city = ClassMateInfo.cityinput.getText();
            String company = ClassMateInfo.companyinput.getText();
            String duty = ClassMateInfo.dutyinput.getText();
            String salary = ClassMateInfo.salaryinput.getText();

            pstmt.setString(1, sex);
            pstmt.setString(2, address);
            pstmt.setString(3, homeaddress);
            pstmt.setString(4, city);
            pstmt.setString(5, company);
            pstmt.setString(6, duty);
            pstmt.setString(7, salary);
            pstmt.setString(8, name);

            int rowsAffected = pstmt.executeUpdate();
            if (rowsAffected > 0) {
                JOptionPane.showMessageDialog(null, "修改成功！", "成功", JOptionPane.INFORMATION_MESSAGE);
            } else {
                JOptionPane.showMessageDialog(null, "未找到匹配的记录！", "失败", JOptionPane.ERROR_MESSAGE);
            }

        } catch (SQLException e) {
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, "发生错误：" + e.getMessage(), "错误", JOptionPane.ERROR_MESSAGE);
        }
    }
}

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104