教职工管理信息系统教职工管理信息系统_.zip

//员工信息管理类 package classsource; import java.awt.*; import javax.swing.*; import java.awt.event.*; import java.sql.*; public class Employeemanage extends JInternalFrame{ JInternalFrame jif; public Employeemanage() { jif=this; initComponents(); } private void initComponents() { setTitle("教职工基本信息"); // String schoolage[]={"大专","本科","研究生"}; // String department[]={"教学部","市场部","人事部","财会部"}; // String Headship[]={"讲师","主管","教学主任"}; String politicsVisage[]={"党员","群众"}; String Estate[]={"在职","停薪留职","离职"}; String Sex[]={"男","女"}; String Marriage[]={"未婚","已婚","离婚"}; Font f = new Font("新宋体", 0, 14); lb1 = new JLabel("员工基本信息管理"); lb2 = new JLabel("编号:"); lb3 = new JLabel("政治面貌:"); lb4 = new JLabel("婚姻状态:"); lb5 = new JLabel("性别:"); lb6 = new JLabel("状态:"); lb7 = new JLabel("职务:"); lb8 = new JLabel("备注:"); lb9 = new JLabel("部门:"); lb10 = new JLabel("转正时间:"); lb11 = new JLabel("进学校日期:"); lb12 = new JLabel("出生日期:"); lb13 = new JLabel("学历:"); lb14 = new JLabel("姓名:"); txt_number = new JTextField(); txt_name = new JTextField(); sex_cb = new JComboBox(Sex); theadship = new JTextField(); tschoolage= new JTextField(); tdepartment = new JTextField(); txt_borndate = new JTextField(); marriage_cb = new JComboBox(Marriage); politicsVisage_cb = new JComboBox(politicsVisage); estate_cb = new JComboBox(Estate); txt_enterdate = new JTextField(); txt_InDueFormDate = new JTextField(); remark_ta = new JTextArea(); save_bt = new JButton("保存"); rm_bt = new JButton(">>"); lm_bt = new JButton("<<"); right_bt = new JButton(">|"); left_bt = new JButton("|<"); exit_bt = new JButton("退出"); append_bt = new JButton("添加"); delet_bt= new JButton("删除"); amend_bt = new JButton("修改"); getContentPane().setLayout(null); setFont(new Font("黑体", 1, 24)); lb1.setBackground(new Color(0, 0, 0)); lb1.setFont(new Font("新宋体", 1, 24)); lb1.setForeground(new Color(0, 0, 255)); getContentPane().add(lb1); lb1.setBounds(140, 10, 210, 40); lb2.setFont(f); getContentPane().add(lb2); lb2.setBounds(20, 80, 60, 20); lb3.setFont(f); getContentPane().add(lb3); lb3.setBounds(10, 240, 80, 20); lb4.setFont(f); getContentPane().add(lb4); lb4.setBounds(10, 190, 80, 20); lb5.setFont(f); getContentPane().add(lb5); lb5.setBounds(360, 140, 60, 20); lb6.setFont(f); getContentPane().add(lb6); lb6.setBounds(200, 290, 60, 20); lb7.setFont(f); getContentPane().add(lb7); lb7.setBounds(200, 190, 60, 20); lb8.setFont(f); getContentPane().add(lb8); lb8.setBounds(350, 240, 60, 20); lb9.setFont(f); getContentPane().add(lb9); lb9.setBounds(200, 140, 60, 20); lb10.setFont(f); getContentPane().add(lb10); lb10.setBounds(350, 190, 70, 20); lb11.setFont(f); getContentPane().add(lb11); lb11.setBounds(10, 290, 110, 20); lb12.setFont(f); getContentPane().add(lb12); lb12.setBounds(10, 140, 80, 20); lb13.setFont(f); getContentPane().add(lb13); lb13.setBounds(200, 240, 60, 20); lb14.setFont(f); getContentPane().add(lb14); lb14.setBounds(190, 80, 60, 20); getContentPane().add(txt_number); txt_number.setBounds(80, 80, 80, 21); getContentPane().add(txt_name); txt_name.setBounds(250, 80, 80, 20); getContentPane().add(sex_cb); sex_cb.setFont(f); sex_cb.setSelectedIndex(1); sex_cb.setBounds(430, 140, 90, 23); getContentPane().add(txt_borndate); txt_borndate.setBounds(80, 140, 100, 20); //出生日期 getContentPane().add(marriage_cb); marriage_cb.setFont(f); marriage_cb.setBounds(80, 190, 100, 23); getContentPane().add(politicsVisage_cb); politicsVisage_cb.setFont(f); politicsVisage_cb.setBounds(80, 240, 100, 23);//政治面貌 getContentPane().add(estate_cb); estate_cb.setFont(f); estate_cb.setBounds(250, 290, 90, 23); //状态 getContentPane().add(tdepartment); tdepartment.setFont(f); tdepartment.setBounds(250, 140, 90, 20); //部门 getContentPane().add(theadship); theadship.setFont(f); theadship.setBounds(250, 190, 90, 20); //职务 getContentPane().add(tschoolage); tschoolage.setFont(f); tschoolage.setBounds(250, 240, 90, 20); //学历 getContentPane().add(txt_enterdate); txt_enterdate.setBounds(100, 290, 90, 20); //进入公司时间 getContentPane().add(txt_InDueFormDate); txt_InDueFormDate.setBounds(430, 190, 100, 20); //转正时间 getContentPane().add(remark_ta); //备注 remark_ta.setBounds(350, 260, 190, 53); save_bt.setFont(f); getContentPane().add(save_bt); save_bt.setBounds(20, 390, 70, 25); save_bt.setEnabled(false); rm_bt.setFont(f); getContentPane().add(rm_bt); rm_bt.setBounds(260, 350, 70, 25); lm_bt.setFont(f); getContentPane().add(lm_bt); lm_bt.setBounds(150, 350, 70, 25); right_bt.setFont(f); getContentPane().add(right_bt); right_bt.setBounds(370, 350, 70, 25); left_bt.setFont(f); getContentPane().add(left_bt); left_bt.setBounds(50, 350, 70, 25); exit_bt.setFont(f); getContentPane().add(exit_bt); exit_bt.setBounds(410, 390, 70,25); append_bt.setFont(f); getContentPane().add(append_bt); append_bt.setBounds(110, 390, 70, 25); delet_bt.setFont(f); getContentPane().add(delet_bt); delet_bt.setBounds(310, 390, 70, 25); amend_bt.setFont(f); getContentPane().add(amend_bt); amend_bt.setBounds(210, 390, 70, 25); //连接数据库--------------------------------------- Database.joinDB(); //初始化窗体数据---------------------------------------------------------------------------- String csql="select * from EmployeeInformation"; try{ if(Database.query(csql)){ Database.rs.next(); txt_number.setText("" + Database.rs.getInt("E_Number")); txt_name.setText(Database.rs.getString("E_Name")); if(Database.rs.getString("E_Sex").equals("男")){ sex_cb.setSelectedIndex(0); } else{ sex_cb.setSelectedIndex(1); } //System.out.println(""+sex_cb.getSelectedItem()); txt_borndate.setText(Database.rs.getString("E_BornDate")); tdepartment.setText(Database.rs.getString("E_Department")); if(Database.rs.getString("E_Marriage").equals("未婚")){ marriage_cb.setSelectedIndex(0); } else if(Database.rs.getString("E_Marriage").equals("已婚")){ marriage_cb.setSelectedIndex(1); } else{ marriage_cb.setSelectedIndex(2); } //System.out.println(""+marriage_cb.getSelectedItem()); theadship.setText(Database.rs.getString("E_Headship")); txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate")); if(Database.rs.getString("E_PoliticsVisage").equals("党员")){ politicsVisage_cb.setSelectedIndex(0); } else{