0
0

Eclipse+Java+Swing+Mysql实现员工工资管理系统

一、系统介绍

1.开发环境

开发工具：Eclipse2021

JDK版本：jdk1.8

Mysql版本：8.0.13

2.技术选型

Java+Swing+Mysql

3.系统功能

1.用户匿名登录系统，查询工资信息；

2.管理员登录登出系统；

3.管理员增加员工信息，修改员工信息，删除员工信息；

3.管理员增加部门信息，修改部门信息，删除部门信息；

4.管理员查询员工工资，添加员工工资；

4.数据库

  1. /*
  2.  Navicat Premium Data Transfer
  4.  Source Server         : MySQL
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80013
  7.  Source Host           : 127.0.0.1:3306
  8.  Source Schema         : swing_salary_management
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80013
  12.  File Encoding         : 65001
  14.  Date: 23/12/2021 21:19:54
  15. */
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  20. -- ----------------------------
  21. -- Table structure for department
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `department`;
  24. CREATE TABLE `department`  (
  25.   `ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  26.   `Name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  27.   `Director` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  28.   `Number` int(16) NOT NULL,
  29.   PRIMARY KEY (`ID`) USING BTREE
  30. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  32. -- ----------------------------
  33. -- Records of department
  34. -- ----------------------------
  35. INSERT INTO `department` VALUES ('ks001', '经理室', '赢政', 10);
  36. INSERT INTO `department` VALUES ('ks002', '财务室', '刘邦', 6);
  37. INSERT INTO `department` VALUES ('ks003', '军机部', '李鸿章', 6);
  38. INSERT INTO `department` VALUES ('ks004', '外交部', '张仪', 8);
  39. INSERT INTO `department` VALUES ('ks005', '技术科', '朱元璋', 10);
  40. INSERT INTO `department` VALUES ('ks006', '董事会', '李世民', 10);
  42. -- ----------------------------
  43. -- Table structure for employee
  44. -- ----------------------------
  45. DROP TABLE IF EXISTS `employee`;
  46. CREATE TABLE `employee`  (
  47.   `ID` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  48.   `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  49.   `sex` char(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  50.   `age` int(6) NOT NULL,
  51.   `department` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  52.   `position` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  53.   `phone` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  54.   `time` datetime(0) NULL DEFAULT NULL,
  55.   `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  56.   PRIMARY KEY (`ID`) USING BTREE
  57. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  59. -- ----------------------------
  60. -- Records of employee
  61. -- ----------------------------
  62. INSERT INTO `employee` VALUES ('0001', '赢政', '男', 37, '经理室', '经理', '10086', '0201-01-01 00:00:00', '咸阳');
  63. INSERT INTO `employee` VALUES ('0002', '刘邦', '男', 40, '技术科', '技术长', '10087910', '2001-05-06 00:00:00', '长安');
  64. INSERT INTO `employee` VALUES ('0003', '武则天', '女', 30, '财务室', '经理', '10088', '1999-08-07 00:00:00', '长安');
  65. INSERT INTO `employee` VALUES ('0004', '刘秀', '男', 46, '军机部', '副部长', '123548788', '2013-05-07 00:00:00', '桂林');
  66. INSERT INTO `employee` VALUES ('0005', '西施', '女', 23, '财务室', '会计', '10089', '2001-02-03 00:00:00', '越国');
  67. INSERT INTO `employee` VALUES ('0006', '李清照', '女', 25, '财务室', '出纳', '125478', '2012-03-04 00:00:00', '宋国');
  68. INSERT INTO `employee` VALUES ('0007', '杨玉环', '女', 29, '财务室', '会计', '125478', '2010-02-04 00:00:00', '长安');
  69. INSERT INTO `employee` VALUES ('0008', '孙权', '男', 35, '外交部', '部长', '150478', '2005-05-04 00:00:00', '江东');
  70. INSERT INTO `employee` VALUES ('0009', '李世民', '男', 54, '董事会', '会长', '100865', '1998-05-08 00:00:00', '西安');
  71. INSERT INTO `employee` VALUES ('0010', '项羽', '男', 40, '经理室', '副经理', '1008670', '2000-02-05 00:00:00', '彭城');
  72. INSERT INTO `employee` VALUES ('0011', '李鸿章', '男', 52, '军机部', '部长', '1008699', '2001-05-08 00:00:00', '北京');
  73. INSERT INTO `employee` VALUES ('0012', '张仪', '男', 44, '外交部', '部长', '10089', '2002-02-04 00:00:00', '魏国');
  74. INSERT INTO `employee` VALUES ('0013', '朱元璋', '男', 35, '技术科', '部长', '100896', '2013-05-07 00:00:00', '南京');
  75. INSERT INTO `employee` VALUES ('0014', '貂蝉', '女', 25, '经理室', '助理', '10086972', '2005-05-04 00:00:00', '洛阳');
  76. INSERT INTO `employee` VALUES ('0015', '李渊', '男', 55, '董事会', '董事', '25897', '2001-02-05 00:00:00', '长安');
  77. INSERT INTO `employee` VALUES ('0016', '1', '男', 1, '经理室', '1', '1', '2001-02-05 00:00:00', '2');
  79. -- ----------------------------
  80. -- Table structure for salary
  81. -- ----------------------------
  82. DROP TABLE IF EXISTS `salary`;
  83. CREATE TABLE `salary`  (
  84.   `salaryID` int(4) NOT NULL AUTO_INCREMENT,
  85.   `ID` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  86.   `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  87.   `basepay` int(10) NULL DEFAULT NULL,
  88.   `welfare` int(10) NULL DEFAULT NULL,
  89.   `reward` int(10) NULL DEFAULT NULL,
  90.   `insurance` int(10) NULL DEFAULT NULL,
  91.   `funds` int(10) NULL DEFAULT NULL,
  92.   `month` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  93.   `remark` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  94.   PRIMARY KEY (`salaryID`, `ID`) USING BTREE
  95. ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  97. -- ----------------------------
  98. -- Records of salary
  99. -- ----------------------------
  100. INSERT INTO `salary` VALUES (1, '0001', '赢政', 3000, 100, 100, 100, 500, '1月', '未结算');
  101. INSERT INTO `salary` VALUES (13, '0002', '刘邦', 3000, 200, 100, 100, 400, '1月', '未结算');
  102. INSERT INTO `salary` VALUES (15, '0003', '武则天', 2500, 100, 200, 100, 300, '1月', '未结算');
  103. INSERT INTO `salary` VALUES (16, '0004', '刘秀', 2900, 100, 150, 250, 200, '1月', '未结算');
  104. INSERT INTO `salary` VALUES (17, '0005', '西施', 2800, 100, 100, 100, 300, '1月', '未结算');
  105. INSERT INTO `salary` VALUES (18, '0006', '李清照', 2700, 120, 150, 100, 300, '1月', '未结算');
  106. INSERT INTO `salary` VALUES (19, '0007', '杨玉环', 2680, 200, 150, 100, 300, '1月', '未结算');
  107. INSERT INTO `salary` VALUES (20, '0008', '孙权', 2900, 100, 200, 100, 500, '1月', '未结算');
  108. INSERT INTO `salary` VALUES (21, '0009', '李世民', 2870, 200, 100, 100, 300, '1月', '未结算');
  109. INSERT INTO `salary` VALUES (22, '0010', '项羽', 2600, 200, 100, 100, 300, '1月', '未结算');
  110. INSERT INTO `salary` VALUES (23, '0011', '李鸿章', 2800, 200, 100, 100, 300, '1月', '未结算');
  111. INSERT INTO `salary` VALUES (24, '0012', '张仪', 2900, 200, 150, 100, 500, '1月', '未结算');
  112. INSERT INTO `salary` VALUES (25, '0013', '朱元璋', 2600, 250, 200, 100, 400, '1月', '未结算');
  113. INSERT INTO `salary` VALUES (26, '0001', '赢政', 3000, 100, 200, 100, 300, '2月', '未结算');
  114. INSERT INTO `salary` VALUES (27, '0001', '赢政', 3000, 250, 200, 100, 400, '3月', '未结算');
  115. INSERT INTO `salary` VALUES (28, '0002', '刘邦', 3000, 250, 150, 100, 400, '2月', '未结算');
  116. INSERT INTO `salary` VALUES (29, '0002', '刘邦', 3000, 300, 150, 100, 500, '3月', '未结算');
  117. INSERT INTO `salary` VALUES (30, '0003', '武则天', 2900, 200, 150, 100, 300, '2月', '未结算');
  118. INSERT INTO `salary` VALUES (31, '0003', '武则天', 2800, 250, 120, 100, 500, '3月', '未结算');
  119. INSERT INTO `salary` VALUES (33, '0004', '刘秀', 2580, 500, 200, 100, 300, '2月', '未结算');
  120. INSERT INTO `salary` VALUES (35, '0004', '刘秀', 2900, 200, 150, 100, 300, '3月', '未结算');
  121. INSERT INTO `salary` VALUES (37, '0005', '西施', 2900, 200, 100, 100, 300, '2月', '未结算');
  122. INSERT INTO `salary` VALUES (39, '0005', '西施', 2800, 200, 150, 100, 300, '3月', '未结算');
  123. INSERT INTO `salary` VALUES (40, '0006', '李清照', 2900, 200, 100, 100, 300, '2月', '未结算');
  124. INSERT INTO `salary` VALUES (41, '0006', '李清照', 2900, 200, 100, 100, 300, '3月', '未结算');
  126. -- ----------------------------
  127. -- Table structure for userlist
  128. -- ----------------------------
  129. DROP TABLE IF EXISTS `userlist`;
  130. CREATE TABLE `userlist`  (
  131.   `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  132.   `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  133.   `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  134.   PRIMARY KEY (`username`) USING BTREE
  135. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  137. -- ----------------------------
  138. -- Records of userlist
  139. -- ----------------------------
  140. INSERT INTO `userlist` VALUES ('管理员', 'admin', 'admin');
  142. -- ----------------------------
  143. -- Table structure for view_salary
  144. -- ----------------------------
  145. DROP TABLE IF EXISTS `view_salary`;
  146. CREATE TABLE `view_salary`  (
  147.   `ID` int(10) NOT NULL AUTO_INCREMENT,
  148.   `工号` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  149.   `姓名` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  150.   `部门` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  151.   `职位` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  152.   `总工资` int(10) NULL DEFAULT NULL,
  153.   `月份` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  154.   `备注` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  155.   PRIMARY KEY (`ID`) USING BTREE
  156. ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  158. -- ----------------------------
  159. -- Records of view_salary
  160. -- ----------------------------
  161. INSERT INTO `view_salary` VALUES (1, '0001', '赢政', '经理室', '经理', 2600, '1月', '未结算');
  162. INSERT INTO `view_salary` VALUES (9, '0002', '刘邦', '技术室', '技术长', 2800, '1月', '未结算');
  163. INSERT INTO `view_salary` VALUES (11, '0003', '武则天', '财务室', '经理', 2400, '1月', '未结算');
  164. INSERT INTO `view_salary` VALUES (12, '0004', '刘秀', '军机部', '大王', 2700, '1月', '未结算');
  165. INSERT INTO `view_salary` VALUES (13, '0005', '西施', '财务室', '会计', 2600, '1月', '未结算');
  166. INSERT INTO `view_salary` VALUES (14, '0006', '李清照', '财务室', '出纳', 2570, '1月', '未结算');
  167. INSERT INTO `view_salary` VALUES (15, '0007', '杨玉环', '财务室', '会计', 2630, '1月', '未结算');
  168. INSERT INTO `view_salary` VALUES (16, '0008', '孙权', '外交部', '部长', 2600, '1月', '未结算');
  169. INSERT INTO `view_salary` VALUES (17, '0009', '李世民', '董事会', '会长', 2770, '1月', '未结算');
  170. INSERT INTO `view_salary` VALUES (18, '0010', '项羽', '经理室', '副经理', 2500, '1月', '未结算');
  171. INSERT INTO `view_salary` VALUES (19, '0011', '李鸿章', '军机部', '部长', 2700, '1月', '未结算');
  172. INSERT INTO `view_salary` VALUES (20, '0012', '张仪', '外交部', '部长', 2650, '1月', '未结算');
  173. INSERT INTO `view_salary` VALUES (21, '0013', '朱元璋', '技术科', '部长', 2550, '1月', '未结算');
  174. INSERT INTO `view_salary` VALUES (22, '0001', '赢政', '经理室', '经理', 2900, '2月', '未结算');
  175. INSERT INTO `view_salary` VALUES (23, '0001', '赢政', '经理室', '经理', 2950, '3月', '未结算');
  176. INSERT INTO `view_salary` VALUES (24, '0002', '刘邦', '技术室', '技术长', 2900, '2月', '未结算');
  177. INSERT INTO `view_salary` VALUES (25, '0002', '刘邦', '技术室', '技术长', 2850, '3月', '未结算');
  178. INSERT INTO `view_salary` VALUES (26, '0003', '武则天', '财务室', '经理', 2850, '2月', '未结算');
  179. INSERT INTO `view_salary` VALUES (27, '0003', '武则天', '财务室', '经理', 2570, '3月', '未结算');
  180. INSERT INTO `view_salary` VALUES (35, '0004', '刘秀', '军机部', '副部长', 2850, '3月', '未结算');
  181. INSERT INTO `view_salary` VALUES (36, '0004', '刘秀', '军机部', '副部长', 2750, '2月', '未结算');
  182. INSERT INTO `view_salary` VALUES (37, '0005', '西施', '财务室', '会计', 2800, '2月', '未结算');
  183. INSERT INTO `view_salary` VALUES (39, '0005', '西施', '财务室', '会计', 2750, '3月', '未结算');
  184. INSERT INTO `view_salary` VALUES (40, '0006', '李清照', '财务室', '出纳', 2800, '2月', '未结算');
  185. INSERT INTO `view_salary` VALUES (41, '0006', '李清照', '财务室', '出纳', 2800, '3月', '未结算');
  186. INSERT INTO `view_salary` VALUES (42, '0001', '赢政', '经理室', '经理', 1, '1月', '未结算');
  188. SET FOREIGN_KEY_CHECKS = 1;

二、系统展示

1.登录系统

2.用户-登录系统

3.用户-查看工资

4.管理员-主界面

5.管理员-添加员工信息

6.管理员-修改员工信息

7.管理员-删除员工信息

8.管理员-添加部门信息

9.管理员-修改部门信息

10.管理员-删除部门信息

11.管理员-工资设定

12.管理员-工资查询

13.管理员-工资一览

三、部分代码

Login.java

  1. /*
  2.  * To change this template, choose Tools | Templates
  3.  * and open the template in the editor.
  4.  */
  6. /*
  7.  * Login.java
  8.  *
  9.  * Created on 2013-6-16, 21:34:00
  10.  */
  12. package com.sjsq;
  14. import java.awt.Toolkit;
  15. import java.awt.event.ItemEvent;
  16. import java.awt.event.ItemListener;
  18. import javax.swing.JOptionPane;
  20. /**
  21.  *
  22.  * @author Administrator
  23.  */
  24. public class Login extends javax.swing.JFrame {
  26.     static String status;
  27.     static String name;
  29.     private Toolkit tk = Toolkit.getDefaultToolkit();
  30.     int x = tk.getScreenSize().width / 2 - 180;
  31.     int y = tk.getScreenSize().height / 2 - 180;
  33.     /** Creates new form Login */
  34.     public Login() {
  35.         initComponents();
  36.         setLocation(x, y);
  37.         setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  38.     }
  40.     /**
  41.      * This method is called from within the constructor to initialize the form.
  42.      * WARNING: Do NOT modify this code. The content of this method is always
  43.      * regenerated by the Form Editor.
  44.      */
  45.     @SuppressWarnings("unchecked")
  46.     // <editor-fold defaultstate="collapsed" desc="Generated
  47.     // Code">//GEN-BEGIN:initComponents
  48.     private void initComponents() {
  50.         jComboBox1 = new javax.swing.JComboBox();
  51.         username = new javax.swing.JTextField();
  52.         jPasswordField1 = new javax.swing.JPasswordField();
  53.         jLabel1 = new javax.swing.JLabel();
  54.         jLabel2 = new javax.swing.JLabel();
  55.         jLabel3 = new javax.swing.JLabel();
  56.         jButton1 = new javax.swing.JButton();
  57.         jButton2 = new javax.swing.JButton();
  58.         jLabel4 = new javax.swing.JLabel();
  60.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  61.         setTitle("登录界面");
  63.         jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "管理员", "员工" }));
  64.         jComboBox1.addItemListener(new ItemListener() {
  66.             @Override
  67.             public void itemStateChanged(ItemEvent e) {
  68.                 // TODO Auto-generated method stub
  69.                 if (e.getStateChange() == ItemEvent.SELECTED) {
  70.                     if ("员工".equals(e.getItem())) {
  71.                         jButton1.setText("查询工资");
  72.                         jLabel2.hide();
  73.                         username.hide();
  74.                         jPasswordField1.hide();
  75.                         jLabel3.hide();
  76.                         jPasswordField1.hide();
  77.                     } else {
  78.                         jButton1.setText("登录");
  79.                         jLabel2.show();
  80.                         username.show();
  81.                         jPasswordField1.show();
  82.                         jLabel3.show();
  83.                         jPasswordField1.show();
  84.                     }
  86.                 }
  87.             }
  88.         });
  89.         // username.setText("quan");
  91.         jLabel1.setText("身份：");
  93.         jLabel2.setText("账号：");
  95.         jLabel3.setText("密码：");
  97.         jButton1.setText("登录");
  98.         jButton1.addActionListener(new java.awt.event.ActionListener() {
  99.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  100.                 jButton1ActionPerformed(evt);
  101.             }
  102.         });
  104.         jButton2.setText("退出");
  105.         jButton2.addActionListener(new java.awt.event.ActionListener() {
  106.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  107.                 jButton2ActionPerformed(evt);
  108.             }
  109.         });
  111.         jLabel4.setForeground(new java.awt.Color(255, 0, 0));
  112.         jLabel4.setText("注：员工可以匿名登录");
  114.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  115.         getContentPane().setLayout(layout);
  116.         layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
  117.                 .createSequentialGroup()
  118.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
  119.                         .createSequentialGroup().addGap(80, 80, 80)
  120.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  121.                                 .addComponent(jLabel1).addComponent(jLabel3).addComponent(jLabel2))
  122.                         .addGap(18, 18, 18)
  123.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  124.                                 .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, 92,
  125.                                         javax.swing.GroupLayout.PREFERRED_SIZE)
  126.                                 .addGroup(layout.createSequentialGroup()
  127.                                         .addGroup(layout
  128.                                                 .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  129.                                                 .addComponent(username, javax.swing.GroupLayout.Alignment.LEADING)
  130.                                                 .addComponent(jComboBox1, javax.swing.GroupLayout.Alignment.LEADING, 0,
  131.                                                         javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  132.                                         .addGap(18, 18, 18).addComponent(jLabel4))))
  133.                         .addGroup(layout.createSequentialGroup().addGap(110, 110, 110).addComponent(jButton1)
  134.                                 .addGap(39, 39, 39).addComponent(jButton2)))
  135.                 .addContainerGap(54, Short.MAX_VALUE)));
  136.         layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  137.                 .addGroup(layout.createSequentialGroup().addGap(65, 65, 65)
  138.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  139.                                 .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
  140.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  141.                                 .addComponent(jLabel1).addComponent(jLabel4))
  142.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  143.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  144.                                 .addComponent(username, javax.swing.GroupLayout.PREFERRED_SIZE,
  145.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  146.                                 .addComponent(jLabel2))
  147.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  148.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  149.                                 .addComponent(jLabel3).addComponent(jPasswordField1,
  150.                                         javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
  151.                                         javax.swing.GroupLayout.PREFERRED_SIZE))
  152.                         .addGap(35, 35, 35)
  153.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  154.                                 .addComponent(jButton1).addComponent(jButton2))
  155.                         .addContainerGap(102, Short.MAX_VALUE)));
  157.         pack();
  158.     }// </editor-fold>//GEN-END:initComponents
  160.     private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton1ActionPerformed
  161.         // TODO add your handling code here:
  163.         status = (String) jComboBox1.getSelectedItem();
  164.         name = username.getText();
  165.         String password = jPasswordField1.getText();
  167.         if (status.equals("管理员")) {
  168.             if (name.equals("")) {
  169.                 JOptionPane.showMessageDialog(null, "用户名不能为空！！");
  170.             } else if (password.equals("")) {
  171.                 JOptionPane.showMessageDialog(null, "密码不能为空！！");
  172.             } else {
  173.                 String sql = "select username from userlist where status = '" + status + "' and username = '" + name
  174.                         + "' and password = '" + password + "'";
  175.                 // String sql = "select * from userlist";
  176.                 System.out.println(sql);
  177.                 DBConn db = new DBConn();
  178.                 if (db.Check(sql) != 0) {
  179.                     new MainFrame().setVisible(true);
  180.                     this.hide();
  181.                 } else {
  182.                     JOptionPane.showMessageDialog(null, "用户名与密码不对！！");
  183.                 }
  184.             }
  185.         } else {
  186.             new SalarySearch().setVisible(true);
  187.         }
  188.     }// GEN-LAST:event_jButton1ActionPerformed
  190.     private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton2ActionPerformed
  191.         // TODO add your handling code here:
  192.         int selection = JOptionPane.showConfirmDialog(this, "是否退出？", "退出提示", JOptionPane.OK_CANCEL_OPTION,
  193.                 JOptionPane.WARNING_MESSAGE);
  194.         if (selection == JOptionPane.OK_OPTION) {
  195.             System.exit(0);
  196.         }
  197.     }// GEN-LAST:event_jButton2ActionPerformed
  199.     /**
  200.      * @param args the command line arguments
  201.      */
  202.     public static void main(String args[]) {
  203.         java.awt.EventQueue.invokeLater(new Runnable() {
  204.             public void run() {
  205.                 new Login().setVisible(true);
  206.             }
  207.         });
  208.     }
  210.     // Variables declaration - do not modify//GEN-BEGIN:variables
  211.     private javax.swing.JButton jButton1;
  212.     private javax.swing.JButton jButton2;
  213.     private javax.swing.JComboBox jComboBox1;
  214.     private javax.swing.JLabel jLabel1;
  215.     private javax.swing.JLabel jLabel2;
  216.     private javax.swing.JLabel jLabel3;
  217.     private javax.swing.JLabel jLabel4;
  218.     private javax.swing.JPasswordField jPasswordField1;
  219.     private javax.swing.JTextField username;
  220.     // End of variables declaration//GEN-END:variables
  222. }

