wagemanage.java

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

//薪筹管理类


package classsource;


import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.util.*;

import java.sql.*;


public class WageManage extends JInternalFrame
{

	
   private JLabel lbl7=new JLabel("员工编号：");
   	
   private JLabel lbl1=new JLabel("员工姓名：");
   	
   private JLabel lbl2=new JLabel(" 福  利：");
   	
   private JLabel lbl4=new JLabel("基本工资：");
   	
   private JLabel lbl3=new JLabel(" 奖  金：");
   	
   private JLabel lbl5=new JLabel("薪资计算：");
   	
   private JLabel lbl6=new JLabel("实发工资：");


   	
   private JTextField stid=new JTextField(10);
   	
   private JTextField stname=new JTextField(10);
   	
   private JTextField stsalary=new JTextField(10);
   	
   private JTextField stboon=new JTextField(10);
   
   private JTextField stprize=new JTextField(10);
   	
   private JTextField stcounter=new JTextField(10);
   	
   private JTextField stfact=new JTextField(10);
 	
   ImageIcon icon1=new ImageIcon("image//up.gif");
	
   ImageIcon icon2=new ImageIcon("image//down.gif");
   	
   private JButton btnadd=new JButton("添加");
   
   private JButton delete=new JButton("删除");
   
   private JButton updete=new JButton("修改");
   
   private JButton save=new JButton("保存");
   	
   private JButton up=new JButton("<<");
   	
   private JButton next=new JButton(">>");



	
   public WageManage()
   {

	   	
      initComponents();
	
   }
		
   private void initComponents() 
  {
		
      setTitle("薪资信息管理");
		
      Font f=new Font("宋体",Font.PLAIN,12);

		
      getContentPane().setLayout(null);
		
      lbl7.setBounds(30,30,80,25);
		
      lbl7.setFont(f);
		
      getContentPane().add(lbl7);
		
      stid.setBounds(100,30,100,25);
		
      stid.setBorder(BorderFactory.createLineBorder(Color.black));
		      
      getContentPane().add(stid);
//--------------------------------------------------
		  
  lbl1.setBounds(30,70,80,25);
		
  lbl1.setFont(f);
		
  getContentPane().add(lbl1);
		
  stname.setBounds(100,70,100,25);
		
  stname.setBorder(BorderFactory.createLineBorder(Color.black));
		  
  getContentPane().add(stname);

        
  lbl2.setBounds(230,70,80,25);
        
  lbl2.setFont(f);
        
  getContentPane().add(lbl2);
       
  stsalary.setBounds(300,70,100,25);
        
  stsalary.setBorder(BorderFactory.createLineBorder(Color.black));
          
  getContentPane().add(stsalary);
 
//----------------------------------
         
  lbl3.setBounds(30,110,80,25);
        
  lbl3.setFont(f);
        
  getContentPane().add(lbl3);
        
  stboon.setBounds(100,110,100,25);
        
  stboon.setBorder(BorderFactory.createLineBorder(Color.black));
          
  getContentPane().add(stboon);

		
  lbl4.setBounds(230,110,80,25);
		
  lbl4.setFont(f);
		
  getContentPane().add(lbl4);
		
  stprize.setBounds(300,110,100,25);
		
  stprize.setBorder(BorderFactory.createLineBorder(Color.black));
		  
  getContentPane().add(stprize);
 
//--------------------------------
        
  lbl5.setBounds(30,150,80,25);
       
  lbl5.setFont(f);
        
  getContentPane().add(lbl5);
        
  stcounter.setBounds(100,150,100,25);
        
  stcounter.setBorder(BorderFactory.createLineBorder(Color.black));
          
  getContentPane().add(stcounter);

        
  lbl6.setBounds(230,150,80,25);
       
  lbl6.setFont(f);
        
  getContentPane().add(lbl6);
        
  stfact.setBounds(300,150,100,25);
       
  stfact.setBorder(BorderFactory.createLineBorder(Color.black));
       
  getContentPane().add(stfact);
 
//-------------------------------------------------------

      
//按钮
        
  btnadd.setBounds(30,220,60,25);
       
  btnadd.setFont(f);
       
  btnadd.setBorder(BorderFactory.createRaisedBevelBorder());
        
  getContentPane().add(btnadd);
       
  delete.setBounds(110,220,60,25);
        
  delete.setFont(f);
        
  delete.setBorder(BorderFactory.createRaisedBevelBorder());
    
  getContentPane().add(delete);
      
  updete.setBounds(190,220,60,25);
     
  updete.setFont(f);
      
  updete.setBorder(BorderFactory.createRaisedBevelBorder());
    
  getContentPane().add(updete);
       
  save.setBounds(270,220,60,25);
        
  save.setFont(f);
       
  save.setBorder(BorderFactory.createRaisedBevelBorder());
      
  getContentPane().add(save);

      
  up.setBounds(350,218,60,15);
        
  up.setBorder(BorderFactory.createRaisedBevelBorder());
      
  getContentPane().add(up);
       
  next.setBounds(350,232,60,15);
       
  next.setBorder(BorderFactory.createRaisedBevelBorder());
        
  getContentPane().add(next);

//---连接数据库----------------------------------------------------------------------------
        
  Database.joinDB();
        
//初始化数据--------
      
  String sqlw="select * from WageInformation";
       
  try
   {
          
     if(Database.query(sqlw))
        {
           	 
            Database.rs.next();
           	
            String wNumber=(""+Database.rs.getInt("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 esql)
   {
        	  
       System.out.println("薪资信息管理-初始化数据失败!");
       
   }
 
//------按钮事件--------------------------------------------------------------------------
    
  up.addActionListener(new ActionListener()
  {
          
      public void actionPerformed(ActionEvent e)
      {
          	
         try
           {
          	
               if(Database.rs.previous())
                  {
           	  
                       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 eup)
         {
          	 
            System.out.println("以到最前一条!");
          	
         }
          
     }
       
  });