人事工资管理系统源代码 java.doc

bm.java

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import javax.swing.*;

class bm extends Frame implements ActionListener,ItemListener

{ private condb conx=null;

private ResultSet rs=null;

private TextField jbtx=new TextField();

private TextField fjtx=new TextField();

private TextField intx=new TextField();

private Choice numcho=new Choice();

private Button add=new Button("增加");

private Button exit=new Button("退出");

public bm()

{ setTitle("扣除工资");

setSize(400,300);

setBackground(Color.LIGHT_GRAY);

in.setBounds(80,140,50,20);

numtx.setBounds(160,50,100,20);

jbtx.setBounds(160,80,100,20);

fjtx.setBounds(160,110,100,20);

intx.setBounds(160,140,100,20);

numcho.setBounds(160,170,100,20);

add.setBounds(60,220,50,20);

exit.setBounds(300,220,50,20);

add(num);

add(jb);

add(fj);

add(in);

add(numtx);

add(jbtx);

add(fjtx);

exit.addActionListener(this);

numcho.addItemListener(this);

setVisible(true);

addWindowListener(new WindowAdapter()

{ public void windowClosing(WindowEvent e)

{dispose();}

}

public void initnumcho()

{ conx=new condb();

sql="select * from 扣除工资 ";

numcho.removeAll();

try { rs=conx.getrs(conx.con,sql);

while(rs.next())

{numcho.add(rs.getString("职工号"));}

conx.dbclose(conx.con,rs);

conx=null;

rs=null;

catch(Exception eo){}

}

public void actionPerformed(ActionEvent e)

{ conx=new condb();

if(e.getActionCommand().equals("退出"))

this.dispose();

if(e.getActionCommand().equals("增加"))

{

sql="select * from 扣除工资 where 职工号='"+numtx.getText()+"'";

jbtx.getText()+","+fjtx.getText()+",'"+intx.getText()+"')";

try { System.out.println(sql);

}

catch(Exception ue){System.out.println(""+ue);}

JOptionPane jop=new JOptionPane();

conx.dbclose(conx.con,rs);

else { JOptionPane jop=new JOptionPane();

conx.dbclose(conx.con,rs);

conx=null;

rs=null;

}

} catch(SQLException et){System.out.println(""+et);}

}

}

/*

*/

import java.awt.*;

private ResultSet rs=null;

private String sql=null;

private Label csex=new Label("税收:");

private Label cage=new Label("医疗保险:");

private Label cdep=new Label("退休保险: ");

private TextField chaotx=new TextField();

private Label cnametx=new Label("");

private Button cx=new Button("查询");

private Button tc=new Button("退出");

public bmcx()

setSize(400,250);

setBackground(Color.LIGHT_GRAY);

this.setLocationRelativeTo(this.getParent());

this.setResizable(false);

setLayout(null);

chao.setBounds(80,50,50,20);

cname.setBounds(80,80,50,20);

csex.setBounds(80,110,50,20);

cage.setBounds(80,140,50,20);

chaotx.setBounds(160,50,150,20);

cnametx.setBounds(160,80,150,20);

cagetx.setBounds(160,140,150,20);

cdeptx.setBounds(140,170,150,20);

cx.setBounds(60,205,50,20);

tc.setBounds(300,205,50,20);

add(chao);

add(cname);

add(cagetx);

add(cdeptx);

add(cx);

add(tc);

setVisible(true);

tc.addActionListener(this);

addWindowListener(new WindowAdapter()

{ public void windowClosing(WindowEvent e)

{dispose();}

}

{ if(e.getActionCommand().equals("退出"))

if(e.getActionCommand().equals("查询"))

{ conc=new condb();

职工.职工号 and 扣除工资.职工号='"+chaotx.getText()+"'";

try { rs=conc.getrs(conc.con,sql);

if(rs.next())

{

cnametx.setText(rs.getString("姓名"));

csextx.setText(rs.getString("税收"));