一、系统介绍
1.开发环境
开发工具:Eclipse2021
JDK版本:jdk1.8
Mysql版本:8.0.13
2.技术选型
Java+Swing+Mysql
3.系统功能
1.管理员登录系统;
2.管理员查询员工信息,增加员工信息,修改员工信息,删除员工信息;
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_staff_management
Target Server Type : MySQL
Target Server Version : 80013
File Encoding : 65001
Date: 07/01/2022 21:39:20
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS ——dept——;
CREATE TABLE ——dept—— (
——num—— int(11) NULL DEFAULT NULL,
——name—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
——address—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO ——dept—— VALUES (101, '大数据部', '一楼');
INSERT INTO ——dept—— VALUES (102, '人力行政部', '二楼');
INSERT INTO ——dept—— VALUES (103, '后勤部', '三楼');
-- ----------------------------
-- Table structure for duty
-- ----------------------------
DROP TABLE IF EXISTS ——duty——;
CREATE TABLE ——duty—— (
——num—— int(4) NOT NULL COMMENT '职务名称',
——name—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——low—— varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——high—— varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of duty
-- ----------------------------
INSERT INTO ——duty—— VALUES (111, '职员', '10000', '20000');
INSERT INTO ——duty—— VALUES (112, '科长', '20000', '40000');
INSERT INTO ——duty—— VALUES (113, '部长', '40000', '60000');
INSERT INTO ——duty—— VALUES (114, '总监', '60000', '80000');
INSERT INTO ——duty—— VALUES (115, '总经理', '100000', '150000');
-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS ——login——;
CREATE TABLE ——login—— (
——id—— decimal(4, 0) NOT NULL,
——username—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——password—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (——id——) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of login
-- ----------------------------
INSERT INTO ——login—— VALUES (1, 'admin', 'admin');
-- ----------------------------
-- Table structure for staff
-- ----------------------------
DROP TABLE IF EXISTS ——staff——;
CREATE TABLE ——staff—— (
——num—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
——name—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——sex—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——salary—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——phone—— varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——dept—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
——duty—— varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (——num——) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of staff
-- ----------------------------
INSERT INTO ——staff—— VALUES ('1001', '张三', '男', '50000', '13332259632', '大数据部', '部长');
INSERT INTO ——staff—— VALUES ('1002', '李四', '男', '30000', '13332259632', '大数据部', '科长');
INSERT INTO ——staff—— VALUES ('1003', '王五', '男', '20000', '13332259632', '后勤部', '职员');
SET FOREIGN_KEY_CHECKS = 1;
二、系统展示
1.登录系统
2.主页面
3.部门管理
4.职位管理
5.员工管理
三、部分代码
AdminDao.java
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import utils.DBUtil;
import vo.Admin;
public class AdminDao {
// 判断有无此用户
public static boolean isUser(Admin admin) {
String sql = "select * from login where username=? and password = ?";
ResultSet rs;
// 定义数组用来存放账号和密码
String[] adminString = new String[] {admin.getUserName(), admin.getPassword()};
try {
rs = DBUtil.execQuery(sql, adminString);
if (rs.next())
return true;
else
return false;
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
DBUtil.close();
}
}
// 测试
public static void main(String[] args) {
Admin admin = new Admin();
admin.setUserName("admin");
admin.setPassword("admin");
boolean flag = isUser(admin);
System.out.println(flag);
}
}
如需转载,请注明文章出处和来源网址:http://www.divcss5.com/html/h64872.shtml