主頁 > 後端開發 > Eclipse+Java+Swing+Mysql實作員工工資管理系統

Eclipse+Java+Swing+Mysql實作員工工資管理系統

2021-12-25 08:25:30 後端開發

目錄

一、系統介紹

1.開發環境

2.技術選型

3.系統功能

4.資料庫

二、系統展示

1.登錄系統

2.用戶-登錄系統

3.用戶-查看工資

4.管理員-主界面

5.管理員-添加員工資訊

6.管理員-修改員工資訊

7.管理員-洗掉員工資訊

8.管理員-添加部門資訊

9.管理員-修改部門資訊

10.管理員-洗掉部門資訊

11.管理員-工資設定

12.管理員-工資查詢

13.管理員-工資一覽

三、部分代碼

Login.java

MainFrame.java

DBConn.java

AddDepartment.java

AddEmployee.java

四、其他

1.更多系統

JavaSwing系統系列實作

Java+JSP系統系列實作

Java+Servlet系統系列實作

Java+SSM系統系列實作

Java+SSH系統系列實作

Java+Springboot系統系列實作

2.原始碼下載

3.運行專案

4.備注

5.支持博主

一、系統介紹

1.開發環境

開發工具：Eclipse2021

JDK版本：jdk1.8

Mysql版本：8.0.13

2.技術選型

Java+Swing+Mysql

3.系統功能

1.用戶匿名登錄系統，查詢工資資訊；

2.管理員登錄登出系統；

3.管理員增加員工資訊，修改員工資訊，洗掉員工資訊；

3.管理員增加部門資訊，修改部門資訊，洗掉部門資訊；

4.管理員查詢員工工資，添加員工工資；