MainFrame.java

  1. /*
  2.  * To change this template, choose Tools | Templates
  3.  * and open the template in the editor.
  4.  */
  6. /*
  7.  * MainFrame.java
  8.  *
  9.  * Created on 2013-6-18, 22:12:20
  10.  */
  12. package com.sjsq;
  14. import java.awt.Graphics;
  15. import java.awt.Image;
  16. import java.awt.Toolkit;
  17. import javax.swing.JOptionPane;
  19. /**
  20.  *
  21.  * @author Administrator
  22.  */
  23. public class MainFrame extends javax.swing.JFrame {
  25.     /** Creates new form MainFrame */
  26.     private Toolkit tk = Toolkit.getDefaultToolkit();
  27.     int x = tk.getScreenSize().width / 2 - 250;
  28.     int y = tk.getScreenSize().height / 2 - 250;
  30.     public MainFrame() {
  31.         setTitle("工资管理系统");
  32.         setLocation(x, y);
  33.         initComponents();
  34.         // this.setDefaultCloseOperation(MainFrame.DO_NOTHING_ON_CLOSE);
  35.     }
  37.     /**
  38.      * This method is called from within the constructor to initialize the form.
  39.      * WARNING: Do NOT modify this code. The content of this method is always
  40.      * regenerated by the Form Editor.
  41.      */
  42.     @SuppressWarnings("unchecked")
  43.     // <editor-fold defaultstate="collapsed" desc="Generated
  44.     // Code">//GEN-BEGIN:initComponents
  45.     private void initComponents() {
  47.         jColorChooser1 = new javax.swing.JColorChooser();
  48.         jPanel1 = new javax.swing.JPanel() {
  49.             protected void paintComponent(Graphics g) {
  50.                 super.paintComponent(g);
  51.                 Image img = Toolkit.getDefaultToolkit().getImage("src/resource/009.jpg");
  52.                 Graphics gg = g.create();
  53.                 gg.drawImage(img, 0, 0, getWidth(), getHeight(), this);
  54.                 gg.dispose();
  55.             }
  56.         };
  57.         jMenuBar1 = new javax.swing.JMenuBar();
  58.         jMenu1 = new javax.swing.JMenu();
  59.         jMenuItem1 = new javax.swing.JMenuItem();
  60.         jMenuItem2 = new javax.swing.JMenuItem();
  61.         jMenuItem3 = new javax.swing.JMenuItem();
  62.         jMenu2 = new javax.swing.JMenu();
  63.         jMenuItem4 = new javax.swing.JMenuItem();
  64.         jMenuItem5 = new javax.swing.JMenuItem();
  65.         jMenuItem6 = new javax.swing.JMenuItem();
  66.         jMenu3 = new javax.swing.JMenu();
  67.         jMenuItem7 = new javax.swing.JMenuItem();
  68.         jMenuItem8 = new javax.swing.JMenuItem();
  69.         jMenuItem12 = new javax.swing.JMenuItem();
  70.         jMenu4 = new javax.swing.JMenu();
  71.         jMenuItem9 = new javax.swing.JMenuItem();
  72.         jMenuItem10 = new javax.swing.JMenuItem();
  73.         jMenuItem13 = new javax.swing.JMenuItem();
  74.         jMenu5 = new javax.swing.JMenu();
  75.         jMenuItem11 = new javax.swing.JMenuItem();
  77.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  78.         setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
  80.         jPanel1.addAncestorListener(new javax.swing.event.AncestorListener() {
  81.             public void ancestorMoved(javax.swing.event.AncestorEvent evt) {
  82.             }
  84.             public void ancestorAdded(javax.swing.event.AncestorEvent evt) {
  85.                 jPanel1AncestorAdded(evt);
  86.             }
  88.             public void ancestorRemoved(javax.swing.event.AncestorEvent evt) {
  89.             }
  90.         });
  92.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  93.         jPanel1.setLayout(jPanel1Layout);
  94.         jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  95.                 .addGap(0, 637, Short.MAX_VALUE));
  96.         jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  97.                 .addGap(0, 365, Short.MAX_VALUE));
  99.         jMenu1.setText("员工信息管理");
  100.         jMenu1.addActionListener(new java.awt.event.ActionListener() {
  101.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  102.                 jMenu1ActionPerformed(evt);
  103.             }
  104.         });
  106.         jMenuItem1.setAccelerator(
  107.                 javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_A, java.awt.event.InputEvent.CTRL_MASK));
  108.         jMenuItem1.setText("添加员工信息");
  109.         jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
  110.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  111.                 jMenuItem1ActionPerformed(evt);
  112.             }
  113.         });
  114.         jMenu1.add(jMenuItem1);
  116.         jMenuItem2.setAccelerator(
  117.                 javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_M, java.awt.event.InputEvent.CTRL_MASK));
  118.         jMenuItem2.setText("修改员工信息");
  119.         jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
  120.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  121.                 jMenuItem2ActionPerformed(evt);
  122.             }
  123.         });
  124.         jMenu1.add(jMenuItem2);
  126.         jMenuItem3.setAccelerator(
  127.                 javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_D, java.awt.event.InputEvent.CTRL_MASK));
  128.         jMenuItem3.setText("删除员工信息");
  129.         jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
  130.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  131.                 jMenuItem3ActionPerformed(evt);
  132.             }
  133.         });
  134.         jMenu1.add(jMenuItem3);
  136.         jMenuBar1.add(jMenu1);
  138.         jMenu2.setText("部门信息管理");
  140.         jMenuItem4.setText("新增部门信息");
  141.         jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
  142.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  143.                 jMenuItem4ActionPerformed(evt);
  144.             }
  145.         });
  146.         jMenu2.add(jMenuItem4);
  148.         jMenuItem5.setText("修改部门信息");
  149.         jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
  150.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  151.                 jMenuItem5ActionPerformed(evt);
  152.             }
  153.         });
  154.         jMenu2.add(jMenuItem5);
  156.         jMenuItem6.setText("删除部门信息");
  157.         jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
  158.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  159.                 jMenuItem6ActionPerformed(evt);
  160.             }
  161.         });
  162.         jMenu2.add(jMenuItem6);
  164.         jMenuBar1.add(jMenu2);
  166.         jMenu3.setText("员工工资设定");
  168.         jMenuItem7.setText("工资设定");
  169.         jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
  170.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  171.                 jMenuItem7ActionPerformed(evt);
  172.             }
  173.         });
  174.         jMenu3.add(jMenuItem7);
  176.         jMenuItem8.setText("工资查询");
  177.         jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
  178.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  179.                 jMenuItem8ActionPerformed(evt);
  180.             }
  181.         });
  182.         jMenu3.add(jMenuItem8);
  184.         jMenuItem12.setText("工资一览表");
  185.         jMenuItem12.addActionListener(new java.awt.event.ActionListener() {
  186.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  187.                 jMenuItem12ActionPerformed(evt);
  188.             }
  189.         });
  190.         jMenu3.add(jMenuItem12);
  192.         jMenuBar1.add(jMenu3);
  194.         jMenu4.setText("系统设置");
  196.         jMenuItem9.setText("信息统计");
  197.         jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
  198.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  199.                 jMenuItem9ActionPerformed(evt);
  200.             }
  201.         });
  202.         jMenu4.add(jMenuItem9);
  204.         jMenuItem10.setText("修改密码");
  205.         jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
  206.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  207.                 jMenuItem10ActionPerformed(evt);
  208.             }
  209.         });
  210.         jMenu4.add(jMenuItem10);
  212.         jMenuItem13.setText("添加管理员");
  213.         jMenuItem13.addActionListener(new java.awt.event.ActionListener() {
  214.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  215.                 jMenuItem13ActionPerformed(evt);
  216.             }
  217.         });
  218.         jMenu4.add(jMenuItem13);
  220.         jMenuBar1.add(jMenu4);
  222.         jMenu5.setText("退出系统");
  223.         jMenu5.addActionListener(new java.awt.event.ActionListener() {
  224.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  225.                 jMenu5ActionPerformed(evt);
  226.             }
  227.         });
  229.         jMenuItem11.setText("退出本系统");
  230.         jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
  231.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  232.                 jMenuItem11ActionPerformed(evt);
  233.             }
  234.         });
  235.         jMenu5.add(jMenuItem11);
  237.         jMenuBar1.add(jMenu5);
  239.         setJMenuBar(jMenuBar1);
  241.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  242.         getContentPane().setLayout(layout);
  243.         layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(
  244.                 jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE,
  245.                 javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE));
  246.         layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(
  247.                 jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE));
  249.         pack();
  250.     }// </editor-fold>//GEN-END:initComponents
  252.     private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem1ActionPerformed
  253.         // TODO add your handling code here:
  254.         new AddEmployee().setVisible(true);
  255.     }// GEN-LAST:event_jMenuItem1ActionPerformed
  257.     private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem2ActionPerformed
  258.         // TODO add your handling code here:
  259.         new ModifyEmployee().setVisible(true);
  260.     }// GEN-LAST:event_jMenuItem2ActionPerformed
  262.     private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem3ActionPerformed
  263.         // TODO add your handling code here:
  264.         new DeleteEmployee().setVisible(true);
  265.     }// GEN-LAST:event_jMenuItem3ActionPerformed
  267.     private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem4ActionPerformed
  268.         // TODO add your handling code here:
  269.         new AddDepartment().setVisible(true);
  270.     }// GEN-LAST:event_jMenuItem4ActionPerformed
  272.     private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem5ActionPerformed
  273.         // TODO add your handling code here:
  274.         new ModifyDepartment().setVisible(true);
  275.     }// GEN-LAST:event_jMenuItem5ActionPerformed
  277.     private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem6ActionPerformed
  278.         // TODO add your handling code here:
  279.         new DeleteDepartment().setVisible(true);
  280.     }// GEN-LAST:event_jMenuItem6ActionPerformed
  282.     private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem7ActionPerformed
  283.         // TODO add your handling code here:
  284.         new SalarySetting().setVisible(true);
  285.     }// GEN-LAST:event_jMenuItem7ActionPerformed
  287.     private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem8ActionPerformed
  288.         // TODO add your handling code here:
  289.         new SalarySearch().setVisible(true);
  290.     }// GEN-LAST:event_jMenuItem8ActionPerformed
  292.     private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem9ActionPerformed
  293.         // TODO add your handling code here:
  294.         new Statistics().setVisible(true);
  295.     }// GEN-LAST:event_jMenuItem9ActionPerformed
  297.     private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem10ActionPerformed
  298.         // TODO add your handling code here:
  299.         new ModifyPassWord().setVisible(true);
  300.     }// GEN-LAST:event_jMenuItem10ActionPerformed
  302.     private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem11ActionPerformed
  303.         // TODO add your handling code here:
  304.         int option = JOptionPane.showConfirmDialog(null, "确定要退出本系统?", "系统提示", JOptionPane.YES_NO_OPTION);
  305.         if (option == JOptionPane.YES_OPTION)
  306.             System.exit(0);
  307.         else
  308.             this.setDefaultCloseOperation(MainFrame.DO_NOTHING_ON_CLOSE);
  309.     }// GEN-LAST:event_jMenuItem11ActionPerformed
  311.     private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem12ActionPerformed
  312.         // TODO add your handling code here:
  313.         new SalaryShow().setVisible(true);
  314.     }// GEN-LAST:event_jMenuItem12ActionPerformed
  316.     private void jMenuItem13ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem13ActionPerformed
  317.         // TODO add your handling code here:
  318.         new NewManager().setVisible(true);
  319.     }// GEN-LAST:event_jMenuItem13ActionPerformed
  321.     private void jMenu5ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenu5ActionPerformed
  322.         // TODO add your handling code here:
  323.     }// GEN-LAST:event_jMenu5ActionPerformed
  325.     private void jPanel1AncestorAdded(javax.swing.event.AncestorEvent evt) {// GEN-FIRST:event_jPanel1AncestorAdded
  326.         // TODO add your handling code here:
  327.     }// GEN-LAST:event_jPanel1AncestorAdded
  329.     private void jMenu1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenu1ActionPerformed
  330.         // TODO add your handling code here:
  331.     }// GEN-LAST:event_jMenu1ActionPerformed
  333.     /**
  334.      * @param args the command line arguments
  335.      */
  336.     /*
  337.      * public static void main(String args[]) { java.awt.EventQueue.invokeLater(new
  338.      * Runnable() { public void run() { new MainFrame().setVisible(true); } }); }
  339.      */
  340.     // Variables declaration - do not modify//GEN-BEGIN:variables
  341.     private javax.swing.JColorChooser jColorChooser1;
  342.     private javax.swing.JMenu jMenu1;
  343.     private javax.swing.JMenu jMenu2;
  344.     private javax.swing.JMenu jMenu3;
  345.     private javax.swing.JMenu jMenu4;
  346.     private javax.swing.JMenu jMenu5;
  347.     private javax.swing.JMenuBar jMenuBar1;
  348.     private javax.swing.JMenuItem jMenuItem1;
  349.     private javax.swing.JMenuItem jMenuItem10;
  350.     private javax.swing.JMenuItem jMenuItem11;
  351.     private javax.swing.JMenuItem jMenuItem12;
  352.     private javax.swing.JMenuItem jMenuItem13;
  353.     private javax.swing.JMenuItem jMenuItem2;
  354.     private javax.swing.JMenuItem jMenuItem3;
  355.     private javax.swing.JMenuItem jMenuItem4;
  356.     private javax.swing.JMenuItem jMenuItem5;
  357.     private javax.swing.JMenuItem jMenuItem6;
  358.     private javax.swing.JMenuItem jMenuItem7;
  359.     private javax.swing.JMenuItem jMenuItem8;
  360.     private javax.swing.JMenuItem jMenuItem9;
  361.     private javax.swing.JPanel jPanel1;
  362.     // End of variables declaration//GEN-END:variables
  364. }

DBConn.java

  1. /*
  2.  * To change this template, choose Tools | Templates
  3.  * and open the template in the editor.
  4.  */
  6. package com.sjsq;
  8. import java.sql.*;
  9. import java.util.logging.Level;
  10. import java.util.logging.Logger;
  12. /**
  13.  *
  14.  * @author Administrator
  15.  */
  16. public class DBConn {
  18.     private Connection conn = null;
  19.     private Statement stmt = null;
  20.     private ResultSet rs = null;
  21.     String url = "jdbc:mysql://localhost/swing_salary_management?serverTimezone=UTC";
  22.     String username = "root";
  23.     String password = "admin";
  25.     public DBConn() { // 构造方法
  27.         try {
  28.             Class.forName("com.mysql.cj.jdbc.Driver");
  29.             // conn = DriverManager.getConnection(url,username,password);
  30.         } catch (java.lang.ClassNotFoundException e) {
  31.             System.err.println(e.getMessage());
  32.         } // catch (SQLException ex) {
  33.             // Logger.getLogger(DBConn.class.getName()).log(Level.SEVERE, null, ex);
  34.             // }
  35.     }
  37.     public int Check(String sql) {
  38.         // int result = 0;
  39.         try {
  40.             conn = DriverManager.getConnection(url, username, password);
  41.             stmt = conn.createStatement();
  42.             rs = stmt.executeQuery(sql);
  43.             if (rs.next()) {
  44.                 return 1;
  45.             }
  46.         } catch (SQLException e) {
  47.             e.printStackTrace();
  48.         }
  49.         return 0;
  50.     }
  52.     public ResultSet Search(String sql) { // 建立查询
  54.         try {
  55.             conn = DriverManager.getConnection(url, username, password);
  56.             stmt = conn.createStatement();
  57.             rs = stmt.executeQuery(sql);
  58.         } catch (SQLException ex) {
  59.             System.err.println(ex.getMessage());
  60.         }
  61.         return rs;
  62.     }
  64.     public int Update(String sql) { // 操作数据库
  66.         int result = 0;
  67.         try {
  68.             conn = DriverManager.getConnection(url, username, password);
  69.             stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
  70.             result = stmt.executeUpdate(sql);
  71.         } catch (SQLException ex) {
  72.             result = 0;
  73.         }
  74.         return result;
  75.     }
  77.     /**
  78.      * 关闭数据库连接
  79.      */
  80.     public void close() {
  81.         try {
  82.             if (rs != null) {
  83.                 rs.close();
  84.             }
  85.         } catch (Exception e) {
  86.             e.printStackTrace(System.err);
  87.         }
  89.         try {
  90.             if (stmt != null) {
  91.                 stmt.close();
  92.             }
  93.         } catch (Exception e) {
  94.             e.printStackTrace(System.err);
  95.         }
  97.         try {
  98.             if (conn != null) {
  99.                 conn.close();
  100.             }
  101.         } catch (Exception e) {
  102.             e.printStackTrace(System.err);
  103.         }
  104.     }
  106. }

AddDepartment.java

  1. /*
  2.  * To change this template, choose Tools | Templates
  3.  * and open the template in the editor.
  4.  */
  6. /*
  7.  * AddDepartment.java
  8.  *
  9.  * Created on 2013-6-22, 12:14:44
  10.  */
  12. package com.sjsq;
  14. //import SQLConnection.DBConn;
  15. import java.awt.Toolkit;
  16. import javax.swing.JOptionPane;
  18. /**
  19.  *
  20.  * @author Administrator
  21.  */
  22. public class AddDepartment extends javax.swing.JFrame {
  24.     /** Creates new form AddDepartment */
  25.     private Toolkit tk = Toolkit.getDefaultToolkit();
  26.     int x = tk.getScreenSize().width / 2 - 100;
  27.     int y = tk.getScreenSize().height / 2 - 100;
  29.     public AddDepartment() {
  30.         initComponents();
  31.         setTitle("添加部门信息");
  32.         setLocation(x, y);
  33.         setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  34.     }
  36.     /**
  37.      * This method is called from within the constructor to initialize the form.
  38.      * WARNING: Do NOT modify this code. The content of this method is always
  39.      * regenerated by the Form Editor.
  40.      */
  41.     @SuppressWarnings("unchecked")
  42.     // <editor-fold defaultstate="collapsed" desc="Generated
  43.     // Code">//GEN-BEGIN:initComponents
  44.     private void initComponents() {
  46.         jPanel1 = new javax.swing.JPanel();
  47.         jLabel1 = new javax.swing.JLabel();
  48.         jLabel2 = new javax.swing.JLabel();
  49.         jLabel3 = new javax.swing.JLabel();
  50.         jLabel4 = new javax.swing.JLabel();
  51.         jTextField1 = new javax.swing.JTextField();
  52.         jTextField2 = new javax.swing.JTextField();
  53.         jTextField3 = new javax.swing.JTextField();
  54.         jTextField4 = new javax.swing.JTextField();
  55.         jButton1 = new javax.swing.JButton();
  56.         jButton2 = new javax.swing.JButton();
  58.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  60.         jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("部门信息"));
  62.         jLabel1.setText("部门编号:");
  64.         jLabel2.setText("部门名称:");
  66.         jLabel3.setText("负责人:");
  68.         jLabel4.setText("总人数:");
  70.         jTextField1.addActionListener(new java.awt.event.ActionListener() {
  71.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  72.                 jTextField1ActionPerformed(evt);
  73.             }
  74.         });
  76.         jTextField2.addActionListener(new java.awt.event.ActionListener() {
  77.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  78.                 jTextField2ActionPerformed(evt);
  79.             }
  80.         });
  82.         jTextField3.addActionListener(new java.awt.event.ActionListener() {
  83.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  84.                 jTextField3ActionPerformed(evt);
  85.             }
  86.         });
  88.         jTextField4.addActionListener(new java.awt.event.ActionListener() {
  89.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  90.                 jTextField4ActionPerformed(evt);
  91.             }
  92.         });
  94.         jButton1.setText("添加");
  95.         jButton1.addActionListener(new java.awt.event.ActionListener() {
  96.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  97.                 jButton1ActionPerformed(evt);
  98.             }
  99.         });
  101.         jButton2.setText("取消");
  102.         jButton2.addActionListener(new java.awt.event.ActionListener() {
  103.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  104.                 jButton2ActionPerformed(evt);
  105.             }
  106.         });
  108.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  109.         jPanel1.setLayout(jPanel1Layout);
  110.         jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  111.                 .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addGroup(jPanel1Layout
  112.                         .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  113.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  114.                                 .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel1)
  115.                                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  116.                                         .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
  117.                                                 javax.swing.GroupLayout.PREFERRED_SIZE))
  118.                                 .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel2)
  119.                                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  120.                                         .addComponent(jTextField2))
  121.                                 .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel3).addGap(18, 18, 18)
  122.                                         .addComponent(jTextField3)))
  123.                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jButton1).addGap(18, 18, 18)
  124.                                 .addComponent(jButton2))
  125.                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel4).addGap(18, 18, 18)
  126.                                 .addComponent(jTextField4)))
  127.                         .addContainerGap(16, Short.MAX_VALUE)));
  128.         jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  129.                 .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap()
  130.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  131.                                 .addComponent(jLabel1).addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE,
  132.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  133.                         .addGap(18, 18, 18)
  134.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  135.                                 .addComponent(jLabel2).addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE,
  136.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  137.                         .addGap(18, 18, 18)
  138.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  139.                                 .addComponent(jLabel3).addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE,
  140.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  141.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  142.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  143.                                 .addComponent(jLabel4).addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE,
  144.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  145.                         .addGap(18, 18, 18)
  146.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  147.                                 .addComponent(jButton1).addComponent(jButton2))
  148.                         .addContainerGap(18, Short.MAX_VALUE)));
  150.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  151.         getContentPane().setLayout(layout);
  152.         layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  153.                 .addGroup(layout.createSequentialGroup().addGap(79, 79, 79)
  154.                         .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
  155.                                 javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  156.                         .addContainerGap(145, Short.MAX_VALUE)));
  157.         layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  158.                 .addGroup(layout.createSequentialGroup().addGap(22, 22, 22)
  159.                         .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
  160.                                 javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  161.                         .addContainerGap(54, Short.MAX_VALUE)));
  163.         pack();
  164.     }// </editor-fold>//GEN-END:initComponents
  166.     private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton1ActionPerformed
  167.         // TODO add your handling code here:
  168.         String strID = jTextField1.getText(); // 部门编号
  169.         String strName = jTextField2.getText(); // 部门姓名
  170.         String strDirector = jTextField3.getText(); // 负责人
  171.         String strNumber = jTextField4.getText(); // 总人数
  173.         if (strID.equals("")) {
  174.             JOptionPane.showMessageDialog(null, "部门编号不能为空！");
  175.         } else if (strName.equals("")) {
  176.             JOptionPane.showMessageDialog(null, "部门名称不能为空！");
  177.         } else if (strDirector.equals("")) {
  178.             JOptionPane.showMessageDialog(null, "部门负责人不能为空！");
  179.         } else {
  181.             // int ID = Integer.parseInt(strID);
  182.             int Number = Integer.parseInt(strNumber);
  183.             String checksql = "select id from department where id = '" + strID + " '";
  184.             System.out.println(checksql);
  185.             DBConn db = new DBConn();
  187.             if (db.Check(checksql) != 0) {
  188.                 JOptionPane.showMessageDialog(null, "该号已存在！！！");
  189.             } else {
  190.                 String sql = "insert into department values('" + strID + "','" + strName + "','" + strDirector + "','"
  191.                         + Number + "')";
  192.                 int result = db.Update(sql);
  193.                 if (result != 0) {
  194.                     JOptionPane.showMessageDialog(null, "部门添加成功！！！");
  195.                 } else {
  196.                     JOptionPane.showMessageDialog(null, "部门添加失败，请重新添加！");
  197.                 }
  198.             }
  199.         }
  200.         jTextField1.setText("");
  201.         jTextField2.setText("");
  202.         jTextField3.setText("");
  203.         jTextField4.setText("");
  204.     }// GEN-LAST:event_jButton1ActionPerformed
  206.     private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton2ActionPerformed
  207.         // TODO add your handling code here:
  208.         jTextField1.setText("");
  209.         jTextField2.setText("");
  210.         jTextField3.setText("");
  211.         jTextField4.setText("");
  212.     }// GEN-LAST:event_jButton2ActionPerformed
  214.     private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField1ActionPerformed
  215.         // TODO add your handling code here:
  216.     }// GEN-LAST:event_jTextField1ActionPerformed
  218.     private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField2ActionPerformed
  219.         // TODO add your handling code here:
  220.     }// GEN-LAST:event_jTextField2ActionPerformed
  222.     private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField3ActionPerformed
  223.         // TODO add your handling code here:
  224.     }// GEN-LAST:event_jTextField3ActionPerformed
  226.     private void jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField4ActionPerformed
  227.         // TODO add your handling code here:
  228.     }// GEN-LAST:event_jTextField4ActionPerformed
  230.     /**
  231.      * @param args the command line arguments
  232.      * 
  233.      *             public static void main(String args[]) {
  234.      *             java.awt.EventQueue.invokeLater(new Runnable() { public void
  235.      *             run() { new AddDepartment().setVisible(true); } }); }
  236.      */
  238.     // Variables declaration - do not modify//GEN-BEGIN:variables
  239.     private javax.swing.JButton jButton1;
  240.     private javax.swing.JButton jButton2;
  241.     private javax.swing.JLabel jLabel1;
  242.     private javax.swing.JLabel jLabel2;
  243.     private javax.swing.JLabel jLabel3;
  244.     private javax.swing.JLabel jLabel4;
  245.     private javax.swing.JPanel jPanel1;
  246.     private javax.swing.JTextField jTextField1;
  247.     private javax.swing.JTextField jTextField2;
  248.     private javax.swing.JTextField jTextField3;
  249.     private javax.swing.JTextField jTextField4;
  250.     // End of variables declaration//GEN-END:variables
  252. }

