?? employeemanage.java
字號:
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{ politicsVisage_cb.setSelectedIndex(1); } tschoolage.setText(Database.rs.getString("E_SchoolAge")); txt_enterdate.setText(Database.rs.getString("E_EnterDate")); if(Database.rs.getString("E_Estate").equals("在職")){ estate_cb.setSelectedIndex(0); } else if(Database.rs.getString("E_Estate").equals("停薪留職")){ estate_cb.setSelectedIndex(1); } else{ estate_cb.setSelectedIndex(2); } remark_ta.setText(Database.rs.getString("E_Remark")); } } catch(Exception erm){ System.out.println(erm); } } }); //最前一條按鈕事件 left_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ try{ if(Database.rs.first()){ 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); } 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); } 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{ politicsVisage_cb.setSelectedIndex(1); } tschoolage.setText(Database.rs.getString("E_SchoolAge")); txt_enterdate.setText(Database.rs.getString("E_EnterDate")); if(Database.rs.getString("E_Estate").equals("在職")){ estate_cb.setSelectedIndex(0); } else if(Database.rs.getString("E_Estate").equals("停薪留職")){ estate_cb.setSelectedIndex(1); } else{ estate_cb.setSelectedIndex(2); } remark_ta.setText(Database.rs.getString("E_Remark")); } } catch(Exception erm){ System.out.println(erm); } } }); right_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ try{ if(Database.rs.last()){ 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); } 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); } 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{ politicsVisage_cb.setSelectedIndex(1); } tschoolage.setText(Database.rs.getString("E_SchoolAge")); txt_enterdate.setText(Database.rs.getString("E_EnterDate")); if(Database.rs.getString("E_Estate").equals("在職")){ estate_cb.setSelectedIndex(0); } else if(Database.rs.getString("E_Estate").equals("停薪留職")){ estate_cb.setSelectedIndex(1); } else{ estate_cb.setSelectedIndex(2); } remark_ta.setText(Database.rs.getString("E_Remark")); } } catch(Exception erm){ System.out.println(erm); } } });//為添加保存按鈕加事件 append_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ save_bt.setEnabled(true); txt_number.setText(""); txt_name.setText(""); sex_cb.setSelectedIndex(0); txt_borndate.setText(""); tdepartment.setText(""); marriage_cb.setSelectedIndex(0); theadship.setText(""); txt_InDueFormDate.setText(""); politicsVisage_cb.setSelectedIndex(0); tschoolage.setText(""); txt_enterdate.setText(""); estate_cb.setSelectedIndex(0); remark_ta.setText(""); } }); save_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ if(txt_name.getText().equals("")||txt_borndate.getText().equals("")||tdepartment.getText().equals("") ||theadship.getText().equals("")||txt_InDueFormDate.getText().equals("")||tschoolage.getText().equals("") ||txt_enterdate.getText().equals("")){ new JOptionPane().showMessageDialog(null,"除備注外，其余數據均不能為空！"); } else{ String number=txt_number.getText(); String name=txt_name.getText(); String borndate=txt_borndate.getText(); String department=tdepartment.getText(); String headship=theadship.getText(); String indueformdate=txt_InDueFormDate.getText(); String schoolage=tschoolage.getText(); String enterdate=txt_enterdate.getText(); String remark=remark_ta.getText(); String sex=("" + sex_cb.getSelectedItem()); String marriage=(""+marriage_cb.getSelectedItem()); String estate=("" + estate_cb.getSelectedItem()); String politicsVisage=("" + politicsVisage_cb.getSelectedItem()); String sInsert="insert UserInfo values( '"+ number +"', '"+ name +"','"+ sex +"','"+ borndate+"',"+ "'"+ marriage +"','"+ politicsVisage +"','"+ schoolage +"','"+ enterdate +"','"+ indueformdate +"',"+ "'"+ department +"','"+ headship +"','"+ estate +"','"+ remark +"')"; try{ if(Database.executeSQL(sInsert)){ txt_number.setEditable(true); save_bt.setEnabled(false); new JOptionPane().showMessageDialog(null,"添加數據成功！"); Database.joinDB(); String sql="select * from UserInfo"; Database.query(sql); Database.rs.last(); txt_number.setText("" + Database.rs.getInt("E_Number")); } } catch(Exception einsert){ System.out.println(einsert); } } } });//為修改刪除按鈕添加事件 amend_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ String number=txt_number.getText(); String name=txt_name.getText(); String borndate=txt_borndate.getText(); String department=tdepartment.getText(); String headship=theadship.getText(); String indueformdate=txt_InDueFormDate.getText(); String schoolage=tschoolage.getText(); String enterdate=txt_enterdate.getText(); String remark=remark_ta.getText(); String sex=("" + sex_cb.getSelectedItem()); String marriage=(""+marriage_cb.getSelectedItem()); String estate=("" + estate_cb.getSelectedItem()); String politicsVisage=("" + politicsVisage_cb.getSelectedItem()); String supdate="update UserInfo set E_Number ='"+ number +"', E_Name ='"+ name +"',E_Sex='"+ sex +"'," + "E_BornDate='"+ borndate +"',E_Marriage='"+ marriage +"',E_PoliticsVisage='"+ politicsVisage +"'," + "E_SchoolAge='"+ schoolage+"',E_EnterDate='"+ enterdate +"',E_InDueFormDate='"+ indueformdate +"',"+ "E_Department='"+ department +"',E_Headship='"+ headship +"',E_Estate='"+ estate +"'," + "E_Remark='"+ remark +"' where E_Number='"+ txt_number.getText() +"'"; System.out.println(supdate); try{ if(Database.executeSQL(supdate)){ new JOptionPane().showMessageDialog(null,"數據修改成功！"); Database.joinDB(); String sqll="select * from UserInfo"; Database.query(sqll); } } catch(Exception eupdate){} } }); delet_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ String sdelete = "delete from UserInfo where E_Number ='"+ txt_number.getText()+"'"; try{ if(Database.executeSQL(sdelete)){ new JOptionPane().showMessageDialog(null,"數據刪除成功！"); String sql="select * from UserInfo"; Database.query(sql); 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); } 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); } 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{ politicsVisage_cb.setSelectedIndex(1); } tschoolage.setText(Database.rs.getString("E_SchoolAge")); txt_enterdate.setText(Database.rs.getString("E_EnterDate")); if(Database.rs.getString("E_Estate").equals("在職")){ estate_cb.setSelectedIndex(0); } else if(Database.rs.getString("E_Estate").equals("停薪留職")){ estate_cb.setSelectedIndex(1); } else{ estate_cb.setSelectedIndex(2); } remark_ta.setText(Database.rs.getString("E_Remark")); } } catch(Exception er){ System.out.println(er); } } }); exit_bt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ jif.setVisible(false); } }); Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); setBounds(0, 0, 688, 470); this.setClosable(true); this.setMaximizable(true); setVisible(true); } private JButton save_bt; private JButton rm_bt; private JButton lm_bt; private JButton right_bt; private JButton left_bt; private JButton exit_bt; private JButton append_bt; private JButton delet_bt; private JButton amend_bt; private JComboBox sex_cb; private JComboBox marriage_cb; private JComboBox politicsVisage_cb; private JComboBox estate_cb; private JFrame jFrame1; private JLabel lb1; private JLabel lb10; private JLabel lb11; private JLabel lb12; private JLabel lb13; private JLabel lb14; private JLabel lb2; private JLabel lb3; private JLabel lb4; private JLabel lb5; private JLabel lb6; private JLabel lb7; private JLabel lb8; private JLabel lb9; private JList headship_ls; private JList schoolage_ls; private JList department_ls; private JTextArea remark_ta; private JTextField txt_number; private JTextField txt_name; private JTextField txt_borndate; private JTextField txt_enterdate; private JTextField txt_InDueFormDate; private JTextField theadship; private JTextField tschoolage; private JTextField tdepartment;}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -