/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50636
Source Host : localhost:3306
Source Database : jspmfkr39
Target Server Type : MYSQL
Target Server Version : 50636
File Encoding : 65001
Date: 2020-12-28 17:49:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bangongshebei
-- ----------------------------
DROP TABLE IF EXISTS `bangongshebei`;
CREATE TABLE `bangongshebei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shebeibianhao` varchar(200) NOT NULL COMMENT '设备编号',
`shebeimingcheng` varchar(200) NOT NULL COMMENT '设备名称',
`fenlei` varchar(200) DEFAULT NULL COMMENT '分类',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`shuliang` int(11) NOT NULL COMMENT '数量',
`xiangqing` longtext COMMENT '详情',
PRIMARY KEY (`id`),
UNIQUE KEY `shebeibianhao` (`shebeibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='办公设备';
-- ----------------------------
-- Records of bangongshebei
-- ----------------------------
INSERT INTO `bangongshebei` VALUES ('1', '2020-12-28 17:11:13', '设备编号1', '设备名称1', '分类1', 'http://localhost:8080/jspmfkr39/upload/bangongshebei_tupian1.jpg', '规格1', '品牌1', '1', '详情1');
INSERT INTO `bangongshebei` VALUES ('2', '2020-12-28 17:11:13', '设备编号2', '设备名称2', '分类2', 'http://localhost:8080/jspmfkr39/upload/bangongshebei_tupian2.jpg', '规格2', '品牌2', '2', '详情2');
INSERT INTO `bangongshebei` VALUES ('3', '2020-12-28 17:11:13', '设备编号3', '设备名称3', '分类3', 'http://localhost:8080/jspmfkr39/upload/bangongshebei_tupian3.jpg', '规格3', '品牌3', '3', '详情3');
INSERT INTO `bangongshebei` VALUES ('5', '2020-12-28 17:11:13', '设备编号5', '设备名称5', '分类5', 'http://localhost:8080/jspmfkr39/upload/bangongshebei_tupian5.jpg', '规格5', '品牌5', '5', '详情5');
INSERT INTO `bangongshebei` VALUES ('6', '2020-12-28 17:11:13', '设备编号6', '设备名称6', '分类6', 'http://localhost:8080/jspmfkr39/upload/bangongshebei_tupian6.jpg', '规格6', '品牌6', '6', '详情6');
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', 'picture1', 'http://localhost:8080/jspmfkr39/upload/picture1.jpg');
INSERT INTO `config` VALUES ('2', 'picture2', 'http://localhost:8080/jspmfkr39/upload/picture2.jpg');
INSERT INTO `config` VALUES ('3', 'picture3', 'http://localhost:8080/jspmfkr39/upload/picture3.jpg');
INSERT INTO `config` VALUES ('4', 'picture4', 'http://localhost:8080/jspmfkr39/upload/picture4.jpg');
INSERT INTO `config` VALUES ('5', 'picture5', 'http://localhost:8080/jspmfkr39/upload/picture5.jpg');
INSERT INTO `config` VALUES ('6', 'homepage', null);
-- ----------------------------
-- Table structure for gongsigonggao
-- ----------------------------
DROP TABLE IF EXISTS `gongsigonggao`;
CREATE TABLE `gongsigonggao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gonggaobiaoti` varchar(200) NOT NULL COMMENT '公告标题',
`gonggaoleixing` varchar(200) NOT NULL COMMENT '公告类型',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`neirong` longtext COMMENT '内容',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='公司公告';
-- ----------------------------
-- Records of gongsigonggao
-- ----------------------------
INSERT INTO `gongsigonggao` VALUES ('1', '2020-12-28 17:11:13', '公告标题1', '公告类型1', 'http://localhost:8080/jspmfkr39/upload/gongsigonggao_tupian1.jpg', '内容1', '2020-12-28');
INSERT INTO `gongsigonggao` VALUES ('2', '2020-12-28 17:11:13', '公告标题2', '公告类型2', 'http://localhost:8080/jspmfkr39/upload/gongsigonggao_tupian2.jpg', '内容2', '2020-12-28');
INSERT INTO `gongsigonggao` VALUES ('3', '2020-12-28 17:11:13', '公告标题3', '公告类型3', 'http://localhost:8080/jspmfkr39/upload/gongsigonggao_tupian3.jpg', '内容3', '2020-12-28');
INSERT INTO `gongsigonggao` VALUES ('4', '2020-12-28 17:11:13', '公告标题4', '公告类型4', 'http://localhost:8080/jspmfkr39/upload/gongsigonggao_tupian4.jpg', '内容4', '2020-12-28');
INSERT INTO `gongsigonggao` VALUES ('5', '2020-12-28 17:11:13', '公告标题5', '公告类型5', 'http://localhost:8080/jspmfkr39/upload/gongsigonggao_tupian5.jpg', '内容5', '2020-12-28');
INSERT INTO `gongsigonggao` VALUES ('6', '2020-12-28 17:11:13', '公告标题6', '公告类型6', 'http://localhost:8080/jspmfkr39/upload/gongsigonggao_tupian6.jpg', '内容6', '2020-12-28');
-- ----------------------------
-- Table structure for shebeifenlei
-- ----------------------------
DROP TABLE IF EXISTS `shebeifenlei`;
CREATE TABLE `shebeifenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fenlei` varchar(200) NOT NULL COMMENT '分类',
PRIMARY KEY (`id`),
UNIQUE KEY `fenlei` (`fenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=1609148271950 DEFAULT CHARSET=utf8 COMMENT='设备分类';
-- ----------------------------
-- Records of shebeifenlei
-- ----------------------------
INSERT INTO `shebeifenlei` VALUES ('1', '2020-12-28 17:11:13', '分类1');
INSERT INTO `shebeifenlei` VALUES ('2', '2020-12-28 17:11:13', '分类2');
INSERT INTO `shebeifenlei` VALUES ('3', '2020-12-28 17:11:13', '分类3');
INSERT INTO `shebeifenlei` VALUES ('4', '2020-12-28 17:11:13', '分类4');
INSERT INTO `shebeifenlei` VALUES ('5', '2020-12-28 17:11:13', '分类5');
INSERT INTO `shebeifenlei` VALUES ('6', '2020-12-28 17:11:13', '分类6');
-- ----------------------------
-- Table structure for shebeishenqing
-- ----------------------------
DROP TABLE IF EXISTS `shebeishenqing`;
CREATE TABLE `shebeishenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shebeibianhao` varchar(200) DEFAULT NULL COMMENT '设备编号',
`shenqingbiaoti` varchar(200) DEFAULT NULL COMMENT '申请标题',
`shebeimingcheng` varchar(200) DEFAULT NULL COMMENT '设备名称',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`shenqingshuliang` int(11) NOT NULL COMMENT '申请数量',
`shenqingneirong` longtext COMMENT '申请内容',
`shenqingriqi` date DEFAULT NULL COMMENT '申请日期',
`guihairiqi` date DEFAULT NULL COMMENT '归还日期',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`shenqingfujian` varchar(200) DEFAULT NULL COMMENT '申请附件',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
`zhiwei` varchar(200) DEFAULT NULL COMMENT '职位',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1609148579617 DEFAULT CHARSET=utf8 COMMENT='设备申请';
-- -----------
java基于ssm+jsp办公OA系统2020管理系统源码 带毕业论文+PPT （1098个子文件） 
YuangongController.class 10KB CommonController.class 10KB YuangongjiankangController.class 8KB YuangongqingjiaController.class 8KB ShebeishenqingController.class 8KB YuangongliuyanController.class 8KB YuangongkaoqinController.class 8KB YuangonggongziController.class 8KB GongsigonggaoController.class 8KB BangongshebeiController.class 8KB ShebeifenleiController.class 8KB MPUtil.class 7KB YuangonggongziEntity.class 7KB UserController.class 6KB ShebeishenqingEntity.class 6KB YuangongqingjiaEntity.class 5KB YuangongkaoqinEntity.class 5KB YuangongjiankangEntity.class 5KB YuangongliuyanEntity.class 5KB TokenServiceImpl.class 4KB FileController.class 4KB YuangongEntity.class 4KB BaiduUtil.class 4KB YuangonggongziModel.class 4KB YuangonggongziVO.class 4KB BangongshebeiEntity.class 4KB YuangongjiankangServiceImpl.class 4KB YuangongqingjiaServiceImpl.class 4KB ShebeishenqingServiceImpl.class 4KB YuangongliuyanServiceImpl.class 4KB YuangongkaoqinServiceImpl.class 4KB YuangonggongziServiceImpl.class 4KB ShebeishenqingModel.class 4KB ShebeishenqingVO.class 4KB GongsigonggaoServiceImpl.class 4KB BangongshebeiServiceImpl.class 4KB ShebeifenleiServiceImpl.class 4KB YuangongServiceImpl.class 4KB ConfigController.class 4KB AuthorizationInterceptor.class 3KB GongsigonggaoEntity.class 3KB YuangongqingjiaModel.class 3KB YuangongqingjiaVO.class 3KB Query.class 3KB YuangongkaoqinModel.class 3KB YuangongkaoqinVO.class 3KB YuangongjiankangModel.class 3KB YuangongjiankangVO.class 3KB UserServiceImpl.class 3KB YuangongliuyanModel.class 3KB YuangongliuyanVO.class 3KB PageUtils.class 3KB TokenEntity.class 3KB ShebeifenleiEntity.class 2KB CommonServiceImpl.class 2KB YuangongModel.class 2KB YuangongVO.class 2KB BangongshebeiModel.class 2KB BangongshebeiVO.class 2KB R.class 2KB UserEntity.class 2KB ValidatorUtils.class 2KB SpringContextUtils.class 2KB YuangongjiankangService.class 2KB YuangongqingjiaService.class 2KB YuangongjiankangDao.class 2KB YuangongliuyanService.class 2KB ShebeishenqingService.class 2KB YuangongkaoqinService.class 2KB YuangonggongziService.class 2KB GongsigonggaoService.class 2KB BangongshebeiService.class 2KB YuangongqingjiaDao.class 2KB ShebeifenleiService.class 2KB ShebeishenqingDao.class 2KB YuangongliuyanDao.class 2KB YuangongkaoqinDao.class 2KB YuangonggongziDao.class 2KB BangongshebeiDao.class 2KB GongsigonggaoDao.class 2KB ShebeifenleiDao.class 2KB HttpClientUtils.class 2KB YuangongService.class 2KB ConfigServiceImpl.class 2KB GongsigonggaoModel.class 2KB YuangongDao.class 2KB GongsigonggaoVO.class 1KB TypeEnum.class 1KB JQPageInfo.class 1KB EIException.class 1KB ConfigEntity.class 1KB SQLFilter.class 1KB YuangongjiankangView.class 1KB YuangongqingjiaView.class 1KB ShebeishenqingView.class 1KB YuangongliuyanView.class 1KB YuangonggongziView.class 1KB YuangongkaoqinView.class 1KB GongsigonggaoView.class 1KB BangongshebeiView.class 1KB共 1098 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
Snailmi
- 粉丝: 2199
- 资源: 2312
最新资源
- python实现Excel表格合并
- Java实现读取Excel批量发送邮件.zip
- 【java毕业设计】商城后台管理系统源码（springboot+vue+mysql+说明文档）.zip
- 【java毕业设计】开发停车位管理系统(调用百度地图API)源码（springboot+vue+mysql+说明文档）.zip
- 星耀软件库(升级版).apk.1
- 基于Django后端和Vue前端的多语言购物车项目设计源码
- 基于Python与Vue的浮光在线教育平台源码设计
- 31129647070291Eclipson MXS R.zip
- 基于Html与Java的会员小程序后台管理系统设计源码
- 基于Python的RabbitMQ消息队列安装使用及脚本开发设计源码
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