AddEmployee.java

  1. /*
  2.  * To change this template, choose Tools | Templates
  3.  * and open the template in the editor.
  4.  */
  6. /*
  7.  * SecondGUI.java
  8.  *
  9.  * Created on 2013-6-19, 12:49:33
  10.  */
  12. package com.sjsq;
  14. import java.awt.Toolkit;
  15. import java.sql.ResultSet;
  16. import java.sql.SQLException;
  17. import java.util.Vector;
  18. import javax.swing.DefaultComboBoxModel;
  19. import javax.swing.JOptionPane;
  20. import javax.swing.table.DefaultTableModel;
  22. /**
  23.  *
  24.  * @author Administrator
  25.  */
  26. public class AddEmployee extends javax.swing.JFrame {
  28.     /** Creates new form SecondGUI */
  29.     private Toolkit tk = Toolkit.getDefaultToolkit();
  30.     int x = tk.getScreenSize().width / 2 - 180;
  31.     int y = tk.getScreenSize().height / 2 - 180;
  32.     DefaultTableModel dm;
  33.     DefaultComboBoxModel dcm;
  35.     public AddEmployee() {
  36.         initTable();
  37.         initComboBox();
  38.         initComponents();
  39.         setTitle("添加员工");
  40.         setLocation(x, y);
  41.         setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  42.     }
  44. //初始化表格
  45.     private void initTable() {
  46.         try {
  47.             String[] head = { "工号", "姓名", "性别", "年龄", "部门", "职位", "电话", "入厂时间", "住址" };
  48.             Object obj[][] = new Object[0][0];
  49.             dm = new DefaultTableModel(obj, head);
  51.             String sql = "select id,name,sex,age,department,position,phone,time,address from employee";
  52.             DBConn db = new DBConn();
  53.             Vector v;
  54.             System.out.println(sql);
  55.             ResultSet rs = db.Search(sql);
  56.             while (rs.next()) {
  57.                 v = new Vector();
  58.                 v.add(rs.getString(1));
  59.                 v.add(rs.getString(2));
  60.                 v.add(rs.getString(3));
  61.                 v.add(rs.getString(4));
  62.                 v.add(rs.getString(5));
  63.                 v.add(rs.getString(6));
  64.                 v.add(rs.getString(7));
  65.                 v.add(rs.getString(8));
  66.                 v.add(rs.getString(9));
  67.                 dm.addRow(v);
  68.             }
  69.             db.close();
  70.         } catch (SQLException ex) {
  71.             System.out.println(ex);
  72.         }
  73.     }
  75.     /// 初始化下拉列表
  76.     private void initComboBox() {
  77.         Vector v = new Vector();
  78.         DBConn db = new DBConn();
  79.         try {
  80.             ResultSet rs = db.Search("select distinct name from department");
  81.             while (rs.next()) {
  82.                 v.addElement(rs.getString("name")); // 添加到向量尾部，大小加1
  83.             }
  84.             dcm = new DefaultComboBoxModel(v);
  85.         } catch (SQLException ex) {
  86.             ex.printStackTrace();
  87.         } finally {
  88.             db.close();
  89.         }
  90.     }
  92.     @SuppressWarnings("unchecked")
  93.     // <editor-fold defaultstate="collapsed" desc="Generated
  94.     // Code">//GEN-BEGIN:initComponents
  95.     private void initComponents() {
  97.         buttonGroup1 = new javax.swing.ButtonGroup();
  98.         jPanel1 = new javax.swing.JPanel();
  99.         jLabel1 = new javax.swing.JLabel();
  100.         jTextField1 = new javax.swing.JTextField();
  101.         jLabel2 = new javax.swing.JLabel();
  102.         jTextField2 = new javax.swing.JTextField();
  103.         jLabel3 = new javax.swing.JLabel();
  104.         jRadioButton1 = new javax.swing.JRadioButton();
  105.         jRadioButton2 = new javax.swing.JRadioButton();
  106.         jLabel4 = new javax.swing.JLabel();
  107.         jTextField3 = new javax.swing.JTextField();
  108.         jLabel5 = new javax.swing.JLabel();
  109.         jComboBox1 = new javax.swing.JComboBox();
  110.         jLabel6 = new javax.swing.JLabel();
  111.         jTextField4 = new javax.swing.JTextField();
  112.         jLabel7 = new javax.swing.JLabel();
  113.         jTextField5 = new javax.swing.JTextField();
  114.         jLabel8 = new javax.swing.JLabel();
  115.         jTextField6 = new javax.swing.JTextField();
  116.         jButton1 = new javax.swing.JButton();
  117.         jButton2 = new javax.swing.JButton();
  118.         jLabel9 = new javax.swing.JLabel();
  119.         jTextField7 = new javax.swing.JTextField();
  120.         jScrollPane1 = new javax.swing.JScrollPane();
  121.         jTable1 = new javax.swing.JTable();
  123.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  125.         jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("员工信息"));
  127.         jLabel1.setText("工号:");
  129.         jLabel2.setText("姓名:");
  131.         jTextField2.addActionListener(new java.awt.event.ActionListener() {
  132.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  133.                 jTextField2ActionPerformed(evt);
  134.             }
  135.         });
  137.         jLabel3.setText("性别:");
  139.         buttonGroup1.add(jRadioButton1);
  140.         jRadioButton1.setSelected(true);
  141.         jRadioButton1.setText("男");
  143.         buttonGroup1.add(jRadioButton2);
  144.         jRadioButton2.setText("女");
  146.         jLabel4.setText("年龄:");
  148.         jTextField3.addActionListener(new java.awt.event.ActionListener() {
  149.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  150.                 jTextField3ActionPerformed(evt);
  151.             }
  152.         });
  154.         jLabel5.setText("所属部门:");
  156.         jComboBox1.setModel(dcm);
  157.         jComboBox1.setToolTipText("请选择");
  158.         jComboBox1.setBorder(javax.swing.BorderFactory.createCompoundBorder());
  159.         jComboBox1.addActionListener(new java.awt.event.ActionListener() {
  160.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  161.                 jComboBox1ActionPerformed(evt);
  162.             }
  163.         });
  165.         jLabel6.setText("职位:");
  167.         jTextField4.addActionListener(new java.awt.event.ActionListener() {
  168.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  169.                 jTextField4ActionPerformed(evt);
  170.             }
  171.         });
  173.         jLabel7.setText("联系方式:");
  175.         jTextField5.addActionListener(new java.awt.event.ActionListener() {
  176.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  177.                 jTextField5ActionPerformed(evt);
  178.             }
  179.         });
  181.         jLabel8.setText("住址:");
  183.         jTextField6.addActionListener(new java.awt.event.ActionListener() {
  184.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  185.                 jTextField6ActionPerformed(evt);
  186.             }
  187.         });
  189.         jButton1.setText("添加");
  190.         jButton1.addActionListener(new java.awt.event.ActionListener() {
  191.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  192.                 jButton1ActionPerformed(evt);
  193.             }
  194.         });
  196.         jButton2.setText("取消");
  197.         jButton2.addActionListener(new java.awt.event.ActionListener() {
  198.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  199.                 jButton2ActionPerformed(evt);
  200.             }
  201.         });
  203.         jLabel9.setText("入厂时间:");
  205.         jTextField7.addActionListener(new java.awt.event.ActionListener() {
  206.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  207.                 jTextField7ActionPerformed(evt);
  208.             }
  209.         });
  211.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  212.         jPanel1.setLayout(jPanel1Layout);
  213.         jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  214.                 .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addGroup(jPanel1Layout
  215.                         .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  216.                         .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout
  217.                                 .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING).addComponent(jButton1)
  218.                                 .addGroup(jPanel1Layout
  219.                                         .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  220.                                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel1)
  221.                                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  222.                                                 .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 82,
  223.                                                         javax.swing.GroupLayout.PREFERRED_SIZE))
  224.                                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel2)
  225.                                                 .addGap(18, 18, 18).addComponent(jTextField2))
  226.                                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel3)
  227.                                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  228.                                                 .addComponent(jRadioButton1)
  229.                                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  230.                                                 .addComponent(jRadioButton2))
  231.                                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel4)
  232.                                                 .addGap(18, 18, 18).addComponent(jTextField3,
  233.                                                         javax.swing.GroupLayout.PREFERRED_SIZE, 80,
  234.                                                         javax.swing.GroupLayout.PREFERRED_SIZE))))
  235.                                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  236.                                         .addGroup(jPanel1Layout.createSequentialGroup().addGap(31, 31, 31)
  237.                                                 .addGroup(jPanel1Layout
  238.                                                         .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
  239.                                                                 false)
  240.                                                         .addGroup(javax.swing.GroupLayout.Alignment.LEADING,
  241.                                                                 jPanel1Layout.createSequentialGroup()
  242.                                                                         .addGroup(jPanel1Layout.createParallelGroup(
  243.                                                                                 javax.swing.GroupLayout.Alignment.LEADING)
  244.                                                                                 .addComponent(jLabel5)
  245.                                                                                 .addComponent(jLabel6))
  246.                                                                         .addPreferredGap(
  247.                                                                                 javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  248.                                                                         .addGroup(jPanel1Layout.createParallelGroup(
  249.                                                                                 javax.swing.GroupLayout.Alignment.LEADING,
  250.                                                                                 false)
  251.                                                                                 .addComponent(jComboBox1, 0,
  252.                                                                                         javax.swing.GroupLayout.DEFAULT_SIZE,
  253.                                                                                         Short.MAX_VALUE)
  254.                                                                                 .addComponent(jTextField4,
  255.                                                                                         javax.swing.GroupLayout.DEFAULT_SIZE,
  256.                                                                                         80, Short.MAX_VALUE)))
  257.                                                         .addGroup(javax.swing.GroupLayout.Alignment.LEADING,
  258.                                                                 jPanel1Layout.createSequentialGroup()
  259.                                                                         .addGroup(jPanel1Layout.createParallelGroup(
  260.                                                                                 javax.swing.GroupLayout.Alignment.LEADING)
  261.                                                                                 .addComponent(jLabel7)
  262.                                                                                 .addComponent(jLabel9))
  263.                                                                         .addPreferredGap(
  264.                                                                                 javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  265.                                                                         .addGroup(jPanel1Layout.createParallelGroup(
  266.                                                                                 javax.swing.GroupLayout.Alignment.LEADING)
  267.                                                                                 .addComponent(jTextField7,
  268.                                                                                         javax.swing.GroupLayout.DEFAULT_SIZE,
  269.                                                                                         80, Short.MAX_VALUE)
  270.                                                                                 .addComponent(jTextField5)))))
  271.                                         .addGroup(jPanel1Layout.createSequentialGroup().addGap(18, 18, 18)
  272.                                                 .addComponent(jButton2)))
  273.                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 57,
  274.                                         Short.MAX_VALUE))
  275.                         .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel8).addGap(18, 18, 18)
  276.                                 .addComponent(jTextField6, javax.swing.GroupLayout.DEFAULT_SIZE, 306, Short.MAX_VALUE)))
  277.                         .addContainerGap()));
  278.         jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  279.                 .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap()
  280.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  281.                                 .addComponent(jLabel1)
  282.                                 .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE,
  283.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  284.                                 .addComponent(jLabel5).addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
  285.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  286.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  287.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  288.                                 .addComponent(jLabel2)
  289.                                 .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE,
  290.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  291.                                 .addComponent(jLabel6).addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE,
  292.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  293.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  294.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  295.                                 .addComponent(jLabel3).addComponent(jRadioButton1).addComponent(jRadioButton2)
  296.                                 .addComponent(jLabel7).addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE,
  297.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  298.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  299.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  300.                                 .addComponent(jLabel4)
  301.                                 .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE,
  302.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  303.                                 .addComponent(jLabel9).addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE,
  304.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  305.                         .addGap(18, 18, 18)
  306.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  307.                                 .addComponent(jLabel8).addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE,
  308.                                         javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  309.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 9, Short.MAX_VALUE)
  310.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  311.                                 .addComponent(jButton1).addComponent(jButton2))
  312.                         .addContainerGap()));
  314.         jTable1.setAutoCreateRowSorter(true);
  315.         jTable1.setModel(dm);
  316.         jScrollPane1.setViewportView(jTable1);
  318.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  319.         getContentPane().setLayout(layout);
  320.         layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
  321.                 .createSequentialGroup()
  322.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  323.                         .addGroup(layout.createSequentialGroup().addGap(88, 88, 88).addComponent(jPanel1,
  324.                                 javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
  325.                                 javax.swing.GroupLayout.PREFERRED_SIZE))
  326.                         .addGroup(layout.createSequentialGroup().addGap(21, 21, 21).addComponent(jScrollPane1,
  327.                                 javax.swing.GroupLayout.PREFERRED_SIZE, 516, javax.swing.GroupLayout.PREFERRED_SIZE)))
  328.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
  329.         layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  330.                 .addGroup(layout.createSequentialGroup().addGap(32, 32, 32)
  331.                         .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
  332.                                 javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  333.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  334.                         .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 117,
  335.                                 javax.swing.GroupLayout.PREFERRED_SIZE)
  336.                         .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
  338.         pack();
  339.     }// </editor-fold>//GEN-END:initComponents
  341.     // 添加事件
  342.     private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton1ActionPerformed
  343.         // TODO add your handling code here:
  344.         String ID = jTextField1.getText();
  345.         String Name = jTextField2.getText();
  346.         String sex = "男";
  347.         if (jRadioButton2.isSelected())
  348.             sex = "女";
  349.         String ageStr = jTextField3.getText();
  350.         int age = Integer.parseInt(ageStr);
  351.         String department = (String) jComboBox1.getSelectedItem();
  352.         String position = jTextField4.getText(); // 职位
  353.         String phone = jTextField5.getText(); // 电话
  354.         String time = jTextField7.getText(); // 入厂时间
  355.         String address = jTextField6.getText();// 住址
  357.         if (ID.equals("")) {
  358.             JOptionPane.showMessageDialog(null, "请输入员工号");
  359.         } else if (Name.equals("")) {
  360.             JOptionPane.showMessageDialog(null, "请输入员工姓名");
  361.         } else if (ageStr.equals("")) {
  362.             JOptionPane.showMessageDialog(null, "请输入年龄");
  363.         } else if (department.equals("")) {
  364.             JOptionPane.showMessageDialog(null, "请输入所在部门");
  365.         } else if (position.equals("")) {
  366.             JOptionPane.showMessageDialog(null, "请输入员职位");
  367.         } else if (phone.equals("")) {
  368.             JOptionPane.showMessageDialog(null, "请输入联系电话");
  369.         } else if (time.equals("")) {
  370.             JOptionPane.showMessageDialog(null, "请输入入厂时间");
  371.         } else if (address.equals("")) {
  372.             JOptionPane.showMessageDialog(null, "请输入住址");
  373.         } else {
  374.             DBConn db = new DBConn();
  375.             if (db.Check("select ID from employee where ID = '" + ID + "'") != 0) {
  376.                 JOptionPane.showMessageDialog(null, "该工号的员工已存在！！");
  377.             } else {
  378.                 String sql = "insert into employee values('" + ID + "','" + Name + "','" + sex + "','" + age + "','"
  379.                         + department + "','" + position + "','" + phone + "','" + time + "','" + address + "')";
  380.                 System.out.println(sql);
  381.                 int result = db.Update(sql);
  382.                 if (result != 0) {
  383.                     JOptionPane.showMessageDialog(null, "添加成功！！");
  384.                     initTable();
  385.                 }
  386.                 db.close();
  388.             }
  390.             new AddEmployee().setVisible(true);
  392.         }
  393.         // this.System.exit(0);
  394.         this.setVisible(false);
  396.     }// GEN-LAST:event_jButton1ActionPerformed
  398.     private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton2ActionPerformed
  399.         // TODO add your handling code here:
  400.         jTextField1.setText("");
  401.         jTextField2.setText("");
  402.         jTextField4.setText("");
  403.         jTextField5.setText("");
  404.         jTextField3.setText("");
  405.         jTextField7.setText("");
  406.         jTextField6.setText("");
  408.     }// GEN-LAST:event_jButton2ActionPerformed
  410.     private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField2ActionPerformed
  411.         // TODO add your handling code here:
  412.     }// GEN-LAST:event_jTextField2ActionPerformed
  414.     private void jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField4ActionPerformed
  415.         // TODO add your handling code here:
  416.     }// GEN-LAST:event_jTextField4ActionPerformed
  418.     private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jComboBox1ActionPerformed
  419.         // TODO add your handling code here:
  420.     }// GEN-LAST:event_jComboBox1ActionPerformed
  422.     private void jTextField5ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField5ActionPerformed
  423.         // TODO add your handling code here:
  424.     }// GEN-LAST:event_jTextField5ActionPerformed
  426.     private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField3ActionPerformed
  427.         // TODO add your handling code here:
  428.     }// GEN-LAST:event_jTextField3ActionPerformed
  430.     private void jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField7ActionPerformed
  431.         // TODO add your handling code here:
  432.     }// GEN-LAST:event_jTextField7ActionPerformed
  434.     private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField6ActionPerformed
  435.         // TODO add your handling code here:
  436.     }// GEN-LAST:event_jTextField6ActionPerformed
  438.     /*
  439.      * 
  440.      * public static void main(String args[]) { java.awt.EventQueue.invokeLater(new
  441.      * Runnable() { public void run() { new AddEmployee().setVisible(true);
  442.      * 
  443.      * } }); }
  444.      */
  446.     // Variables declaration - do not modify//GEN-BEGIN:variables
  447.     private javax.swing.ButtonGroup buttonGroup1;
  448.     private javax.swing.JButton jButton1;
  449.     private javax.swing.JButton jButton2;
  450.     private javax.swing.JComboBox jComboBox1;
  451.     private javax.swing.JLabel jLabel1;
  452.     private javax.swing.JLabel jLabel2;
  453.     private javax.swing.JLabel jLabel3;
  454.     private javax.swing.JLabel jLabel4;
  455.     private javax.swing.JLabel jLabel5;
  456.     private javax.swing.JLabel jLabel6;
  457.     private javax.swing.JLabel jLabel7;
  458.     private javax.swing.JLabel jLabel8;
  459.     private javax.swing.JLabel jLabel9;
  460.     private javax.swing.JPanel jPanel1;
  461.     private javax.swing.JRadioButton jRadioButton1;
  462.     private javax.swing.JRadioButton jRadioButton2;
  463.     private javax.swing.JScrollPane jScrollPane1;
  464.     private javax.swing.JTable jTable1;
  465.     private javax.swing.JTextField jTextField1;
  466.     private javax.swing.JTextField jTextField2;
  467.     private javax.swing.JTextField jTextField3;
  468.     private javax.swing.JTextField jTextField4;
  469.     private javax.swing.JTextField jTextField5;
  470.     private javax.swing.JTextField jTextField6;
  471.     private javax.swing.JTextField jTextField7;
  472.     // End of variables declaration//GEN-END:variables
  474. }

