Javaweb实现数据库的增删查

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50717 Source Host : localhost:3306 Source Database : ems Target Server Type : MYSQL Target Server Version : 50717 File Encoding : 65001 Date: 2023-09-18 21:42:32 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) DEFAULT NULL, `pwd` varchar(20) DEFAULT NULL, `email` varchar(20) DEFAULT NULL, `truename` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('1', 'admin', 'admin', '[email protected]', '张三'); -- ---------------------------- -- Table structure for department -- ---------------------------- DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of department -- ---------------------------- INSERT INTO `department` VALUES ('1', '研发部'); INSERT INTO `department` VALUES ('2', '人事部'); INSERT INTO `department` VALUES ('3', 'UI部'); INSERT INTO `department` VALUES ('4', '行政部'); INSERT INTO `department` VALUES ('5', '其他部门'); -- ---------------------------- -- Table structure for employee -- ---------------------------- DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `sex` int(11) DEFAULT NULL, `age` int(11) DEFAULT NULL, `salary` int(11) DEFAULT NULL, `photo` varchar(200) DEFAULT NULL, `dept_id` int(11) DEFAULT NULL, `hobby` varchar(200) DEFAULT NULL, `createtime` datetime DEFAULT NULL, `updatetime` datetime DEFAULT NULL, `photoname` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of employee -- ---------------------------- INSERT INTO `employee` VALUES ('1', '张贵橙', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('2', '黄小样', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('3', '黄笑杨', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('4', '莉志君', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('5', '尘伽号', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('6', '留星辰', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('7', '张贵橙', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('8', '黄小样', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('9', '黄笑杨', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('10', '莉志君', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('11', '尘伽号', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('12', '留星辰', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('13', '张贵橙', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('16', '莉志君', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('17', '尘伽号', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('18', '留星辰', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('19', '张贵橙', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('20', '黄小样', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('21', '黄笑杨', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('22', '莉志君', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('23', '尘伽号', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('24', '留星辰', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('25', '张贵橙', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('26', '黄小样', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('27', '黄笑杨', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('28', '莉志君', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('29', '尘伽号', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('30', '留星辰', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', '1'); INSERT INTO `employee` VALUES ('35', '222', '0', '20', '2222', '2222', '2', '2222', '2020-09-09 10:58:48', '2022-12-12 00:00:00', '2222'); INSERT INTO `employee` VALUES ('36', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('37', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('38', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('39', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('40', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('41', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('42', '橙伊林', '1', '20', '20000', '111', '5', '打游戏,睡觉,', '2020-09-09 10:58:48', '2020-09-09 10:59:30', null); INSERT INTO `employee` VALUES ('44', '阿桂', '1', null, '2