基于微信小程序的基于微信小程序的图书馆预约系统(java).zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50726 Source Host : localhost:3306 Source Database : tsgyy Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2023-02-12 12:04:26 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for article -- ---------------------------- DROP TABLE IF EXISTS `article`; CREATE TABLE `article` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `cate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '类别', `title` longtext COLLATE utf8_bin COMMENT '标题', `content` longtext COLLATE utf8_bin COMMENT '内容', `pic` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '封面', `created_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间', `updated_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='文章'; -- ---------------------------- -- Records of article -- ---------------------------- INSERT INTO `article` VALUES ('1', '系统公告', 0xE8BF99E698AFE59BBEE4B9A6E9A686E887AAE4B9A0E5AEA4E9A284E7BAA6E7B3BBE7BB9FE79A84E7ACACE4B880E69DA1E585ACE5918A, 0x3C703EE8BF99E698AFE59BBEE4B9A6E9A686E887AAE4B9A0E5AEA4E9A284E7BAA6E7B3BBE7BB9FE79A84E7ACACE4B880E69DA1E585ACE5918AE8BF99E698AFE59BBEE4B9A6E9A686E887AAE4B9A0E5AEA4E9A284E7BAA6E7B3BBE7BB9FE79A84E7ACACE4B880E69DA1E585ACE5918AE8BF99E698AFE59BBEE4B9A6E9A686E887AAE4B9A0E5AEA4E9A284E7BAA6E7B3BBE7BB9FE79A84E7ACACE4B880E69DA1E585ACE5918AE8BF99E698AFE59BBEE4B9A6E9A686E887AAE4B9A0E5AEA4E9A284E7BAA6E7B3BBE7BB9FE79A84E7ACACE4B880E69DA1E585ACE5918A3C2F703E, '/static/uploads/20221106/20221106222220.jpeg', '2022-11-06 22:22:23', null); -- ---------------------------- -- Table structure for cate -- ---------------------------- DROP TABLE IF EXISTS `cate`; CREATE TABLE `cate` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '名称', `notes` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '备注', `created_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间', `updated_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='自习室类别'; -- ---------------------------- -- Records of cate -- ---------------------------- INSERT INTO `cate` VALUES ('1', '朗读房', '朗读房', '2022-11-06 21:05:29', null); INSERT INTO `cate` VALUES ('2', '普通房', '', '2022-11-06 21:05:36', null); INSERT INTO `cate` VALUES ('3', '电脑房', '', '2022-11-06 22:17:24', null); -- ---------------------------- -- Table structure for message -- ---------------------------- DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `student_id` int(11) DEFAULT '0' COMMENT '学生ID', `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '名称', `notes` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '备注', `created_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间', `updated_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='自习室预约'; -- ---------------------------- -- Records of message -- ---------------------------- INSERT INTO `message` VALUES ('1', '1', '22222222222222222222222', 'sdadfasd', '2022-11-06 22:08:37', null); INSERT INTO `message` VALUES ('2', '2', '我要开始一个新的留言咯', '请注意留言措辞', '2022-11-06 22:21:43', null); -- ---------------------------- -- Table structure for reserve -- ---------------------------- DROP TABLE IF EXISTS `reserve`; CREATE TABLE `reserve` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `student_id` int(11) DEFAULT '0' COMMENT '学生ID', `room_id` int(11) DEFAULT '0' COMMENT '自习室ID', `area` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '区域', `date` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '预约日期', `time1` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '开始时间', `time2` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '截至时间', `sign` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '签到', `signinfo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '签到位置', `status` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '状态', `optinfo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '操作信息', `optuser` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '操作人', `optdate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '操作时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='自习室预约'; -- ---------------------------- -- Records of reserve -- ---------------------------- INSERT INTO `reserve` VALUES ('1', '1', '1', 'R5', '2022-11-07', '07:00', '08:00', '0', null, '1', null, null, null); INSERT INTO `reserve` VALUES ('2', '2', '2', 'L1', '2022-11-07', '07:00', '09:00', '0', null, '1', null, null, null); INSERT INTO `reserve` VALUES ('3', '2', '0', 'L2', '2022-11-07', '08:00', '09:00', '0', null, '0', null, null, null); INSERT INTO `reserve` VALUES ('4', '2', '1', 'L2', '2022-11-07', '07:00', '08:30', '0', null, '0', null, null, null); -- ---------------------------- -- Table structure for room -- ---------------------------- DROP TABLE IF EXISTS `room`; CREATE TABLE `room` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `title` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '名称', `pic` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '图片', `address` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '位置', `cate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '类别', `peoples` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '容纳人数', `areas` longtext COLLATE utf8_bin COMMENT '区域', `start_time` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '开始时间', `end_time` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '截至时间', `content` longtext COLLATE utf8_bin COMMENT '明细', `created_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间', `updated_at` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='图书馆自习室'; -- ---------------------------- -- Records of room -- ---------------------------- INSERT INTO `room` VALUES ('1', '朗读房101', '/static/uploads/20221106/20221106211916.jpeg', '图书馆A座', '朗读房', '10', 0x4C312C4C322C4C332C4C342C4C352C52312C52322C52332C52342C5235, '07:00', '14:00', 0xE68B89E890A8E985B1E8B186E88590E59E83E59CBEE69292, '2022-11-06 21:19:54', null); INSERT INTO `room` VALUES ('2', '电脑房101', '/static/uploads/20221106/20221106221740.jpeg', '图书馆B区', '电脑房', '8', 0x4C312C4C322C4C332C4C342C52312C52322C52332C5234, '07:00', '22:00', 0xE8AFB7E5AE89E99D99, '2022-11-06 22:18:23', null); -- ---------------------------- -- Table structure for student -- ---------------------------- DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名', `code` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '账号', `pwd` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '密码', `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '联系电话', `idcard` varchar(18) COLLATE utf8_bin DEFAULT NULL COMMENT '身份证号', `major` varch