四、其他

1.更多系统

JavaSwing系统系列实现

Java+Swing实现斗地主游戏

Java+Swing实现图书管理系统

Java+Swing实现医院管理系统

Java+Swing实现考试管理系统

Java+Swing实现酒店管理系统

Java+Swing实现超市管理系统

Java+Swing实现电影购票系统

Java+Swing实现仓库管理系统-1

Java+Swing实现仓库管理系统-2

Java+Swing实现进销存管理系统

Java+Swing实现自助取款机系统

Java+Swing实现通讯录管理系统

Java+Swing实现停车场管理系统

Java+Swing实现学生信息管理系统

Java+Swing实现学生宿舍管理系统

Java+Swing实现学生选课管理系统

Java+Swing实现学生成绩管理系统

Java+Swing实现学校教材管理系统

Java+Swing实现学校教务管理系统

Java+Swing实现企业人事管理系统

Java+Swing实现电子相册管理系统

Java+Swing实现超市管理系统-TXT存储数据

Java+Swing实现自助取款机系统-TXT存储数据

Java+Swing实现宠物商店管理系统-TXT存储数据

Java+JSP系统系列实现

Java+JSP实现学生图书管理系统

Java+JSP实现学生信息管理系统

Java+JSP实现用户信息管理系统

Java+Servlet系统系列实现

