wagemanage.java

详细说明： —增加— 增加员工的基本信息、培训信息、奖罚信息、薪资信息 —删除— 可根据员工的编号及姓名等资料的删除 —修改— 用户可以对员工的姓名和编号、进行修改。 —查询—

  next.addActionListener(new ActionListener()
   {
          
      public void actionPerformed(ActionEvent e)
        {
           	 
            try
              {
           	 
                  if(Database.rs.next())
                    {
           	  
                        String wNumber=(""+Database.rs.getString("W_Number"));
           	  
                        String wName=Database.rs.getString("W_Name");
           	  
                        String wBasicWage=Database.rs.getString("W_BasicWage");
           	
                        String wBoon=Database.rs.getString("W_Boon");
           	  
                        String wBonus=Database.rs.getString("W_Bonus");
           	 
                        String wCountMethod=Database.rs.getString("W_CountMethod");
           	                         
                        String wFactWage=Database.rs.getString("W_FactWage");
           	 
                        stid.setText(wNumber);
           	  
                        stname.setText(wName);
           	 
                        stsalary.setText(wBasicWage);
        	  
                        stboon.setText(wBoon);
        	  
                        stprize.setText(wBonus);
        	  
                        stcounter.setText(wCountMethod);
        	  
                        stfact.setText(wFactWage);
           	 
                    }
           	 
              }
           	
           catch(Exception enext)
            {
           	 	
                System.out.println("以到最后一条");
           	 
             }
           
        }
       
    });

//为添加删除保存修改按钮加事件----------------------------------------
     
//添加
       btnadd.addActionListener(new ActionListener()
  {
       
     public void actionPerformed(ActionEvent e)
      {
           	
         save.setEnabled(true);
           	
         stid.setText("");
           	
         stid.setEditable(false);
           	
         stname.setText("");
           	
         stsalary.setText("");
        	
         stboon.setText("");
        	
         stprize.setText("");
        	
         stcounter.setText("");
        	
         stfact.setText("");
        
      }
     
   });
     
//保存
     
  save.addActionListener(new ActionListener()
   {
        
      public void actionPerformed(ActionEvent e)
        {
        	
           if(stname.getText().equals("")||stsalary.getText().equals("")||stboon.getText().equals("")||
stprize.getText                            ().equals("")||stcounter.getText().equals("")||stfact.getText().equals(""))
              {
        		
                  System.out.println("以上信息必须填写!");
        	
              }
        	
           else
              {
           	
                 // String wNumber=stid.getText();
           	  
                      String wName=stname.getText();
           	 
                      String wBasicWage=stsalary.getText();
           	  
                      String wBoon=stboon.getText();
           	  
                      String wBonus=stprize.getText();
           	  
                      String wCountMethod=stcounter.getText();
           	  
                      String wFactWage=stfact.getText();
           	  
                      String Insert="insert WageInformation valus                                                                                                                                   ('"+wName+"','"+wBasicWage+"','"+wBoon+"','"+wBonus+"','"+wCountMethod+"','"+wFactWage+"')";
                      try
                       {
              	
                          if(Database.executeSQL(Insert))
                             {
              		
                                 stid.setEditable(true);
              		
                                 save.setEnabled(false);
              		
                                 new JOptionPane().showMessageDialog(null,"添加数据成功！");
              		                                                    Database.joinDB();
              		
                                 String sql="select * from WageInformation";
              		
                                 Database.query(sql);
              		
                                 Database.rs.last();

		           	  
                                 String wNumber1=(""+Database.rs.getString("W_Number"));
		           	                                                    String wName1=Database.rs.getString("W_Name");
		           	                                                                    String wBasicWage1=Database.rs.getString("W_BasicWage");
		           	                   
                                 String wBoon1=Database.rs.getString("W_Boon");
		           	                                   
                                 String wBonus1=Database.rs.getString("W_Bonus");
		           	                                   
                                 String wCountMethod1=Database.rs.getString("W_CountMethod");
		           	                                                    String wFactWage1=Database.rs.getString("W_FactWage");
		           	                                                    stid.setText(wNumber1);
		           	  
                                 stname.setText(wName1);
		           	  
                                 stsalary.setText(wBasicWage1);
		        	 
                                 stboon.setText(wBoon1);
		        	  
                                 stprize.setText(wBonus1);
		        	  
                                 stcounter.setText(wCountMethod1);
		        	  
                                 stfact.setText(wFactWage1);
                
                             }
                
                           else
                             {
   	  				
                                  new JOptionPane().showMessageDialog(null,"添加数据不成功！");
                
                             }
              
                        }
             
                     catch(Exception esave)
                       {
   	  				
                           new JOptionPane().showMessageDialog(null,"添加数据不成功！");
              
                       }
         	
                 }
        
            }

     
      });
   
