数据库代码：
/*
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’);