高校实验室设备管理系统设计与实现-计算机毕业设计源码+LW文档

数据库代码：

/*
Navicat MySQL Data Transfer

Source Server         : mysql5
Source Server Version : 50562
Source Host           : localhost:3306
Source Database       : ssmgxsyssbglxthsg3511cg
​
Target Server Type    : MYSQL
Target Server Version : 50562
File Encoding         : 65001

Date: 2022-03-16 15:17:02
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `cx` varchar(50) DEFAULT '普通管理员',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2022-03-16 14:27:01');

-- ----------------------------
-- Table structure for `shebeiguihuan`
-- ----------------------------
DROP TABLE IF EXISTS `shebeiguihuan`;
CREATE TABLE `shebeiguihuan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shebeibianhao` varchar(50) DEFAULT NULL,
  `shebeimingcheng` varchar(50) DEFAULT NULL,
  `guihuanshijian` datetime DEFAULT NULL,
  `guihuanren` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of shebeiguihuan
-- ----------------------------
INSERT INTO `shebeiguihuan` VALUES ('7', '3161217776566', 'L设备', '2022-04-06 15:23:00', '014', '2022-03-16 14:26:28');
INSERT INTO `shebeiguihuan` VALUES ('8', '3161219053608', 'J设备', '2022-02-27 02:01:00', '031', '2022-03-16 14:26:28');
INSERT INTO `shebeiguihuan` VALUES ('9', '3161219053608', 'J设备', '2022-04-10 23:21:00', '001', '2022-03-16 14:26:28');
INSERT INTO `shebeiguihuan` VALUES ('10', '3161298124756', 'D设备', '2022-03-16 15:07:04', '001', '2022-03-16 15:07:06');
INSERT INTO `shebeiguihuan` VALUES ('11', '3161217776566', 'L设备', '2022-03-16 15:14:27', '001', '2022-03-16 15:14:29');

-- ----------------------------
-- Table structure for `shebeijieyong`
-- ----------------------------
DROP TABLE IF EXISTS `shebeijieyong`;
CREATE TABLE `shebeijieyong` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shebeibianhao` varchar(50) DEFAULT NULL,
  `shebeimingcheng` varchar(50) DEFAULT NULL,
  `shebeileibie` varchar(50) DEFAULT NULL,
  `shiyanshi` varchar(50) DEFAULT NULL,
  `qijieriqi` date DEFAULT NULL,
  `jieyongtianshu` varchar(50) DEFAULT NULL,
  `jieyongren` varchar(50) DEFAULT NULL,
  `beizhu` varchar(50) DEFAULT NULL,
  `issh` varchar(10) DEFAULT '否',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of shebeijieyong
-- ----------------------------
INSERT INTO `shebeijieyong` VALUES ('7', '3161206857713', 'P设备', 'K类', '实验室A', '2022-02-16', '78', '009', '借用', '是', '2022-03-16 14:26:28');
INSERT INTO `shebeijieyong` VALUES ('8', '3161278796087', 'A设备', 'K类', '实验室B', '2022-02-24', '78', '011', '借用', '是', '2022-03-16 14:26:28');
INSERT INTO `shebeijieyong` VALUES ('9', '3161219053608', 'J设备', 'L类', '实验室A', '2022-02-24', '86', '001', '领用', '是', '2022-03-16 14:26:28');
INSERT INTO `shebeijieyong` VALUES ('11', '3161298124756', 'D设备', 'C类', '实验室A', '2022-03-16', '5', '001', '借用', '是', '2022-03-16 15:05:47');
INSERT INTO `shebeijieyong` VALUES ('12', '3161217776566', 'L设备', 'K类', '实验室B', '2022-03-16', '5', '001', '借用', '是', '2022-03-16 15:13:36');

-- ----------------------------
-- Table structure for `shebeileibie`
-- ----------------------------
DROP TABLE IF EXISTS `shebeileibie`;
CREATE TABLE `shebeileibie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leibie` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of shebeileibie
-- ----------------------------
INSERT INTO `shebeileibie` VALUES ('2', 'K类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('3', 'N类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('4', 'L类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('5', 'A类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('6', 'Q类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('7', 'H类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('8', 'C类', '2022-03-16 14:26:28');
INSERT INTO `shebeileibie` VALUES ('9', 'Z类', '2022-03-16 14:26:28');

-- ----------------------------
-- Table structure for `shebeiweixiu`
-- ----------------------------
DROP TABLE IF EXISTS `shebeiweixiu`;
CREATE TABLE `shebeiweixiu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weixiudanhao` varchar(50) DEFAULT NULL,
  `shebeibianhao` varchar(50) DEFAULT NULL,
  `shebeimingcheng` varchar(50) DEFAULT NULL,
  `shebeileibie` varchar(50) DEFAULT NULL,
  `wentifankui` varchar(500) DEFAULT NULL,
  `weixiuriqi` date DEFAULT NULL,
  `beizhu` varchar(500) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of shebeiweixiu
-- ----------------------------
INSERT INTO `shebeiweixiu` VALUES ('2', '3162092826074', '3161219053608', 'J设备', 'L类', '', '2022-03-25', 'ok', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('3', '3162081996122', '3161258134177', 'X设备', 'N类', '', '2022-04-14', '暂无', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('4', '3162020987791', '3161278796087', 'A设备', 'K类', '', '2022-02-22', '无', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('5', '3162032816643', '3161298124756', 'D设备', 'C类', '', '2022-02-23', '没问题', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('6', '3162040539501', '3161257866134', 'K设备', 'L类', '', '2022-03-26', '无', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('7', '3162029600758', '3161298124756', 'D设备', 'C类', '', '2022-03-25', '暂无', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('8', '3162080629179', '3161269063039', 'H设备', 'A类', '', '2022-03-27', '暂无', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('9', '3162091559032', '3161278796087', 'A设备', 'K类', '', '2022-02-22', '没问题', '2022-03-16 14:26:28');
INSERT INTO `shebeiweixiu` VALUES ('10', '03161455475530', '3161278796087', 'A设备', 'K类', 'test', '2022-03-16', 'test', '2022-03-16 14:56:00');
INSERT INTO `shebeiweixiu` VALUES ('11', '03161515183318', '3161217776566', 'L设备', 'K类', 'tttttt', '2022-03-16', 'tttttttt', '2022-03-16 15:15:27');

-- ----------------------------
-- Table structure for `shebeixinxi`
-- ----------------------------
DROP TABLE IF EXISTS `shebeixinxi`;
CREATE TABLE `shebeixinxi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shebeibianhao` varchar(50) DEFAULT NULL,
  `shebeimingcheng` varchar(50) DEFAULT NULL,
  `shebeileibie` varchar(50) DEFAULT NULL,
  `shiyanshi` varchar(50) DEFAULT NULL,
  `zhuangtai` varchar(50) DEFAULT NULL,
  `shebeijianjie` varchar(500) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of shebeixinxi
-- ----------------------------
INSERT INTO `shebeixinxi` VALUES ('2', '3161269063039', 'H设备', 'A类', '实验室A', '正常', 'ok', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('3', '3161258134177', 'X设备', 'N类', '实验室A', '正常', '暂无', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('4', '3161206857713', 'P设备', 'K类', '实验室A', '正常', '没问题', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('5', '3161257866134', 'K设备', 'L类', '实验室A', '正常', '无', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('6', '3161298124756', 'D设备', 'C类', '实验室A', '正常', '无', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('7', '3161219053608', 'J设备', 'L类', '实验室A', '良好', '暂无', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('8', '3161217776566', 'L设备', 'K类', '实验室B', '良好', '暂无', '2022-03-16 14:26:28');
INSERT INTO `shebeixinxi` VALUES ('9', '3161278796087', 'A设备', 'K类', '实验室B', '良好', '没问题', '2022-03-16 14:26:28');

-- ----------------------------
-- Table structure for `yonghu`
-- ----------------------------
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yonghuming` varchar(50) DEFAULT NULL,
  `mima` varchar(50) DEFAULT NULL,
  `xingming` varchar(50) DEFAULT NULL,
  `shoujihao` varchar(50) DEFAULT NULL,
  `shenfenzheng` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of yonghu
-- ----------------------------
INSERT INTO `yonghu` VALUES ('2', '004', '001', '舒畅', '13544655202', '330327199005060003', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('3', '020', '001', '张燕', '17706641413', '330327198501020300', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('4', '008', '001', '刘建福', '13186835580', '330327198406150488', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('5', '029', '001', '冯子杰', '13184865998', '330327199504059511', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('6', '013', '001', '陈贵柏', '13025896548', '330327198811020456', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('7', '024', '001', '余少庆', '13489665487', '330327198708070789', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('8', '011', '001', '郭家顺', '18759640002', '33032719900723568X', '2022-03-16 14:26:28');
INSERT INTO `yonghu` VALUES ('9', '001', '001', '陈燕琪', '13623256544', '330327198805060222', '2022-03-16 14:26:28');

 

 

 

 

​