工资系统代码JAVA版-.pdf

《工资系统代码JAVA版-.pdf》由会员分享，可在线阅读，更多相关《工资系统代码JAVA版-.pdf（33页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、工资系统代码/*系统欢迎界面*/import java.awt.FlowLayout;import java.awt.event.*;import javax.swing.*;SuppressWarnings(serial)class WagesSystem extends JFrame implements ActionListener JFrame frame=new JFrame(欢迎进入工资管理系统);JButton button1=new JButton(进入系统);JButton button2=new JButton(退出系统);ImageIcon im=new ImageIco

2、n(1.jpg);JLabel a1=new JLabel(im);void Create()JPanel pcontentPane=(JPanel)frame.getContentPane();pcontentPane.add(a1);pcontentPane.setLayout(new FlowLayout();pcontentPane.add(button1);pcontentPane.add(button2);pcontentPane.setVisible(true);button1.addActionListener(this);button2.addActionListener(t

3、his);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.pack();frame.setLocationRelativeTo(null);frame.setVisible(true);public static void main(String args)WagesSystem dome=new WagesSystem();dome.Create();public void actionPerformed(ActionEvent e)if(button1.equals(e.getSource()DL dl=new DL()

4、;dl.create();frame.dispose();if(button2.equals(e.getSource()System.exit(0);/*登录界面*/import java.awt.HeadlessException;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;

5、import java.sql.Statement;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPasswordField;import javax.swing.JTextField;import .*;import java.sql.*;SuppressWarnings(serial)class DL extends JFrame implements ActionListene

6、r NetConn sql;Statement sqll;ResultSet rs;JFrame frame=new JFrame(职工/管理员登陆);JLabel label1=new JLabel(用户名);JLabel label2=new JLabel(密码);JButton logonButton1=new JButton(系统管理员登录);JButton logonButton2=new JButton(教职工登录);JButton logonButton3=new JButton(财务管理员登录);JButton cancelButton=new JButton(退出);JTex

7、tField username=new JTextField(9);JPasswordField password=new JPasswordField(9);static String t1;static String t2;void create()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);p

8、assword.setBounds(130,50,150,20);frame.add(password);logonButton1.setBounds(100,90,150,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(cancelButt

9、on);logonButton1.addActionListener(this);logonButton2.addActionListener(this);logonButton3.addActionListener(this);cancelButton.addActionListener(this);sql=new NetConn();/建立数据库连接frame.setSize(350,250);frame.setLocationRelativeTo(null);frame.setVisible(true);frame.setDefaultCloseOperation(JFrame.EXIT

10、_ON_CLOSE);SuppressWarnings(deprecation)public void actionPerformed(ActionEvent e)t1=username.getText();t2=password.getText();/系统管理员登录if(e.getSource()=logonButton1)if(username.getText().equals(admin)=true&(password.getText().equals(admin)=true)JOptionPane.showMessageDialog(this,登录成功！);xtgly a=new xt

11、gly();frame.dispose();else JOptionPane.showMessageDialog(null,输入用户名或密码错误！);/教职工登陆if(e.getSource()=logonButton2)sqll=sql.connect();try rs=sqll.executeQuery(SELECT*FROM user_teacher where name=+username.getText()+);String sname,spass;if(rs.next()sname=rs.getString(2);spass=rs.getString(3);if(password.

12、getText().trim().equals(spass)&(username.getText().trim().equals(sname)JOptionPane.showMessageDialog(this,登录成功！);Teacher_P a=new Teacher_P();a.creat(rs.getString(1);frame.dispose();else JOptionPane.showMessageDialog(null,输入用户名或密码错误！);else JOptionPane.showMessageDialog(null,用户不存在！);catch(SQLException

13、 e2)/TODO 自动生成的catch 块e2.printStackTrace();/财务登陆if(e.getSource()=logonButton3)sqll=sql.connect();try rs=sqll.executeQuery(SELECT*FROM user_cw where name=+username.getText()+);String sname,spass;if(rs.next()sname=rs.getString(2);spass=rs.getString(3);if(password.getText().trim().equals(spass)&(userna

14、me.getText().trim().equals(sname)JOptionPane.showMessageDialog(this,登录成功！);CW a=new CW();a.create(rs.getString(1);frame.dispose();else JOptionPane.showMessageDialog(null,输入用户名或密码错误！);else JOptionPane.showMessageDialog(null,用户不存在！);catch(SQLException e2)/TODO 自动生成的catch 块e2.printStackTrace();/退出if(ca

15、ncelButton.equals(e.getSource()System.exit(0);/*数据库链接*/import java.sql.*;/数据库联接类public class NetConn Connection con;Statement sql;public Statement connect()try /载入驱动程序字符串Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);catch(ClassNotFoundException e1)try /通过 JDBC URL 得到 Connetction 对象con=

16、DriverManager.getConnection(jdbc:sqlserver:/localhost:1433;DatabaseName=gzxt,sa,123456);/通过 Connection 对象创建 Statement 对象sql=con.createStatement();catch(SQLException e2)return sql;/*系统管理员界面*/import java.awt.BorderLayout;import java.awt.Container;import java.awt.event.ActionEvent;import java.awt.event

17、.ActionListener;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPasswordField;import javax.swing.JScrollPane;import javax.swing.JTabbedPane;i

18、mport javax.swing.JTable;import javax.swing.JTextField;SuppressWarnings(serial)class xtgly extends JFrame implements ActionListener JFrame frame=new JFrame(教职工信息查询及密码修改);Object a,b;Object colname=工号,姓名,密码;NetConn sql;Statement sqll;ResultSet rs;JTable table,table2;JButton Button1=new JButton(添加教职工);

19、JButton Button2=new JButton(添加财务管理员);JButton Button3=new JButton(修改密码);JButton Button4=new JButton(刷新);JTabbedPane tab=new JTabbedPane(JTabbedPane.TOP);int i=0;xtgly()frame.setLayout(null);sql=new NetConn();sqll=sql.connect();a=new Object303;b=new Object303;try String temp=select*from user_cw;rs=sql

20、l.executeQuery(temp);while(rs.next()ai0=rs.getString(1);ai1=rs.getString(2);ai2=rs.getString(3);i+;i=0;String temp2=select*from user_teacher;rs=sqll.executeQuery(temp2);while(rs.next()bi0=rs.getString(1);bi1=rs.getString(2);bi2=rs.getString(3);i+;catch(SQLException e)/TODO 自动生成的catch 块e.printStackTr

21、ace();table=new JTable(a,colname);table.setEnabled(false);table2=new JTable(b,colname);table2.setEnabled(false);JScrollPane JSP=new JScrollPane(table);JScrollPane JSP2=new JScrollPane(table2);tab.add(JSP,财务管理员);tab.add(JSP2,教职工);tab.setBounds(0,0,350,180);Button1.setBounds(1,185,110,20);Button1.addA

22、ctionListener(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(Button2);frame.add(Button3);frame.add(Button4);frame.add(

23、tab);frame.setSize(350,250);frame.setLocationRelativeTo(null);frame.setVisible(true);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);public void actionPerformed(ActionEvent e)/添加教职工if(e.getSource()=Button1)Add_teacher add1=new Add_teacher();/添加财务管理员if(e.getSource()=Button2)Add_cw add2=new Add_c

24、w();/修改密码if(e.getSource()=Button3)Change_mima change=new Change_mima();if(e.getSource()=Button4)i=0;try String temp=select*from user_cw;rs=sqll.executeQuery(temp);while(rs.next()ai0=rs.getString(1);ai1=rs.getString(2);ai2=rs.getString(3);i+;i=0;String temp2=select*from user_teacher;rs=sqll.executeQu

25、ery(temp2);while(rs.next()bi0=rs.getString(1);bi1=rs.getString(2);bi2=rs.getString(3);i+;catch(SQLException e1)/TODO 自动生成的catch 块e1.printStackTrace();table.removeAll();table2.removeAll();table=new JTable(a,colname);table.setEnabled(false);table2=new JTable(b,colname);table2.setEnabled(false);tab.upd

26、ateUI();/*添加财务管理人员*/import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swin

27、g.JPasswordField;import javax.swing.JTextField;public class Add_cw implements ActionListener JDialog user_cw=new JDialog();JLabel no,name,key,re_key;JTextField user_no,user_name;JPasswordField pass,aenter;JButton button1,button2;NetConn sql;Statement sqll;ResultSet rs;Add_cw()user_cw.setTitle(添加财务管理

28、员);user_cw.setLayout(null);no=new JLabel(工号：);user_no=new JTextField(,10);user_no.setBounds(115,5,120,20);no.setBounds(20,5,80,20);name=new JLabel(姓名：);user_name=new JTextField(,10);user_name.setBounds(115,30,120,20);name.setBounds(20,30,80,20);key=new JLabel(密码：);pass=new JPasswordField(,10);pass.s

29、etEchoChar(*);pass.setBounds(115,55,120,20);key.setBounds(20,55,80,20);re_key=new JLabel(确认密码:);aenter=new JPasswordField(,10);aenter.setEchoChar(*);aenter.setBounds(115,80,120,20);re_key.setBounds(20,80,80,20);button1=new JButton(确认);button1.setBounds(50,110,80,20);button1.addActionListener(this);b

30、utton2=new JButton(取消);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.setSize(3

31、00,180);user_cw.setModal(true);user_cw.setLocationRelativeTo(null);user_cw.setVisible(true);public void actionPerformed(ActionEvent e)if(e.getSource()=button1)String s=aenter.getText().trim();if(!(pass.getText().trim().equals(s)JOptionPane.showMessageDialog(null,两次输入的密码不一致！);else if(pass.getText().t

32、rim().equals()|user_no.getText().trim().equals()|user_name.getText().trim().equals()JOptionPane.showMessageDialog(null,输入的信息不全，请填写完整！);else try sql=new NetConn();sqll=sql.connect();/根据用户添加的用户名进行选择rs=sqll.executeQuery(SELECT*FROM user_cw where no=+user_no.getText()+);/如果已经存在同名的用户，则显示错误提示if(rs.next()J

33、OptionPane.showMessageDialog(null,用户已经存在,添加失败！);/如果不存在用户名，则将用户新添加信息添加到数据库中else /int s1=Integer.parseInt(user_no.getText().trim();String s1=+user_no.getText().trim()+;String s2=+user_name.getText().trim()+;String s3=+pass.getText().trim()+;String temp=INSERT INTO user_cw VALUES(+s1+,+s2+,+s3+);sqll.e

34、xecuteUpdate(temp);JOptionPane.showMessageDialog(null,用户添加成功!);catch(SQLException e1)e1.printStackTrace();if(e.getSource()=button2)user_cw.dispose();/*添加教职工用户*/import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.ResultSet;import java.sql.SQLException;import java.sq

35、l.Statement;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPasswordField;import javax.swing.JTextField;public class Add_teacher implements ActionListener JDialog user_teacher=new JDialog();JLabel no,name,key,re_key,y

36、hk_num,zhiwu;JTextField user_no,user_name,user_yhk_num,user_zhiwu;JPasswordField pass,aenter;JButton button1,button2;NetConn sql;Statement sqll;ResultSet rs;Add_teacher()user_teacher.setTitle(添加教职工);user_teacher.setLayout(null);no=new JLabel(工号：);user_no=new JTextField(,10);user_no.setBounds(115,5,1

37、20,20);no.setBounds(20,5,80,20);name=new JLabel(姓名：);user_name=new JTextField(,10);user_name.setBounds(115,30,120,20);name.setBounds(20,30,80,20);key=new JLabel(密码：);pass=new JPasswordField(,10);pass.setEchoChar(*);pass.setBounds(115,55,120,20);key.setBounds(20,55,80,20);re_key=new JLabel(确认密码:);aen

38、ter=new JPasswordField(,10);aenter.setEchoChar(*);aenter.setBounds(115,80,120,20);re_key.setBounds(20,80,80,20);yhk_num=new JLabel(银行卡号:);user_yhk_num=new JTextField(,10);user_yhk_num.setBounds(115,105,120,20);yhk_num.setBounds(20,105,80,20);zhiwu=new JLabel(职务：);user_zhiwu=new JTextField(,10);user_

39、zhiwu.setBounds(115,130,120,20);zhiwu.setBounds(20,130,80,20);button1=new JButton(确认);button1.setBounds(50,160,80,20);button1.addActionListener(this);button2=new JButton(取消);button2.setBounds(170,160,80,20);button2.addActionListener(this);user_teacher.add(no);user_teacher.add(name);user_teacher.add(

40、key);user_teacher.add(re_key);user_teacher.add(yhk_num);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_t

41、eacher.setSize(300,230);user_teacher.setModal(true);user_teacher.setLocationRelativeTo(null);user_teacher.setVisible(true);public void actionPerformed(ActionEvent e)if(e.getSource()=button1)String s=aenter.getText().trim();if(!(pass.getText().trim().equals(s)JOptionPane.showMessageDialog(null,两次输入的密

42、码不一致！);else if(pass.getText().trim().equals()|user_no.getText().trim().equals()|user_name.getText().trim().equals()|user_yhk_num.getText().trim().equals()|user_zhiwu.getText().trim().equals()JOptionPane.showMessageDialog(null,输入的信息不全，请填写完整！);else try sql=new NetConn();sqll=sql.connect();/根据用户添加的用户名进

43、行选择rs=sqll.executeQuery(SELECT*FROM user_teacher where no=+user_no.getText()+);/如果已经存在同名的用户，则显示错误提示if(rs.next()JOptionPane.showMessageDialog(null,用户已经存在,添加失败！);/如果不存在用户名，则将用户新添加信息添加到数据库中else /int s1=Integer.parseInt(user_no.getText().trim();String s1=+user_no.getText().trim()+;String s2=+user_name.g

44、etText().trim()+;String s3=+pass.getText().trim()+;String s4=+user_yhk_num.getText().trim()+;String s5=+user_zhiwu.getText().trim()+;String temp=INSERT INTO user_teacher VALUES(+s1+,+s2+,+s3+,+s4+,+s5+);sqll.executeUpdate(temp);JOptionPane.showMessageDialog(null,用户添加成功!);catch(SQLException e1)e1.pri

45、ntStackTrace();if(e.getSource()=button2)user_teacher.dispose();/*通过管理员密码修改*/import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing

46、.JLabel;import javax.swing.JOptionPane;import javax.swing.JPasswordField;import javax.swing.JTextField;public class Change_mima implements ActionListener JDialog change=new JDialog();JLabel no,name,key,re_key;JTextField user_no,user_name;JPasswordField pass,aenter;JButton button1,button2;NetConn sql

47、;Statement sqll;ResultSet rs,rs2;Change_mima()change.setTitle(添加财务管理员);change.setLayout(null);no=new JLabel(工号：);user_no=new JTextField(,10);user_no.setBounds(115,5,120,20);no.setBounds(20,5,80,20);name=new JLabel(姓名：);user_name=new JTextField(,10);user_name.setBounds(115,30,120,20);name.setBounds(2

48、0,30,80,20);key=new JLabel(密码：);pass=new JPasswordField(,10);pass.setEchoChar(*);pass.setBounds(115,55,120,20);key.setBounds(20,55,80,20);re_key=new JLabel(确认密码:);aenter=new JPasswordField(,10);aenter.setEchoChar(*);aenter.setBounds(115,80,120,20);re_key.setBounds(20,80,80,20);button1=new JButton(确认

49、);button1.setBounds(50,110,80,20);button1.addActionListener(this);button2=new JButton(取消);button2.setBounds(170,110,80,20);button2.addActionListener(this);change.add(no);change.add(name);change.add(key);change.add(re_key);change.add(user_no);change.add(user_name);change.add(pass);change.add(aenter);

50、change.add(button1);change.add(button2);change.setSize(300,180);change.setModal(true);change.setLocationRelativeTo(null);change.setVisible(true);public void actionPerformed(ActionEvent e)if(e.getSource()=button1)String s=aenter.getText().trim();if(!(pass.getText().trim().equals(s)JOptionPane.showMes