計算機課程設計SpringBoot在線心理咨詢系統【代碼講解+安裝除錯+檔案指導】

🍊作者：計算機編程-吉哥

🍊簡介：專業從事JavaWeb程式開發，微信小程式開發，定制化專案、原始碼、代碼講解、檔案撰寫、ppt制作，做自己喜歡的事，生活就是快樂的，

🍊心愿：點贊 👍 收藏 ?評論 📝

🍅 文末獲取原始碼聯系

技術選型

springboot、mybatis、maven、thymeleaf、html、mysql、tomcat8.5、jdk1.8

資料庫表結構

8張

開發工具：

idea、navicat

?功能：

• 登錄
• 首頁
• 文章
• 心理評測
• 留言
• 公告

🏆專案演示截圖：

資料庫表結構設計：

CREATE TABLE `sys_article`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章ID',
  `label` int(11) NULL DEFAULT NULL COMMENT '文章標簽',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '文章標題',
  `content` varchar(10000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '文章內容',
  `author` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '文章作者',
  `status` int(2) NULL DEFAULT NULL COMMENT '文章發布狀態',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '文章發布時間',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_label`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' 文章標簽id',
  `label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '文章標簽名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_leacot`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '留言ID',
  `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '留言內容',
  `leacots_time` datetime(0) NULL DEFAULT NULL COMMENT '留言時間',
  `leacots_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '留言用戶',
  `reply_id` int(11) NULL DEFAULT NULL COMMENT '關聯回復內容',
  `status` int(2) NULL DEFAULT NULL COMMENT '回復狀態',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_notice`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `title` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '公告標題',
  `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '公告內容',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '公告創建時間',
  `user_op` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '操作用戶',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_pgtest`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '評測ID',
  `pgtest_result` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '評測結果',
  `pgtest_score` int(5) NULL DEFAULT NULL COMMENT '評測分數',
  `pgtest_time` datetime(0) NULL DEFAULT NULL COMMENT '評測時間',
  `user_op` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '評測用戶',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_reply`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '回復ID',
  `reply_content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '回復內容',
  `reply_time` datetime(0) NULL DEFAULT NULL COMMENT '回復時間',
  `reply_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '回復用戶',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_topic`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '題目ID',
  ` topic_content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '題目內容',
  `refer_answer` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '題目參考答案',
  `topic_time` datetime(0) NULL DEFAULT NULL COMMENT '題目創建時間',
  `user_op` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '題目操作用戶',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

CREATE TABLE `sys_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶型別名',
  `tocheck` int(2) NULL DEFAULT NULL COMMENT '用戶型別',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

更多精彩文章欄目：計算機畢業設計專案

公眾號：IT躍遷谷【更多精彩文章】

↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓如果大家有任何疑慮，請在下方或昵稱位置詳細咨詢，