JAVA课设职工信息管理系统

btn_query.setText(\查询\);

btn_query.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) { }

btn_queryActionPerformed(e);

lb_cx_id.setText(\职工号：\);

lb_cx_id.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_cx_id); contentPanel.add(tf_cx_id);

{

contentPanel.setLayout(new GridLayout(6, 4, 6, 6));

{

dialogPane.setBorder(new EmptyBorder(12, 12, 12, 12)); dialogPane.setLayout(new BorderLayout());

setTitle(\修改职工信息\); setResizable(false);

Container contentPane = getContentPane(); contentPane.setLayout(new BorderLayout());

lb_id = new JLabel(); tf_id = new JTextField(); lb_name = new JLabel(); tf_name = new JTextField(); lb_type = new JLabel();

cb_type = new JComboBox(Constant.STAFF_TYPES); lb_xueli = new JLabel(); tf_xueli = new JTextField(); lb_address = new JLabel(); tf_address = new JTextField(); lb_sex = new JLabel(); tf_sex = new JTextField(); lb_salary = new JLabel(); tf_salary = new JTextField(); lb_age = new JLabel(); tf_age = new JTextField(); buttonBar = new JPanel(); btn_save = new JButton(); btn_close = new JButton();

});

contentPanel.add(btn_query);

- 10 -

lb_age.setText(\年龄：\);

lb_age.setHorizontalAlignment(SwingConstants.RIGHT);

lb_salary.setText(\工资：\);

lb_salary.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_salary); contentPanel.add(tf_salary);

lb_sex.setText(\性别：\);

lb_sex.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_sex); contentPanel.add(tf_sex);

lb_address.setText(\地址：\);

lb_address.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_address); contentPanel.add(tf_address);

lb_xueli.setText(\学历：\);

lb_xueli.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_xueli); contentPanel.add(tf_xueli);

lb_type.setText(\任职类型：\);

lb_type.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_type); contentPanel.add(cb_type);

lb_name.setText(\姓名：\);

lb_name.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_name); contentPanel.add(tf_name);

tf_id.setEditable(false); contentPanel.add(tf_id);

lb_id.setText(\职工号：\);

lb_id.setHorizontalAlignment(SwingConstants.RIGHT); contentPanel.add(lb_id);

label12.setText(\); label12.setVisible(false); contentPanel.add(label12);

- 11 -

{

private void btn_saveActionPerformed(ActionEvent e) { }

}

contentPane.add(dialogPane, BorderLayout.CENTER); setSize(625, 260);

setLocationRelativeTo(getOwner()); show(); }

dialogPane.add(buttonBar, BorderLayout.SOUTH);

btn_close.setText(\关闭\);

btn_close.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) { }

btn_closeActionPerformed(e);

btn_save.setText(\保存\);

btn_save.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) { }

btn_saveActionPerformed(e);

0, 85, 80 };

((GridBagLayout) buttonBar.getLayout()).columnWeights = new

1.0, 0.0, 0.0 };

{

buttonBar.setBorder(new EmptyBorder(12, 0, 0, 0)); buttonBar.setLayout(new GridBagLayout());

((GridBagLayout) buttonBar.getLayout()).columnWidths = new int[]

}

dialogPane.add(contentPanel, BorderLayout.CENTER);

contentPanel.add(lb_age); contentPanel.add(tf_age);

double[] {

});

buttonBar.add(btn_save, new GridBagConstraints(1, 0, 1, 1, 0.0,

0.0, GridBagConstraints.CENTER,

GridBagConstraints.BOTH, new Insets(0, 0, 0, 5), 0, 0));

});

buttonBar.add(btn_close, new GridBagConstraints(2, 0, 1, 1,

0.0, 0.0, GridBagConstraints.CENTER,

GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), 0, 0));

- 12 -

// 获取用户输入信息

String id = tf_id.getText(); String name = tf_name.getText();

String type = cb_type.getSelectedItem().toString(); String xueli = tf_xueli.getText(); String address = tf_address.getText(); String sex = tf_sex.getText(); String salary = tf_salary.getText(); String age = tf_age.getText();

// 拼接sql

String sql = \ + name + \ + type

+ \ + xueli + \ + address + \ + sex + \ + Double.parseDouble(salary) + \ + age + \ + id + \;

}

// 执行数据库操作

int i = BaseDao.executeUpdate(sql); if (i == 1) { }

JOptionPane.showMessageDialog(null, \修改成功\); dispose();

private void btn_queryActionPerformed(ActionEvent e) { }

private void btn_closeActionPerformed(ActionEvent e) { }

dispose();

String id = tf_cx_id.getText(); // 职工号

Staff staff = StaffDao.selectStaff(id); // 根据编号查询职工信息 // 设置职工信息

if (staff != null) { }

tf_id.setText(staff.getId()); tf_name.setText(staff.getName());

cb_type.setSelectedItem(staff.getType()); tf_xueli.setText(staff.getXueli()); tf_address.setText(staff.getAddress()); tf_sex.setText(staff.getSex());

tf_salary.setText(String.valueOf(staff.getSalary())); tf_age.setText(String.valueOf(staff.getAge()));

- 13 -