Java+Servlet+JSP实现航空订票系统

Java+Servlet+JSP实现新闻发布系统

Java+Servlet+JSP学生宿舍管理系统

Java+Servlet+JSP实现图书管理系统

Java+Servlet+JSP实现停车场管理系统

Java+Servlet+JSP实现房屋租赁管理系统

Java+Servlet+JSP实现学生信息管理系统

Java+Servlet+JSP实现学生选课管理系统

Java+Servlet+JSP实现宠物诊所管理系统

Java+Servlet+JSP实现学生成绩管理系统-1

Java+Servlet+JSP实现学生成绩管理系统-2

Java+SSM系统系列实现

Java+SSM+JSP实现图书管理系统

Java+SSM+JSP实现超市订单系统

J​​​ava+SSM+JSP实现网上考试系统

Java+SSM+JSP实现宠物商城系统

Java+SSM+Layui实现学生成绩管理系统

Java+SSM+Bootstrap实现学生信息管理系统

Java+SSH系统系列实现

Java+SSH+JSP实现在线考试系统

Java+SSH+JSP实现医院在线挂号系统

Java+Springboot系统系列实现

Java+Springboot+H-ui+Maven实现营销管理系统

Java+Springboot+Bootstrap+Maven实现网上商城系统

Java+Springboot+Bootstrap+Maven实现景区旅游管理系统

1.更多JavaWeb系统请关注专栏。

https://blog.csdn.net/helongqiang/category_10020130.htmlhttps://blog.csdn.net/helongqiang/category_10020130.html

2.更多JavaSwing系统请关注专栏。

https://blog.csdn.net/helongqiang/category_6229101.htmlhttps://blog.csdn.net/helongqiang/category_6229101.html

2.源码下载

Java+Swing+Mysql实现员工工资管理系统

3.运行项目

请点击以下链接，部署你的项目。

Eclipse如何导入JavaSwing项目超详细图文教程

Eclipse如何导入JavaSwing项目超详细视频教程

4.备注

如有侵权请联系我删除。

5.支持博主

如果您觉得此文对您有帮助，请点赞加关注加收藏。祝您生活愉快！

标签： mysql java eclipse
本文转载自: https://blog.csdn.net/helongqiang/article/details/122117668
版权归原作者 水坚石青 所有， 如有侵权，请联系我们删除。
登录后发布评论

“Eclipse+Java+Swing+Mysql实现员工工资管理系统”的评论:

还没有评论
关于作者
...
overfit同步小助手
文章同步
相关阅读

网络安全法-网络运行安全

使用selenium/drissionpage时如何阻止chrome自动跳转http到https

docker desktop 里部署的Open WebUI 管理员密码忘记了的处理方法

在ubuntu20.04中搭建onsite比赛运行环境

利用开源的低代码表单设计器FcDesigner高效管理和渲染复杂表单结构

Kafka学习笔记

【前端】浏览器输入url到页面呈现发生了什么？