/*
?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', '經(jīng)理室', '贏政', 10);
INSERT INTO `department` VALUES ('ks002', '財(cái)務(wù)室', '劉邦', 6);
INSERT INTO `department` VALUES ('ks003', '軍機(jī)部', '李鴻章', 6);
INSERT INTO `department` VALUES ('ks004', '外交部', '張儀', 8);
INSERT INTO `department` VALUES ('ks005', '技術(shù)科', '朱元璋', 10);
INSERT INTO `department` VALUES ('ks006', '董事會(huì)', '李世民', 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, '經(jīng)理室', '經(jīng)理', '10086', '0201-01-01 00:00:00', '咸陽');
INSERT INTO `employee` VALUES ('0002', '劉邦', '男', 40, '技術(shù)科', '技術(shù)長(zhǎng)', '10087910', '2001-05-06 00:00:00', '長(zhǎng)安');
INSERT INTO `employee` VALUES ('0003', '武則天', '女', 30, '財(cái)務(wù)室', '經(jīng)理', '10088', '1999-08-07 00:00:00', '長(zhǎng)安');
INSERT INTO `employee` VALUES ('0004', '劉秀', '男', 46, '軍機(jī)部', '副部長(zhǎng)', '123548788', '2013-05-07 00:00:00', '桂林');
INSERT INTO `employee` VALUES ('0005', '西施', '女', 23, '財(cái)務(wù)室', '會(huì)計(jì)', '10089', '2001-02-03 00:00:00', '越國');
INSERT INTO `employee` VALUES ('0006', '李清照', '女', 25, '財(cái)務(wù)室', '出納', '125478', '2012-03-04 00:00:00', '宋國');
INSERT INTO `employee` VALUES ('0007', '楊玉環(huán)', '女', 29, '財(cái)務(wù)室', '會(huì)計(jì)', '125478', '2010-02-04 00:00:00', '長(zhǎng)安');
INSERT INTO `employee` VALUES ('0008', '孫權(quán)', '男', 35, '外交部', '部長(zhǎng)', '150478', '2005-05-04 00:00:00', '江東');
INSERT INTO `employee` VALUES ('0009', '李世民', '男', 54, '董事會(huì)', '會(huì)長(zhǎng)', '100865', '1998-05-08 00:00:00', '西安');
INSERT INTO `employee` VALUES ('0010', '項(xiàng)羽', '男', 40, '經(jīng)理室', '副經(jīng)理', '1008670', '2000-02-05 00:00:00', '彭城');
INSERT INTO `employee` VALUES ('0011', '李鴻章', '男', 52, '軍機(jī)部', '部長(zhǎng)', '1008699', '2001-05-08 00:00:00', '北京');
INSERT INTO `employee` VALUES ('0012', '張儀', '男', 44, '外交部', '部長(zhǎng)', '10089', '2002-02-04 00:00:00', '魏國');
INSERT INTO `employee` VALUES ('0013', '朱元璋', '男', 35, '技術(shù)科', '部長(zhǎng)', '100896', '2013-05-07 00:00:00', '南京');
INSERT INTO `employee` VALUES ('0014', '貂蟬', '女', 25, '經(jīng)理室', '助理', '10086972', '2005-05-04 00:00:00', '洛陽');
INSERT INTO `employee` VALUES ('0015', '李淵', '男', 55, '董事會(huì)', '董事', '25897', '2001-02-05 00:00:00', '長(zhǎng)安');
INSERT INTO `employee` VALUES ('0016', '1', '男', 1, '經(jīng)理室', '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月', '未結(jié)算');
INSERT INTO `salary` VALUES (13, '0002', '劉邦', 3000, 200, 100, 100, 400, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (15, '0003', '武則天', 2500, 100, 200, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (16, '0004', '劉秀', 2900, 100, 150, 250, 200, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (17, '0005', '西施', 2800, 100, 100, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (18, '0006', '李清照', 2700, 120, 150, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (19, '0007', '楊玉環(huán)', 2680, 200, 150, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (20, '0008', '孫權(quán)', 2900, 100, 200, 100, 500, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (21, '0009', '李世民', 2870, 200, 100, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (22, '0010', '項(xiàng)羽', 2600, 200, 100, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (23, '0011', '李鴻章', 2800, 200, 100, 100, 300, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (24, '0012', '張儀', 2900, 200, 150, 100, 500, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (25, '0013', '朱元璋', 2600, 250, 200, 100, 400, '1月', '未結(jié)算');
INSERT INTO `salary` VALUES (26, '0001', '贏政', 3000, 100, 200, 100, 300, '2月', '未結(jié)算');
INSERT INTO `salary` VALUES (27, '0001', '贏政', 3000, 250, 200, 100, 400, '3月', '未結(jié)算');
INSERT INTO `salary` VALUES (28, '0002', '劉邦', 3000, 250, 150, 100, 400, '2月', '未結(jié)算');
INSERT INTO `salary` VALUES (29, '0002', '劉邦', 3000, 300, 150, 100, 500, '3月', '未結(jié)算');
INSERT INTO `salary` VALUES (30, '0003', '武則天', 2900, 200, 150, 100, 300, '2月', '未結(jié)算');
INSERT INTO `salary` VALUES (31, '0003', '武則天', 2800, 250, 120, 100, 500, '3月', '未結(jié)算');
INSERT INTO `salary` VALUES (33, '0004', '劉秀', 2580, 500, 200, 100, 300, '2月', '未結(jié)算');
INSERT INTO `salary` VALUES (35, '0004', '劉秀', 2900, 200, 150, 100, 300, '3月', '未結(jié)算');
INSERT INTO `salary` VALUES (37, '0005', '西施', 2900, 200, 100, 100, 300, '2月', '未結(jié)算');
INSERT INTO `salary` VALUES (39, '0005', '西施', 2800, 200, 150, 100, 300, '3月', '未結(jié)算');
INSERT INTO `salary` VALUES (40, '0006', '李清照', 2900, 200, 100, 100, 300, '2月', '未結(jié)算');
INSERT INTO `salary` VALUES (41, '0006', '李清照', 2900, 200, 100, 100, 300, '3月', '未結(jié)算');
?
-- ----------------------------
-- 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,
? `工號(hào)` 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', '贏政', '經(jīng)理室', '經(jīng)理', 2600, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (9, '0002', '劉邦', '技術(shù)室', '技術(shù)長(zhǎng)', 2800, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (11, '0003', '武則天', '財(cái)務(wù)室', '經(jīng)理', 2400, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (12, '0004', '劉秀', '軍機(jī)部', '大王', 2700, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (13, '0005', '西施', '財(cái)務(wù)室', '會(huì)計(jì)', 2600, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (14, '0006', '李清照', '財(cái)務(wù)室', '出納', 2570, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (15, '0007', '楊玉環(huán)', '財(cái)務(wù)室', '會(huì)計(jì)', 2630, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (16, '0008', '孫權(quán)', '外交部', '部長(zhǎng)', 2600, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (17, '0009', '李世民', '董事會(huì)', '會(huì)長(zhǎng)', 2770, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (18, '0010', '項(xiàng)羽', '經(jīng)理室', '副經(jīng)理', 2500, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (19, '0011', '李鴻章', '軍機(jī)部', '部長(zhǎng)', 2700, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (20, '0012', '張儀', '外交部', '部長(zhǎng)', 2650, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (21, '0013', '朱元璋', '技術(shù)科', '部長(zhǎng)', 2550, '1月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (22, '0001', '贏政', '經(jīng)理室', '經(jīng)理', 2900, '2月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (23, '0001', '贏政', '經(jīng)理室', '經(jīng)理', 2950, '3月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (24, '0002', '劉邦', '技術(shù)室', '技術(shù)長(zhǎng)', 2900, '2月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (25, '0002', '劉邦', '技術(shù)室', '技術(shù)長(zhǎng)', 2850, '3月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (26, '0003', '武則天', '財(cái)務(wù)室', '經(jīng)理', 2850, '2月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (27, '0003', '武則天', '財(cái)務(wù)室', '經(jīng)理', 2570, '3月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (35, '0004', '劉秀', '軍機(jī)部', '副部長(zhǎng)', 2850, '3月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (36, '0004', '劉秀', '軍機(jī)部', '副部長(zhǎng)', 2750, '2月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (37, '0005', '西施', '財(cái)務(wù)室', '會(huì)計(jì)', 2800, '2月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (39, '0005', '西施', '財(cái)務(wù)室', '會(huì)計(jì)', 2750, '3月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (40, '0006', '李清照', '財(cái)務(wù)室', '出納', 2800, '2月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (41, '0006', '李清照', '財(cái)務(wù)室', '出納', 2800, '3月', '未結(jié)算');
INSERT INTO `view_salary` VALUES (42, '0001', '贏政', '經(jīng)理室', '經(jīng)理', 1, '1月', '未結(jié)算');
?
SET FOREIGN_KEY_CHECKS = 1;

/*
?* 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("賬號(hào)：");
?
?? ??? ?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("注：?jiǎn)T工可以匿名登錄");
?
?? ??? ?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, "用戶名與密碼不對(duì)??！");
?? ??? ??? ??? ?}
?? ??? ??? ?}
?? ??? ?} 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
?
}

/*
?* 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("工資管理系統(tǒng)");
?? ??? ?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("員工工資設(shè)定");
?
?? ??? ?jMenuItem7.setText("工資設(shè)定");
?? ??? ?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("系統(tǒng)設(shè)置");
?
?? ??? ?jMenuItem9.setText("信息統(tǒng)計(jì)");
?? ??? ?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("退出系統(tǒng)");
?? ??? ?jMenu5.addActionListener(new java.awt.event.ActionListener() {
?? ??? ??? ?public void actionPerformed(java.awt.event.ActionEvent evt) {
?? ??? ??? ??? ?jMenu5ActionPerformed(evt);
?? ??? ??? ?}
?? ??? ?});
?
?? ??? ?jMenuItem11.setText("退出本系統(tǒng)");
?? ??? ?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, "確定要退出本系統(tǒng)?", "系統(tǒng)提示", 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
?
}

/*
?* 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() { // 構(gòu)造方法
?
?? ??? ?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) { // 操作數(shù)據(jù)庫
?
?? ??? ?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;
?? ?}
?
?? ?/**
?? ? * 關(guān)閉數(shù)據(jù)庫連接
?? ? */
?? ?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);
?? ??? ?}
?? ?}
?
}

