写在开头,首先我们学校是在12月初开题的,然后到了第二年的2月中旬,才开始着手写项目,因为我开题的题目是基于《SpringBoot的海滨校友管理系统的设计与实现》,所以这个是一个单体的SpringBoot项目。
这个项目已经完成了,一直没时间更新博客,然后项目可以开源给你。
第一天
第一天的安排是把数据库建好,把项目的框架搭好。
数据库文件我会放在网盘上,如果有跟着做的小伙伴可以评论一下我把链接放上,下边我把sql语句贴上大家自取就行
/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 80017
Source Host : localhost:3306
Source Schema : hbxiaoyou
Target Server Type : MySQL
Target Server Version : 80017
File Encoding : 65001
Date: 13/02/2021 15:35:31
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for tr_activity
-- ----------------------------
DROP TABLE IF EXISTS `tr_activity`;
CREATE TABLE `tr_activity` (
`ac_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '活动id',
`ac_title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动标题',
`ac_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动描述',
`ac_per` int(8) NULL DEFAULT NULL COMMENT '活动发起人',
`ac_create_time` datetime(0) NULL DEFAULT NULL COMMENT '活动创建时间',
`ac_start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动开始时间',
`ac_end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动结束时间',
`ac_count` int(255) NULL DEFAULT NULL COMMENT '报名人数',
`ac_status` int(8) NULL DEFAULT NULL COMMENT '审核状态:0未审核,1通过,2未通过',
`ac_opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见',
PRIMARY KEY (`ac_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_activity_join
-- ----------------------------
DROP TABLE IF EXISTS `tr_activity_join`;
CREATE TABLE `tr_activity_join` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`ac_id` int(8) NULL DEFAULT NULL COMMENT '活动id',
`user_id` int(8) NULL DEFAULT NULL COMMENT '参加活动的人员id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_around
-- ----------------------------
DROP TABLE IF EXISTS `tr_around`;
CREATE TABLE `tr_around` (
`around_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '周围食宿信息id',
`around_tittle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '周围食宿信息标题',
`around_content` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '周围食宿信息内容',
`around_user` int(8) NULL DEFAULT NULL COMMENT '发布的作者',
`around_time` datetime(0) NULL DEFAULT NULL COMMENT '发表时间',
PRIMARY KEY (`around_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_ass
-- ----------------------------
DROP TABLE IF EXISTS `tr_ass`;
CREATE TABLE `tr_ass` (
`ass_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '校友会ID',
`ass_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校友会名字',
`ass_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校友会简介',
`ass_per` int(8) NULL DEFAULT NULL COMMENT '校友会会长',
`ass_con` bigint(32) NULL DEFAULT NULL COMMENT '联系方式',
`ass_group` bigint(32) NULL DEFAULT NULL COMMENT '校友会交流群',
`ass_status` int(2) NULL DEFAULT NULL COMMENT '审核状态',
`ass_opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见',
`ass_createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ass_examinetime` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
PRIMARY KEY (`ass_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_assstu
-- ----------------------------
DROP TABLE IF EXISTS `tr_assstu`;
CREATE TABLE `tr_assstu` (
`tas_id` int(8) NOT NULL AUTO_INCREMENT,
`ass_id` int(8) NULL DEFAULT NULL COMMENT '校友会ID',
`user_id` int(8) NULL DEFAULT NULL COMMENT '校友ID',
PRIMARY KEY (`tas_id`) USING BTREE,
INDEX `asssid`(`ass_id`) USING BTREE,
INDEX `stuuid`(`user_id`) USING BTREE,
CONSTRAINT `asssid` FOREIGN KEY (`ass_id`) REFERENCES `tr_ass` (`ass_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `stuuid` FOREIGN KEY (`user_id`) REFERENCES `tr_stu` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_class
-- ----------------------------
DROP TABLE IF EXISTS `tr_class`;
CREATE TABLE `tr_class` (
`class_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '班级id',
`class_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级名称',
`admin_id` int(8) NULL DEFAULT NULL COMMENT '班级管理员id',
`spec_id` int(4) NULL DEFAULT NULL COMMENT '专业id',
PRIMARY KEY (`class_id`) USING BTREE,
INDEX `admin001`(`admin_id`) USING BTREE,
INDEX `spec001`(`spec_id`) USING BTREE,
CONSTRAINT `admin001` FOREIGN KEY (`admin_id`) REFERENCES `tr_stu` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `spec001` FOREIGN KEY (`spec_id`) REFERENCES `tr_spec` (`spec_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_comment
-- ----------------------------
DROP TABLE IF EXISTS `tr_comment`;
CREATE TABLE `tr_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`parent_id` int(11) NOT NULL COMMENT '父级或者文章评论id',
`type` int(11) NOT NULL COMMENT '评论类型',
`commentor` int(11) NULL DEFAULT NULL COMMENT '评论人',
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`like_count` int(11) NULL DEFAULT 0 COMMENT '点赞数',
`content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`commentcount` int(11) NULL DEFAULT 0 COMMENT '评论数量',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_depart
-- ----------------------------
DROP TABLE IF EXISTS `tr_depart`;
CREATE TABLE `tr_depart` (
`depart_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '院系id',
`depart_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '院系名字',
PRIMARY KEY (`depart_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_don
-- ----------------------------
DROP TABLE IF EXISTS `tr_don`;
CREATE TABLE `tr_don` (
`don_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '捐赠id',
`don_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '捐赠name',
`don_desc` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '捐赠描述',
`don_per` int(8) NULL DEFAULT NULL COMMENT '捐赠人id',
`don_status` int(8) NULL DEFAULT NULL COMMENT '状态',
`don_opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见',
`don_time` datetime(0) NULL DEFAULT NULL COMMENT '捐赠时间',
PRIMARY KEY (`don_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_don_money
-- ----------------------------
DROP TABLE IF EXISTS `tr_don_money`;
CREATE TABLE `tr_don_money` (
`mon_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '筹款id',
`mon_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目描述',
`mon_count` int(11) NULL DEFAULT NULL COMMENT '需要金额',
`mon_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`mon_per` int(255) NULL DEFAULT NULL COMMENT '项目发起人',
`mon_time` datetime(0) NULL DEFAULT NULL COMMENT '发起时间',
`mon_status` int(11) NULL DEFAULT NULL COMMENT '众筹状态',
`mon_had` int(11) NULL DEFAULT NULL COMMENT '已众筹金额',
PRIMARY KEY (`mon_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_img
-- ----------------------------
DROP TABLE IF EXISTS `tr_img`;
CREATE TABLE `tr_img` (
`img_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '图片id',
`img_name` varchar(360) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片name',
`img_url` varchar(360) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片url',
`img_state` int(2) NULL DEFAULT NULL COMMENT '启用状态',
`img_time` datetime(0) NULL DEFAULT NULL COMMENT '上传时间',
PRIMARY KEY (`img_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_job
-- ----------------------------
DROP TABLE IF EXISTS `tr_job`;
CREATE TABLE `tr_job` (
`job_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '职位id',
`job_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',
`job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位名称',
`job_desc` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位介绍',
`user_id` int(8) NULL DEFAULT NULL COMMENT '校友id',
`job_time` datetime(0) NULL DEFAULT NULL COMMENT '发布时间',
`per_count` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '招聘人数',
`job_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作地址',
`job_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投递地址',
`check_status` int(8) NULL DEFAULT NULL COMMENT '审核状态:0未审核,1已通过,2未通过',
`check_opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见',
PRIMARY KEY (`job_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_links
-- ----------------------------
DROP TABLE IF EXISTS `tr_links`;
CREATE TABLE `tr_links` (
`links_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '链接id',
`links_tittle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接标题',
`links_content` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接文案',
`links_user` int(8) NULL DEFAULT NULL COMMENT '文案作者作者',
`links_time` datetime(0) NULL DEFAULT NULL COMMENT '发表时间',
PRIMARY KEY (`links_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_map
-- ----------------------------
DROP TABLE IF EXISTS `tr_map`;
CREATE TABLE `tr_map` (
`map_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '校园地图id',
`map_tittle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校园地图标题',
`map_content` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校园地图内容',
`map_user` int(8) NULL DEFAULT NULL COMMENT '校园地图作者',
`map_time` datetime(0) NULL DEFAULT NULL COMMENT '发表时间',
PRIMARY KEY (`map_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_mon_stu
-- ----------------------------
DROP TABLE IF EXISTS `tr_mon_stu`;
CREATE TABLE `tr_mon_stu` (
`money_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '项目捐款id',
`user_id` int(11) NULL DEFAULT NULL COMMENT '项目捐款人id',
`money_count` int(11) NULL DEFAULT NULL COMMENT '项目捐款金额',
`money_time` datetime(0) NULL DEFAULT NULL COMMENT '捐款时间',
`mon_id` int(11) NULL DEFAULT NULL COMMENT '项目id',
`mon_status` int(11) NULL DEFAULT NULL COMMENT '审核状态',
`mon_type` int(11) NULL DEFAULT NULL COMMENT '支付方式',
PRIMARY KEY (`money_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_news
-- ----------------------------
DROP TABLE IF EXISTS `tr_news`;
CREATE TABLE `tr_news` (
`news_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '新闻id',
`news_tittle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新闻标题',
`news_content` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新闻内容',
`news_user` int(8) NULL DEFAULT NULL COMMENT '新闻作者',
`news_time` datetime(0) NULL DEFAULT NULL COMMENT '发表时间',
PRIMARY KEY (`news_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_notification
-- ----------------------------
DROP TABLE IF EXISTS `tr_notification`;
CREATE TABLE `tr_notification` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '通知id',
`notifier` int(11) NOT NULL COMMENT '通知者id',
`receiver` int(11) NOT NULL COMMENT '接收者id',
`outerid` int(11) NOT NULL,
`type` int(11) NOT NULL COMMENT '通知类型',
`createtime` datetime(0) NOT NULL COMMENT '时间',
`status` int(11) NOT NULL DEFAULT 0 COMMENT '已读or未读',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_propaganda
-- ----------------------------
DROP TABLE IF EXISTS `tr_propaganda`;
CREATE TABLE `tr_propaganda` (
`propa_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '宣传资料id',
`propa_tittle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宣传资料标题',
`propa_content` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宣传资料内容',
`propa_user` int(8) NULL DEFAULT NULL COMMENT '宣传资料作者',
`propa_time` datetime(0) NULL DEFAULT NULL COMMENT '发表时间',
PRIMARY KEY (`propa_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_question
-- ----------------------------
DROP TABLE IF EXISTS `tr_question`;
CREATE TABLE `tr_question` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帖子标题',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帖子描述',
`createid` int(11) NOT NULL COMMENT '发帖人id',
`comment_count` int(11) NOT NULL DEFAULT 0 COMMENT '评论数量',
`view_count` int(11) NOT NULL DEFAULT 0 COMMENT '浏览量',
`like_count` int(11) NOT NULL DEFAULT 0 COMMENT '喜欢数量',
`tag` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签',
`createtime` datetime(0) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_role
-- ----------------------------
DROP TABLE IF EXISTS `tr_role`;
CREATE TABLE `tr_role` (
`id` int(11) NOT NULL COMMENT '角色id',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_spec
-- ----------------------------
DROP TABLE IF EXISTS `tr_spec`;
CREATE TABLE `tr_spec` (
`spec_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '专业id',
`specname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业名称',
`depart_id` int(4) NULL DEFAULT NULL COMMENT '院系id',
PRIMARY KEY (`spec_id`) USING BTREE,
INDEX `depart`(`depart_id`) USING BTREE,
CONSTRAINT `depart` FOREIGN KEY (`depart_id`) REFERENCES `tr_depart` (`depart_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_stu
-- ----------------------------
DROP TABLE IF EXISTS `tr_stu`;
CREATE TABLE `tr_stu` (
`user_id` int(32) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`class_id` int(5) NULL DEFAULT NULL COMMENT '班级ID',
`depart_id` int(5) NULL DEFAULT NULL COMMENT '院系id',
`spec_id` int(5) NULL DEFAULT NULL COMMENT '专业id',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`stu_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
`is_admin` int(2) NULL DEFAULT NULL COMMENT '用户/管理员',
`mobile` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`job` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作',
`address` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tr_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tr_user_role`;
CREATE TABLE `tr_user_role` (
`user_id` int(11) NOT NULL COMMENT '用户id',
`role_id` int(11) NOT NULL COMMENT '角色id',
PRIMARY KEY (`user_id`) USING BTREE,
INDEX `fk_role_id`(`role_id`) USING BTREE,
CONSTRAINT `fk_role_id` FOREIGN KEY (`role_id`) REFERENCES `tr_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `tr_stu` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;
然后建好数据库截图就是这样,数据库名字可以和我一样也可以不一样
然后就是新建项目了
新建项目选择1.8jdk版本,点击下一步
Java的版本选择8就行,点下一步
选择相对应的依赖,点下一步
选择好项目的位置,点完成
然后就得到了一个父工程
然后再新建里边的子模块
然后步骤和新建项目一样