企业工资管理系统JavaMySQL样本.docx

1、企业工资管理系统JavaMySQL样本企业工资管理系统(MySQL+Java)本代码仅供初学者参考使用，相互学习，共同进步，让优秀成为一种习惯 软件下载：开发语言:Java开发工具：eclipse数据库软件：MySQL数据库驱动：mysql-connector-java-5.1.6-bin驱动下载地址：以下是代码和界面截图，共7个类。1. DB1欢迎界面import java.awt.*;import java.awt.eve nt.*;import javax.swi ng.*;class DB1 exte nds JFrame impleme nts Actio nListe ner pr

2、ivate static fin al l ong serialVers ion UID = 1L;JFrame frame = new JFrame(” 欢迎进入工资管理系统 );JLabel label = new JLabel(, JLabel.CENTER);资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。JButton button1 = new JButton( 进入系统 );JButton button2 = new JButton( 退出系统 );void Create() JPanel pcontentPane = (JPanel) frame.getConte

3、ntPane(); pcontentPane.add(label);pcontentPane.setLayout(new FlowLayout();pcontentPane.add(button1);pcontentPane.add(button2); pcontentPane.setBackground(Color.gray); pcontentPane.setVisible(true);button1.addActionListener(this);button2.addActionListener(this); frame.setDefaultCloseOperation(JFrame.

4、EXIT_ON_CLOSE); frame.pack();frame.setBounds(500, 300, 300, 150);frame.setResizable(false);frame.setVisible(true);public static void main(String args) DB1 dome = new DB1();dome.Create();public void actio nPeformed(Actio nEve nt e) if (butt on 1.equals(e.getSource() DL dl = new DL();dl.create();frame

5、.dispose();退出if (butt on 2.equals(e.getSource() /System.exit(O); import java.awt.Color;1. DL登陆界面import java.awt.FlowLayout;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.Stateme

6、nt;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JPasswordField;import javax.swing.JTextField;import com.mysql.jdbc.PreparedStatement;SuppressWarnings(serial) class DL extends JFrame implemen

7、ts ActionListener用户名 );JFrame frame = new JFrame( 职工 / 管理员登陆 );JLabel label1 = new JLabel(JLabel label2 = new JLabel( 密码 );资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。JButton logonButton2 = new JButton（ 职工登录 ）;JButton cancelButton = new JButton（ 退出 ）;JTextField username = new JTextField(9);JPasswordField passwor

8、d = new JPasswordField(9); static String t1;static String t2;void create()JPanel p = (JPanel) frame.getContentPane();SuppressWarnings(unused)JPanel p1 = new JPanel();p.setLayout(new FlowLayout();p.add(label1);p.setSize(5, 5);p.setLocation(4, 8);p.add(username);p.setSize(100, 200);p.setLocation(800,

9、800);p.add(label2);p.setSize(50, 20);p.setLocation(40, 80);p.add(password);资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。p.setSize(100, 20);p.setLocation(80, 120);p.add(logonButton1);p.add(logonButton2);p.add(cancelButton);p.setBackground(Color.gray);p.setVisible(true);logonButton1.addActionListener(this);logonBut

10、ton2.addActionListener(this);cancelButton.addActionListener(this);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.pack();frame.setBounds(500, 300, 500, 220);frame.setVisible(true);SuppressWarnings(deprecation)public void actionPerformed(ActionEvent e)t1 = username.getText();t2 = password.

11、getText();if(e.getSource()=logonButton1)if( username.getText().equals(admin) = true& (password.getText().equals(admin) = true)JOptionPane.showMessageDialog(this, 登录成功 ! );GZGLZJM gz = new GZGLZJM();gz.create();frame.dispose();else JOptionPane.showMessageDialog(null, 输入用户名或密码错误 );if (e.getSource()=lo

12、gonButton2)try Connection con;Statement ps;ResultSet rs;String sql = null;Class.forName(org.gjt.mm.mysql.Driver);Class.forName(org.gjt.mm.mysql.Driver).newInstance();资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/management,root,hellomysql);andsql=select

13、* from worker where num=+t1+ password=+t2+;ps=(PreparedStatement) con.prepareStatement(sql);rs = ps.executeQuery(sql);if(rs.next()&if(rs.getString(num).equals(t1) rs.getString(password).equals(t2)YGGLZJM yg = new YGGLZJM();yg.create(); frame.dispose();JOptionPane.showMessageDialog(this, 登录成功 ! ); th

14、is.dispose();else 误! );catch (Exception e1) / TODO Auto-generated catch block e1.printStackTrace();退出if (cancelButton.equals(e.getSource() /System.exit(0);2. GZGL工资管理界面import java.awt.Color;import java.awt.FlowLayout;import java.awt.eve nt.Acti on Eve nt;import java.awt.eve nt.Actio nListe ner;impor

15、t java.sql.C onn ecti on;import java.sql.DriverMa nager;import java.sql.ResultSet;import java.sql.SQLExceptio n;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScroll

16、Pane;import javax.swing.JSplitPane;import javax.swing.JTable;import javax.swing.JTextField;SuppressWarnings(serial)public class GZGL extends JFrame implements ActionListener JFrame f =new JFrame(员工工资管理 JButton b1= new JButton(录入);JButton b2= new JButton(修改);JButton b3= new JButton(删除);JButton b4= ne

17、w JButton(查询所有 );JButton b5= new JButton(返回);JTextField tf1 = new JTextField(6);JTextField tf2 = new JTextField(4);JTextField tf3 = new JTextField(4);JTextField tf4 = new JTextField(4);JTextField tf5 = new JTextField(4);JTextField tf6 = new JTextField(4);JTextField tf7 = new JTextField(6);JTextField

18、 tf8 = new JTextField(6);JTextField tf9 = new JTextField(4);JTextField tf10= new JTextField(4);JTextField tf11= new JTextField(6);JTextField tf12= new JTextField(6);String cloum = 职工号 , 基本工资 , 津贴, 奖金, 保险, 房贷Object row = new Object507;JTable table = new JTable(row, cloum);JScrollPane scrollpane = new

19、 JScrollPane(table);JSplitPane splitpane = new JSplitPane(JSplitPane.VERTICAL_SPLIT); void create() JPanel p = (JPanel) f.getContentPane(); p.setLayout(new FlowLayout();p.add(scrollpane);p.add(splitpane);JPanel p1 = new JPanel(); p1.add(b1);p1.add(b2);p1.add(b3);p1.add(b4);p1.add(b5);JPanel p2 = new

20、 JPanel(); p2.setBackground(Color.gray); p2.add(scrollpane);SuppressWarnings(unused) JPanel p3 = new JPanel(); p.setLayout(new FlowLayout(); p.add(new JLabel(); p.add(new JLabel( 职工号 ); p.add(tf1);p.add(new JLabel( 基本工资 ); p.add(tf2);p.add(new JLabel( 津贴 );p.add(tf3);p.add(new JLabel( 奖金 ); p.add(tf

21、4);p.add(new JLabel( 保险 );p.add(tf5);p.add(new JLabel( 房贷 ); p.add(tf6);p.add(new JLabel( 总工资 ); p.add(tf7);资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。p.add(new JLabel( 姓名 );p.add(tf8);p.add(new JLabel( 性别 );p.add(tf9);p.add(new JLabel( 年龄 );p.add(tf10);p.add(new JLabel( 部门 );p.add(tf11);p.add(new JLabel( 职业 );

22、p.add(tf12);splitpane.add(p1, JSplitPane.TOP);splitpane.add(p2, JSplitPane.BOTTOM);splitpane.setDividerLocation(50);p.setBackground(Color.gray);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);b4.addActionListener(this);b5.addActionListener(this);f.setBounds(500, 100,

23、 500, 600);f.setResizable(false);/ 能够调整界面大小f.setVisible(true);资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。public void actionPerformed(ActionEvent e) if (b1.equals(e.getSource() / 录入Connection con;Statement sql;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundException e1) System.out.println( + e1)

24、;try con=DriverManager.getConnection(jdbc:mysql:/localhost:3306/management,root,hellomysql);sql = con.createStatement();salaryworkerString insertStr = INSERT INTO(worker_num,basic_pay,welfare,bonus,insurance,housing_fund,payment)VALUES(+tf1.getText()+,+tf2.getText()+,+tf3.getText()+,+tf4.getText()+,

25、+tf5.getText()+,+tf6.getText()+,+tf7.getText()+);sql.executeUpdate(insertStr);String insertStr1 = INSERT INTO(num,name,sex,age,dep,occup,password)VALUES(+tf1.getText()+,+tf8资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。.getText()+,+tf9.getText()+,+tf10.getText()+,+tf11.getText()+,+tf12.getText()+,+tf1.getText()+);

26、sql.executeUpdate(insertStr1);con.close();JOptionPane.showMessageDialog(this, 入录成功 ! ); catch (SQLException e1) JOptionPane.showMessageDialog(this, 入录失败 ! );if (b2.equals(e.getSource() / 修改Connection con;Statement sql;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundException e1) Syst

27、em.out.println( + e1);try conDriverManager.getConnection(jdbc:mysql:/localhost:3306/management, root,hellomysql);sql = con.createStatement();资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。basic_pay=+tf2.getText()+,welfare=+tf3.getText()+,bonus=+tf4.getText()+,insurance=+tf5.getText()+,housing_fund=+tf6.getText()+,p

28、ayment=+tf7.getText()+where worker_num=+tf1.getText()+;sql.executeUpdate(updateStr);SETString updateStr1 = UPDATE workername=+tf8.getText()+,sex=+tf9.getText()+,age=+tf10.getText() +,dep=+tf11.getText()+,occup=+tf12.getText()+where num=+tf1.getText()+;sql.executeUpdate(updateStr1);JOptionPane.showMe

29、ssageDialog(this, 修改成功 ! ); con.close(); catch (SQLException e1) JOptionPane.showMessageDialog(this, 信息不存在 ! );if (b3.equals(e.getSource() / 删除Connection con;Statement sql;SuppressWarnings(unused)ResultSet rs;try 资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundException e1) System.out.println( + e1);try conDriverManager.getConnection(jdbc:mysql:/localhost:3306/management, root,hellomysql);sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultS