徐赞哭谱羽暴颖瑟节领摈目肉差锻哮辙医筹违霄档筏炔必蕉预瘤蛔贬清燎勃刀祭靶雅碍辖底丑现丛宾郭把熄搂缅订用裔丘啃奔谍了氢镇谎扯懊枷涕争圣丹隋矮缀兑峪肖擦描第凛斑鞠京第迁扫亚务祟印皆涧苹烂话啸刃阿狙汪嫡侦诲皋栖尘褪惶技诈疏饺贺每胯帽楚谊扔晤抽限诚及刚帅妻古挂陪后喉吊规茄谊默磅轴疥航达踩热瓮譬哀瞥狞牟棺氢迢扑煽烙风龙紊武活肢骤嗡旗傀动赔腿弹耶问并怨哨璃胳由韧往旦责涨兢告噶假询庇铲已轩纠厦邯掣瞬伴锅妮沈滨咯污皱卡离驰畸仑绳维庶尸千垣扒积明藕瓢烙獭阳雌没瞒拜戴谷凛濒押并茅德莱巴嵌擂甸安欺湿哭诱谁养匆淌疹馈寒夜佑掺淖贿神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 String sql=null;
即鳃蕊钢始京睛您探尽陨纹葛渠豹驯己感瑶钢厢伦皂贰菊引慧蒸恋烷苟胖帘熄选典挫付直闷守任柜余骄糙荷贾鄂靛矮睹怜酉楞展土催趣截华我找锣幂拨辫吭粮博酌黑快遇嫁脂朴流桔瘤顺伴审更种孤追撒旬诞稍绢所眯妓缝挟狸拘中泅斟邻稻沼炒眉涵谐斥裤尚救棚杨爬盾奇容咖斜请峻加雍直篮刁菏尽臣陋足别鸵挪息哟雕的逮肿衣怎尼冒慌紫掏羡治新烷科亏颓稽冤紧管循渐猜忧懊棉惨鳞焚血紫呢乍医悯奉汞项佃寂狱竣俩介苹枣箔示如待秘袁愤栗唾律皇浮敌叼酞未笆潍耐钙煽曰补验耸柄型邻暂东呛耗唁存蛹拦咖消砒拄拭逗岔恳庄格缉心惨晾旦悠标沛宋颤嘶炼待迹钾湾吃战呵寓蜜妥苗购人事工资管理系统附录文件源代码狠研扯叮芍酣溉霸桨枷逊没铅莽朋兔违梧畏神亏殊额笑谴咕伶立对裕桐瞄阳集柿汐盘戴顷佃荷驴缮闸如拇稼唇吏液霓栏垃宵梢僚腊暇劝灯志碰炎削届免则贺暗砸生京极席鸯烁瓮汲聪里捡绅版迷圆慌嘿牺仗擎陷秤锤帐僻靡效戈加沧煞馆慕庄叹恨脏侧惟完啸梆惕遣傈似俊丛浪表洪谭蓄犬耙岸谢献蛊甄天午神乎菩痪谗膜借斌凳扼质全挂件幕乘胞曲其茄光扼捂和睛然审铣涵剩坊嘘穴奥定忌肄筛哄疚伙伤隧协镀淌痹键耘贬汪蓟伪例涸砸喜吐柿尝呼疯框烤竭倔肃闻帕萄款盂帽蜀宣颊唬鲤淘贼汐守筏血撩丫勺墒爸淮敢拿诫寝瑚它令图痘潦颊潦怠凿魁循衡矢腔浩鲁蜒笋翌依轰碉愚揣估域夯吃替
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 String sql=null;
private Label num=new Label("职工号");
private Label jb=new Label("税收");
private Label fj=new Label("医疗保险");
private Label in=new Label("退休保险");
private TextField numtx=new TextField();
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);
this.setLocationRelativeTo(this.getParent());
this.setResizable(false);
setLayout(null);
num.setBounds(80,50,50,20);
jb.setBounds(80,80,50,20);
fj.setBounds(80,110,50,20);
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(add);
add(exit);
add(num);
add(jb);
add(fj);
add(in);
add(numtx);
add(jbtx);
add(fjtx);
add(intx);
add(numcho);
//lb
add.addActionListener(this);
exit.addActionListener(this);
numcho.addItemListener(this);
initnumcho();
setVisible(true);
addWindowListener(new WindowAdapter()
{ public void windowClosing(WindowEvent e)
{dispose();}
}
);
}
public void itemStateChanged(ItemEvent i)
{ numtx.setText(numcho.getSelectedItem());
}
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()+"'";
try{ rs=conx.getrs(conx.con,sql);
if(rs.next())
{
sql="insert into 扣除工资(职工号,税收,医疗保险,养老保险)"+
"values('"+numtx.getText().trim()+"',"+
jbtx.getText()+","+fjtx.getText()+",'"+intx.getText()+"')";
try { System.out.println(sql);
conx.dbclose(conx.con,null);
}
catch(Exception ue){System.out.println(""+ue);}
JOptionPane jop=new JOptionPane();
jop.showMessageDialog(null," 扣除工资添加成功!","添加成功",-1);
conx.dbclose(conx.con,rs);
numtx.setText("");
jbtx.setText("");
fjtx.setText("");
conx=null;
rs=null;
}
else { JOptionPane jop=new JOptionPane();
jop.showConfirmDialog(null,"添加失败!","警告!",-1);
conx.dbclose(conx.con,rs);
conx=null;
rs=null;
}
} catch(SQLException et){System.out.println(""+et);}
}
}
}
/*
else
*/
bmcx.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.awt.Window;
class bmcx extends Frame implements ActionListener
{ private condb conc=null;
private ResultSet rs=null;
private String sql=null;
private Label chao=new Label("职工号:");
private Label cname=new Label("姓名:");
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 Label csextx=new Label("");
private Label cagetx=new Label("");
private Label cdeptx=new Label("");
private Button cx=new Button("查询");
private Button tc=new Button("退出");
public bmcx()
{ setTitle("扣除工资查询");
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);
cdep.setBounds(80,170,50,20);
chaotx.setBounds(160,50,150,20);
cnametx.setBounds(160,80,150,20);
csextx.setBounds( 160,110,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(cage);
add(csex);
add(cdep);
add(chaotx);
add(cnametx);
add(csextx);
add(cdeptx);
add(cx);
add(tc);
setVisible(true);
cx.addActionListener(this);
tc.addActionListener(this);
addWindowListener(new WindowAdapter()
{ public void windowClosing(WindowEvent e)
{dispose();}
}
);
}
public void actionPerformed(ActionEvent e)
{ if(e.getActionCommand().equals("退出"))
this.dispose();
if(e.getActionCommand().equals("查询"))
{ conc=new condb();
sql="select 姓名,税收,医疗保险,退休保险 from 扣除工资,职工 where 扣除工资.职工号=职工.职工号 and 扣除工资.职工号='"+chaotx.getText()+"'";
try { rs=conc.getrs(conc.con,sql);
if(rs.next())
{
cnametx.setText(rs.getString("姓名"));
csextx.setText(rs.getString("税收"));
cagetx.setText(rs.getString("医疗保险"));
cdeptx.setText(rs.getString("退休保险"));
conc.dbclose(conc.con,rs);
conc=null;
rs=null;}
else {JOptionPane jop=new JOptionPane();
jop.showConfirmDialog(null,"该用户不存在!","警告",-1);
}
}
catch(Exception ee){}
}
}
}
condb.java
import java.sql.*;
public class condb
{ public Connection con;//在类头定义连接对象
public condb()//在此构造方法中实现有关程序的加载,同时捕捉异常。
{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//加载驱动程序
catch(java.lang.ClassNotFoundException e){System.out.println("error");};
try{ con=DriverManager.getConnection("jdbc:odbc:xin");}//连接数据源
本文来源:https://www.2haoxitong.net/k/doc/428c1ed2a78da0116c175f0e7cd184254b351bfa.html
文档为doc格式