企业工资管理系统Java+MySQL.docx

1、企业工资管理系统Java+MySQL企业工资管理系统（MySQL+Java）本代码仅供初学者参考使用，相互学习，共同进步，让优秀成为一种习惯。软件下载：开发语言：Java开发工具：eclipse数据库软件：MySQL数据库驱动：mysql-connector-java-5.1.6-bin驱动下载地址：以下是代码和界面截图，共7个类。1. DB1 欢迎界面import java.awt.*;import java.awt.event.*;import javax.swing.*;class DB1 extends JFrame implements ActionListener private

2、static final long serialVersionUID = 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.getContentPane(); pcontentPane.add(label); pcontent

3、Pane.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.EXIT_ON_CLOSE); frame.pack(); frame.se

4、tBounds(500, 300, 300, 150); frame.setResizable(false); frame.setVisible(true); public static void main(String args) DB1 dome = new DB1(); dome.Create(); public void actionPerformed(ActionEvent e) if (button1.equals(e.getSource() DL dl = new DL(); dl.create(); frame.dispose(); if (button2.equals(e.g

5、etSource() / 退出 System.exit(0); 1. DL 登陆界面import java.awt.Color;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.Statement;import javax.swing.JButton;im

6、port 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 implements ActionListener JFrame frame =

7、new JFrame(职工/管理员登陆); JLabel label1 = new JLabel(用户名); JLabel label2 = new JLabel(密码); JButton logonButton1 = new JButton(管理员登录); JButton logonButton2 = new JButton(职工登录); JButton cancelButton = new JButton(退出); JTextField username = new JTextField(9); JPasswordField password = new JPasswordField(9)

8、; 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, 800); p.add(l

9、abel2); 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); logonButton2.addActionListener(this); c

10、ancelButton.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.getText(); if(e.getSou

11、rce()=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()=logonButton2) try

12、 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); sql=select * from worker where num=+t1+ and passwor

13、d=+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, 登录成功！); this.dispose(); else JOptionPane

14、.showMessageDialog(this, 输入用户名或密码错误！); 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.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;impo