staff_add.java

很好的Java绘图程序源代码

package project;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.table.DefaultTableModel;
import java.sql.ResultSet;
import java.awt.Dimension;
import java.awt.Rectangle;

public class Staff_add
    extends JPanel implements All_view {
  public Staff_add() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  Object[][] dep = null;
  Object[][] position = null;
  int partid = 0, positionid = 0;
  JFrame mainframe = null;
  String showMessage = null;
  JLabel id = new JLabel();
  JLabel name = new JLabel();
  JTextField nameText = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField birthText = new JTextField();
  JLabel jLabel1 = new JLabel();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  JRadioButton male = new JRadioButton();
  JRadioButton female = new JRadioButton();
  JTextField idText = new JTextField();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JTextField telText = new JTextField();
  JLabel jLabel6 = new JLabel();
  JTextField addressText = new JTextField();
  JLabel jLabel7 = new JLabel();
  JTextField hire_dateText = new JTextField();
  JLabel jLabel8 = new JLabel();
  JTextField contract_expireText = new JTextField();
  JLabel jLabel9 = new JLabel();
  JTextField salaryText = new JTextField();
  JLabel jLabel10 = new JLabel();
  JTextField educationText = new JTextField();
  JButton okbtn = new JButton();
  JButton resetbtn = new JButton();
  JComboBox partBox = new JComboBox();
  JComboBox positionBox = new JComboBox();
  JLabel showMsg = new JLabel();
  JLabel jLabel11 = new JLabel();
  JButton jButton1 = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable1 = null;

  public void tb() {
    DataBase db3 = new DataBase();
    String sql = "select top 1 employee_id,name,dep_id,position_id from employee_table order by employee_id desc";
    ResultSet rs = db3.executeQuery(sql);
    DataMap mp = new DataMap(rs);
    Object[][] obj = mp.get_DataMap_Array();
    String[] colnames = {
        "工号", "姓名", "部门ID", "职位ID"};
    DefaultTableModel dm = new DefaultTableModel(obj, colnames);
    jTable1 = new JTable(dm);
    jScrollPane1.setBounds(new Rectangle(56, 442, 216, 44));
    this.add(jScrollPane1);
    jScrollPane1.getViewport().add(jTable1);
  }

  public Staff_add(JFrame mainframe) {
    this.mainframe = mainframe;
    try {
      jbInit();
      setPanelPosOnDesktop(this.mainframe);
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.setLayout(null);
    setSize(new Dimension(877, 612));
    id.setText("工号:");
    id.setBounds(new Rectangle(54, 86, 38, 28));
    name.setText("姓名:");
    name.setBounds(new Rectangle(303, 88, 39, 28));
    nameText.setText("");
    nameText.setBounds(new Rectangle(402, 82, 92, 28));
    jLabel4.setText("出生年月:");
    jLabel4.setBounds(new Rectangle(537, 83, 74, 28));
    birthText.setBounds(new Rectangle(615, 83, 103, 28));
    jLabel1.setText("性别:");
    jLabel1.setBounds(new Rectangle(542, 132, 55, 28));
    male.setText("男");
    male.setBounds(new Rectangle(616, 128, 53, 28));
    female.setText("女");
    female.setBounds(new Rectangle(677, 127, 42, 28));
    idText.setBounds(new Rectangle(133, 83, 83, 28));
    jLabel2.setText("部门ID:");
    jLabel2.setBounds(new Rectangle(54, 140, 61, 28));
    Staff_C sm = new Staff_C();
    dep = sm.depart();
    for (int i = 0; i < dep.length; i++) {
      partBox.addItem(dep[i][1].toString());
    }
    jLabel3.setText("职务ID:");
    jLabel3.setBounds(new Rectangle(303, 140, 79, 28));
    jLabel5.setText("联系电话:");
    jLabel5.setBounds(new Rectangle(54, 193, 74, 28));
    telText.setText("");
    telText.setBounds(new Rectangle(133, 190, 141, 28));
    jLabel6.setText("家庭住址:");
    jLabel6.setBounds(new Rectangle(303, 195, 84, 28));
    addressText.setText("");
    addressText.setBounds(new Rectangle(402, 189, 224, 28));
    jLabel7.setText("进司日期:");
    jLabel7.setBounds(new Rectangle(54, 250, 76, 28));
    hire_dateText.setBounds(new Rectangle(133, 247, 103, 28));
    jLabel8.setText("合同到期日期:");
    jLabel8.setBounds(new Rectangle(303, 252, 91, 28));
    contract_expireText.setText("");
    contract_expireText.setBounds(new Rectangle(402, 246, 103, 28));
    jLabel9.setText("工资底薪:");
    jLabel9.setBounds(new Rectangle(54, 303, 72, 28));
    salaryText.setText("");
    salaryText.setBounds(new Rectangle(133, 305, 101, 28));
    jLabel10.setText("本人学历:");
    jLabel10.setBounds(new Rectangle(303, 305, 87, 28));
    educationText.setText("");
    educationText.setBounds(new Rectangle(402, 304, 100, 28));
    okbtn.setBounds(new Rectangle(172, 370, 97, 28));
    okbtn.setText("确认");
    okbtn.addActionListener(new Staff_add_okbtn_actionAdapter(this));
    resetbtn.setText("重置");
    resetbtn.setBounds(new Rectangle(463, 368, 97, 28));
    resetbtn.addActionListener(new Staff_add_resetbtn_actionAdapter(this));
    partBox.setSelectedIndex( -1);
    partBox.setBounds(new Rectangle(133, 135, 91, 28));
    partBox.addItemListener(new Staff_add_partBox_itemAdapter(this));
    positionBox.setBounds(new Rectangle(402, 134, 110, 28));
    positionBox.addItemListener(new Staff_add_positionBox_itemAdapter(this));
    showMsg.setText("");
    showMsg.setBounds(new Rectangle(494, 34, 219, 25));
    jButton1.setBounds(new Rectangle(55, 418, 218, 23));
    jButton1.setText("最近录入记录");
    jLabel11.setFont(new java.awt.Font("幼圆", Font.BOLD, 20));
    jLabel11.setForeground(new Color(85, 45, 25));
    jLabel11.setText("员 工 信 息 录 入");
    jLabel11.setBounds(new Rectangle(221, 25, 197, 45));

    this.add(jLabel11);
    this.add(id);
    this.add(jLabel2);
    this.add(jLabel5);
    this.add(jLabel7);
    this.add(jLabel9);
    this.add(jButton1);
    this.add(idText);
    this.add(partBox);
    this.add(telText);
    this.add(hire_dateText);
    this.add(salaryText);
    this.add(name);
    this.add(jLabel3);
    this.add(jLabel6);
    this.add(jLabel8);
    this.add(jLabel10);
    this.add(nameText);
    this.add(positionBox);
    this.add(addressText);
    this.add(contract_expireText);
    this.add(educationText);
    this.add(jLabel4);
    this.add(jLabel1);
    this.add(birthText);
    this.add(male);
    this.add(female);
    this.add(showMsg);
    this.add(okbtn);
    this.add(resetbtn);
    this.tb();

    buttonGroup1.add(male);
    buttonGroup1.add(female);
  }

  public void setPanelPosOnDesktop(JFrame frame) {
    this.setLocation( ( ( (Frame1) frame).get_Container_width() -
                       this.getSize().width) / 2,
                     ( ( (Frame1) frame).get_Container_height() -
                      this.getSize().height) / 2);
  }

  public void closeCurrentPanel(JFrame frame) {
    ( (Frame1) frame).remove_panel();
  }

  public void set_focus() {
    nameText.requestFocus();
  }

  public void requestFocus() {
    set_focus();
  }

  public void clear() {
    //partBox.setSelectedIndex( -1);
    idText.setText("");
    nameText.setText("");
    birthText.setText("");
    addressText.setText("");
    hire_dateText.setText("");
    contract_expireText.setText("");
    telText.setText("");
    salaryText.setText("");
    educationText.setText("");
    this.tb();
  }

  public void okbtn_actionPerformed(ActionEvent e) {
    try {
      Staff_obj_M obj1 = new Staff_obj_M();
      Staff_C method = new Staff_C();
      obj1.setId(Integer.parseInt(idText.getText()));
      obj1.setName(nameText.getText());
      obj1.setBirth(birthText.getText());
      obj1.setAddress(addressText.getText());
      if (male.isSelected()) {
        obj1.setSex(1);
      }
      else {
        obj1.setSex(0);
      }
      obj1.setDep(partid);
      obj1.setPosition(Integer.parseInt(position[positionBox.getSelectedIndex()][
                                        0].toString()));
      obj1.setHiredate(hire_dateText.getText());
      obj1.setContract(contract_expireText.getText());
      obj1.setTelephone(telText.getText());
      obj1.setSalary(Integer.parseInt(salaryText.getText()));
      obj1.setEducation(educationText.getText());
      int r = method.staff_add(obj1);
      if (r == 0) {
        showMsg.setForeground(Color.cyan);
        showMsg.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        showMessage = "输入数据失败！！";
        this.clear();
      }
      else {
        showMessage = "输入数据成功！！";

      }
      showMsg.setForeground(Color.blue);
      showMsg.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
      showMsg.setText(showMessage);
      this.clear();
    }
    catch (NumberFormatException ex) {
      showMessage = "格式有误请重新输入！！";
      showMsg.setForeground(Color.red);
      showMsg.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
      showMsg.setText(showMessage);
      this.clear();
    }
  }

  public void resetbtn_actionPerformed(ActionEvent e) {
    this.clear();

  }

  public void partBox_itemStateChanged(ItemEvent e) {
    int pname = partBox.getSelectedIndex();
    partid = Integer.parseInt(dep[pname][0].toString());
    Staff_C sm = new Staff_C();
    position = sm.position(partid);
    positionBox.removeAllItems();
    for (int i = 0; i < position.length; i++) {
      positionBox.addItem(position[i][1].toString());
    }

  }

  public void positionBox_itemStateChanged(ItemEvent e) {

  }

}

class Staff_add_positionBox_itemAdapter
    implements ItemListener {
  private Staff_add adaptee;
  Staff_add_positionBox_itemAdapter(Staff_add adaptee) {
    this.adaptee = adaptee;
  }

  public void itemStateChanged(ItemEvent e) {
    adaptee.positionBox_itemStateChanged(e);
  }
}

class Staff_add_partBox_itemAdapter
    implements ItemListener {
  private Staff_add adaptee;
  Staff_add_partBox_itemAdapter(Staff_add adaptee) {
    this.adaptee = adaptee;
  }

  public void itemStateChanged(ItemEvent e) {

    adaptee.partBox_itemStateChanged(e);
  }
}

class Staff_add_resetbtn_actionAdapter
    implements ActionListener {
  private Staff_add adaptee;
  Staff_add_resetbtn_actionAdapter(Staff_add adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.resetbtn_actionPerformed(e);
  }
}

class Staff_add_okbtn_actionAdapter
    implements ActionListener {
  private Staff_add adaptee;
  Staff_add_okbtn_actionAdapter(Staff_add adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.okbtn_actionPerformed(e);
  }
}