/*
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
版权申诉
5星 · 超过95%的资源 85 浏览量
2023-04-15
15:01:28
上传
评论
收藏 15.41MB 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
资源评论
2301_768320722023-11-09怎么能有这么好的资源！只能用感激涕零来形容TAT...
盈梓的博客
- 粉丝: 6839
- 资源: 1245
下载权益
C知道特权
VIP文章
课程特权
VIP享7折，此内容立减5.97元 开通VIP