4.資料庫

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : 127.0.0.1:3306
 Source Schema         : swing_salary_management

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 23/12/2021 21:19:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Director` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Number` int(16) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('ks001', '經理室', '贏政', 10);
INSERT INTO `department` VALUES ('ks002', '財務室', '劉邦', 6);
INSERT INTO `department` VALUES ('ks003', '軍機部', '李鴻章', 6);
INSERT INTO `department` VALUES ('ks004', '外交部', '張儀', 8);
INSERT INTO `department` VALUES ('ks005', '技術科', '朱元璋', 10);
INSERT INTO `department` VALUES ('ks006', '董事會', '李世民', 10);

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `ID` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sex` char(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `age` int(6) NOT NULL,
  `department` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `position` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `time` datetime(0) NULL DEFAULT NULL,
  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('0001', '贏政', '男', 37, '經理室', '經理', '10086', '0201-01-01 00:00:00', '咸陽');
INSERT INTO `employee` VALUES ('0002', '劉邦', '男', 40, '技術科', '技術長', '10087910', '2001-05-06 00:00:00', '長安');
INSERT INTO `employee` VALUES ('0003', '武則天', '女', 30, '財務室', '經理', '10088', '1999-08-07 00:00:00', '長安');
INSERT INTO `employee` VALUES ('0004', '劉秀', '男', 46, '軍機部', '副部長', '123548788', '2013-05-07 00:00:00', '桂林');
INSERT INTO `employee` VALUES ('0005', '西施', '女', 23, '財務室', '會計', '10089', '2001-02-03 00:00:00', '越國');
INSERT INTO `employee` VALUES ('0006', '李清照', '女', 25, '財務室', '出納', '125478', '2012-03-04 00:00:00', '宋國');
INSERT INTO `employee` VALUES ('0007', '楊玉環', '女', 29, '財務室', '會計', '125478', '2010-02-04 00:00:00', '長安');
INSERT INTO `employee` VALUES ('0008', '孫權', '男', 35, '外交部', '部長', '150478', '2005-05-04 00:00:00', '江東');
INSERT INTO `employee` VALUES ('0009', '李世民', '男', 54, '董事會', '會長', '100865', '1998-05-08 00:00:00', '西安');
INSERT INTO `employee` VALUES ('0010', '項羽', '男', 40, '經理室', '副經理', '1008670', '2000-02-05 00:00:00', '彭城');
INSERT INTO `employee` VALUES ('0011', '李鴻章', '男', 52, '軍機部', '部長', '1008699', '2001-05-08 00:00:00', '北京');
INSERT INTO `employee` VALUES ('0012', '張儀', '男', 44, '外交部', '部長', '10089', '2002-02-04 00:00:00', '魏國');
INSERT INTO `employee` VALUES ('0013', '朱元璋', '男', 35, '技術科', '部長', '100896', '2013-05-07 00:00:00', '南京');
INSERT INTO `employee` VALUES ('0014', '貂蟬', '女', 25, '經理室', '助理', '10086972', '2005-05-04 00:00:00', '洛陽');
INSERT INTO `employee` VALUES ('0015', '李淵', '男', 55, '董事會', '董事', '25897', '2001-02-05 00:00:00', '長安');
INSERT INTO `employee` VALUES ('0016', '1', '男', 1, '經理室', '1', '1', '2001-02-05 00:00:00', '2');

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary`  (
  `salaryID` int(4) NOT NULL AUTO_INCREMENT,
  `ID` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `basepay` int(10) NULL DEFAULT NULL,
  `welfare` int(10) NULL DEFAULT NULL,
  `reward` int(10) NULL DEFAULT NULL,
  `insurance` int(10) NULL DEFAULT NULL,
  `funds` int(10) NULL DEFAULT NULL,
  `month` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `remark` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`salaryID`, `ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of salary
-- ----------------------------
INSERT INTO `salary` VALUES (1, '0001', '贏政', 3000, 100, 100, 100, 500, '1月', '未結算');
INSERT INTO `salary` VALUES (13, '0002', '劉邦', 3000, 200, 100, 100, 400, '1月', '未結算');
INSERT INTO `salary` VALUES (15, '0003', '武則天', 2500, 100, 200, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (16, '0004', '劉秀', 2900, 100, 150, 250, 200, '1月', '未結算');
INSERT INTO `salary` VALUES (17, '0005', '西施', 2800, 100, 100, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (18, '0006', '李清照', 2700, 120, 150, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (19, '0007', '楊玉環', 2680, 200, 150, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (20, '0008', '孫權', 2900, 100, 200, 100, 500, '1月', '未結算');
INSERT INTO `salary` VALUES (21, '0009', '李世民', 2870, 200, 100, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (22, '0010', '項羽', 2600, 200, 100, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (23, '0011', '李鴻章', 2800, 200, 100, 100, 300, '1月', '未結算');
INSERT INTO `salary` VALUES (24, '0012', '張儀', 2900, 200, 150, 100, 500, '1月', '未結算');
INSERT INTO `salary` VALUES (25, '0013', '朱元璋', 2600, 250, 200, 100, 400, '1月', '未結算');
INSERT INTO `salary` VALUES (26, '0001', '贏政', 3000, 100, 200, 100, 300, '2月', '未結算');
INSERT INTO `salary` VALUES (27, '0001', '贏政', 3000, 250, 200, 100, 400, '3月', '未結算');
INSERT INTO `salary` VALUES (28, '0002', '劉邦', 3000, 250, 150, 100, 400, '2月', '未結算');
INSERT INTO `salary` VALUES (29, '0002', '劉邦', 3000, 300, 150, 100, 500, '3月', '未結算');
INSERT INTO `salary` VALUES (30, '0003', '武則天', 2900, 200, 150, 100, 300, '2月', '未結算');
INSERT INTO `salary` VALUES (31, '0003', '武則天', 2800, 250, 120, 100, 500, '3月', '未結算');
INSERT INTO `salary` VALUES (33, '0004', '劉秀', 2580, 500, 200, 100, 300, '2月', '未結算');
INSERT INTO `salary` VALUES (35, '0004', '劉秀', 2900, 200, 150, 100, 300, '3月', '未結算');
INSERT INTO `salary` VALUES (37, '0005', '西施', 2900, 200, 100, 100, 300, '2月', '未結算');
INSERT INTO `salary` VALUES (39, '0005', '西施', 2800, 200, 150, 100, 300, '3月', '未結算');
INSERT INTO `salary` VALUES (40, '0006', '李清照', 2900, 200, 100, 100, 300, '2月', '未結算');
INSERT INTO `salary` VALUES (41, '0006', '李清照', 2900, 200, 100, 100, 300, '3月', '未結算');

-- ----------------------------
-- Table structure for userlist
-- ----------------------------
DROP TABLE IF EXISTS `userlist`;
CREATE TABLE `userlist`  (
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of userlist
-- ----------------------------
INSERT INTO `userlist` VALUES ('管理員', 'admin', 'admin');

-- ----------------------------
-- Table structure for view_salary
-- ----------------------------
DROP TABLE IF EXISTS `view_salary`;
CREATE TABLE `view_salary`  (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `工號` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `姓名` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `部門` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `職位` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `總工資` int(10) NULL DEFAULT NULL,
  `月份` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `備注` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of view_salary
-- ----------------------------
INSERT INTO `view_salary` VALUES (1, '0001', '贏政', '經理室', '經理', 2600, '1月', '未結算');
INSERT INTO `view_salary` VALUES (9, '0002', '劉邦', '技術室', '技術長', 2800, '1月', '未結算');
INSERT INTO `view_salary` VALUES (11, '0003', '武則天', '財務室', '經理', 2400, '1月', '未結算');
INSERT INTO `view_salary` VALUES (12, '0004', '劉秀', '軍機部', '大王', 2700, '1月', '未結算');
INSERT INTO `view_salary` VALUES (13, '0005', '西施', '財務室', '會計', 2600, '1月', '未結算');
INSERT INTO `view_salary` VALUES (14, '0006', '李清照', '財務室', '出納', 2570, '1月', '未結算');
INSERT INTO `view_salary` VALUES (15, '0007', '楊玉環', '財務室', '會計', 2630, '1月', '未結算');
INSERT INTO `view_salary` VALUES (16, '0008', '孫權', '外交部', '部長', 2600, '1月', '未結算');
INSERT INTO `view_salary` VALUES (17, '0009', '李世民', '董事會', '會長', 2770, '1月', '未結算');
INSERT INTO `view_salary` VALUES (18, '0010', '項羽', '經理室', '副經理', 2500, '1月', '未結算');
INSERT INTO `view_salary` VALUES (19, '0011', '李鴻章', '軍機部', '部長', 2700, '1月', '未結算');
INSERT INTO `view_salary` VALUES (20, '0012', '張儀', '外交部', '部長', 2650, '1月', '未結算');
INSERT INTO `view_salary` VALUES (21, '0013', '朱元璋', '技術科', '部長', 2550, '1月', '未結算');
INSERT INTO `view_salary` VALUES (22, '0001', '贏政', '經理室', '經理', 2900, '2月', '未結算');
INSERT INTO `view_salary` VALUES (23, '0001', '贏政', '經理室', '經理', 2950, '3月', '未結算');
INSERT INTO `view_salary` VALUES (24, '0002', '劉邦', '技術室', '技術長', 2900, '2月', '未結算');
INSERT INTO `view_salary` VALUES (25, '0002', '劉邦', '技術室', '技術長', 2850, '3月', '未結算');
INSERT INTO `view_salary` VALUES (26, '0003', '武則天', '財務室', '經理', 2850, '2月', '未結算');
INSERT INTO `view_salary` VALUES (27, '0003', '武則天', '財務室', '經理', 2570, '3月', '未結算');
INSERT INTO `view_salary` VALUES (35, '0004', '劉秀', '軍機部', '副部長', 2850, '3月', '未結算');
INSERT INTO `view_salary` VALUES (36, '0004', '劉秀', '軍機部', '副部長', 2750, '2月', '未結算');
INSERT INTO `view_salary` VALUES (37, '0005', '西施', '財務室', '會計', 2800, '2月', '未結算');
INSERT INTO `view_salary` VALUES (39, '0005', '西施', '財務室', '會計', 2750, '3月', '未結算');
INSERT INTO `view_salary` VALUES (40, '0006', '李清照', '財務室', '出納', 2800, '2月', '未結算');
INSERT INTO `view_salary` VALUES (41, '0006', '李清照', '財務室', '出納', 2800, '3月', '未結算');
INSERT INTO `view_salary` VALUES (42, '0001', '贏政', '經理室', '經理', 1, '1月', '未結算');

SET FOREIGN_KEY_CHECKS = 1;

二、系統展示

1.登錄系統

2.用戶-登錄系統

3.用戶-查看工資

4.管理員-主界面

5.管理員-添加員工資訊

6.管理員-修改員工資訊

7.管理員-洗掉員工資訊

8.管理員-添加部門資訊

9.管理員-修改部門資訊

10.管理員-洗掉部門資訊

11.管理員-工資設定

12.管理員-工資查詢

13.管理員-工資一覽

三、部分代碼

Login.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Login.java
 *
 * Created on 2013-6-16, 21:34:00
 */

package com.sjsq;

import java.awt.Toolkit;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;

import javax.swing.JOptionPane;

/**
 *
 * @author Administrator
 */
public class Login extends javax.swing.JFrame {

	static String status;
	static String name;

	private Toolkit tk = Toolkit.getDefaultToolkit();
	int x = tk.getScreenSize().width / 2 - 180;
	int y = tk.getScreenSize().height / 2 - 180;

	/** Creates new form Login */
	public Login() {
		initComponents();
		setLocation(x, y);
		setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
	}

	/**
	 * This method is called from within the constructor to initialize the form.
	 * WARNING: Do NOT modify this code. The content of this method is always
	 * regenerated by the Form Editor.
	 */
	@SuppressWarnings("unchecked")
	// <editor-fold defaultstate="collapsed" desc="Generated
	// Code">//GEN-BEGIN:initComponents
	private void initComponents() {

		jComboBox1 = new javax.swing.JComboBox();
		username = new javax.swing.JTextField();
		jPasswordField1 = new javax.swing.JPasswordField();
		jLabel1 = new javax.swing.JLabel();
		jLabel2 = new javax.swing.JLabel();
		jLabel3 = new javax.swing.JLabel();
		jButton1 = new javax.swing.JButton();
		jButton2 = new javax.swing.JButton();
		jLabel4 = new javax.swing.JLabel();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
		setTitle("登錄界面");

		jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "管理員", "員工" }));
		jComboBox1.addItemListener(new ItemListener() {

			@Override
			public void itemStateChanged(ItemEvent e) {
				// TODO Auto-generated method stub
				if (e.getStateChange() == ItemEvent.SELECTED) {
					if ("員工".equals(e.getItem())) {
						jButton1.setText("查詢工資");
						jLabel2.hide();
						username.hide();
						jPasswordField1.hide();
						jLabel3.hide();
						jPasswordField1.hide();
					} else {
						jButton1.setText("登錄");
						jLabel2.show();
						username.show();
						jPasswordField1.show();
						jLabel3.show();
						jPasswordField1.show();
					}

				}
			}
		});
		// username.setText("quan");

		jLabel1.setText("身份：");

		jLabel2.setText("賬號：");

		jLabel3.setText("密碼：");

		jButton1.setText("登錄");
		jButton1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton1ActionPerformed(evt);
			}
		});

		jButton2.setText("退出");
		jButton2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton2ActionPerformed(evt);
			}
		});

		jLabel4.setForeground(new java.awt.Color(255, 0, 0));
		jLabel4.setText("注：員工可以匿名登錄");

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
		getContentPane().setLayout(layout);
		layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
				.createSequentialGroup()
				.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
						.createSequentialGroup().addGap(80, 80, 80)
						.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
								.addComponent(jLabel1).addComponent(jLabel3).addComponent(jLabel2))
						.addGap(18, 18, 18)
						.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
								.addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, 92,
										javax.swing.GroupLayout.PREFERRED_SIZE)
								.addGroup(layout.createSequentialGroup()
										.addGroup(layout
												.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
												.addComponent(username, javax.swing.GroupLayout.Alignment.LEADING)
												.addComponent(jComboBox1, javax.swing.GroupLayout.Alignment.LEADING, 0,
														javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
										.addGap(18, 18, 18).addComponent(jLabel4))))
						.addGroup(layout.createSequentialGroup().addGap(110, 110, 110).addComponent(jButton1)
								.addGap(39, 39, 39).addComponent(jButton2)))
				.addContainerGap(54, Short.MAX_VALUE)));
		layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(layout.createSequentialGroup().addGap(65, 65, 65)
						.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
								.addComponent(jLabel1).addComponent(jLabel4))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
						.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(username, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
								.addComponent(jLabel2))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
						.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel3).addComponent(jPasswordField1,
										javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
										javax.swing.GroupLayout.PREFERRED_SIZE))
						.addGap(35, 35, 35)
						.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jButton1).addComponent(jButton2))
						.addContainerGap(102, Short.MAX_VALUE)));

		pack();
	}// </editor-fold>//GEN-END:initComponents

	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton1ActionPerformed
		// TODO add your handling code here:

		status = (String) jComboBox1.getSelectedItem();
		name = username.getText();
		String password = jPasswordField1.getText();

		if (status.equals("管理員")) {
			if (name.equals("")) {
				JOptionPane.showMessageDialog(null, "用戶名不能為空！！");
			} else if (password.equals("")) {
				JOptionPane.showMessageDialog(null, "密碼不能為空！！");
			} else {
				String sql = "select username from userlist where status = '" + status + "' and username = '" + name
						+ "' and password = '" + password + "'";
				// String sql = "select * from userlist";
				System.out.println(sql);
				DBConn db = new DBConn();
				if (db.Check(sql) != 0) {
					new MainFrame().setVisible(true);
					this.hide();
				} else {
					JOptionPane.showMessageDialog(null, "用戶名與密碼不對！！");
				}
			}
		} else {
			new SalarySearch().setVisible(true);
		}
	}// GEN-LAST:event_jButton1ActionPerformed

	private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton2ActionPerformed
		// TODO add your handling code here:
		int selection = JOptionPane.showConfirmDialog(this, "是否退出？", "退出提示", JOptionPane.OK_CANCEL_OPTION,
				JOptionPane.WARNING_MESSAGE);
		if (selection == JOptionPane.OK_OPTION) {
			System.exit(0);
		}
	}// GEN-LAST:event_jButton2ActionPerformed

	/**
	 * @param args the command line arguments
	 */
	public static void main(String args[]) {
		java.awt.EventQueue.invokeLater(new Runnable() {
			public void run() {
				new Login().setVisible(true);
			}
		});
	}

	// Variables declaration - do not modify//GEN-BEGIN:variables
	private javax.swing.JButton jButton1;
	private javax.swing.JButton jButton2;
	private javax.swing.JComboBox jComboBox1;
	private javax.swing.JLabel jLabel1;
	private javax.swing.JLabel jLabel2;
	private javax.swing.JLabel jLabel3;
	private javax.swing.JLabel jLabel4;
	private javax.swing.JPasswordField jPasswordField1;
	private javax.swing.JTextField username;
	// End of variables declaration//GEN-END:variables

}


MainFrame.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * MainFrame.java
 *
 * Created on 2013-6-18, 22:12:20
 */

package com.sjsq;

import java.awt.Graphics;
import java.awt.Image;
import java.awt.Toolkit;
import javax.swing.JOptionPane;

/**
 *
 * @author Administrator
 */
public class MainFrame extends javax.swing.JFrame {

	/** Creates new form MainFrame */
	private Toolkit tk = Toolkit.getDefaultToolkit();
	int x = tk.getScreenSize().width / 2 - 250;
	int y = tk.getScreenSize().height / 2 - 250;

	public MainFrame() {
		setTitle("工資管理系統");
		setLocation(x, y);
		initComponents();
		// this.setDefaultCloseOperation(MainFrame.DO_NOTHING_ON_CLOSE);
	}

	/**
	 * This method is called from within the constructor to initialize the form.
	 * WARNING: Do NOT modify this code. The content of this method is always
	 * regenerated by the Form Editor.
	 */
	@SuppressWarnings("unchecked")
	// <editor-fold defaultstate="collapsed" desc="Generated
	// Code">//GEN-BEGIN:initComponents
	private void initComponents() {

		jColorChooser1 = new javax.swing.JColorChooser();
		jPanel1 = new javax.swing.JPanel() {
			protected void paintComponent(Graphics g) {
				super.paintComponent(g);
				Image img = Toolkit.getDefaultToolkit().getImage("src/resource/009.jpg");
				Graphics gg = g.create();
				gg.drawImage(img, 0, 0, getWidth(), getHeight(), this);
				gg.dispose();
			}
		};
		jMenuBar1 = new javax.swing.JMenuBar();
		jMenu1 = new javax.swing.JMenu();
		jMenuItem1 = new javax.swing.JMenuItem();
		jMenuItem2 = new javax.swing.JMenuItem();
		jMenuItem3 = new javax.swing.JMenuItem();
		jMenu2 = new javax.swing.JMenu();
		jMenuItem4 = new javax.swing.JMenuItem();
		jMenuItem5 = new javax.swing.JMenuItem();
		jMenuItem6 = new javax.swing.JMenuItem();
		jMenu3 = new javax.swing.JMenu();
		jMenuItem7 = new javax.swing.JMenuItem();
		jMenuItem8 = new javax.swing.JMenuItem();
		jMenuItem12 = new javax.swing.JMenuItem();
		jMenu4 = new javax.swing.JMenu();
		jMenuItem9 = new javax.swing.JMenuItem();
		jMenuItem10 = new javax.swing.JMenuItem();
		jMenuItem13 = new javax.swing.JMenuItem();
		jMenu5 = new javax.swing.JMenu();
		jMenuItem11 = new javax.swing.JMenuItem();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
		setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

		jPanel1.addAncestorListener(new javax.swing.event.AncestorListener() {
			public void ancestorMoved(javax.swing.event.AncestorEvent evt) {
			}

			public void ancestorAdded(javax.swing.event.AncestorEvent evt) {
				jPanel1AncestorAdded(evt);
			}

			public void ancestorRemoved(javax.swing.event.AncestorEvent evt) {
			}
		});

		javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
		jPanel1.setLayout(jPanel1Layout);
		jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGap(0, 637, Short.MAX_VALUE));
		jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGap(0, 365, Short.MAX_VALUE));

		jMenu1.setText("員工資訊管理");
		jMenu1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenu1ActionPerformed(evt);
			}
		});

		jMenuItem1.setAccelerator(
				javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_A, java.awt.event.InputEvent.CTRL_MASK));
		jMenuItem1.setText("添加員工資訊");
		jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem1ActionPerformed(evt);
			}
		});
		jMenu1.add(jMenuItem1);

		jMenuItem2.setAccelerator(
				javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_M, java.awt.event.InputEvent.CTRL_MASK));
		jMenuItem2.setText("修改員工資訊");
		jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem2ActionPerformed(evt);
			}
		});
		jMenu1.add(jMenuItem2);

		jMenuItem3.setAccelerator(
				javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_D, java.awt.event.InputEvent.CTRL_MASK));
		jMenuItem3.setText("洗掉員工資訊");
		jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem3ActionPerformed(evt);
			}
		});
		jMenu1.add(jMenuItem3);

		jMenuBar1.add(jMenu1);

		jMenu2.setText("部門資訊管理");

		jMenuItem4.setText("新增部門資訊");
		jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem4ActionPerformed(evt);
			}
		});
		jMenu2.add(jMenuItem4);

		jMenuItem5.setText("修改部門資訊");
		jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem5ActionPerformed(evt);
			}
		});
		jMenu2.add(jMenuItem5);

		jMenuItem6.setText("洗掉部門資訊");
		jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem6ActionPerformed(evt);
			}
		});
		jMenu2.add(jMenuItem6);

		jMenuBar1.add(jMenu2);

		jMenu3.setText("員工工資設定");

		jMenuItem7.setText("工資設定");
		jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem7ActionPerformed(evt);
			}
		});
		jMenu3.add(jMenuItem7);

		jMenuItem8.setText("工資查詢");
		jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem8ActionPerformed(evt);
			}
		});
		jMenu3.add(jMenuItem8);

		jMenuItem12.setText("工資一覽表");
		jMenuItem12.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem12ActionPerformed(evt);
			}
		});
		jMenu3.add(jMenuItem12);

		jMenuBar1.add(jMenu3);

		jMenu4.setText("系統設定");

		jMenuItem9.setText("資訊統計");
		jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem9ActionPerformed(evt);
			}
		});
		jMenu4.add(jMenuItem9);

		jMenuItem10.setText("修改密碼");
		jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem10ActionPerformed(evt);
			}
		});
		jMenu4.add(jMenuItem10);

		jMenuItem13.setText("添加管理員");
		jMenuItem13.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem13ActionPerformed(evt);
			}
		});
		jMenu4.add(jMenuItem13);

		jMenuBar1.add(jMenu4);

		jMenu5.setText("退出系統");
		jMenu5.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenu5ActionPerformed(evt);
			}
		});

		jMenuItem11.setText("退出本系統");
		jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jMenuItem11ActionPerformed(evt);
			}
		});
		jMenu5.add(jMenuItem11);

		jMenuBar1.add(jMenu5);

		setJMenuBar(jMenuBar1);

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
		getContentPane().setLayout(layout);
		layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(
				jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE,
				javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE));
		layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(
				jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE));

		pack();
	}// </editor-fold>//GEN-END:initComponents

	private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem1ActionPerformed
		// TODO add your handling code here:
		new AddEmployee().setVisible(true);
	}// GEN-LAST:event_jMenuItem1ActionPerformed

	private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem2ActionPerformed
		// TODO add your handling code here:
		new ModifyEmployee().setVisible(true);
	}// GEN-LAST:event_jMenuItem2ActionPerformed

	private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem3ActionPerformed
		// TODO add your handling code here:
		new DeleteEmployee().setVisible(true);
	}// GEN-LAST:event_jMenuItem3ActionPerformed

	private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem4ActionPerformed
		// TODO add your handling code here:
		new AddDepartment().setVisible(true);
	}// GEN-LAST:event_jMenuItem4ActionPerformed

	private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem5ActionPerformed
		// TODO add your handling code here:
		new ModifyDepartment().setVisible(true);
	}// GEN-LAST:event_jMenuItem5ActionPerformed

	private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem6ActionPerformed
		// TODO add your handling code here:
		new DeleteDepartment().setVisible(true);
	}// GEN-LAST:event_jMenuItem6ActionPerformed

	private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem7ActionPerformed
		// TODO add your handling code here:
		new SalarySetting().setVisible(true);
	}// GEN-LAST:event_jMenuItem7ActionPerformed

	private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem8ActionPerformed
		// TODO add your handling code here:
		new SalarySearch().setVisible(true);
	}// GEN-LAST:event_jMenuItem8ActionPerformed

	private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem9ActionPerformed
		// TODO add your handling code here:
		new Statistics().setVisible(true);
	}// GEN-LAST:event_jMenuItem9ActionPerformed

	private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem10ActionPerformed
		// TODO add your handling code here:
		new ModifyPassWord().setVisible(true);
	}// GEN-LAST:event_jMenuItem10ActionPerformed

	private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem11ActionPerformed
		// TODO add your handling code here:
		int option = JOptionPane.showConfirmDialog(null, "確定要退出本系統?", "系統提示", JOptionPane.YES_NO_OPTION);
		if (option == JOptionPane.YES_OPTION)
			System.exit(0);
		else
			this.setDefaultCloseOperation(MainFrame.DO_NOTHING_ON_CLOSE);
	}// GEN-LAST:event_jMenuItem11ActionPerformed

	private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem12ActionPerformed
		// TODO add your handling code here:
		new SalaryShow().setVisible(true);
	}// GEN-LAST:event_jMenuItem12ActionPerformed

	private void jMenuItem13ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenuItem13ActionPerformed
		// TODO add your handling code here:
		new NewManager().setVisible(true);
	}// GEN-LAST:event_jMenuItem13ActionPerformed

	private void jMenu5ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenu5ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jMenu5ActionPerformed

	private void jPanel1AncestorAdded(javax.swing.event.AncestorEvent evt) {// GEN-FIRST:event_jPanel1AncestorAdded
		// TODO add your handling code here:
	}// GEN-LAST:event_jPanel1AncestorAdded

	private void jMenu1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jMenu1ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jMenu1ActionPerformed

	/**
	 * @param args the command line arguments
	 */
	/*
	 * public static void main(String args[]) { java.awt.EventQueue.invokeLater(new
	 * Runnable() { public void run() { new MainFrame().setVisible(true); } }); }
	 */
	// Variables declaration - do not modify//GEN-BEGIN:variables
	private javax.swing.JColorChooser jColorChooser1;
	private javax.swing.JMenu jMenu1;
	private javax.swing.JMenu jMenu2;
	private javax.swing.JMenu jMenu3;
	private javax.swing.JMenu jMenu4;
	private javax.swing.JMenu jMenu5;
	private javax.swing.JMenuBar jMenuBar1;
	private javax.swing.JMenuItem jMenuItem1;
	private javax.swing.JMenuItem jMenuItem10;
	private javax.swing.JMenuItem jMenuItem11;
	private javax.swing.JMenuItem jMenuItem12;
	private javax.swing.JMenuItem jMenuItem13;
	private javax.swing.JMenuItem jMenuItem2;
	private javax.swing.JMenuItem jMenuItem3;
	private javax.swing.JMenuItem jMenuItem4;
	private javax.swing.JMenuItem jMenuItem5;
	private javax.swing.JMenuItem jMenuItem6;
	private javax.swing.JMenuItem jMenuItem7;
	private javax.swing.JMenuItem jMenuItem8;
	private javax.swing.JMenuItem jMenuItem9;
	private javax.swing.JPanel jPanel1;
	// End of variables declaration//GEN-END:variables

}


DBConn.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.sjsq;

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Administrator
 */
public class DBConn {

	private Connection conn = null;
	private Statement stmt = null;
	private ResultSet rs = null;
	String url = "jdbc:mysql://localhost/swing_salary_management?serverTimezone=UTC";
	String username = "root";
	String password = "admin";

	public DBConn() { // 構造方法

		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			// conn = DriverManager.getConnection(url,username,password);
		} catch (java.lang.ClassNotFoundException e) {
			System.err.println(e.getMessage());
		} // catch (SQLException ex) {
			// Logger.getLogger(DBConn.class.getName()).log(Level.SEVERE, null, ex);
			// }
	}

	public int Check(String sql) {
		// int result = 0;
		try {
			conn = DriverManager.getConnection(url, username, password);
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if (rs.next()) {
				return 1;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return 0;
	}

	public ResultSet Search(String sql) { // 建立查詢

		try {
			conn = DriverManager.getConnection(url, username, password);
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		} catch (SQLException ex) {
			System.err.println(ex.getMessage());
		}
		return rs;
	}

	public int Update(String sql) { // 操作資料庫

		int result = 0;
		try {
			conn = DriverManager.getConnection(url, username, password);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			result = stmt.executeUpdate(sql);
		} catch (SQLException ex) {
			result = 0;
		}
		return result;
	}

	/**
	 * 關閉資料庫連接
	 */
	public void close() {
		try {
			if (rs != null) {
				rs.close();
			}
		} catch (Exception e) {
			e.printStackTrace(System.err);
		}

		try {
			if (stmt != null) {
				stmt.close();
			}
		} catch (Exception e) {
			e.printStackTrace(System.err);
		}

		try {
			if (conn != null) {
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace(System.err);
		}
	}

}


AddDepartment.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * AddDepartment.java
 *
 * Created on 2013-6-22, 12:14:44
 */

package com.sjsq;

//import SQLConnection.DBConn;
import java.awt.Toolkit;
import javax.swing.JOptionPane;

/**
 *
 * @author Administrator
 */
public class AddDepartment extends javax.swing.JFrame {

	/** Creates new form AddDepartment */
	private Toolkit tk = Toolkit.getDefaultToolkit();
	int x = tk.getScreenSize().width / 2 - 100;
	int y = tk.getScreenSize().height / 2 - 100;

	public AddDepartment() {
		initComponents();
		setTitle("添加部門資訊");
		setLocation(x, y);
		setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
	}

	/**
	 * This method is called from within the constructor to initialize the form.
	 * WARNING: Do NOT modify this code. The content of this method is always
	 * regenerated by the Form Editor.
	 */
	@SuppressWarnings("unchecked")
	// <editor-fold defaultstate="collapsed" desc="Generated
	// Code">//GEN-BEGIN:initComponents
	private void initComponents() {

		jPanel1 = new javax.swing.JPanel();
		jLabel1 = new javax.swing.JLabel();
		jLabel2 = new javax.swing.JLabel();
		jLabel3 = new javax.swing.JLabel();
		jLabel4 = new javax.swing.JLabel();
		jTextField1 = new javax.swing.JTextField();
		jTextField2 = new javax.swing.JTextField();
		jTextField3 = new javax.swing.JTextField();
		jTextField4 = new javax.swing.JTextField();
		jButton1 = new javax.swing.JButton();
		jButton2 = new javax.swing.JButton();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

		jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("部門資訊"));

		jLabel1.setText("部門編號:");

		jLabel2.setText("部門名稱:");

		jLabel3.setText("負責人:");

		jLabel4.setText("總人數:");

		jTextField1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField1ActionPerformed(evt);
			}
		});

		jTextField2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField2ActionPerformed(evt);
			}
		});

		jTextField3.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField3ActionPerformed(evt);
			}
		});

		jTextField4.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField4ActionPerformed(evt);
			}
		});

		jButton1.setText("添加");
		jButton1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton1ActionPerformed(evt);
			}
		});

		jButton2.setText("取消");
		jButton2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton2ActionPerformed(evt);
			}
		});

		javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
		jPanel1.setLayout(jPanel1Layout);
		jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addGroup(jPanel1Layout
						.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
								.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel1)
										.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
										.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 70,
												javax.swing.GroupLayout.PREFERRED_SIZE))
								.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel2)
										.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
										.addComponent(jTextField2))
								.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel3).addGap(18, 18, 18)
										.addComponent(jTextField3)))
						.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jButton1).addGap(18, 18, 18)
								.addComponent(jButton2))
						.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel4).addGap(18, 18, 18)
								.addComponent(jTextField4)))
						.addContainerGap(16, Short.MAX_VALUE)));
		jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(jPanel1Layout.createSequentialGroup().addContainerGap()
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel1).addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addGap(18, 18, 18)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel2).addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addGap(18, 18, 18)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel3).addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel4).addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addGap(18, 18, 18)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jButton1).addComponent(jButton2))
						.addContainerGap(18, Short.MAX_VALUE)));

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
		getContentPane().setLayout(layout);
		layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(layout.createSequentialGroup().addGap(79, 79, 79)
						.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
								javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(145, Short.MAX_VALUE)));
		layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(layout.createSequentialGroup().addGap(22, 22, 22)
						.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
								javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(54, Short.MAX_VALUE)));

		pack();
	}// </editor-fold>//GEN-END:initComponents

	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton1ActionPerformed
		// TODO add your handling code here:
		String strID = jTextField1.getText(); // 部門編號
		String strName = jTextField2.getText(); // 部門姓名
		String strDirector = jTextField3.getText(); // 負責人
		String strNumber = jTextField4.getText(); // 總人數

		if (strID.equals("")) {
			JOptionPane.showMessageDialog(null, "部門編號不能為空！");
		} else if (strName.equals("")) {
			JOptionPane.showMessageDialog(null, "部門名稱不能為空！");
		} else if (strDirector.equals("")) {
			JOptionPane.showMessageDialog(null, "部門負責人不能為空！");
		} else {

			// int ID = Integer.parseInt(strID);
			int Number = Integer.parseInt(strNumber);
			String checksql = "select id from department where id = '" + strID + " '";
			System.out.println(checksql);
			DBConn db = new DBConn();

			if (db.Check(checksql) != 0) {
				JOptionPane.showMessageDialog(null, "該號已存在！！！");
			} else {
				String sql = "insert into department values('" + strID + "','" + strName + "','" + strDirector + "','"
						+ Number + "')";
				int result = db.Update(sql);
				if (result != 0) {
					JOptionPane.showMessageDialog(null, "部門添加成功！！！");
				} else {
					JOptionPane.showMessageDialog(null, "部門添加失敗，請重新添加！");
				}
			}
		}
		jTextField1.setText("");
		jTextField2.setText("");
		jTextField3.setText("");
		jTextField4.setText("");
	}// GEN-LAST:event_jButton1ActionPerformed

	private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton2ActionPerformed
		// TODO add your handling code here:
		jTextField1.setText("");
		jTextField2.setText("");
		jTextField3.setText("");
		jTextField4.setText("");
	}// GEN-LAST:event_jButton2ActionPerformed

	private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField1ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField1ActionPerformed

	private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField2ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField2ActionPerformed

	private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField3ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField3ActionPerformed

	private void jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField4ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField4ActionPerformed

	/**
	 * @param args the command line arguments
	 * 
	 *             public static void main(String args[]) {
	 *             java.awt.EventQueue.invokeLater(new Runnable() { public void
	 *             run() { new AddDepartment().setVisible(true); } }); }
	 */

	// Variables declaration - do not modify//GEN-BEGIN:variables
	private javax.swing.JButton jButton1;
	private javax.swing.JButton jButton2;
	private javax.swing.JLabel jLabel1;
	private javax.swing.JLabel jLabel2;
	private javax.swing.JLabel jLabel3;
	private javax.swing.JLabel jLabel4;
	private javax.swing.JPanel jPanel1;
	private javax.swing.JTextField jTextField1;
	private javax.swing.JTextField jTextField2;
	private javax.swing.JTextField jTextField3;
	private javax.swing.JTextField jTextField4;
	// End of variables declaration//GEN-END:variables

}


AddEmployee.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * SecondGUI.java
 *
 * Created on 2013-6-19, 12:49:33
 */

package com.sjsq;

import java.awt.Toolkit;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author Administrator
 */
public class AddEmployee extends javax.swing.JFrame {

	/** Creates new form SecondGUI */
	private Toolkit tk = Toolkit.getDefaultToolkit();
	int x = tk.getScreenSize().width / 2 - 180;
	int y = tk.getScreenSize().height / 2 - 180;
	DefaultTableModel dm;
	DefaultComboBoxModel dcm;

	public AddEmployee() {
		initTable();
		initComboBox();
		initComponents();
		setTitle("添加員工");
		setLocation(x, y);
		setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
	}

//初始化表格
	private void initTable() {
		try {
			String[] head = { "工號", "姓名", "性別", "年齡", "部門", "職位", "電話", "入廠時間", "住址" };
			Object obj[][] = new Object[0][0];
			dm = new DefaultTableModel(obj, head);

			String sql = "select id,name,sex,age,department,position,phone,time,address from employee";
			DBConn db = new DBConn();
			Vector v;
			System.out.println(sql);
			ResultSet rs = db.Search(sql);
			while (rs.next()) {
				v = new Vector();
				v.add(rs.getString(1));
				v.add(rs.getString(2));
				v.add(rs.getString(3));
				v.add(rs.getString(4));
				v.add(rs.getString(5));
				v.add(rs.getString(6));
				v.add(rs.getString(7));
				v.add(rs.getString(8));
				v.add(rs.getString(9));
				dm.addRow(v);
			}
			db.close();
		} catch (SQLException ex) {
			System.out.println(ex);
		}
	}

	/// 初始化下拉串列
	private void initComboBox() {
		Vector v = new Vector();
		DBConn db = new DBConn();
		try {
			ResultSet rs = db.Search("select distinct name from department");
			while (rs.next()) {
				v.addElement(rs.getString("name")); // 添加到向量尾部，大小加1
			}
			dcm = new DefaultComboBoxModel(v);
		} catch (SQLException ex) {
			ex.printStackTrace();
		} finally {
			db.close();
		}
	}

	@SuppressWarnings("unchecked")
	// <editor-fold defaultstate="collapsed" desc="Generated
	// Code">//GEN-BEGIN:initComponents
	private void initComponents() {

		buttonGroup1 = new javax.swing.ButtonGroup();
		jPanel1 = new javax.swing.JPanel();
		jLabel1 = new javax.swing.JLabel();
		jTextField1 = new javax.swing.JTextField();
		jLabel2 = new javax.swing.JLabel();
		jTextField2 = new javax.swing.JTextField();
		jLabel3 = new javax.swing.JLabel();
		jRadioButton1 = new javax.swing.JRadioButton();
		jRadioButton2 = new javax.swing.JRadioButton();
		jLabel4 = new javax.swing.JLabel();
		jTextField3 = new javax.swing.JTextField();
		jLabel5 = new javax.swing.JLabel();
		jComboBox1 = new javax.swing.JComboBox();
		jLabel6 = new javax.swing.JLabel();
		jTextField4 = new javax.swing.JTextField();
		jLabel7 = new javax.swing.JLabel();
		jTextField5 = new javax.swing.JTextField();
		jLabel8 = new javax.swing.JLabel();
		jTextField6 = new javax.swing.JTextField();
		jButton1 = new javax.swing.JButton();
		jButton2 = new javax.swing.JButton();
		jLabel9 = new javax.swing.JLabel();
		jTextField7 = new javax.swing.JTextField();
		jScrollPane1 = new javax.swing.JScrollPane();
		jTable1 = new javax.swing.JTable();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

		jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("員工資訊"));

		jLabel1.setText("工號:");

		jLabel2.setText("姓名:");

		jTextField2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField2ActionPerformed(evt);
			}
		});

		jLabel3.setText("性別:");

		buttonGroup1.add(jRadioButton1);
		jRadioButton1.setSelected(true);
		jRadioButton1.setText("男");

		buttonGroup1.add(jRadioButton2);
		jRadioButton2.setText("女");

		jLabel4.setText("年齡:");

		jTextField3.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField3ActionPerformed(evt);
			}
		});

		jLabel5.setText("所屬部門:");

		jComboBox1.setModel(dcm);
		jComboBox1.setToolTipText("請選擇");
		jComboBox1.setBorder(javax.swing.BorderFactory.createCompoundBorder());
		jComboBox1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jComboBox1ActionPerformed(evt);
			}
		});

		jLabel6.setText("職位:");

		jTextField4.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField4ActionPerformed(evt);
			}
		});

		jLabel7.setText("聯系方式:");

		jTextField5.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField5ActionPerformed(evt);
			}
		});

		jLabel8.setText("住址:");

		jTextField6.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField6ActionPerformed(evt);
			}
		});

		jButton1.setText("添加");
		jButton1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton1ActionPerformed(evt);
			}
		});

		jButton2.setText("取消");
		jButton2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton2ActionPerformed(evt);
			}
		});

		jLabel9.setText("入廠時間:");

		jTextField7.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jTextField7ActionPerformed(evt);
			}
		});

		javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
		jPanel1.setLayout(jPanel1Layout);
		jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addGroup(jPanel1Layout
						.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout
								.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING).addComponent(jButton1)
								.addGroup(jPanel1Layout
										.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
										.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel1)
												.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
												.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 82,
														javax.swing.GroupLayout.PREFERRED_SIZE))
										.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel2)
												.addGap(18, 18, 18).addComponent(jTextField2))
										.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel3)
												.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
												.addComponent(jRadioButton1)
												.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
												.addComponent(jRadioButton2))
										.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel4)
												.addGap(18, 18, 18).addComponent(jTextField3,
														javax.swing.GroupLayout.PREFERRED_SIZE, 80,
														javax.swing.GroupLayout.PREFERRED_SIZE))))
								.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
										.addGroup(jPanel1Layout.createSequentialGroup().addGap(31, 31, 31)
												.addGroup(jPanel1Layout
														.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
																false)
														.addGroup(javax.swing.GroupLayout.Alignment.LEADING,
																jPanel1Layout.createSequentialGroup()
																		.addGroup(jPanel1Layout.createParallelGroup(
																				javax.swing.GroupLayout.Alignment.LEADING)
																				.addComponent(jLabel5)
																				.addComponent(jLabel6))
																		.addPreferredGap(
																				javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																		.addGroup(jPanel1Layout.createParallelGroup(
																				javax.swing.GroupLayout.Alignment.LEADING,
																				false)
																				.addComponent(jComboBox1, 0,
																						javax.swing.GroupLayout.DEFAULT_SIZE,
																						Short.MAX_VALUE)
																				.addComponent(jTextField4,
																						javax.swing.GroupLayout.DEFAULT_SIZE,
																						80, Short.MAX_VALUE)))
														.addGroup(javax.swing.GroupLayout.Alignment.LEADING,
																jPanel1Layout.createSequentialGroup()
																		.addGroup(jPanel1Layout.createParallelGroup(
																				javax.swing.GroupLayout.Alignment.LEADING)
																				.addComponent(jLabel7)
																				.addComponent(jLabel9))
																		.addPreferredGap(
																				javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																		.addGroup(jPanel1Layout.createParallelGroup(
																				javax.swing.GroupLayout.Alignment.LEADING)
																				.addComponent(jTextField7,
																						javax.swing.GroupLayout.DEFAULT_SIZE,
																						80, Short.MAX_VALUE)
																				.addComponent(jTextField5)))))
										.addGroup(jPanel1Layout.createSequentialGroup().addGap(18, 18, 18)
												.addComponent(jButton2)))
								.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 57,
										Short.MAX_VALUE))
						.addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel8).addGap(18, 18, 18)
								.addComponent(jTextField6, javax.swing.GroupLayout.DEFAULT_SIZE, 306, Short.MAX_VALUE)))
						.addContainerGap()));
		jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(jPanel1Layout.createSequentialGroup().addContainerGap()
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel1)
								.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
								.addComponent(jLabel5).addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel2)
								.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
								.addComponent(jLabel6).addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel3).addComponent(jRadioButton1).addComponent(jRadioButton2)
								.addComponent(jLabel7).addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel4)
								.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
								.addComponent(jLabel9).addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addGap(18, 18, 18)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jLabel8).addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE,
										javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 9, Short.MAX_VALUE)
						.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
								.addComponent(jButton1).addComponent(jButton2))
						.addContainerGap()));

		jTable1.setAutoCreateRowSorter(true);
		jTable1.setModel(dm);
		jScrollPane1.setViewportView(jTable1);

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
		getContentPane().setLayout(layout);
		layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
				.createSequentialGroup()
				.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(layout.createSequentialGroup().addGap(88, 88, 88).addComponent(jPanel1,
								javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
								javax.swing.GroupLayout.PREFERRED_SIZE))
						.addGroup(layout.createSequentialGroup().addGap(21, 21, 21).addComponent(jScrollPane1,
								javax.swing.GroupLayout.PREFERRED_SIZE, 516, javax.swing.GroupLayout.PREFERRED_SIZE)))
				.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
		layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(layout.createSequentialGroup().addGap(32, 32, 32)
						.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
								javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
						.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 117,
								javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));

		pack();
	}// </editor-fold>//GEN-END:initComponents

	// 添加事件
	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton1ActionPerformed
		// TODO add your handling code here:
		String ID = jTextField1.getText();
		String Name = jTextField2.getText();
		String sex = "男";
		if (jRadioButton2.isSelected())
			sex = "女";
		String ageStr = jTextField3.getText();
		int age = Integer.parseInt(ageStr);
		String department = (String) jComboBox1.getSelectedItem();
		String position = jTextField4.getText(); // 職位
		String phone = jTextField5.getText(); // 電話
		String time = jTextField7.getText(); // 入廠時間
		String address = jTextField6.getText();// 住址

		if (ID.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入員工號");
		} else if (Name.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入員工姓名");
		} else if (ageStr.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入年齡");
		} else if (department.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入所在部門");
		} else if (position.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入員職位");
		} else if (phone.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入聯系電話");
		} else if (time.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入入廠時間");
		} else if (address.equals("")) {
			JOptionPane.showMessageDialog(null, "請輸入住址");
		} else {
			DBConn db = new DBConn();
			if (db.Check("select ID from employee where ID = '" + ID + "'") != 0) {
				JOptionPane.showMessageDialog(null, "該工號的員工已存在！！");
			} else {
				String sql = "insert into employee values('" + ID + "','" + Name + "','" + sex + "','" + age + "','"
						+ department + "','" + position + "','" + phone + "','" + time + "','" + address + "')";
				System.out.println(sql);
				int result = db.Update(sql);
				if (result != 0) {
					JOptionPane.showMessageDialog(null, "添加成功！！");
					initTable();
				}
				db.close();

			}

			new AddEmployee().setVisible(true);

		}
		// this.System.exit(0);
		this.setVisible(false);

	}// GEN-LAST:event_jButton1ActionPerformed

	private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jButton2ActionPerformed
		// TODO add your handling code here:
		jTextField1.setText("");
		jTextField2.setText("");
		jTextField4.setText("");
		jTextField5.setText("");
		jTextField3.setText("");
		jTextField7.setText("");
		jTextField6.setText("");

	}// GEN-LAST:event_jButton2ActionPerformed

	private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField2ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField2ActionPerformed

	private void jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField4ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField4ActionPerformed

	private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jComboBox1ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jComboBox1ActionPerformed

	private void jTextField5ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField5ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField5ActionPerformed

	private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField3ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField3ActionPerformed

	private void jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField7ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField7ActionPerformed

	private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {// GEN-FIRST:event_jTextField6ActionPerformed
		// TODO add your handling code here:
	}// GEN-LAST:event_jTextField6ActionPerformed

	/*
	 * 
	 * public static void main(String args[]) { java.awt.EventQueue.invokeLater(new
	 * Runnable() { public void run() { new AddEmployee().setVisible(true);
	 * 
	 * } }); }
	 */

	// Variables declaration - do not modify//GEN-BEGIN:variables
	private javax.swing.ButtonGroup buttonGroup1;
	private javax.swing.JButton jButton1;
	private javax.swing.JButton jButton2;
	private javax.swing.JComboBox jComboBox1;
	private javax.swing.JLabel jLabel1;
	private javax.swing.JLabel jLabel2;
	private javax.swing.JLabel jLabel3;
	private javax.swing.JLabel jLabel4;
	private javax.swing.JLabel jLabel5;
	private javax.swing.JLabel jLabel6;
	private javax.swing.JLabel jLabel7;
	private javax.swing.JLabel jLabel8;
	private javax.swing.JLabel jLabel9;
	private javax.swing.JPanel jPanel1;
	private javax.swing.JRadioButton jRadioButton1;
	private javax.swing.JRadioButton jRadioButton2;
	private javax.swing.JScrollPane jScrollPane1;
	private javax.swing.JTable jTable1;
	private javax.swing.JTextField jTextField1;
	private javax.swing.JTextField jTextField2;
	private javax.swing.JTextField jTextField3;
	private javax.swing.JTextField jTextField4;
	private javax.swing.JTextField jTextField5;
	private javax.swing.JTextField jTextField6;
	private javax.swing.JTextField jTextField7;
	// End of variables declaration//GEN-END:variables

}

四、其他

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.支持博主

如果您覺得此文對您有幫助，請點贊加關注加收藏，祝您生活愉快！

轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/392103.html

標籤：java

上一篇：看了這篇博文，原來配置Maven如此簡單

下一篇：阿里面試題庫被“泄露“導致多人進大廠，慘遭多家大廠威脅下架

標籤雲
其他(157675) Python(38076) JavaScript(25376) Java(17977) C(15215) 區塊鏈(8255) C＃(7972) AI(7469) 爪哇(7425) MySQL(7132) html(6777) 基礎類(6313) sql(6102) 熊猫(6058) PHP(5869) 数组(5741) R(5409) Linux(5327) 反应(5209) 腳本語言(PerlPython)(5129) 非技術區(4971) Android(4554) 数据框(4311) css(4259) 节点.js(4032) C語言(3288) json(3245) 列表(3129) 扑(3119) C++語言(3117) 安卓(2998) 打字稿(2995) VBA(2789) Java相關(2746) 疑難問題(2699) 细绳(2522) 單片機工控(2479) iOS(2429) ASP.NET(2402) MongoDB(2323) 麻木的(2285) 正则表达式(2254) 字典(2211) 循环(2198) 迅速(2185) 擅长(2169) 镖(2155) 功能(1967) .NET技术(1958) Web開發(1951) python-3.x(1918) HtmlCss(1915) 弹簧靴(1913) C++(1909) xml(1889) PostgreSQL(1872) .NETCore(1853) 谷歌表格(1846) Unity3D(1843) for循环(1842)

熱門瀏覽
  • 【C++】Microsoft C++、C 和匯編程式檔案

    ......

    uj5u.com 2020-09-10 00:57:23 more
  • 例外宣告

    相比于斷言適用于排除邏輯上不可能存在的狀態，例外通常是用于邏輯上可能發生的錯誤。 例外宣告 Item 1：當函式不可能拋出例外或不能接受拋出例外時，使用noexcept 理由 如果不打算拋出例外的話，程式就會認為無法處理這種錯誤，并且應當盡早終止，如此可以有效地阻止例外的傳播與擴散。 示例 //不可 ......

    uj5u.com 2020-09-10 00:57:27 more
  • Codeforces 1400E Clear the Multiset(貪心 + 分治)

    鏈接：https://codeforces.com/problemset/problem/1400/E 來源：Codeforces 思路：給你一個陣列，現在你可以進行兩種操作，操作1：將一段沒有 0 的區間進行減一的操作，操作2：將 i 位置上的元素歸零。最終問：將這個陣列的全部元素歸零后操作的最少 ......

    uj5u.com 2020-09-10 00:57:30 more
  • UVA11610 【Reverse Prime】

    本人看到此題沒有翻譯，就附帶了一個自己的翻譯版本 思考 這一題，它的第一個要求是找出所有 $7$ 位反向質數及其質因數的個數。 我們應該需要質數篩篩選1~$10^{7}$的所有數，這里就不慢慢介紹了。但是，重讀題，我們突然發現反向質數都是 $7$ 位，而將它反過來后的數字卻是 $6$ 位數，這就說明 ......

    uj5u.com 2020-09-10 00:57:36 more
  • 統計區間素數數量

    1 #pragma GCC optimize(2) 2 #include <bits/stdc++.h> 3 using namespace std; 4 bool isprime[1000000010]; 5 vector<int> prime; 6 inline int getlist(int ......

    uj5u.com 2020-09-10 00:57:47 more
  • C/C++編程筆記：C++中的 const 變數詳解，教你正確認識const用法

    1、C中的const 1、區域const變數存放在堆疊區中，會分配記憶體（也就是說可以通過地址間接修改變數的值）。測驗代碼如下： 運行結果： 2、全域const變數存放在只讀資料段（不能通過地址修改，會發生寫入錯誤）， 默認為外部聯編，可以給其他源檔案使用（需要用extern關鍵字修飾） 運行結果： ......

    uj5u.com 2020-09-10 00:58:04 more
  • 【C++犯錯記錄】VS2019 MFC添加資源不懂如何修改資源宏ID

    1. 首先在資源視圖中，添加資源 2. 點擊新添加的資源，復制自動生成的ID 3. 在解決方案資源管理器中找到Resource.h檔案，編輯，使用整個專案搜索和替換的方式快速替換 宏宣告 4. Ctrl+Shift+F 全域搜索，點擊查找全部，然后逐個替換 5. 為什么使用搜索替換而不使用屬性視窗直 ......

    uj5u.com 2020-09-10 00:59:11 more
  • 【C++犯錯記錄】VS2019 MFC不懂的批量添加資源

    1. 打開資源頭檔案Resource.h，在其中預先定義好宏 ID（不清楚其實ID值應該設定多少，可以先新建一個相同的資源項，再在這個資源的ID值的基礎上遞增即可） 2. 在資源視圖中選中專案資源，按F7編輯資源檔案，按 ID 型別 相對路徑的形式添加 資源。（別忘了先把檔案拷貝到專案中的res檔案 ......

    uj5u.com 2020-09-10 01:00:19 more
  • C/C++編程筆記：關于C++的參考型別，專供新手入門使用

    今天要講的是C++中我最喜歡的一個用法——參考，也叫別名。 參考就是給一個變數名取一個變數名，方便我們間接地使用這個變數。我們可以給一個變數創建N個參考，這N + 1個變數共享了同一塊記憶體區域。(參考型別的變數會占用記憶體空間，占用的記憶體空間的大小和指標型別的大小是相同的。雖然參考是一個物件的別名，但 ......

    uj5u.com 2020-09-10 01:00:22 more
  • 【C/C++編程筆記】從頭開始學習C ++：初學者完整指南

    眾所周知，C ++的學習曲線陡峭，但是花時間學習這種語言將為您的職業帶來奇跡，并使您與其他開發人員區分開。您會更輕松地學習新語言，形成真正的解決問題的技能，并在編程的基礎上打下堅實的基礎。 C ++將幫助您養成良好的編程習慣（即清晰一致的編碼風格，在撰寫代碼時注釋代碼，并限制類內部的可見性），并且由 ......

    uj5u.com 2020-09-10 01:00:41 more
最新发布
  • Rust中的智能指標:Box<T> Rc<T> Arc<T> Cell<T> RefCell<T> Weak

    Rust中的智能指標是什么 智能指標（smart pointers）是一類資料結構，是擁有資料所有權和額外功能的指標。是指標的進一步發展 指標（pointer）是一個包含記憶體地址的變數的通用概念。這個地址參考，或 ” 指向”（points at）一些其 他資料 。參考以 & 符號為標志并借用了他們所 ......

    uj5u.com 2023-04-20 07:24:10 more
  • Java的值傳遞和參考傳遞

    值傳遞不會改變本身，參考傳遞（如果傳遞的值需要實體化到堆里）如果發生修改了會改變本身。 1.基本資料型別都是值傳遞 package com.example.basic; public class Test { public static void main(String[] args) { int ......

    uj5u.com 2023-04-20 07:24:04 more
  • [2]SpinalHDL教程——Scala簡單入門

    第一個 Scala 程式 shell里面輸入 $ scala scala> 1 + 1 res0: Int = 2 scala> println("Hello World!") Hello World! 檔案形式 object HelloWorld { /* 這是我的第一個 Scala 程式 * 以 ......

    uj5u.com 2023-04-20 07:23:58 more
  • 理解函式指標和回呼函式

    理解 函式指標 指向函式的指標。比如： 理解函式指標的偽代碼 void (*p)(int type, char *data); // 定義一個函式指標p void func(int type, char *data); // 宣告一個函式func p = func; // 將指標p指向函式func ......

    uj5u.com 2023-04-20 07:23:52 more
  • Django筆記二十五之資料庫函式之日期函式

    本文首發于公眾號：Hunter后端 原文鏈接：Django筆記二十五之資料庫函式之日期函式 日期函式主要介紹兩個大類，Extract() 和 Trunc() Extract() 函式作用是提取日期，比如我們可以提取一個日期欄位的年份，月份，日等資料 Trunc() 的作用則是截取，比如 2022-0 ......

    uj5u.com 2023-04-20 07:23:45 more
  • 一天吃透JVM面試八股文

    什么是JVM？ JVM，全稱Java Virtual Machine（Java虛擬機），是通過在實際的計算機上仿真模擬各種計算機功能來實作的。由一套位元組碼指令集、一組暫存器、一個堆疊、一個垃圾回收堆和一個存盤方法域等組成。JVM屏蔽了與作業系統平臺相關的資訊，使得Java程式只需要生成在Java虛擬機 ......

    uj5u.com 2023-04-20 07:23:31 more
  • 使用Java接入小程式訂閱訊息！

    更新完微信服務號的模板訊息之后，我又趕緊把微信小程式的訂閱訊息給實作了！之前我一直以為微信小程式也是要企業才能申請，沒想到小程式個人就能申請。 訊息推送平臺🔥推送下發【郵件】【短信】【微信服務號】【微信小程式】【企業微信】【釘釘】等訊息型別。 https://gitee.com/zhongfuch ......

    uj5u.com 2023-04-20 07:22:59 more
  • java -- 緩沖流、轉換流、序列化流

    緩沖流 緩沖流, 也叫高效流, 按照資料型別分類： 位元組緩沖流：BufferedInputStream，BufferedOutputStream 字符緩沖流：BufferedReader，BufferedWriter 緩沖流的基本原理，是在創建流物件時，會創建一個內置的默認大小的緩沖區陣列，通過緩沖 ......

    uj5u.com 2023-04-20 07:22:49 more
  • Java-SpringBoot-Range請求頭設定實作視頻分段傳輸

    老實說，人太懶了，現在基本都不喜歡寫筆記了，但是網上有關Range請求頭的文章都太水了 下面是抄的一段StackOverflow的代碼...自己大修改過的，寫的注釋挺全的，應該直接看得懂，就不解釋了 寫的不好...只是希望能給視頻網站開發的新手一點點幫助吧. 業務場景：視頻分段傳輸、視頻多段傳輸（理 ......

    uj5u.com 2023-04-20 07:22:42 more
  • Windows 10開發教程_編程入門自學教程_菜鳥教程-免費教程分享

    教程簡介 Windows 10開發入門教程 - 從簡單的步驟了解Windows 10開發，從基本到高級概念，包括簡介，UWP，第一個應用程式，商店，XAML控制元件，資料系結，XAML性能，自適應設計，自適應UI，自適應代碼，檔案管理，SQLite資料庫，應用程式到應用程式通信，應用程式本地化，應用程式 ......

    uj5u.com 2023-04-20 07:22:35 more

Copyright © 2010-2020 有解無憂