人力资源系统
1.在eclipse里，点击file--import，打开如下界面
点击鼠标所属位置--next
从D盘打开hr文件夹，查看路径，如下图点击browse，找到前面提到的路径，并如图所示进行勾选，完成后点击finish，左边创建出hr文件夹。
2.（1）打开Navicat，打开管理员命令框，输入命令net start mysql，启动MySQL
（2）左边右击mysql，点击新建数据库：
数据库名：db_hr
字符集：utf8
排序规则：utf8_general_ci
（3）右击db_hr，点击新建查询，在下面写入建立四个表格的代码：
/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 50733
Source Host : localhost:3306
Source Schema : db_hr
Target Server Type : MySQL
Target Server Version : 50733
File Encoding : 65001
Date: 08/03/2022 09:23:36
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for applicant
-- ----------------------------
DROP TABLE IF EXISTS `applicant`;
CREATE TABLE `applicant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sex` bit(1) NULL DEFAULT b'1',
`age` int(11) NULL DEFAULT NULL,
`job` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`specialty` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`experience` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`studyeffort` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`school` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`createtime` datetime(0) NULL DEFAULT NULL,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`isstock` bit(1) NULL DEFAULT b'0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of applicant
-- ----------------------------
INSERT INTO `applicant` VALUES (1, '张三', b'1', 22, '工程师', '计算机', '2', '硕士', '师大', '123456', 'zhangsan', NULL, 'abc123', b'0');
INSERT INTO `applicant` VALUES (2, '李四', b'0', 25, '销售', '物联网', '3', '本科', '烟大', '9878', 'lisi', '2022-02-23 17:24:23', 'woshilisi', b'0');
-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`basic` double NULL DEFAULT NULL,
`eat` double NULL DEFAULT NULL,
`house` double NULL DEFAULT NULL,
`duty` double NULL DEFAULT NULL,
`scot` double NULL DEFAULT NULL,
`punishment` double NULL DEFAULT NULL,
`other` double NULL DEFAULT NULL,
`granttime` datetime(0) NULL DEFAULT NULL,
`totalize` double NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of salary
-- ----------------------------
INSERT INTO `salary` VALUES (1, '李华伟', 5000, 1000, 2000, 500, 300, 0, 200, '2022-02-28 00:00:00', 8400);
-- ----------------------------
-- Table structure for train
-- ----------------------------
DROP TABLE IF EXISTS `train`;
CREATE TABLE `train` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`purpose` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`begintime` datetime(0) NULL DEFAULT NULL,
`endtime` datetime(0) NULL DEFAULT NULL,
`datum` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`teacher` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`student` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`createtime` datetime(0) NULL DEFAULT NULL,
`educate` bit(1) NOT NULL,
`effect` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`summarize` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of train
-- ----------------------------
INSERT INTO `train` VALUES (1, 'Java培训', '提高', '2022-02-25 00:00:00', '2022-02-28 00:00:00', '好好学习', '李华伟', '全体', NULL, b'1', '优秀', '以后继续');
INSERT INTO `train` VALUES (2, 'Android开发', '学习移动开发', '2022-02-26 00:00:00', '2022-02-28 00:00:00', '随便学学', '李华伟', '全体', NULL, b'0', NULL, NULL);
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sex` bit(1) NULL DEFAULT b'1',
`birthday` datetime(0) NULL,
`createtime` datetime(0) NULL DEFAULT NULL,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (2, 'admin', 'admin', b'1', '2015-05-13 00:00:00', '2022-02-23 00:00:00', '123');
INSERT INTO `user` VALUES (3, 'lhw', '123', b'1', '1979-05-13 00:00:00', '2022-02-23 11:36:07', '李华伟');
INSERT INTO `user` VALUES (4, 'aaa', 'aaa', b'0', '2010-03-12 00:00:00', '2022-02-23 11:46:57', '啊啊啊');
INSERT INTO `user` VALUES (5, 'zhangsan', '1234', b'0', '1990-04-25 00:00:00', '2022-03-07 10:21:57', '企业文化培训师');
INSERT INTO `user` VALUES (7, 'xing', '123456', b'1', '1000-10-10 00:00:00', '2022-03-07 10:56:33', '');
INSERT INTO `user` VALUES (8, 'Heart', '1234567890', b'1', '1840-07-21 00:00:00', '2022-03-07 10:56:56', '你充Q币吗？\r\n');
INSERT INTO `user` VALUES (9, 'beauty', 'xyyyrjm9', b'0', '2003-09-09 00:00:00', '2022-03-07 10:57:07', '任佳美');
INSERT INTO `user` VALUES (10, 'lisi', '123', b'1', '1998-03-06 00:00:00', '2022-03-07 14:19:51', '李四');
SET FOREIGN_KEY_CHECKS = 1;
点击视图出现简称的四个表。
3.（1）打开eclipse，打开hr，再打开c3p0-config.xml
注意：如果访问自己的数据库，则不用改动，依然是localhost；如果访问别人数据库，localhost改成别人IP地址即可。
（2）在左边找到webcontent，点开文件夹后找到index.jsp并右击运行，可直接打开人力资源系统。
浙公网安备 33010602011771号