工资系统代码JAVA版

1、工资系统代码/*系统欢迎界面*/importjava.awt.FlowLayout;importjava.awt.event.*;importjavax.swing.*;SuppressWarnings(serial)classWagesSystemextendsJFrameimplementsActionListenerJFrameframe=newJFrame(欢迎进入工资管理系统)；JButtonbuttonl=newJButton(进入系统)；JButtonbutton2=newJButton(退出系统)；ImageIconim=newImageIcon(1.jpg);JLabela1

2、=newJLabel(im);voidCreate()JPanelpcontentPane=(JPanel)frame.getContentPane();pcontentPane.add(a1);pcontentPane.setLayout(newFlowLayout();pcontentPane.add(button1);pcontentPane.add(button2);pcontentPane.setVisible(true);button1.addActionListener(this);button2.addActionListener(this);frame.setDefaultC

3、loseOperation(JFrame.EXIT_ON_CLOSE);frame.pack();frame.setLocationRelativeTo(null);frame.setVisible(true);publicstaticvoidmain(Stringargs)WagesSystemdome=newWagesSystem();dome.Create();publicvoidactionPerformed(ActionEvente)if(button1.equals(e.getSource()DLdl=newDL();dl.create();frame.dispose();if(b

4、utton2.equals(e.getSource()System.exit(0);/*登录界面*/importjava.awt.HeadlessException;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swi

5、ng.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPasswordField;importjavax.swing.JTextField;.*;importjava.sql.*;SuppressWarnings(serial)classDLextendsJFrameimplementsActionListenerNetConnsql;Statementsqll;ResultSetrs;JFrameframe=newJFrame(

6、职工/管理员登陆)；JLabe11abe11=newJLabel(用户名)；JLabe11abe12=newJLabe1(密码)；JButtonlogonButtonl=newJButton(系统管理员登录);JButton1ogonButton2=newJButton(教职工登录)；JButton1ogonButton3=newJButton(财务管理员登录);JButtoncancelButton=newJButton(退出)；JTextFie1dusername=newJTextFie1d(9);JPasswordFie1dpassword=newJPasswordFie1d(9);st

7、aticStringt1;staticStringt2;voidcreate()frame.setLayout(null);label1.setBounds(60,20,50,20);frame.add(label1);username.setBounds(130,20,150,20);frame.add(username);label2.setBounds(60,50,50,20);frame.add(label2);password.setBounds(130,50,150,20);frame.add(password);logonButton1.setBounds(100,90,150,

8、20);frame.add(logonButton1);logonButton2.setBounds(100,120,150,20);frame.add(logonButton2);logonButton3.setBounds(100,150,150,20);frame.add(logonButton3);cancelButton.setBounds(100,180,150,20);frame.add(cancelButton);logonButton1.addActionListener(this);logonButton2.addActionListener(this);logonButt

9、on3.addActionListener(this);cancelButton.addActionListener(this);sql=newNetConn();/建立数据库连接frame.setSize(350,250);frame.setLocationRelativeTo(null);frame.setVisible(true);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);SuppressWarnings(deprecation)publicvoidactionPerformed(ActionEvente)t1=userna

10、me.getText();t2=password.getText();/系统管理员登录if(e.getSource()=logonButton1)if(username.getText().equals(admin)=true&(password.getText().equals(admin)=true)登录成功！);登录成功！);frame.dispose();elseJOptionPane.showMessageDialog(null,输入用户名或密码错误！);/教职工登陆if(e.getSource()=logonButton2)sqll=sql.connect();tryrs=sqll

11、.executeQuery(SELECT*FROMuser_teacherwherename=+username.getText()+);Stringsname,spass;if(rs.next()sname=rs.getString(2);spass=rs.getString(3);if(password.getText().trim().equals(spass)&(username.getText().trim().equals(sname)JOptionPane.showMessageDialog(this,登录成功！);Teacher_Pa=newTeacher_P();a.crea

12、t(rs.getString(1);frame.dispose();elseJOptionPane.showMessageDialog(null,输入用户名或密码错误！);elseJOptionPane.showMessageDialog(null,用户不存在！);catch(SQLExceptione2)/TODO自动生成的catch块e2.printStackTrace();/财务登陆if(e.getSource()=logonButton3)sqll=sql.connect();tryrs=sqll.executeQuery(SELECT*FROMuser_cwwherename=+us

13、ername.getText()+);Stringsname,spass;if(rs.next()sname=rs.getString(2);spass=rs.getString(3);if(password.getText().trim().equals(spass)&(username.getText().trim().equals(sname)JOptionPane.showMessageDialog(this,登录成功！);CWa=newCW();a.create(rs.getString(1);frame.dispose();elseJOptionPane.showMessageDi

14、alog(null,输入用户名或密码错误！);elseJOptionPane.showMessageDialog(null,用户不存在！);catch(SQLExceptione2)/TODO自动生成的catch块e2.printStackTrace();/退出if(cancelButton.equals(e.getSource()System.exit(0);/*数据库链接*/importjava.sql.*;/数据库联接类publicclassNetConnConnectioncon;Statementsql;publicStatementconnect()try/载入驱动程序字符串Cla

15、ss.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);catch(ClassNotFoundExceptione1)try通过JDBCURL得到Connetction对象con=DriverManager.getConnection(jdbc:sqlserver:/localhost:1433;DatabaseName=gzxt,sa,123456);/通过Connection对象创建Statement对象sql=con.createStatement();catch(SQLExceptione2)returnsql;/*系统管理员界

16、面*/importjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JDialog;importjavax.swing.JFrame;importjavax.swing.JL

17、abel;importjavax.swing.JPasswordField;importjavax.swing.JScrollPane;importjavax.swing.JTabbedPane;importjavax.swing.JTable;importjavax.swing.JTextField;SuppressWarnings(serial)classxtglyextendsJFrameimplementsActionListenerJFrameframe=newJFrame(教职工信息查询及密码修改);Objecta,b;Objectcolname=工号，姓名,密码;NetConns

18、ql;Statementsqll;ResultSetrs;JTabletable,table2;JButtonButtonl=newJButton(添加教职工)；JButtonButton2=newJButton(添力口财务管理员”)；JButtonButton3=newJButton(修改密码)；JButtonButton4=newJButton(刷新)；JTabbedPanetab=newJTabbedPane(JTabbedPane.TOP);inti=0;xtgly()frame.setLayout(null);sql=newNetConn();sqll=sql.connect();a

19、=newObject303;b=newObject303;tryStringtemp=select*fromuser_cw;rs=sqll.executeQuery(temp);while(rs.next()ai0=rs.getString(1);ai1=rs.getString(2);ai2=rs.getString(3);i+;i=0;Stringtemp2=select*fromuser_teacher;rs=sqll.executeQuery(temp2);while(rs.next()bi0=rs.getString(1);bi1=rs.getString(2);bi2=rs.get

20、String(3);i+;catch(SQLExceptione)/TODO自动生成的catch块e.printStackTrace();table=newJTable(a,colname);table.setEnabled(false);table2=newJTable(b,colname);table2.setEnabled(false);JScrollPaneJSP=newJScrollPane(table);JScrollPaneJSP2=newJScrollPane(table2);tab.add(JSP,财务管理员)；tab.add(JSP2,教职工)；tab.setBounds(

21、0,0,350,180);Button1.setBounds(1,185,110,20);Button1.addActionListener(this);Button2.setBounds(115,185,125,20);Button2.addActionListener(this);Button3.setBounds(245,185,89,20);Button3.addActionListener(this);Button4.setBounds(260,0,75,20);Button4.addActionListener(this);frame.add(Button1);frame.add(

22、Button2);frame.add(Button3);frame.add(Button4);frame.add(tab);frame.setSize(350,250);frame.setLocationRelativeTo(null);frame.setVisible(true);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);publicvoidactionPerformed(ActionEvente)/添加教职工if(e.getSource()=Button1)Add_teacheradd1=newAdd_teacher();/添

23、加财务管理员if(e.getSource()=Button2)Add_cwadd2=newAdd_cw();/修改密码if(e.getSource()=Button3)Change_mimachange=newChange_mima();if(e.getSource()=Button4)i=0;tryStringtemp=select*fromuser_cw;rs=sqll.executeQuery(temp);while(rs.next()ai0=rs.getString(1);ai1=rs.getString(2);ai2=rs.getString(3);i+;i=0;Stringtemp

24、2=select*fromuser_teacher;rs=sqll.executeQuery(temp2);while(rs.next()bi0=rs.getString(1);bi1=rs.getString(2);bi2=rs.getString(3);i+;catch(SQLExceptione1)/TODO自动生成的catch块e1.printStackTrace();table.removeAll();table2.removeAll();table=newJTable(a,colname);table.setEnabled(false);table2=newJTable(b,col

25、name);table2.setEnabled(false);tab.updateUI();/*添加财务管理人员*/importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JDialog;importjavax.swing.JLabel;importjavax.swing.

26、JOptionPane;importjavax.swing.JPasswordField;importjavax.swing.JTextField;publicclassAdd_cwimplementsActionListenerJDialoguser_cw=newJDialog();JLabelno,name,key,re_key;JTextFielduser_no,user_name;JPasswordFieldpass,aenter;JButtonbutton1,button2;NetConnsql;Statementsqll;ResultSetrs;Add_cw()user_cw.se

27、tTitle(添加财务管理员)；user_cw.setLayout(null);no=newJLabel(工号：);user_no=newJTextField(,10);user_no.setBounds(115,5,120,20);no.setBounds(20,5,80,20);name=newJLabel(姓名：);user_name=newJTextField(,10);user_name.setBounds(115,30,120,20);name.setBounds(20,30,80,20);key=newJLabel(密码：);pass=newJPasswordField(,10)

28、;pass.setEchoChar(*);pass.setBounds(115,55,120,20);key.setBounds(20,55,80,20);re_key=newJLabel(确认密码:)；aenter=newJPasswordField(,10);aenter.setEchoChar(*);aenter.setBounds(115,80,120,20);re_key.setBounds(20,80,80,20);button1=newJButton(确认)；button1.setBounds(50,110,80,20);button1.addActionListener(thi

29、s);button2=newJButton(取消)；button2.setBounds(170,110,80,20);button2.addActionListener(this);user_cw.add(no);user_cw.add(name);user_cw.add(key);user_cw.add(re_key);user_cw.add(user_no);user_cw.add(user_name);user_cw.add(pass);user_cw.add(aenter);user_cw.add(button1);user_cw.add(button2);user_cw.setSiz

30、e(300,180);user_cw.setModal(true);user_cw.setLocationRelativeTo(null);user_cw.setVisible(true);publicvoidactionPerformed(ActionEvente)if(e.getSource()=button1)Strings=aenter.getText().trim();if(!(pass.getText().trim().equals(s)JOptionPane.showMessageDialog(null,两次输入的密码不一致！);elseif(pass.getText().tri

31、m().equals()|user_no.getText().trim().equals()|user_name.getText().trim().equals()JOptionPane.showMessageDialog(null,输入的信息不全，请填写完整！);elsetrysql=newNetConn();sqll=sql.connect();/根据用户添加的用户名进行选择rs=sqll.executeQuery(SELECT*FROMuser_cwwhereno=+user_no.getText()+);/如果已经存在同名的用户，则显示错误提示if(rs.next()JOptionPa

32、ne.showMessageDialog(null,”用户已经存在,添加失败！);/如果不存在用户名，则将用户新添加信息添加到数据库中else/ints1=Integer.parseInt(user_no.getText().trim();Strings1=+user_no.getText().trim()+;Strings2=+user_name.getText().trim()+;Strings3=+pass.getText().trim()+;Stringtemp=INSERTINTOuser_cwVALUES(+s1+,+s2+,+s3+);sqll.executeUpdate(tem

33、p);JOptionPane.showMessageDialog(null,”用户添加成功!”)；catch(SQLExceptione1)e1.printStackTrace();if(e.getSource()=button2)user_cw.dispose();/*添加教职工用户*/importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importja

34、vax.swing.JButton;importjavax.swing.JDialog;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPasswordField;importjavax.swing.JTextField;publicclassAdd_teacherimplementsActionListenerJDialoguser_teacher=newJDialog();JLabelno,name,key,re_key,yhk_num,zhiwu;JTextFielduser_no,use

35、r_name,user_yhk_num,user_zhiwu;JPasswordFieldpass,aenter;JButtonbutton1,button2;NetConnsql;Statementsqll;ResultSetrs;Add_teacher()user_teacher.setTitle(添加教职工)；user_teacher.setLayout(null);no=newJLabel(工号：);user_no=newJTextField(,10);user_no.setBounds(115,5,120,20);no.setBounds(20,5,80,20);name=newJL

36、abel(姓名：);user_name=newJTextField(,10);user_name.setBounds(115,30,120,20);name.setBounds(20,30,80,20);key=newJLabel(密码：);pass=newJPasswordField(,10);pass.setEchoChar(*);pass.setBounds(115,55,120,20);key.setBounds(20,55,80,20);re_key=newJLabel(确认密码:)；aenter=newJPasswordField(,10);aenter.setEchoChar(*

37、);aenter.setBounds(115,80,120,20);re_key.setBounds(20,80,80,20);yhk_num=newJLabel(银行卡号:)；user_yhk_num=newJTextField(,10);user_yhk_num.setBounds(115,105,120,20);yhk_num.setBounds(20,105,80,20);zhiwu=newJLabel(职务：);user_zhiwu=newJTextField(,10);user_zhiwu.setBounds(115,130,120,20);zhiwu.setBounds(20,1

38、30,80,20);button1=newJButton(确认)；button1.setBounds(50,160,80,20);button1.addActionListener(this);button2=newJButton(取消)；button2.setBounds(170,160,80,20);button2.addActionListener(this);user_teacher.add(no);user_teacher.add(name);user_teacher.add(key);user_teacher.add(re_key);user_teacher.add(yhk_num

39、);user_teacher.add(zhiwu);user_teacher.add(user_no);user_teacher.add(user_name);user_teacher.add(pass);user_teacher.add(aenter);user_teacher.add(user_yhk_num);user_teacher.add(user_zhiwu);user_teacher.add(button1);user_teacher.add(button2);user_teacher.setSize(300,230);user_teacher.setModal(true);user_teacher.setLocationRelativeTo(null);user_teacher.setVisible(true);publicvoidactionPerformed(ActionEvente)if(e.getSource()=button1)Strings=aenter.getText().trim();if(!(pass.getText().trim().equals(s)JOptionPane.showMessageDialog(null,两次输入的密码不一致！);elseif(pass.getText().trim().equals(