JAVA课设职工信息管理系统

private void btn_closeActionPerformed(ActionEvent e) { }

// 执行数据库操作

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

JOptionPane.showMessageDialog(null, \删除成功\); dispose();

private void btn_delActionPerformed(ActionEvent e) {

String id = tf_id.getText(); // 获取职工编号

String sql = \ + 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()));

private void btn_queryActionPerformed(ActionEvent e) {

String id = tf_cx_id.getText();

Staff staff = StaffDao.selectStaff(id); }

}

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

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

dialogPane.add(buttonBar, BorderLayout.SOUTH);

}

});

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));

的职工

- 18 -

}

}

dispose();

3.2.4职工信息查询

public class StaffUpdate extends JFrame {

private void initComponents() {

dialogPane = new JPanel(); contentPanel = new JPanel(); lb_cx_id = new JLabel(); tf_cx_id = new JTextField(); btn_query = new JButton();

- 19 -

public StaffUpdate() { }

initComponents(); private JPanel dialogPane; private JPanel contentPanel; private JLabel lb_cx_id; private JTextField tf_cx_id; private JButton btn_query; private JLabel label12; private JLabel lb_id; private JTextField tf_id; private JLabel lb_name; private JTextField tf_name; private JLabel lb_type; private JComboBox cb_type; private JLabel lb_xueli; private JTextField tf_xueli; private JLabel lb_address; private JTextField tf_address; private JLabel lb_sex; private JTextField tf_sex; private JLabel lb_salary; private JTextField tf_salary; private JLabel lb_age; private JTextField tf_age; private JPanel buttonBar; private JButton btn_save; private JButton btn_close;

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());

label12 = new JLabel(); 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();

});

- 20 -

lb_age.setText(\年龄：\);

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);

contentPanel.add(btn_query);

- 21 -