/*
Navicat Premium Data Transfer
Source Server : yzw2
Source Server Type : MySQL
Source Server Version : 50644
Source Host : localhost:3306
Source Schema : device
Target Server Type : MySQL
Target Server Version : 50644
File Encoding : 65001
Date: 01/05/2020 09:50:27
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_apply
-- ----------------------------
DROP TABLE IF EXISTS `t_apply`;
CREATE TABLE `t_apply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`cid` int(11) NULL DEFAULT NULL,
`count` int(11) NULL DEFAULT NULL,
`reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`applyDate` datetime(0) NULL DEFAULT NULL,
`applyPerson` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`amount` double(20, 2) NULL DEFAULT NULL,
`state` int(10) NULL DEFAULT 0,
`price` double(10, 2) NULL DEFAULT NULL,
`specs` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`cateNum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`isShow` int(2) NULL DEFAULT 1,
`opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`checkDate` datetime(0) NULL DEFAULT NULL,
`checkPerson` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `a_cate`(`cid`) USING BTREE,
CONSTRAINT `a_cate` FOREIGN KEY (`cid`) REFERENCES `t_category` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_apply
-- ----------------------------
INSERT INTO `t_apply` VALUES (1, '蒸馏器', '蒸馏器', 49, 3, '实验室蒸馏设备缺少', '2020-04-22 14:58:02', '杨子为', 240.00, 0, 80.00, '200ml,大型蒸馏器', '2-11-49', 1, NULL, NULL, NULL);
INSERT INTO `t_apply` VALUES (2, '研磨机', '研磨机', 54, 1, '实验室缺少研磨机', '2020-04-22 15:00:56', '杨子为', 180.00, 0, 180.00, '20ms研磨机', '2-12-54', 1, NULL, NULL, NULL);
INSERT INTO `t_apply` VALUES (3, '实验室用洗眼器', '洗眼器', 69, 10, '实验室应急用', '2020-04-22 16:03:03', '小菜鸡', 260.00, 0, 26.00, '无', '2-16-69', 1, NULL, NULL, NULL);
INSERT INTO `t_apply` VALUES (4, '实验室用红外测定仪', '红外测定仪', 97, 3, '实验需要', '2020-04-22 16:51:01', '杨字为', 960.00, 1, 320.00, '高25cm,重1200g', '4-23-97', 0, '同意', '2020-04-23 00:00:00', '杨自问');
INSERT INTO `t_apply` VALUES (5, '实验室用采样箱', '采样箱', 57, 4, '实验室必须', '2020-04-22 17:37:33', '李继红', 241.00, 1, 60.25, '高20cm,宽20cm,长30cm', '2-13-57', 0, NULL, NULL, NULL);
INSERT INTO `t_apply` VALUES (6, '实验用纯水机', '纯水机', 48, 2, '的看法看看领导', '2020-04-23 00:00:00', '杨丹', 126.00, 0, 63.00, '实验用纯水机(但是到了)', '2-11-48', 1, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for t_category
-- ----------------------------
DROP TABLE IF EXISTS `t_category`;
CREATE TABLE `t_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`level` int(11) NULL DEFAULT NULL,
`seq` int(11) NULL DEFAULT NULL,
`pid` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `cpid`(`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_category
-- ----------------------------
INSERT INTO `t_category` VALUES (1, '人身防护', 1, 1, 0);
INSERT INTO `t_category` VALUES (2, '实验室通用设备', 1, 2, 0);
INSERT INTO `t_category` VALUES (3, '测量计量', 1, 3, 0);
INSERT INTO `t_category` VALUES (4, '环境测量', 1, 4, 0);
INSERT INTO `t_category` VALUES (5, '头部防护', 2, 1, 1);
INSERT INTO `t_category` VALUES (6, '足部防护', 2, 2, 1);
INSERT INTO `t_category` VALUES (7, '身体防护', 2, 3, 1);
INSERT INTO `t_category` VALUES (8, '手部防护', 2, 4, 1);
INSERT INTO `t_category` VALUES (9, '试听防护', 2, 5, 1);
INSERT INTO `t_category` VALUES (10, '呼吸防护', 2, 6, 1);
INSERT INTO `t_category` VALUES (11, '纯化设备', 2, 7, 2);
INSERT INTO `t_category` VALUES (12, '粉碎设备', 2, 8, 2);
INSERT INTO `t_category` VALUES (13, '运输储存', 2, 9, 2);
INSERT INTO `t_category` VALUES (14, '分离萃取', 2, 10, 2);
INSERT INTO `t_category` VALUES (15, '制样消解', 2, 11, 2);
INSERT INTO `t_category` VALUES (16, '消杀应急', 2, 12, 2);
INSERT INTO `t_category` VALUES (17, '加热干燥', 2, 13, 2);
INSERT INTO `t_category` VALUES (18, '制冷恒温', 2, 14, 2);
INSERT INTO `t_category` VALUES (19, '压力仪表', 2, 15, 3);
INSERT INTO `t_category` VALUES (20, '计量仪表', 2, 16, 3);
INSERT INTO `t_category` VALUES (21, '测量仪器', 2, 17, 3);
INSERT INTO `t_category` VALUES (22, '天平衡量', 2, 18, 3);
INSERT INTO `t_category` VALUES (23, '水质分析仪', 2, 19, 4);
INSERT INTO `t_category` VALUES (24, '安全帽', 3, 1, 5);
INSERT INTO `t_category` VALUES (25, '防护屏', 3, 2, 5);
INSERT INTO `t_category` VALUES (26, '无纺布帽', 3, 3, 5);
INSERT INTO `t_category` VALUES (27, '无尘头套', 3, 4, 5);
INSERT INTO `t_category` VALUES (28, '防化靴', 3, 5, 6);
INSERT INTO `t_category` VALUES (29, '防静电鞋', 3, 6, 6);
INSERT INTO `t_category` VALUES (30, '高温/低温防护鞋', 3, 7, 6);
INSERT INTO `t_category` VALUES (31, '防化服', 3, 8, 7);
INSERT INTO `t_category` VALUES (32, '医用防化服', 3, 9, 7);
INSERT INTO `t_category` VALUES (33, '防静电服', 3, 10, 7);
INSERT INTO `t_category` VALUES (34, '防辐射服', 3, 11, 7);
INSERT INTO `t_category` VALUES (35, '防尘服', 3, 12, 7);
INSERT INTO `t_category` VALUES (36, '放切割手套', 3, 13, 8);
INSERT INTO `t_category` VALUES (37, '耐寒高温手套', 3, 14, 8);
INSERT INTO `t_category` VALUES (38, '防寒手套', 3, 15, 8);
INSERT INTO `t_category` VALUES (39, '乳胶手套', 3, 16, 8);
INSERT INTO `t_category` VALUES (40, '防酸碱手套', 3, 17, 8);
INSERT INTO `t_category` VALUES (41, '防护眼罩', 3, 18, 9);
INSERT INTO `t_category` VALUES (42, '防噪耳塞', 3, 19, 9);
INSERT INTO `t_category` VALUES (43, '防护眼镜', 3, 20, 9);
INSERT INTO `t_category` VALUES (44, '面具', 3, 21, 10);
INSERT INTO `t_category` VALUES (45, '口罩', 3, 22, 10);
INSERT INTO `t_category` VALUES (46, '呼吸机', 3, 23, 10);
INSERT INTO `t_category` VALUES (47, '呼吸防护配件', 3, 24, 10);
INSERT INTO `t_category` VALUES (48, '纯水机', 3, 25, 11);
INSERT INTO `t_category` VALUES (49, '蒸馏器', 3, 26, 11);
INSERT INTO `t_category` VALUES (50, '浓缩仪', 3, 27, 11);
INSERT INTO `t_category` VALUES (51, '纯化仪', 3, 28, 11);
INSERT INTO `t_category` VALUES (52, '其他', 3, 29, 11);
INSERT INTO `t_category` VALUES (53, '粉碎机', 3, 30, 12);
INSERT INTO `t_category` VALUES (54, '研磨机', 3, 31, 12);
INSERT INTO `t_category` VALUES (55, '其他', 3, 32, 12);
INSERT INTO `t_category` VALUES (56, '运输箱', 3, 33, 13);
INSERT INTO `t_category` VALUES (57, '采样箱', 3, 34, 13);
INSERT INTO `t_category` VALUES (58, '储存盒', 3, 35, 13);
INSERT INTO `t_category` VALUES (59, '其他', 3, 36, 13);
INSERT INTO `t_category` VALUES (60, '离心机', 3, 37, 14);
INSERT INTO `t_category` VALUES (61, '萃取设备', 3, 38, 14);
INSERT INTO `t_category` VALUES (62, '过滤装置', 3, 39, 14);
INSERT INTO `t_category` VALUES (63, '其他', 3, 4
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip 已获老师指导并通过的高分设计项目,可作为期末大作业和课程设计,纯手打高分项目,小白实战没难度。 基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip 已获老师指导并通过的高分设计项目,可作为期末大作业和课程设计,纯手打高分项目,小白实战没难度。 基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip 已获老师指导并通过的高分设计项目,可作为期末大作业和课程设计,纯手打高分项目,小白实战没难度。基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip 已获老师指导并通过的高分设计项目,可作为期末大作业和课程设计,纯手打高分项目,小白实战没难度。基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip 已获老师指导并通过的高分设计项目,可作为期末大作业和课程设计,纯手打高分项目,小白实战没难度。基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip 已获老师指导并通过的高分设计项目,可作为期末大作业和课程设计
资源推荐
资源详情
资源评论
收起资源包目录
基于javaweb项目实验室设备管理系统源码+数据库(95分以上).zip (1243个子文件)
$CACHE_FILE$ 7KB
$PRODUCT_WORKSPACE_FILE$ 489B
DeviceServlet.class 11KB
DeviceServlet.class 11KB
Test.class 10KB
DeviceServiceImpl.class 10KB
DeviceServiceImpl.class 10KB
ApplyServlet.class 8KB
ApplyServlet.class 8KB
DownItemServiceImpl.class 7KB
DownItemServiceImpl.class 7KB
CategoryServiceImpl.class 7KB
CategoryServiceImpl.class 7KB
ApplyServiceImpl.class 7KB
ApplyServiceImpl.class 7KB
FixInfoServiceImpl.class 7KB
FixInfoServiceImpl.class 7KB
TxQueryRunner.class 5KB
TxQueryRunner.class 5KB
Apply.class 4KB
Apply.class 4KB
BaseServlet.class 4KB
BaseServlet.class 4KB
SystemServlet.class 4KB
SystemServlet.class 4KB
DeviceDaoImpl.class 4KB
DeviceDaoImpl.class 4KB
ConsoleServlet.class 4KB
ConsoleServlet.class 4KB
CategoryServlet.class 4KB
CategoryServlet.class 4KB
ApplyDaoImpl.class 4KB
ApplyDaoImpl.class 4KB
LoginFilter.class 4KB
LoginFilter.class 4KB
DownItem.class 3KB
DownItem.class 3KB
JdbcUtil.class 3KB
JdbcUtil.class 3KB
AbstractBaseDaoImpl.class 3KB
AbstractBaseDaoImpl.class 3KB
Device.class 3KB
Device.class 3KB
PageVo.class 3KB
PageVo.class 3KB
CategoryDaoImpl.class 3KB
CategoryDaoImpl.class 3KB
UserServiceImpl.class 3KB
UserServiceImpl.class 3KB
Category.class 3KB
Category.class 3KB
FixInfo.class 3KB
FixInfo.class 3KB
FixInfoDaoImpl.class 2KB
FixInfoDaoImpl.class 2KB
RoleFilter.class 2KB
RoleFilter.class 2KB
CheckCodeUtil.class 2KB
CheckCodeUtil.class 2KB
EncodeFilter.class 2KB
EncodeFilter.class 2KB
User.class 2KB
User.class 2KB
UserDaoImpl.class 2KB
UserDaoImpl.class 2KB
ResMessage.class 2KB
ResMessage.class 2KB
CheckCodeServlet.class 2KB
CheckCodeServlet.class 2KB
DownItemDaoImpl.class 1KB
DownItemDaoImpl.class 1KB
Strings.class 1KB
Strings.class 1KB
BaseService.class 1KB
BaseService.class 1KB
ResMessageBuilder.class 1KB
ResMessageBuilder.class 1KB
BaseServlet$1.class 1KB
BaseServlet$1.class 1KB
BaseDao.class 557B
BaseDao.class 557B
DeviceService.class 536B
DeviceService.class 536B
CategoryService.class 442B
CategoryService.class 442B
DownItemService.class 298B
DownItemService.class 298B
FixInfoService.class 295B
FixInfoService.class 295B
ApplyService.class 289B
ApplyService.class 289B
CategoryDao.class 270B
CategoryDao.class 270B
FixInfoDao.class 267B
FixInfoDao.class 267B
DeviceDao.class 264B
DeviceDao.class 264B
ApplyDao.class 261B
ApplyDao.class 261B
UserDao.class 258B
共 1243 条
- 1
- 2
- 3
- 4
- 5
- 6
- 13
资源评论
不安分的小女孩
- 粉丝: 9213
- 资源: 2001
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 学生成绩管理系统-C++版本
- 吉林大学离散数学2笔记.pdf
- 通道处理过程的模拟通常涉及对通道处理机制的理解与实现.txt
- Flume进阶-自定义拦截器jar包
- Dubins曲线算法讲解和在运动规划中的使用.pdf
- 上市公司-股票性质数据-工具变量(民企、国企、央企)2003-2022年.dta
- 上市公司-股票性质数据-工具变量(民企、国企、央企)2003-2022年.xlsx
- Reeds+Shepp曲线算法讲解和实现.pdf
- 毕业设计基于SpringBoot+MyBatisPlus+MySQL+Vue的外卖配送信息系统源代码+数据库
- 词向量(Word Embeddings)是自然语言处理(NLP)领域的一种重要技术.txt
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功