//删除
   
  delete.addActionListener(new ActionListener()
   {
   	  
      public void actionPerformed(ActionEvent edel)
        {
   	  	
           try
             {
   	  	  
                String sqle="delete from WageInformation where W_Number ='"+stid.getText()+"'";
   	  	   
                System.out.println(sqle);
   	      
                if(Database.executeSQL(sqle))
                  {
   			  
                     new JOptionPane().showMessageDialog(null,"数据删除成功！");
   			                                          Database.joinDB();
   	  		  
                     String sqll="select * from WageInformation";
   	  		                       
                     Database.query(sqll);
   	  		 
                     Database.rs.last();
           	  
                     String wNumber1=(""+Database.rs.getString("W_Number"));
           	  
                     String wName1=Database.rs.getString("W_Name");
           	  
                     String wBasicWage1=Database.rs.getString("W_BasicWage");
           	                       
                     String wBoon1=Database.rs.getString("W_Boon");
           	  
                     String wBonus1=Database.rs.getString("W_Bonus");
           	 
                     String wCountMethod1=Database.rs.getString("W_CountMethod");
           	                       
                     String wFactWage1=Database.rs.getString("W_FactWage");
	                               
                     stid.setText(wNumber1);
           	  
                     stname.setText(wName1);
           	  
                     stsalary.setText(wBasicWage1);
        	  
                     stboon.setText(wBoon1);
        	  
                     stprize.setText(wBonus1);
        	 
                     stcounter.setText(wCountMethod1);
        	  
                     stfact.setText(wFactWage1);
   	     
                  }
   	   
              }
   	  
           catch(Exception edelete)
             {
   	   	  
                System.out.println("数据删除失败!");
   	   
             }
   	  
        }

   
   });
  
//修改
   
  updete.addActionListener(new ActionListener()
   {
      
      public void actionPerformed(ActionEvent eupd)
        {
      	 
           try
             {
   			
                 String supdate="update WageInformation set W_Name='"+ stname.getText()+"',W_BasicWage='"+                                          stid.getText()+"',W_Boon='"+stboon.getText()+"',W_Bonus='"+stprize.getTex()                                                                 +"',W_CountMethod='"+stcounter.getText()+"',W_FactWage='"+stfact.getText()+"'where                           W_Number='"+ stid.getText()+"'";
      	 
                 if(Database.executeSQL(supdate))
                    {
   			  
                       new JOptionPane().showMessageDialog(null,"数据修改成功！");
   			                                              Database.joinDB();
   	  		 
                       String sqll="select * from WageInformation";
   	  		                                                Database.query(sqll);
   	  		  
                       Database.rs.last();
           	  
                       String wNumber1=(""+Database.rs.getString("W_Number"));
           	
                       String wName1=Database.rs.getString("W_Name");
           	 
                       String wBasicWage1=Database.rs.getString("W_BasicWage");
           	                        
                       String wBoon1=Database.rs.getString("W_Boon");
           	  
                       String wBonus1=Database.rs.getString("W_Bonus");
           	  
                       String wCountMethod1=Database.rs.getString("W_CountMethod");
           	                         
                       String wFactWage1=Database.rs.getString("W_FactWage");
	                                 
                       stid.setText(wNumber1);
           	 
                       stname.setText(wName1);
           	  
                       stsalary.setText(wBasicWage1);
        	  
                       stboon.setText(wBoon1);
        	  
                       stprize.setText(wBonus1);
        	  
                       stcounter.setText(wCountMethod1);
        	  
                       stfact.setText(wFactWage1);
        	
                    }
      	 
              }
      	
           catch(Exception eupdete)
             {
      	 	
                System.out.println("修改数据失败!");
      	 
             }
      
        }


   
   });

//---------------------------------------------------------------------------------
		   
   setSize(460,350);
		
   this.setClosable(true);
		
   setVisible(true);
		
  }

	
}