java 职工信息管理系统源代码.doc

《java 职工信息管理系统源代码.doc》由会员分享，可在线阅读，更多相关《java 职工信息管理系统源代码.doc（31页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、 源代码package lesson2;import java.sql.*;public class employeepublic String num;public String name;public String sex;public String age;public String edu;public String sla;public String add;public String tel;public void init(String x1,String x2,String x3,String x4,String x5,String x6,String x7,String x8

2、)num=x1;name=x2; sex=x3;age=x4;edu=x5;sla=x6;add=x7;tel=x8;public void load(String f)try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); String url=jdbc:sqlserver:/localhost:1433;DatabaseName=employee; String userName=sa; String password=xhw; Connection conn=DriverManager.getConnection(

3、url,userName,password); if(conn!=null) System.out.println(已成功地与SQL Server 2005数据库建立连接！); Statement stmt=conn.createStatement(); stmt.executeUpdate(f); stmt.close(); catch(Exception e) e.printStackTrace(); package lesson2;import java.awt.*;import java.awt.event.*;import java.sql.*;public class lesson

4、2_1 static Frame f;CardLayout myCard;Panel p1;Panel p2;Panel p3;Panel p4;Panel p5;Panel p6;Panel p7;Panel p8;public static void main(String args) lesson2_1 test=new lesson2_1();test.go1();test.go2();test.go3();test.go4();test.go5();test.go6();test.go7();test.go8();public void go1()f=new Frame(呵 呵 !)

5、;myCard=new CardLayout();f.setLayout(myCard);p1=new Panel();Button b1,b2,b3;Label L1;TextField te1; final TextField te2;p1.setLayout(new GridBagLayout();GridBagConstraints c=new GridBagConstraints();Panel p1_1=new Panel();p1_1.setLayout(new GridBagLayout();GridBagConstraints x=new GridBagConstraints

6、();b1=new Button( 请 输 入 用 户 名 );b1.setBackground(Color.CYAN);x.insets=new Insets(50,50,50,50);x.gridx=0;x.gridy=0;x.gridwidth=1;x.gridheight=1;p1_1.add(b1,x);b2=new Button( 请 输 入 密 码 );b2.setBackground(Color.CYAN);x.gridx=0;x.gridy=5;x.gridwidth=1;x.gridheight=1;p1_1.add(b2,x);te1=new TextField(15);

7、c.insets=new Insets(40,0,40,0);x.gridx=5;x.gridy=0;x.gridwidth=1;x.gridheight=1;p1_1.add(te1,x);te2=new TextField(15);x.gridx=5;x.gridy=5;x.gridwidth=1;x.gridheight=1;p1_1.add(te2,x);L1=new Label( * * * * * * * * * *欢 迎 进 入 职 工 管 理 系 统* * * * * * * * * * * * * *);L1.setBackground(Color.CYAN);c.gridx

8、=0;c.gridy=0;c.gridwidth=0;c.gridheight=1;p1.add(L1,c);b3=new Button( 登 录 );b3.setBackground(Color.CYAN);c.gridx=0;c.gridy=10;c.gridwidth=5;c.gridheight=5;p1.add(b3,c);c.gridx=0;c.gridy=20;c.gridwidth=5;c.gridheight=5;p1.add(p1_1,c);p1.setBackground(Color.green);f.add(p1,First);myCard.show(f,First);

9、 f.setSize(600,600); f.setVisible(true);f.addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent e)System.exit(0););b3.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) String x=te2.getText(); int y=Integer.parseInt(x); if(y=106) myCard.show(f,Second); );

10、 public void go2()p2=new Panel();Button b1,b2,b3,b4,b5,b6;Label L1;p2.setLayout(new GridBagLayout();GridBagConstraints c=new GridBagConstraints();c.insets=new Insets(50,0,8,0);b1 = new Button(1 职 工 信 息 录 入);b1.setBackground(Color.CYAN);c.gridx=1;c.gridy=50;c.gridwidth=5;c.gridheight=50;p2.add(b1,c);

11、b2=new Button(2 职 工 信 息 浏 览);b2.setBackground(Color.CYAN);c.gridx=1;c.gridy=100;c.gridwidth=5;c.gridheight=50;p2.add(b2,c);b3=new Button(3 职 工 信 息 查 询);b3.setBackground(Color.CYAN);c.gridx=1;c.gridy=150;c.gridwidth=5;c.gridheight=50;p2.add(b3,c);b4=new Button(4 职 工 信 息 排 序);b4.setBackground(Color.CY

12、AN);c.gridx=1;c.gridy=200;c.gridwidth=5;c.gridheight=50;p2.add(b4,c);b5=new Button(5 职 工 信 息 修 改);b5.setBackground(Color.CYAN);c.gridx=1;c.gridy=250;c.gridwidth=5;c.gridheight=50;p2.add(b5,c);b6=new Button(6 职 工 信 息 删 除);b6.setBackground(Color.CYAN);c.gridx=1;c.gridy=300;c.gridwidth=5;c.gridheight=5

13、0;p2.add(b6,c);L1=new Label( * * * * * * * *欢 迎 进 入 职 工 管 理 系 统* * * * * * * * * *);L1.setBackground(Color.CYAN);c.gridx=1;c.gridy=0;c.gridwidth=5;c.gridheight=10;p2.add(L1,c);p2.setBackground(Color.green);f.add(p2,Second);b1.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e)