/*
?* 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("部門編號(hào):");
?
?? ??? ?jLabel2.setText("部門名稱:");
?
?? ??? ?jLabel3.setText("負(fù)責(zé)人:");
?
?? ??? ?jLabel4.setText("總?cè)藬?shù):");
?
?? ??? ?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(); // 部門編號(hào)
?? ??? ?String strName = jTextField2.getText(); // 部門姓名
?? ??? ?String strDirector = jTextField3.getText(); // 負(fù)責(zé)人
?? ??? ?String strNumber = jTextField4.getText(); // 總?cè)藬?shù)
?
?? ??? ?if (strID.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "部門編號(hào)不能為空！");
?? ??? ?} else if (strName.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "部門名稱不能為空！");
?? ??? ?} else if (strDirector.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "部門負(fù)責(zé)人不能為空！");
?? ??? ?} 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, "該號(hào)已存在?。?！");
?? ??? ??? ?} 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, "部門添加失敗，請(qǐng)重新添加！");
?? ??? ??? ??? ?}
?? ??? ??? ?}
?? ??? ?}
?? ??? ?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
?
}

/*
?* 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 = { "工號(hào)", "姓名", "性別", "年齡", "部門", "職位", "電話", "入廠時(shí)間", "住址" };
?? ??? ??? ?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("工號(hào):");
?
?? ??? ?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("請(qǐng)選擇");
?? ??? ?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("聯(lián)系方式:");
?
?? ??? ?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("入廠時(shí)間:");
?
?? ??? ?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(); // 入廠時(shí)間
?? ??? ?String address = jTextField6.getText();// 住址
?
?? ??? ?if (ID.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入員工號(hào)");
?? ??? ?} else if (Name.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入員工姓名");
?? ??? ?} else if (ageStr.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入年齡");
?? ??? ?} else if (department.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入所在部門");
?? ??? ?} else if (position.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入員職位");
?? ??? ?} else if (phone.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入聯(lián)系電話");
?? ??? ?} else if (time.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入入廠時(shí)間");
?? ??? ?} else if (address.equals("")) {
?? ??? ??? ?JOptionPane.showMessageDialog(null, "請(qǐng)輸入住址");
?? ??? ?} else {
?? ??? ??? ?DBConn db = new DBConn();
?? ??? ??? ?if (db.Check("select ID from employee where ID = '" + ID + "'") != 0) {
?? ??? ??? ??? ?JOptionPane.showMessageDialog(null, "該工號(hào)的員工已存在??！");
?? ??? ??? ?} 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
?
}