zg.java

工资管理系统的软件.是同许设计的 是一个比较完整的工资管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
 class zg extends JFrame implements ActionListener
{   private condb con=null;
    private ResultSet rs=null;
    private String sql=null;
    private JLabel name=new JLabel("姓名");
    private JLabel sex=new JLabel("性别");
    private JLabel age=new JLabel("年龄");
    private JLabel hao=new JLabel("职工号");
    private JTextField haotx=new JTextField();
    private JLabel bm=new JLabel("所在部门");
    private JTextField nametx=new JTextField();
    private JTextField agetx=new JTextField();
    
    private JComboBox sexbox=new JComboBox();
    private JComboBox depbox=new JComboBox();
    private JButton add=new JButton("增加");
    private JButton del=new JButton("删除");
    private JButton mod=new JButton("修改");
    private JButton exit=new JButton("退出");
   public zg()
  { super("职工信息");
    setSize(500,250);
    setBackground(Color.LIGHT_GRAY);
    this.setLocationRelativeTo(this.getParent());
    setResizable(false);
    Container cont=this.getContentPane();
    cont.setLayout(null);
    name.setBounds(30,30,50,30);
    nametx.setBounds(90,30,100,30);
    sex.setBounds(210,30,50,30);
    sexbox.setBounds(270,30,60,30);
    age.setBounds(340,30,50,30);
    agetx.setBounds(400,30,60,30);
    depbox.setBounds(330,80,80,30);
    sexbox.addItem("男");
    sexbox.addItem("女"); 

    hao.setBounds(50,80,60,30);
    haotx.setBounds(110,80,130,30);
    bm.setBounds(260,80,60,30);
    
    add.setBounds(60,150,80,30);
    del.setBounds(160,150,80,30);
    mod.setBounds(260,150,80,30);
    exit.setBounds(360,150,80,30);
    cont.add(name);
    cont.add(sex);
    cont.add(age);
    cont.add(hao);
    cont.add(bm);
    cont.add(nametx);
    cont.add(sexbox);
    cont.add(agetx);
    cont.add(haotx);
    cont.add(depbox);
    cont.add(add);
    cont.add(del);
    cont.add(mod);
    cont.add(exit);
    
    depbox.addActionListener(this);
    add.addActionListener(this);
    del.addActionListener(this);
    mod.addActionListener(this);
    exit.addActionListener(this);
    setVisible(true);
    this.initbm(); 
   }
 
 public void initbm()
 { condb con=new condb();
  String sql="select * from 部门";
   try{ rs=con.getrs(con.con,sql);
        while(rs.next())
        {depbox.addItem(rs.getString("部门号"));}
        con.dbclose(con.con,rs);
        con=null;
       rs=null;
      }
    catch(Exception e2){System.out.println("部门未初始化");}
}






public void actionPerformed(ActionEvent ae)
{   con=new condb();
    if(ae.getActionCommand().equals("退出"))
      dispose();
    if(ae.getActionCommand().equals("增加"))
      { sql="insert into 职工 values ('"+haotx.getText()+"','"+
             nametx.getText()+"','"+sexbox.getSelectedItem()+"',"+agetx.getText()+
              ",'"+depbox.getSelectedItem()+"')";
        try{ con.moddb(con.con,sql);
             con.dbclose(con.con,null);
            }
        catch(Exception ue){}
        con=null;
        nametx.setText("");
      
       
        agetx.setText("");
        haotx.setText("");
      }
   if(ae.getActionCommand().equals("删除"))
     {  sql="delete  from 职工 where 职工号='"+haotx.getText()+"'";
        try{ con.moddb(con.con,sql);
           con.dbclose(con.con,null);
         }
        catch(Exception ee) {System.out.println("");}
        con=null;
      }
         
  if(ae.getActionCommand().equals("修改"))
    { sql="update 职工 set 姓名='"+nametx.getText()+"',性别='"+
            sexbox.getSelectedItem()+"',年龄="+agetx.getText()+
            ",所在部门='"+depbox.getSelectedItem()+"' where 职工号='"
            +haotx.getText()+"'";
      try{ System.out.println(sql);
           con.moddb(con.con,sql);
           con.dbclose(con.con,null);
         }
      catch(Exception ex){}
      con=null;
     }
    }
}