基于 Spring AI MCP 实现一个数据库对话操作助手
使用
- 创建一个数据库，并创建一些业务表，例如：
-- MySQL dump 10.13 Distrib 8.0.32, for macos13.0 (arm64)
--
-- Host: www.xumumi.com Database: tclass
-- ------------------------------------------------------
-- Server version 8.0.32-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION = @@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE = @@TIME_ZONE */;
/*!40103 SET TIME_ZONE = '+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;
/*!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 */;
--
-- Table structure for table `department`
--
DROP TABLE IF EXISTS `department`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `department`
(
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '部门名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 11
DEFAULT CHARSET = utf8mb3
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `department`
--
LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department`
DISABLE KEYS */;
INSERT INTO `department`
VALUES (1, '组织部'),
(2, '实践部'),
(3, '外联部'),
(4, '学习部'),
(5, '文体部'),
(6, '英语协会'),
(7, '心理协会'),
(8, '计算机协会'),
(9, '乒乓球协会'),
(10, '摄影协会');
/*!40000 ALTER TABLE `department`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `extension`
--
DROP TABLE IF EXISTS `extension`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `extension`
(
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 13
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `extension`
--
LOCK TABLES `extension` WRITE;
/*!40000 ALTER TABLE `extension`
DISABLE KEYS */;
INSERT INTO `extension`
VALUES (1, '无'),
(3, '.html'),
(4, '.txt'),
(5, '.sql'),
(6, '.docx'),
(7, '.xlsx'),
(8, '.pptx'),
(9, '.7z'),
(10, '.java'),
(11, '.jpeg');
/*!40000 ALTER TABLE `extension`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `flyway_schema_history`
--
DROP TABLE IF EXISTS `flyway_schema_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `flyway_schema_history`
(
`installed_rank` int NOT NULL,
`version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`script` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`checksum` int DEFAULT NULL,
`installed_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`execution_time` int NOT NULL,
`success` tinyint(1) NOT NULL,
PRIMARY KEY (`installed_rank`) USING BTREE,
KEY `flyway_schema_history_s_idx` (`success`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `flyway_schema_history`
--
LOCK TABLES `flyway_schema_history` WRITE;
/*!40000 ALTER TABLE `flyway_schema_history`
DISABLE KEYS */;
INSERT INTO `flyway_schema_history`
VALUES (1, '1.0.0', 'tclass', 'SQL', 'V1.0.0__tclass.sql', -548938363, 'teoan', '2021-04-20 13:47:18', 11146, 1);
/*!40000 ALTER TABLE `flyway_schema_history`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nation`
--
DROP TABLE IF EXISTS `nation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `nation`
(
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 57
DEFAULT CHARSET = utf8mb3
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nation`
--
LOCK TABLES `nation` WRITE;
/*!40000 ALTER TABLE `nation`
DISABLE KEYS */;
INSERT INTO `nation`
VALUES (1, '汉族'),
(2, '蒙古族'),
(3, '回族'),
(4, '藏族'),
(5, '维吾尔族'),
(6, '苗族'),
(7, '彝族'),
(8, '壮族'),
(9, '布依族'),
(10, '朝鲜族'),
(11, '满族'),
(12, '侗族'),
(13, '瑶族'),
(14, '白族'),
(15, '土家族'),
(16, '哈尼族'),
(17, '哈萨克族'),
(18, '傣族'),
(19, '黎族'),
(20, '傈僳族'),
(21, '佤族'),
(22, '畲族'),
(23, '高山族'),
(24, '拉祜族'),
(25, '水族'),
(26, '东乡族'),
(27, '纳西族'),
(28, '景颇族'),
(29, '柯尔克孜族'),
(30, '土族'),
(31, '达斡尔族'),
(32, '仫佬族'),
(33, '羌族'),
(34, '布朗族'),
(35, '撒拉族'),
(36, '毛难族'),
(37, '仡佬族'),
(38, '锡伯族'),
(39, '阿昌族'),
(40, '普米族'),
(41, '塔吉克族'),
(42, '怒族'),
(43, '乌孜别克族'),
(44, '俄罗斯族'),
(45, '鄂温克族'),
(46, '崩龙族'),
(47, '保安族'),
(48, '裕固族'),
(49, '京族'),
(50, '塔塔尔族'),
(51, '独龙族'),
(52, '鄂伦春族'),
(53, '赫哲族'),
(54, '门巴族'),
(55, '珞巴族'),
(56, '基诺族');
/*!40000 ALTER TABLE `nation`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notice`
--
DROP TABLE IF EXISTS `notice`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notice`
(
`id` int NOT NULL AUTO_INCREMENT,
`s_id` int NOT NULL COMMENT '通知发起人',
`edit_s_id` int DEFAULT NULL COMMENT '编辑人',
`deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
`title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知内容',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `sId` (`s_id`) USING BTREE,
CONSTRAINT `notice_ibfk_1` FOREIGN KEY (`s_id`) REFERENCES `student` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB
AUTO_INCREMENT = 38
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notice`
--
LOCK TABLES `notice` WRITE;
/*!40000 ALTER TABLE `notice`
DISABLE KEYS */;
INSERT INTO `notice`
VALUES (20, 1724111400, 1724111400, 0, '学校通知',
'为更好处理毕业生相关工作，学院将于本周六（8月8日）下午4点在腾讯会议召开准毕业生会议。主持人：史婉怡 主讲人：张文台\n会议内容：\n1. 关于实习实训处理。\n2. 论文事情怎么处理好。\n3. 工作什么时候出去找合适，以及现在毕业生就业情况。\n4. 大四需要处理的事情。5.问答 有疑问可以询问。\n\n会议 ID：404 401 142 16：00准时开始，因为房间人数有限，参加的同学尽快进入。这是大家毕业找工作前最大一次会议，大家不要错过。',
'2020-08-10 14:28:09', '2020-12-14 20:55:25'),
(29, 1724111400, 1724111400, 0, '学校通知',
'1. 12月12日（周六）上午10点市人社在鼎湖的人力资源服务产业园举行开园活动及2021届毕业生招聘会专场（10点－11点半）。\n2. 请有意参与招聘会的同学于12月8日上午12点（本周二前）向本班就业指导员报名\n3. 报名的同学于12月12日上午9点45分在国砚广场路边上车。',
'2020-12-19 12:14:56', '2021-04-27 11:23:27'),
(30, 1724111400, NULL, 0, '项目申报系统开放的通知',
'2021年度广东省科技创新战略专项资金（大学生科技创新培育） 项目申报系统已开放。【系统操作及相关参考文件】已附于2021年申报平台首页，请有意参加的老师指导好项目组学生完成相应的申报工作。以下几个方面请注意：\n\n1. 学生注册账号及申报时间为：2020 年 11 月 25 日-12 月 9 日。请大家合理安排时间，以免影响下一阶段审核工作。\n2. 申报阶段相关细则请具体参照《广东省科技创新战略专项资金（大学生科技创新培育）管理办法》和《2021年广东省科技创新战略专项资金（大学生科技创新培育）项目申报指南》要求推动相关工作。请转发班群，学院老师有收到该通知了，如有想法及时跟学院老师沟通与申请。',
'2020-12-19 12:43:20', '2020-12-19 12:43:20'),
(31, 1724111400, NULL, 0, '学校通知',
'第七届“助学·筑梦·铸人”主题作品征集活动，同学们可以看看，征集时间在2020年11月2日-2020年12月31日，现在已开通报名，有意向参加活动的同学可以参加啦，参加活动的同学记得提前跟我说一声哈，最后提交作品后记得截图证明，以及将作品发我一份，参与活动的同学可以获得2分综测分！',
'2020-12-19 12:44:19', '2020-12-19 12:44:19'),
(32, 1724111400, 1724111400, 0, '学校通知',
'学校有关对特困新生及受灾受疫情影响学生等的资助，具体资助及相关要求如下\n1. 2020级特困新生学费资助:\n 对象:经学校认定的20级特困新生\n2. 受疫情影响学生资助\n 对象:在校学生\n 申请条件：\n 思想品德良好，无违纪违法行为；\n 本人或家人感染新冠肺炎或受疫情影响而造成家庭经济困难的学生。\n3. 受灾学生资助:\n对象:在校学生\n申请条件:\n 1. 无违纪违规行为\n 2. 因低温雨雪冰冻、超强台风等自然灾害造成的人员伤亡、主要居住房屋倒塌、作为生活来源的农作物绝收或财产经济受到重大损失的情况；\n4. 来自受灾地区家庭，有当地村委或政府部门的受灾证明等材料。（证明材料可先拍照作证，再将原件寄回学校提交；若是开学申请时已提交，请在表格说明）',
'2020-12-19 12:47:45', '2020-12-19 13:29:12'),
(33, 1724111400, 1724111400, 0, '关于英语四六级通知',
'# 英语四六级通知\n1. 报考资格\n 本次补报考生应满足唯一条件：已参加2020年9月延考且当次英语四级（CET4）笔试成绩大于等于425分的考生。\n2. 报名方式及时间\n 1. 本次补报科目仅为英语六级（CET6）笔试，其他科目不予补报。\n 2. 本次补报时间为11月9日9:00-11日17:00，过时不再予以补报。\n 3. 符合补报资格的考生，请自行登录报名系统http://cet-bm.neea.edu.cn完成CET6笔试补报及缴费。',
'2020-12-19 12:49:30', '2020-12-19 12:51:27'),
(34, 1724111400, NULL, 0, '关于开展年级会议(毕业离校会议)',
'* 由于同学返校时间不确定，现以班级形式开展毕业生离校前一次大会，会议要求全部毕业生都有参与\n* ️时间可以是中午或者晚上，一次性最多两个班同时开\n* ️会议时间大概是1个小时～2个小时',
'2021-04-27 11:21:25', '2021-04-27 11:21:25'),
(35, 1724111400, NULL, 1, '测试', '1', '2021-04-27 11:23:53', '2021-04-27 11:23:55'),
(36, 1724111400, NULL, 0, '【“青年大学习”】全省各级团干：团中央的“青年大学习”网上主题团课现已推出第十一季第五期。',
'* 请各班团支书、班长在4月25日下午18:00分前广泛发动团员青年完成本周学习。\n* “青年大学习”网上主题团课广东入口更新啦！请移步“广东共青团”微信公众号底部菜单栏点击智慧团建主页面进入学习。团员须观看视频并完成答题。\n* 从本期开始，团省委将以各地、各高校团员参学比为主要指标进行排名，并在公众号进行推送。请全省专兼挂职团干、各校是团员的学生干部必须参与每期学习，并广泛发动团员青年参与。',
'2021-04-27 11:50:07', '2021-04-27 11:50:07'),
(37, 1724111400, 1724111400, 0, '关于拍照费用',
'**拍摄方提供：学士服、学士帽、证书、场地服务、照片排版设计等**\n价格选择：\n\n* 70元，只拍照。\n* 80元，拍照+电子照片\n* 90元，拍照+纸质照片（一张班级大合照、一张学院大合照）\n* 120元，拍照+相册',
'2021-04-27 11:59:09', '2021-04-28 07:57:45');
/*!40000 ALTER TABLE `notice`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oauth_client_details`
--
DROP TABLE IF EXISTS `oauth_client_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_client_details`
(
`client_id` varchar(48) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`resource_ids` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`client_secret` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`scope` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`authorized_grant_types` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`web_server_redirect_uri` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`authorities` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`access_token_validity` int DEFAULT NULL,
`refresh_token_validity` int DEFAULT NULL,
`additional_information` varchar(4096) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`autoapprove` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`client_id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb3
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oauth_client_details`
--
LOCK TABLES `oauth_client_details` WRITE;
/*!40000 ALTER TABLE `oauth_client_details`
DISABLE KEYS */;
INSERT INTO `oauth_client_details`
VALUES ('tclass-notice-server', '', 'e10adc3949ba59abbe56e057f20f883e', 'server',
'password,authorization_code,refresh_token,client_credentials', NULL, NULL, 1800, 300, NULL, NULL),
('tclass-user-server', '', 'e10adc3949ba59abbe56e057f20f883e', 'server',
'password,authorization_code,refresh_token,client_credentials', NULL, NULL, 1800, 300, NULL, NULL),
('tclass-work-server', '', 'e10adc3949ba59abbe56e057f20f883e', 'server',
'password,authorization_code,refresh_token,client_credentials', NULL, NULL, 1800, 300, NULL, NULL),
('webapp', NULL, 'e10adc3949ba59abbe56e057f20f883e', 'server',
'password,authorization_code,refresh_token,client_credentials', NULL, NULL, 1800, 300, NULL, NULL);
/*!40000 ALTER TABLE `oauth_client_details`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `politicsstatus`
--
DROP TABLE IF EXISTS `politicsstatus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `politicsstatus`
(
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 14
DEFAULT CHARSET = utf8mb3
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `politicsstatus`
--
LOCK TABLES `politicsstatus` WRITE;
/*!40000 ALTER TABLE `politicsstatus`
DISABLE KEYS */;
INSERT INTO `politicsstatus`
VALUES (1, '中共党员'),
(2, '中共预备党员'),
(3, '共青团员'),
(4, '民革党员'),
(5, '民盟盟员'),
(6, '民建会员'),
(7, '民进会员'),
(8, '农工党党员'),
(9, '致公党党员'),
(10, '九三学社社员'),
(11, '台盟盟员'),
(12, '无党派民主人士'),
(13, '普通公民');
/*!40000 ALTER TABLE `politicsstatus`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `position`
--
DROP TABLE IF EXISTS `position`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `position`
(
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 12
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `position`
--
LOCK TABLES `position` WRITE;
/*!40000 ALTER TABLE `position`
DISABLE KEYS */;
INSERT INTO `position`
VALUES (1, '班长'),
(2, '纪委'),
(3, '学习委员'),
(4, '信息委员'),
(5, '心理委员'),
(6, '学习委员'),
(7, '文娱委员'),
(8, '宣传委员'),
(9, '生活委员'),
(10, '组织委员'),
(11, '无');
/*!40000 ALTER TABLE `position`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role`
(
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`zh_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 3
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role`
DISABLE KEYS */;
INSERT INTO `role`
VALUES (1, 'ROLE_admin', '管理员'),
(2, 'ROLE_student', '普通用户');
/*!40000 ALTER TABLE `role`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stu_dep_ref`
--
DROP TABLE IF EXISTS `stu_dep_ref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stu_dep_ref`
(
`sId` int DEFAULT NULL,
`dId` int DEFAULT NULL,
KEY `sId` (`sId`) USING BTREE,
KEY `dId` (`dId`) USING BTREE,
CONSTRAINT `stu_dep_ref_ibfk_1` FOREIGN KEY (`sId`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `stu_dep_ref_ibfk_2` FOREIGN KEY (`dId`) REFERENCES `department` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stu_dep_ref`
--
LOCK TABLES `stu_dep_ref` WRITE;
/*!40000 ALTER TABLE `stu_dep_ref`
DISABLE KEYS */;
INSERT INTO `stu_dep_ref`
VALUES (1724111408, 2),
(1724111402, 5),
(1724111403, 8),
(1724111404, 4),
(1724111405, 4),
(1724111406, 6),
(1724111407, 6),
(1724111408, 4),
(1724111409, 10),
(1724111413, 6),
(1724111414, 10),
(1724111416, 2),
(1724111417, 9),
(1724111418, 6),
(1724111423, 4),
(1724111424, 8),
(1724111425, 9),
(1724111426, 10),
(1724111427, 2),
(1724111428, 10),
(1724111429, 10),
(1724111430, 2),
(1724111431, 7),
(1724111432, 10),
(1724111433, 6),
(1724111434, 10),
(1724111435, 9),
(1724111436, 6),
(1724111437, 10),
(1724111438, 2),
(1724111439, 7),
(1724111440, 1),
(1724111441, 2),
(1724111442, 7),
(1724111443, 6),
(1724111444, 8),
(1724111445, 10),
(1724111403, 6),
(1724111402, 10),
(1724111405, 6),
(1724111404, 1),
(1724111407, 6),
(1724111406, 9),
(1724111413, 6),
(1724111409, 2),
(1724111416, 2),
(1724111428, 6),
(1724111414, 4),
(1724111417, 7),
(1724111418, 8),
(1724111432, 2),
(1724111423, 4),
(1724111424, 8),
(1724111425, 10),
(1724111426, 4),
(1724111427, 9),
(1724111442, 6),
(1724111429, 10),
(1724111430, 3),
(1724111431, 4),
(1724111438, 2),
(1724111433, 9),
(1724111434, 7),
(1724111435, 7),
(1724111436, 7),
(1724111437, 3),
(1724111440, 2),
(1724111439, 1),
(1724111441, 4),
(1724111443, 7),
(1724111444, 8),
(1724111445, 9),
(1724111421, 3),
(1724111421, 7),
(1724111421, 5),
(1724111421, 4),
(1724111419, 1),
(1724111419, 2),
(1724111419, 6),
(1724111419, 4),
(1724111422, 3),
(1724111422, 3),
(1724111420, 7),
(1724111420, 5),
(1724111401, 9),
(1724111401, 8),
(1724111400, 4),
(1724111400, 2),
(1724111400, 7),
(1724111400, 8),
(1724111400, 9),
(1724111400, 6),
(1724111400, 5),
(1724111400, 3);
/*!40000 ALTER TABLE `stu_dep_ref`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student`
--
DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student`
(
`id` int NOT NULL AUTO_INCREMENT COMMENT '学号',
`role_id` int NOT NULL COMMENT '权限',
`name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学生名字',
`password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
`gender` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '性别',
`nation_id` int NOT NULL COMMENT '民族',
`native_place` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '籍贯',
`politic_id` int DEFAULT '13' COMMENT '政治面貌',
`email` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电话',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '家庭住址',
`pos_id` int DEFAULT '11' COMMENT '班级职位',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`login_time` datetime DEFAULT NULL COMMENT '最近登录时间',
`avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像链接',
`deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
PRIMARY KEY (`id`) USING BTREE,
KEY `roleId` (`role_id`) USING BTREE,
KEY `id` (`id`) USING BTREE,
KEY `nationId` (`nation_id`) USING BTREE,
KEY `politicId` (`politic_id`) USING BTREE,
KEY `posId` (`pos_id`) USING BTREE,
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `student_ibfk_2` FOREIGN KEY (`nation_id`) REFERENCES `nation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `student_ibfk_3` FOREIGN KEY (`politic_id`) REFERENCES `politicsstatus` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `student_ibfk_4` FOREIGN KEY (`pos_id`) REFERENCES `position` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB
AUTO_INCREMENT = 1724111451
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student`
--
LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student`
DISABLE KEYS */;
INSERT INTO `student`
VALUES (1724111400, 1, '王涛', 'e10adc3949ba59abbe56e057f20f883e', '男', 50, '广东省,广州市,天河区', 1, 'wang@qq.com',
'15644442252', '陕西西安新城区', 1, '2020-07-23 16:32:47', '2021-07-19 07:32:47', '2021-06-09 18:05:36',
'group1/M00/00/00/CmiHO2D1KuSAC-qRAAJURtAS76c27.jpeg', 0),
(1724111401, 2, '陈静', 'e10adc3949ba59abbe56e057f20f883e', '女', 44, '广东省,广州市,天河区', 11,
'chenjing@qq.com', '18795556693', '海南省海口市美兰区', 11, '2020-07-23 16:38:45', '2021-04-27 11:57:00',
'2021-04-27 11:56:05', '/student/avatar/1724111401.jpg', 0),
(1724111402, 2, '赵琳浩', 'e10adc3949ba59abbe56e057f20f883e', '男', 35, '广东省,广州市,天河区', 10,
'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', 3, '2020-07-23 16:38:45', '2020-12-14 22:41:13',
'2020-11-29 17:25:00', 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111403, 2, '鹿存亮', 'e10adc3949ba59abbe56e057f20f883e', '男', 30, '广东省,广州市,天河区', 9, 'zhao@qq.com',
'15612347795', '陕西省西安市莲湖区', 4, '2020-07-23 16:38:45', '2020-12-14 22:41:13', '2020-11-21 21:55:06',
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111404, 2, '姚森', 'e10adc3949ba59abbe56e057f20f883e', '男', 27, '广东省,广州市,天河区', 8, 'yaosen@qq.com',
'14785559936', '河南洛阳人民大道58号', 5, '2020-07-23 16:38:45', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111405, 2, '云星', 'e10adc3949ba59abbe56e057f20f883e', '女', 10, '广东省,广州市,天河区', 4,
'yunxing@qq.com', '15644442252', '陕西西安新城区', 6, '2020-07-23 16:38:45', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111406, 2, '贾旭明', 'e10adc3949ba59abbe56e057f20f883e', '男', 46, '广东省,广州市,天河区', 4,
'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', 7, '2020-07-23 16:38:45', '2020-12-14 22:41:13',
NULL, 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111407, 2, '张黎明', 'e10adc3949ba59abbe56e057f20f883e', '男', 40, '广东省,广州市,天河区', 12,
'zhangliming@qq.com', '18979994478', '广东珠海', 8, '2020-07-23 16:38:45', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111408, 2, '薛磊', 'e10adc3949ba59abbe56e057f20f883e', '男', 5, '广东省,广州市,天河区', 12, 'xuelei@qq.com',
'15648887741', '西安市雁塔区', 9, '2020-07-23 16:38:45', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111409, 2, '张洁', 'e10adc3949ba59abbe56e057f20f883e', '女', 11, '广东省,广州市,天河区', 4,
'zhangjie@qq.com', '13695557742', '海口市美兰区', 10, '2020-07-23 16:38:45', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111413, 2, '王涛1', 'e10adc3949ba59abbe56e057f20f883e', '男', 14, '广东省,广州市,天河区', 6, 'wang@qq.com',
'15644442252', '陕西西安新城区', 11, '2020-07-23 20:02:20', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111414, 2, '陈静1', 'e10adc3949ba59abbe56e057f20f883e', '女', 21, '广东省,广州市,天河区', 8,
'chenjing@qq.com', '18795556693', '海南省海口市美兰区', 11, '2020-07-23 20:02:20', '2020-12-14 22:41:13',
'2020-07-29 12:10:29', 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111416, 2, '王涛1', 'e10adc3949ba59abbe56e057f20f883e', '男', 41, '广东省,广州市,天河区', 9, 'wang@qq.com',
'15644442252', '陕西西安新城区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111417, 2, '陈静1', 'e10adc3949ba59abbe56e057f20f883e', '女', 56, '广东省,广州市,天河区', 1,
'chenjing@qq.com', '18795556693', '海南省海口市美兰区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111418, 2, '赵琳浩1', 'e10adc3949ba59abbe56e057f20f883e', '男', 14, '广东省,广州市,天河区', 2,
'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13',
'2020-08-09 10:57:55', 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111419, 2, '鹿存亮1', 'e10adc3949ba59abbe56e057f20f883e', '男', 36, '湖北省,十堰市,茅箭区', 13,
'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111420, 2, '姚森', 'e10adc3949ba59abbe56e057f20f883e', '男', 46, '湖北省,宜昌市,点军区', 4, 'yaosen@qq.com',
'14785559936', '河南洛阳人民大道58号', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111421, 2, '云星1', 'e10adc3949ba59abbe56e057f20f883e', '女', 34, '广东省,广州市,天河区', 5,
'yunxing@qq.com', '15644442252', '陕西西安新城区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111422, 2, '贾旭明', 'e10adc3949ba59abbe56e057f20f883e', '男', 48, '广东省,广州市,天河区', 4,
'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13',
NULL, 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111423, 2, '张黎明1', 'e10adc3949ba59abbe56e057f20f883e', '男', 33, '广东省,广州市,天河区', 4,
'zhangliming@qq.com', '18979994478', '广东珠海', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111424, 2, '薛磊1', 'e10adc3949ba59abbe56e057f20f883e', '男', 17, '广东省,广州市,天河区', 12,
'xuelei@qq.com', '15648887741', '西安市雁塔区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111425, 2, '张洁1', 'e10adc3949ba59abbe56e057f20f883e', '女', 19, '广东省,广州市,天河区', 2,
'zhangjie@qq.com', '13695557742', '海口市美兰区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111426, 2, '王涛2', 'e10adc3949ba59abbe56e057f20f883e', '男', 23, '广东省,广州市,天河区', 11, 'wang@qq.com',
'15644442252', '陕西西安新城区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111427, 2, '陈静2', 'e10adc3949ba59abbe56e057f20f883e', '女', 46, '广东省,广州市,天河区', 8,
'chenjing@qq.com', '18795556693', '海南省海口市美兰区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111428, 2, '赵琳浩2', 'e10adc3949ba59abbe56e057f20f883e', '男', 29, '广东省,广州市,天河区', 11,
'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111429, 2, '鹿存亮2', 'e10adc3949ba59abbe56e057f20f883e', '男', 11, '广东省,广州市,天河区', 10,
'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111430, 2, '姚森2', 'e10adc3949ba59abbe56e057f20f883e', '男', 4, '广东省,广州市,天河区', 2, 'yaosen@qq.com',
'14785559936', '河南洛阳人民大道58号', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111431, 2, '云星2', 'e10adc3949ba59abbe56e057f20f883e', '女', 15, '广东省,广州市,天河区', 2,
'yunxing@qq.com', '15644442252', '陕西西安新城区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111432, 2, '贾旭明2', 'e10adc3949ba59abbe56e057f20f883e', '男', 27, '广东省,广州市,天河区', 3,
'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13',
NULL, 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111433, 2, '张黎明2', 'e10adc3949ba59abbe56e057f20f883e', '男', 27, '广东省,广州市,天河区', 11,
'zhangliming@qq.com', '18979994478', '广东珠海', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111434, 2, '薛磊2', 'e10adc3949ba59abbe56e057f20f883e', '男', 29, '广东省,广州市,天河区', 3,
'xuelei@qq.com', '15648887741', '西安市雁塔区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111435, 2, '张洁2', 'e10adc3949ba59abbe56e057f20f883e', '女', 22, '广东省,广州市,天河区', 5,
'zhangjie@qq.com', '13695557742', '海口市美兰区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111436, 2, '王涛3', 'e10adc3949ba59abbe56e057f20f883e', '男', 32, '广东省,广州市,天河区', 11, 'wang@qq.com',
'15644442252', '陕西西安新城区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111437, 2, '陈静3', 'e10adc3949ba59abbe56e057f20f883e', '女', 16, '广东省,广州市,天河区', 13,
'chenjing@qq.com', '18795556693', '海南省海口市美兰区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111438, 2, '赵琳浩3', 'e10adc3949ba59abbe56e057f20f883e', '男', 54, '广东省,广州市,天河区', 13,
'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111439, 2, '鹿存亮3', 'e10adc3949ba59abbe56e057f20f883e', '男', 38, '广东省,广州市,天河区', 9,
'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111440, 2, '姚森3', 'e10adc3949ba59abbe56e057f20f883e', '男', 9, '广东省,广州市,天河区', 12,
'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111441, 2, '云星3', 'e10adc3949ba59abbe56e057f20f883e', '女', 42, '广东省,广州市,天河区', 3,
'yunxing@qq.com', '15644442252', '陕西西安新城区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111442, 2, '贾旭明3', 'e10adc3949ba59abbe56e057f20f883e', '男', 29, '广东省,广州市,天河区', 2,
'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13',
NULL, 'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111443, 2, '张黎明3', 'e10adc3949ba59abbe56e057f20f883e', '男', 56, '广东省,广州市,天河区', 9,
'zhangliming@qq.com', '18979994478', '广东珠海', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111444, 2, '薛磊3', 'e10adc3949ba59abbe56e057f20f883e', '男', 2, '广东省,广州市,天河区', 5, 'xuelei@qq.com',
'15648887741', '西安市雁塔区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111445, 2, '张洁3', 'e10adc3949ba59abbe56e057f20f883e', '女', 32, '广东省,广州市,天河区', 12,
'zhangjie@qq.com', '13695557742', '海口市美兰区', 11, '2020-07-23 20:04:49', '2020-12-14 22:41:13', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111446, 2, '薛磊33', 'e10adc3949ba59abbe56e057f20f883e', '男', 2, '广东省,广州市,天河区', 5,
'xuelei@qq.com', '15648887741', '西安市雁塔区', 11, '2021-04-23 15:27:29', '2021-04-23 15:27:29', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111447, 2, '张洁33', 'e10adc3949ba59abbe56e057f20f883e', '女', 32, '广东省,广州市,天河区', 12,
'zhangjie@qq.com', '13695557742', '海口市美兰区', 11, '2021-04-23 15:27:29', '2021-04-23 15:27:29', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111448, 2, '张黎明33', 'e10adc3949ba59abbe56e057f20f883e', '男', 40, '广东省,广州市,天河区', 12,
'zhangliming@qq.com', '18979994478', '广东珠海', 8, '2021-04-28 11:23:31', '2021-04-28 11:23:31', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111449, 2, '薛磊33', 'e10adc3949ba59abbe56e057f20f883e', '男', 5, '广东省,广州市,天河区', 12,
'xuelei@qq.com', '15648887741', '西安市雁塔区', 9, '2021-04-28 11:23:32', '2021-04-28 11:23:32', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0),
(1724111450, 2, '张洁33', 'e10adc3949ba59abbe56e057f20f883e', '女', 11, '广东省,广州市,天河区', 4,
'zhangjie@qq.com', '13695557742', '海口市美兰区', 10, '2021-04-28 11:23:33', '2021-04-28 11:23:33', NULL,
'https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png', 0);
/*!40000 ALTER TABLE `student`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `upload`
--
DROP TABLE IF EXISTS `upload`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `upload`
(
`s_id` int NOT NULL COMMENT '学生编号',
`w_id` int NOT NULL COMMENT '作业编号',
`file_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件类型',
`file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名',
`size` bigint NOT NULL COMMENT '文件大小',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '上传时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`file_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件保存路径',
KEY `sId` (`s_id`) USING BTREE,
KEY `wId` (`w_id`) USING BTREE,
CONSTRAINT `upload_ibfk_1` FOREIGN KEY (`s_id`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `upload_ibfk_2` FOREIGN KEY (`w_id`) REFERENCES `work` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `upload`
--
LOCK TABLES `upload` WRITE;
/*!40000 ALTER TABLE `upload`
DISABLE KEYS */;
INSERT INTO `upload`
VALUES (1724111400, 3, 'image/jpeg', '1724111400_王涛_医保凭证.jpeg', 260561, '2021-04-28 10:47:50',
'2021-04-28 10:47:50', NULL);
/*!40000 ALTER TABLE `upload`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `work`
--
DROP TABLE IF EXISTS `work`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `work`
(
`id` int NOT NULL AUTO_INCREMENT,
`s_id` int NOT NULL COMMENT '发布者',
`edit_s_id` int DEFAULT NULL COMMENT '最近编辑者',
`remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作业名称',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`last_time` datetime NOT NULL COMMENT '最晚提交时间',
`extension_id` int NOT NULL DEFAULT '1' COMMENT '文件扩展名',
`file_name_format_enum` int NOT NULL COMMENT '文件名命名枚举',
PRIMARY KEY (`id`) USING BTREE,
KEY `id` (`id`) USING BTREE,
KEY `sId` (`s_id`) USING BTREE,
CONSTRAINT `work_ibfk_1` FOREIGN KEY (`s_id`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
AUTO_INCREMENT = 6
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `work`
--
LOCK TABLES `work` WRITE;
/*!40000 ALTER TABLE `work`
DISABLE KEYS */;
INSERT INTO `work`
VALUES (1, 1724111423, 1724111400, '数据库存储过程作业收集', 0, '数据库作业', '2020-10-17 22:19:37',
'2020-12-19 12:54:59', '2020-11-27 22:20:00', 5, 4),
(2, 1724111400, NULL, 'Java算法作业', 0, 'Java作业', '2020-12-19 12:54:35', '2020-12-19 12:54:35',
'2020-12-31 00:00:00', 10, 2),
(3, 1724111400, 1724111400, '请同学们将医保凭证上传到此处', 0, '医保凭证', '2020-12-19 12:58:38',
'2021-04-27 11:52:39', '2021-06-30 00:00:00', 11, 2),
(4, 1724111400, 1724111400, '测试', 1, 'test', '2021-04-20 23:30:06', '2021-04-21 10:04:16',
'2021-04-30 00:00:00', 11, 3),
(5, 1724111400, NULL, 'test', 1, 'test', '2021-04-28 10:51:48', '2021-04-28 11:42:16', '2021-05-28 00:00:00', 10,
2);
/*!40000 ALTER TABLE `work`
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'tclass'
--
/*!50003 DROP PROCEDURE IF EXISTS `addref` */;
/*!50003 SET @saved_cs_client = @@character_set_client */;
/*!50003 SET @saved_cs_results = @@character_set_results */;
/*!50003 SET @saved_col_connection = @@collation_connection */;
/*!50003 SET character_set_client = utf8mb4 */;
/*!50003 SET character_set_results = utf8mb4 */;
/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50003 SET @saved_sql_mode = @@sql_mode */;
/*!50003 SET sql_mode =
'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */;
DELIMITER ;;
CREATE
DEFINER = `teoan`@`%` PROCEDURE `addref`()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i <= 42
DO
INSERT INTO `tclass`.`stu_dep_ref`() VALUES ();
SET i = i + 1;
END WHILE;
END ;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */;
/*!50003 SET character_set_client = @saved_cs_client */;
/*!50003 SET character_set_results = @saved_cs_results */;
/*!50003 SET collation_connection = @saved_col_connection */;
/*!50003 DROP PROCEDURE IF EXISTS `addStudent` */;
/*!50003 SET @saved_cs_client = @@character_set_client */;
/*!50003 SET @saved_cs_results = @@character_set_results */;
/*!50003 SET @saved_col_connection = @@collation_connection */;
/*!50003 SET character_set_client = utf8mb4 */;
/*!50003 SET character_set_results = utf8mb4 */;
/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50003 SET @saved_sql_mode = @@sql_mode */;
/*!50003 SET sql_mode =
'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */;
DELIMITER ;;
CREATE
DEFINER = `teoan`@`%` PROCEDURE `addStudent`(num INT)
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i <= num
DO
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('王涛', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '广东广州',
ROUND((RAND() * 13)), 'wang@qq.com', '15644442252', '陕西西安新城区');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('陈静', i), 'e10adc3949ba59abbe56e057f20f883e', '女', ROUND((RAND() * 56)), '海南',
ROUND((RAND() * 13)), 'chenjing@qq.com', '18795556693', '海南省海口市美兰区');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('赵琳浩', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '陕西',
ROUND((RAND() * 13)), 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('鹿存亮', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '陕西',
ROUND((RAND() * 13)), 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('姚森', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '河南',
ROUND((RAND() * 13)), 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('云星', i), 'e10adc3949ba59abbe56e057f20f883e', '女', ROUND((RAND() * 56)), '陕西西安',
ROUND((RAND() * 13)), 'yunxing@qq.com', '15644442252', '陕西西安新城区');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('贾旭明', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '广东广州',
ROUND((RAND() * 13)), 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('张黎明', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '广东',
ROUND((RAND() * 13)), 'zhangliming@qq.com', '18979994478', '广东珠海');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('薛磊', i), 'e10adc3949ba59abbe56e057f20f883e', '男', ROUND((RAND() * 56)), '陕西西安',
ROUND((RAND() * 13)), 'xuelei@qq.com', '15648887741', '西安市雁塔区');
INSERT INTO student(roleId, name, password, gender, nationId, nativePlace, politicId, email, phone, address)
VALUES (2, CONCAT('张洁', i), 'e10adc3949ba59abbe56e057f20f883e', '女', ROUND((RAND() * 56)), '海南',
ROUND((RAND() * 13)), 'zhangjie@qq.com', '13695557742', '海口市美兰区');
SET i = i + 1;
END WHILE;
END ;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */;
/*!50003 SET character_set_client = @saved_cs_client */;
/*!50003 SET character_set_results = @saved_cs_results */;
/*!50003 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE = @OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE = @OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS = @OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT = @OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS = @OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION = @OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES = @OLD_SQL_NOTES */;
-- Dump completed on 2023-03-30 12:36:43
- 配置数据库链接信息如：
spring:
application:
name: teoan-ai-db-mcp
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/tclass?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true&serverTimezone=Asia/Shanghai&useSSL=false&allowPublicKeyRetrieval=true
username: root
password: teoan_pwd+-
- 启动项目，默认端口 8080
- 在大模型客户端中配置 mcp 服务，这里使用cherry-studio为例
mcpConfig.png mcpTool.png
- 对话测试
chat1.png chat2.png chat3.png chat4.png chat5.png