14、 myCard.show(f,Third); );b2.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) myCard.show(f,Fourth); );b3.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) myCard.show(f,Fifth); );b4.addMouseListener(new MouseAdapter() public void mouseClicked(MouseE

15、vent e) myCard.show(f,Sixth); );b5.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) myCard.show(f,Seventh); );b6.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) myCard.show(f,Eighth); );public void go3()p3=new Panel();p3.setLayout(new GridBagLayou

16、t();GridBagConstraints c=new GridBagConstraints();Button b1,b2,b3,b4,b5,b6,b7,b8,b9,b10;final TextField te1,te2,te3,te4,te5,te6,te7,te8;Label L1;c.insets=new Insets(60,50,0,0); L1=new Label(* * * * * * * * * * * * * * * 请 输 入 下 面 信 息 * * * * * * * * * * * * * * * *);L1.setBackground(Color.CYAN);c.gr

17、idx=0;c.gridy=0;c.gridwidth=0;c.gridheight=1;p3.add(L1,c);b1=new Button( 工 号 );b1.setBackground(Color.CYAN);c.gridx=0;c.gridy=10;c.gridwidth=1;c.gridheight=1;p3.add(b1,c);b2=new Button( 姓 名 );b2.setBackground(Color.CYAN);c.gridx=35;c.gridy=10;c.gridwidth=1;c.gridheight=1;p3.add(b2,c);b3=new Button(

18、性 别 );b3.setBackground(Color.CYAN);c.gridx=0;c.gridy=30;c.gridwidth=1;c.gridheight=1;p3.add(b3,c);b4=new Button( 年 龄 );b4.setBackground(Color.CYAN);c.gridx=35;c.gridy=30;c.gridwidth=1;c.gridheight=1;p3.add(b4,c);b5=new Button( 学 历 );b5.setBackground(Color.CYAN);c.gridx=0;c.gridy=50;c.gridwidth=1;c.g

19、ridheight=1;p3.add(b5,c);b6=new Button( 工 资 );b6.setBackground(Color.CYAN);c.gridx=35;c.gridy=50;c.gridwidth=1;c.gridheight=1;p3.add(b6,c);b7=new Button( 住 址 );b7.setBackground(Color.CYAN);c.gridx=0;c.gridy=70;c.gridwidth=1;c.gridheight=1;p3.add(b7,c);b8=new Button( 电 话 );b8.setBackground(Color.CYAN

20、);c.gridx=35;c.gridy=70;c.gridwidth=1;c.gridheight=1;p3.add(b8,c);b9=new Button( 提 交 );b9.setBackground(Color.CYAN);c.gridx=10;c.gridy=100;c.gridwidth=1;c.gridheight=1;p3.add(b9,c);b10=new Button( 返 回 );b10.setBackground(Color.CYAN);c.gridx=35;c.gridy=100;c.gridwidth=1;c.gridheight=1;p3.add(b10,c);

21、te1=new TextField(10);c.gridx=10;c.gridy=10;c.gridwidth=1;c.gridheight=1;p3.add(te1,c);te2=new TextField(10);c.gridx=37;c.gridy=10;c.gridwidth=1;c.gridheight=1;p3.add(te2,c);te3=new TextField(10);c.gridx=10;c.gridy=30;c.gridwidth=1;c.gridheight=1;p3.add(te3,c);te4=new TextField(10);c.gridx=37;c.grid

22、y=30;c.gridwidth=1;c.gridheight=1;p3.add(te4,c);te5=new TextField(10);c.gridx=10;c.gridy=50;c.gridwidth=1;c.gridheight=1;p3.add(te5,c);te6=new TextField(10);c.gridx=37;c.gridy=50;c.gridwidth=1;c.gridheight=1;p3.add(te6,c);te7=new TextField(10);c.gridx=10;c.gridy=70;c.gridwidth=1;c.gridheight=1;p3.ad

23、d(te7,c);te8=new TextField(10);c.gridx=37;c.gridy=70;c.gridwidth=1;c.gridheight=1;p3.add(te8,c);p3.setBackground(Color.green);f.add(p3,Third);b9.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) employee e1=new employee(); e1.init(te1.getText(),te2.getText(),te3.getText(),te

24、4.getText(), te5.getText(),te6.getText(),te7.getText(),te8.getText(); String x=; String y=; String z=,; String w=); String sql=insert into xhw values(; sql=sql+x+e1.num+y+z+x+e1.name+y+z+x+e1.sex+y+z+x+e1.age+y+z+x+e1.edu+y+z +x+e1.sla+y+z+x+e1.add+y+z+x+e1.tel+y+w; e1.load(sql); te1.setText(); te2.

25、setText(); te3.setText(); te4.setText(); te5.setText(); te6.setText(); te7.setText(); te8.setText(); );b10.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) myCard.show(f,Second); );public void go4()p4=new Panel();p4.setLayout(new GridBagLayout();GridBagConstraints c=new Gri

26、dBagConstraints();Button b1,b2;Label L1;final TextArea ta;c.insets=new Insets(60,0,0,0);L1=new Label(* * * * * * * * * * * * * * * 欢 迎 进 入 信 息 浏 览 界 面 * * * * * * * * * * * * * * * *);L1.setBackground(Color.CYAN);c.gridx=0;c.gridy=0;c.gridwidth=0;c.gridheight=1;p4.add(L1,c); b1=new Button( 浏 览 );b1.

27、setBackground(Color.CYAN);c.gridx=0;c.gridy=10;c.gridwidth=1;c.gridheight=1;p4.add(b1,c);b2=new Button( 返 回 );b2.setBackground(Color.CYAN);c.gridx=0;c.gridy=20;c.gridwidth=1;c.gridheight=1;p4.add(b2,c);ta= new TextArea(15,50);c.gridx=0;c.gridy=11;c.gridwidth=1;c.gridheight=1;p4.add(ta,c);p4.setBackg

28、round(Color.green);f.add(p4,Fourth);b1.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); String url=jdbc:sqlserver:/localhost:1433;DatabaseName=employee; String userName=sa; String password=xhw; Connection conn

29、=DriverManager.getConnection(url,userName,password); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(select * from xhw); employee em =new employee10; int i=0; while(rs.next() employee em1=new employee(); em1.num=rs.getString(工号); em1.name=rs.getString(姓名); em1.sex=rs.getString(

30、性别); em1.age=rs.getString(年龄); em1.edu=rs.getString(学历); em1.sla=rs.getString(工资); em1.add=rs.getString(住址); em1.tel=rs.getString(电话); emi=em1; i+; String s = 工号t姓名t性别t年龄t学历t工资t住址t电话n; for(int j=0;ji;j+) s=s+emj.num+t+emj.name+t+emj.sex+t+emj.age+t+ emj.edu+t+emj.sla+t+emj.add+t+emj.tel+nn; ta.setTe

31、xt(s); rs.close(); stmt.close(); catch(Exception e1) e1.printStackTrace(); );b2.addMouseListener(new MouseAdapter() public void mouseClicked(MouseEvent e) ta.setText(); myCard.show(f,Second); );public void go5()p5=new Panel();p5.setLayout(new GridBagLayout();GridBagConstraints c=new GridBagConstrain

32、ts();c.insets=new Insets(40,0,0,0);Panel p5_2=new Panel();p5_2.setLayout(new GridBagLayout();GridBagConstraints x=new GridBagConstraints();x.insets=new Insets(30,60,0,80);Button b1,b2,b3,b4; final TextField t1;final TextField t2; final TextArea ta;Label L1;b1=new Button( 查 询 名 称 );b1.setBackground(C

33、olor.CYAN);x.gridx=0;x.gridy=0;x.gridwidth=2;x.gridheight=1;p5_2.add(b1,x);b2=new Button( 查 询 范 围 );b2.setBackground(Color.CYAN);x.gridx=0;x.gridy=5;x.gridwidth=2;x.gridheight=1;p5_2.add(b2,x);b3=new Button( 查 询 );b3.setBackground(Color.CYAN);x.gridx=0;x.gridy=10;x.gridwidth=2;x.gridheight=1;p5_2.ad

34、d(b3,x);b4=new Button( 返 回 );b4.setBackground(Color.CYAN);x.gridx=20;x.gridy=10;x.gridwidth=1;x.gridheight=1;p5_2.add(b4,x);t1 = new TextField(10);x.gridx=20;x.gridy=0;x.gridwidth=1;x.gridheight=1;p5_2.add(t1,x);t2=new TextField(10);x.gridx=20;x.gridy=5;x.gridwidth=1;x.gridheight=1;p5_2.add(t2,x);L1=new Label( * * * * * * * * * * * 欢 迎 进 入 职 工 信 息 查 询 界 面 * * * * * * * * * * *);L1.setBackground(Color.CYAN);c.gridx=0;c.gridy=0;c.gridwidth=0;c.gridheight=1;p5.add(L1,c);c.gridx=0;c.gridy=5;c.gridwidth=1;c.gridheight=1;p5.add(p5_2,c); ta= new TextAre