• 计算机毕业设计 高校课程评价系统的设计与实现 Java实战项目 附源码+文档+视频讲解

    博主介绍：✌从事软件开发10年之余，专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌

    🍅文末获取源码联系🍅

    👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
    ————————————————

    计算机毕业设计题目《1000套》✌

    目录

    一.前言介绍

    二.功能设计

    三.功能截图

    四.数据库表结构设计

    五.关键代码

    六.论文目录参考

    七.源码获取

    一.前言介绍

    网络的广泛应用给生活带来了十分的便利。所以把高校课程评价管理与现在网络相结合，利用java技术建设高校课程评价系统，实现高校课程评价的信息化。则对于进一步提高高校课程评价管理发展，丰富高校课程评价管理经验能起到不少的促进作用。高校课程评价系统能够通过互联网得到广泛的、全面的宣传，让尽可能多的学生、教师和专家了解和熟知高校课程评价系统的便捷高效，不仅为学校提供了服务，而且也推广了自己，让更多的群众了解自己。对于高校课程评价而言，若拥有自己的系统，通过系统得到更好的管理，同时提升了形象。

    二.功能设计

     本系统设计的现状和趋势，从需求、结构、数据库等方面的设计到系统的实现，分别为管理员、学生、专家和教师的实现。论文的内容从系统的设计、描述、实现、分析、测试方面来表明开发的过程。本系统根据现实情况来选择一种可行的开发方案，借助java编程语言和MySQL数据库等实现系统的全部功能，接下来对系统进行测试，测试系统是否有漏洞和测试用户权限来完善系统，最终系统完成达到相关标准。

     

    三.功能截图 

     

     

     

     

    四.数据库表结构设计

    1. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmnc4nx` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
    2.  
    3. USE `ssmnc4nx`;
    4.  
    5. --
    6. -- Table structure for table `banji`
    7. --
    8.  
    9. DROP TABLE IF EXISTS `banji`;
    10. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    11. /*!40101 SET character_set_client = utf8 */;
    12. CREATE TABLE `banji` (
    13.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    14.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    15.   `banji` varchar(200) NOT NULL COMMENT '班级',
    16.   PRIMARY KEY (`id`),
    17.   UNIQUE KEY `banji` (`banji`)
    18. ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='班级';
    19. /*!40101 SET character_set_client = @saved_cs_client */;
    20.  
    21. --
    22. -- Dumping data for table `banji`
    23. --
    24.  
    25. LOCK TABLES `banji` WRITE;
    26. /*!40000 ALTER TABLE `banji` DISABLE KEYS */;
    27. INSERT INTO `banji` VALUES (51,'2022-03-28 11:34:08','班级1'),(52,'2022-03-28 11:34:08','班级2'),(53,'2022-03-28 11:34:08','班级3'),(54,'2022-03-28 11:34:08','班级4'),(55,'2022-03-28 11:34:08','班级5'),(56,'2022-03-28 11:34:08','班级6');
    28. /*!40000 ALTER TABLE `banji` ENABLE KEYS */;
    29. UNLOCK TABLES;
    30.  
    31. --
    32. -- Table structure for table `config`
    33. --
    34.  
    35. DROP TABLE IF EXISTS `config`;
    36. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    37. /*!40101 SET character_set_client = utf8 */;
    38. CREATE TABLE `config` (
    39.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    40.   `name` varchar(100) NOT NULL COMMENT '配置参数名称',
    41.   `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
    42.   PRIMARY KEY (`id`)
    43. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
    44. /*!40101 SET character_set_client = @saved_cs_client */;
    45.  
    46. --
    47. -- Dumping data for table `config`
    48. --
    49.  
    50. LOCK TABLES `config` WRITE;
    51. /*!40000 ALTER TABLE `config` DISABLE KEYS */;
    52. INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
    53. /*!40000 ALTER TABLE `config` ENABLE KEYS */;
    54. UNLOCK TABLES;
    55.  
    56. --
    57. -- Table structure for table `jiaoshi`
    58. --
    59.  
    60. DROP TABLE IF EXISTS `jiaoshi`;
    61. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    62. /*!40101 SET character_set_client = utf8 */;
    63. CREATE TABLE `jiaoshi` (
    64.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    65.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    66.   `jiaoshigonghao` varchar(200) NOT NULL COMMENT '教师工号',
    67.   `mima` varchar(200) NOT NULL COMMENT '密码',
    68.   `jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',
    69.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    70.   `yuanxi` varchar(200) DEFAULT NULL COMMENT '院系',
    71.   `zhuanye` varchar(200) NOT NULL COMMENT '专业',
    72.   `zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',
    73.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    74.   `jiaoshiyouxiang` varchar(200) DEFAULT NULL COMMENT '教师邮箱',
    75.   PRIMARY KEY (`id`),
    76.   UNIQUE KEY `jiaoshigonghao` (`jiaoshigonghao`)
    77. ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='教师';
    78. /*!40101 SET character_set_client = @saved_cs_client */;
    79.  
    80. --
    81. -- Dumping data for table `jiaoshi`
    82. --
    83.  
    84. LOCK TABLES `jiaoshi` WRITE;
    85. /*!40000 ALTER TABLE `jiaoshi` DISABLE KEYS */;
    86. INSERT INTO `jiaoshi` VALUES (61,'2022-03-28 11:34:08','教师工号1','123456','教师姓名1','男','院系1','专业1','职称1','13823888881','773890001@qq.com'),(62,'2022-03-28 11:34:08','教师工号2','123456','教师姓名2','男','院系2','专业2','职称2','13823888882','773890002@qq.com'),(63,'2022-03-28 11:34:08','教师工号3','123456','教师姓名3','男','院系3','专业3','职称3','13823888883','773890003@qq.com'),(64,'2022-03-28 11:34:08','教师工号4','123456','教师姓名4','男','院系4','专业4','职称4','13823888884','773890004@qq.com'),(65,'2022-03-28 11:34:08','教师工号5','123456','教师姓名5','男','院系5','专业5','职称5','13823888885','773890005@qq.com'),(66,'2022-03-28 11:34:08','教师工号6','123456','教师姓名6','男','院系6','专业6','职称6','13823888886','773890006@qq.com');
    87. /*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
    88. UNLOCK TABLES;
    89.  
    90. --
    91. -- Table structure for table `jiaoshiziping`
    92. --
    93.  
    94. DROP TABLE IF EXISTS `jiaoshiziping`;
    95. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    96. /*!40101 SET character_set_client = utf8 */;
    97. CREATE TABLE `jiaoshiziping` (
    98.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    99.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    100.   `kecheng` varchar(200) DEFAULT NULL COMMENT '课程',
    101.   `quweixing` varchar(200) NOT NULL COMMENT '趣味性',
    102.   `hudongxing` varchar(200) NOT NULL COMMENT '互动性',
    103.   `kechengpingfen` int(11) NOT NULL COMMENT '课程评分',
    104.   `zongtipingjia` varchar(200) NOT NULL COMMENT '总体评价',
    105.   `pingjianeirong` longtext COMMENT '评价内容',
    106.   `pingjiariqi` date DEFAULT NULL COMMENT '评价日期',
    107.   `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
    108.   `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
    109.   `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
    110.   PRIMARY KEY (`id`)
    111. ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='教师自评';
    112. /*!40101 SET character_set_client = @saved_cs_client */;
    113.  
    114. --
    115. -- Dumping data for table `jiaoshiziping`
    116. --
    117.  
    118. LOCK TABLES `jiaoshiziping` WRITE;
    119. /*!40000 ALTER TABLE `jiaoshiziping` DISABLE KEYS */;
    120. INSERT INTO `jiaoshiziping` VALUES (101,'2022-03-28 11:34:08','课程1','1','1',1,'优秀','评价内容1','2022-03-28','教师工号1',1,1),(102,'2022-03-28 11:34:08','课程2','1','1',2,'优秀','评价内容2','2022-03-28','教师工号2',2,2),(103,'2022-03-28 11:34:08','课程3','1','1',3,'优秀','评价内容3','2022-03-28','教师工号3',3,3),(104,'2022-03-28 11:34:08','课程4','1','1',4,'优秀','评价内容4','2022-03-28','教师工号4',4,4),(105,'2022-03-28 11:34:08','课程5','1','1',5,'优秀','评价内容5','2022-03-28','教师工号5',5,5),(106,'2022-03-28 11:34:08','课程6','1','1',6,'优秀','评价内容6','2022-03-28','教师工号6',6,6);
    121. /*!40000 ALTER TABLE `jiaoshiziping` ENABLE KEYS */;
    122. UNLOCK TABLES;
    123.  
    124. --
    125. -- Table structure for table `kecheng`
    126. --
    127.  
    128. DROP TABLE IF EXISTS `kecheng`;
    129. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    130. /*!40101 SET character_set_client = utf8 */;
    131. CREATE TABLE `kecheng` (
    132.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    133.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    134.   `kecheng` varchar(200) NOT NULL COMMENT '课程',
    135.   PRIMARY KEY (`id`),
    136.   UNIQUE KEY `kecheng` (`kecheng`)
    137. ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='课程';
    138. /*!40101 SET character_set_client = @saved_cs_client */;
    139.  
    140. --
    141. -- Dumping data for table `kecheng`
    142. --
    143.  
    144. LOCK TABLES `kecheng` WRITE;
    145. /*!40000 ALTER TABLE `kecheng` DISABLE KEYS */;
    146. INSERT INTO `kecheng` VALUES (21,'2022-03-28 11:34:08','课程1'),(22,'2022-03-28 11:34:08','课程2'),(23,'2022-03-28 11:34:08','课程3'),(24,'2022-03-28 11:34:08','课程4'),(25,'2022-03-28 11:34:08','课程5'),(26,'2022-03-28 11:34:08','课程6');
    147. /*!40000 ALTER TABLE `kecheng` ENABLE KEYS */;
    148. UNLOCK TABLES;
    149.  
    150. --
    151. -- Table structure for table `kechengxinxi`
    152. --
    153.  
    154. DROP TABLE IF EXISTS `kechengxinxi`;
    155. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    156. /*!40101 SET character_set_client = utf8 */;
    157. CREATE TABLE `kechengxinxi` (
    158.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    159.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    160.   `mingcheng` varchar(200) NOT NULL COMMENT '名称',
    161.   `kecheng` varchar(200) DEFAULT NULL COMMENT '课程',
    162.   `banji` varchar(200) DEFAULT NULL COMMENT '班级',
    163.   `kechengtupian` varchar(200) DEFAULT NULL COMMENT '课程图片',
    164.   `jiaoxuedagang` varchar(200) DEFAULT NULL COMMENT '教学大纲',
    165.   `kechengjindu` varchar(200) DEFAULT NULL COMMENT '课程进度',
    166.   `kechengshipin` varchar(200) DEFAULT NULL COMMENT '课程视频',
    167.   `kechengxiangqing` longtext COMMENT '课程详情',
    168.   `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
    169.   `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
    170.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    171.   PRIMARY KEY (`id`)
    172. ) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='课程信息';
    173. /*!40101 SET character_set_client = @saved_cs_client */;
    174.  
    175. --
    176. -- Dumping data for table `kechengxinxi`
    177. --
    178.  
    179. LOCK TABLES `kechengxinxi` WRITE;
    180. /*!40000 ALTER TABLE `kechengxinxi` DISABLE KEYS */;
    181. INSERT INTO `kechengxinxi` VALUES (91,'2022-03-28 11:34:08','名称1','课程1','班级1','upload/kechengxinxi_kechengtupian1.jpg','教学大纲1','进行中','','课程详情1','教师工号1','教师姓名1','13823888881'),(92,'2022-03-28 11:34:08','名称2','课程2','班级2','upload/kechengxinxi_kechengtupian2.jpg','教学大纲2','进行中','','课程详情2','教师工号2','教师姓名2','13823888882'),(93,'2022-03-28 11:34:08','名称3','课程3','班级3','upload/kechengxinxi_kechengtupian3.jpg','教学大纲3','进行中','','课程详情3','教师工号3','教师姓名3','13823888883'),(94,'2022-03-28 11:34:08','名称4','课程4','班级4','upload/kechengxinxi_kechengtupian4.jpg','教学大纲4','进行中','','课程详情4','教师工号4','教师姓名4','13823888884'),(95,'2022-03-28 11:34:08','名称5','课程5','班级5','upload/kechengxinxi_kechengtupian5.jpg','教学大纲5','进行中','','课程详情5','教师工号5','教师姓名5','13823888885'),(96,'2022-03-28 11:34:08','名称6','课程6','班级6','upload/kechengxinxi_kechengtupian6.jpg','教学大纲6','进行中','','课程详情6','教师工号6','教师姓名6','13823888886');
    182. /*!40000 ALTER TABLE `kechengxinxi` ENABLE KEYS */;
    183. UNLOCK TABLES;
    184.  
    185. --
    186. -- Table structure for table `token`
    187. --
    188.  
    189. DROP TABLE IF EXISTS `token`;
    190. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    191. /*!40101 SET character_set_client = utf8 */;
    192. CREATE TABLE `token` (
    193.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    194.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    195.   `username` varchar(100) NOT NULL COMMENT '用户名',
    196.   `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
    197.   `role` varchar(100) DEFAULT NULL COMMENT '角色',
    198.   `token` varchar(200) NOT NULL COMMENT '密码',
    199.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    200.   `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
    201.   PRIMARY KEY (`id`)
    202. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='token表';
    203. /*!40101 SET character_set_client = @saved_cs_client */;
    204.  
    205. --
    206. -- Dumping data for table `token`
    207. --
    208.  
    209. LOCK TABLES `token` WRITE;
    210. /*!40000 ALTER TABLE `token` DISABLE KEYS */;
    211. INSERT INTO `token` VALUES (1,61,'教师工号1','jiaoshi','管理员','vpmgcrg9serfzovx026ga0ovj86o5kox','2022-03-28 11:37:49','2022-03-28 12:37:50');
    212. /*!40000 ALTER TABLE `token` ENABLE KEYS */;
    213. UNLOCK TABLES;
    214.  
    215. --
    216. -- Table structure for table `users`
    217. --
    218.  
    219. DROP TABLE IF EXISTS `users`;
    220. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    221. /*!40101 SET character_set_client = utf8 */;
    222. CREATE TABLE `users` (
    223.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    224.   `username` varchar(100) NOT NULL COMMENT '用户名',
    225.   `password` varchar(100) NOT NULL COMMENT '密码',
    226.   `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
    227.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    228.   PRIMARY KEY (`id`)
    229. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
    230. /*!40101 SET character_set_client = @saved_cs_client */;
    231.  
    232. --
    233. -- Dumping data for table `users`
    234. --
    235.  
    236. LOCK TABLES `users` WRITE;
    237. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
    238. INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-03-28 11:34:08');
    239. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
    240. UNLOCK TABLES;
    241.  
    242. --
    243. -- Table structure for table `xuesheng`
    244. --
    245.  
    246. DROP TABLE IF EXISTS `xuesheng`;
    247. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    248. /*!40101 SET character_set_client = utf8 */;
    249. CREATE TABLE `xuesheng` (
    250.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    251.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    252.   `xuehao` varchar(200) NOT NULL COMMENT '学号',
    253.   `mima` varchar(200) NOT NULL COMMENT '密码',
    254.   `xingming` varchar(200) NOT NULL COMMENT '姓名',
    255.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    256.   `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
    257.   `yuanxi` varchar(200) DEFAULT NULL COMMENT '院系',
    258.   `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
    259.   `banji` varchar(200) DEFAULT NULL COMMENT '班级',
    260.   `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
    261.   PRIMARY KEY (`id`),
    262.   UNIQUE KEY `xuehao` (`xuehao`)
    263. ) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='学生';
    264. /*!40101 SET character_set_client = @saved_cs_client */;
    265.  
    266. --
    267. -- Dumping data for table `xuesheng`
    268. --
    269.  
    270. LOCK TABLES `xuesheng` WRITE;
    271. /*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;
    272. INSERT INTO `xuesheng` VALUES (81,'2022-03-28 11:34:08','学号1','123456','姓名1','男','13823888881','院系1','专业1','班级1','773890001@qq.com'),(82,'2022-03-28 11:34:08','学号2','123456','姓名2','男','13823888882','院系2','专业2','班级2','773890002@qq.com'),(83,'2022-03-28 11:34:08','学号3','123456','姓名3','男','13823888883','院系3','专业3','班级3','773890003@qq.com'),(84,'2022-03-28 11:34:08','学号4','123456','姓名4','男','13823888884','院系4','专业4','班级4','773890004@qq.com'),(85,'2022-03-28 11:34:08','学号5','123456','姓名5','男','13823888885','院系5','专业5','班级5','773890005@qq.com'),(86,'2022-03-28 11:34:08','学号6','123456','姓名6','男','13823888886','院系6','专业6','班级6','773890006@qq.com');
    273. /*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;
    274. UNLOCK TABLES;
    275.  
    276. --
    277. -- Table structure for table `xueshengpingjia`
    278. --
    279.  
    280. DROP TABLE IF EXISTS `xueshengpingjia`;
    281. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    282. /*!40101 SET character_set_client = utf8 */;
    283. CREATE TABLE `xueshengpingjia` (
    284.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    285.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    286.   `kecheng` varchar(200) DEFAULT NULL COMMENT '课程',
    287.   `banji` varchar(200) DEFAULT NULL COMMENT '班级',
    288.   `jiaoxuenengli` varchar(200) NOT NULL COMMENT '教学能力',
    289.   `jiaoxuexiaoguo` varchar(200) NOT NULL COMMENT '教学效果',
    290.   `quweixing` varchar(200) NOT NULL COMMENT '趣味性',
    291.   `hudongxing` varchar(200) NOT NULL COMMENT '互动性',
    292.   `jiaoxuepingfen` int(11) NOT NULL COMMENT '教学评分',
    293.   `jiaoxuepingji` varchar(200) NOT NULL COMMENT '教学评级',
    294.   `jiaoxuepingjia` longtext COMMENT '教学评价',
    295.   `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
    296.   `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
    297.   `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
    298.   `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
    299.   `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
    300.   PRIMARY KEY (`id`)
    301. ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='学生评价';
    302. /*!40101 SET character_set_client = @saved_cs_client */;
    303.  
    304. --
    305. -- Dumping data for table `xueshengpingjia`
    306. --
    307.  
    308. LOCK TABLES `xueshengpingjia` WRITE;
    309. /*!40000 ALTER TABLE `xueshengpingjia` DISABLE KEYS */;
    310. INSERT INTO `xueshengpingjia` VALUES (121,'2022-03-28 11:34:08','课程1','班级1','1','1','1','1',1,'优秀','教学评价1','教师工号1','学号1','姓名1',1,1),(122,'2022-03-28 11:34:08','课程2','班级2','1','1','1','1',2,'优秀','教学评价2','教师工号2','学号2','姓名2',2,2),(123,'2022-03-28 11:34:08','课程3','班级3','1','1','1','1',3,'优秀','教学评价3','教师工号3','学号3','姓名3',3,3),(124,'2022-03-28 11:34:08','课程4','班级4','1','1','1','1',4,'优秀','教学评价4','教师工号4','学号4','姓名4',4,4),(125,'2022-03-28 11:34:08','课程5','班级5','1','1','1','1',5,'优秀','教学评价5','教师工号5','学号5','姓名5',5,5),(126,'2022-03-28 11:34:08','课程6','班级6','1','1','1','1',6,'优秀','教学评价6','教师工号6','学号6','姓名6',6,6);
    311. /*!40000 ALTER TABLE `xueshengpingjia` ENABLE KEYS */;
    312. UNLOCK TABLES;
    313.  
    314. --
    315. -- Table structure for table `yuanxi`
    316. --
    317.  
    318. DROP TABLE IF EXISTS `yuanxi`;
    319. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    320. /*!40101 SET character_set_client = utf8 */;
    321. CREATE TABLE `yuanxi` (
    322.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    323.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    324.   `yuanxi` varchar(200) NOT NULL COMMENT '院系',
    325.   PRIMARY KEY (`id`),
    326.   UNIQUE KEY `yuanxi` (`yuanxi`)
    327. ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='院系';
    328. /*!40101 SET character_set_client = @saved_cs_client */;
    329.  
    330. --
    331. -- Dumping data for table `yuanxi`
    332. --
    333.  
    334. LOCK TABLES `yuanxi` WRITE;
    335. /*!40000 ALTER TABLE `yuanxi` DISABLE KEYS */;
    336. INSERT INTO `yuanxi` VALUES (31,'2022-03-28 11:34:08','院系1'),(32,'2022-03-28 11:34:08','院系2'),(33,'2022-03-28 11:34:08','院系3'),(34,'2022-03-28 11:34:08','院系4'),(35,'2022-03-28 11:34:08','院系5'),(36,'2022-03-28 11:34:08','院系6');
    337. /*!40000 ALTER TABLE `yuanxi` ENABLE KEYS */;
    338. UNLOCK TABLES;
    339.  
    340. --
    341. -- Table structure for table `zhibiaoxinxi`
    342. --
    343.  
    344. DROP TABLE IF EXISTS `zhibiaoxinxi`;
    345. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    346. /*!40101 SET character_set_client = utf8 */;
    347. CREATE TABLE `zhibiaoxinxi` (
    348.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    349.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    350.   `zhibiaohao` varchar(200) DEFAULT NULL COMMENT '指标号',
    351.   `zhibiaomingcheng` varchar(200) DEFAULT NULL COMMENT '指标名称',
    352.   `zhibiaoquanzhong` varchar(200) DEFAULT NULL COMMENT '指标权重',
    353.   `zhibiaoneirong` longtext COMMENT '指标内容',
    354.   PRIMARY KEY (`id`),
    355.   UNIQUE KEY `zhibiaohao` (`zhibiaohao`)
    356. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='指标信息';
    357. /*!40101 SET character_set_client = @saved_cs_client */;
    358.  
    359. --
    360. -- Dumping data for table `zhibiaoxinxi`
    361. --
    362.  
    363. LOCK TABLES `zhibiaoxinxi` WRITE;
    364. /*!40000 ALTER TABLE `zhibiaoxinxi` DISABLE KEYS */;
    365. INSERT INTO `zhibiaoxinxi` VALUES (11,'2022-03-28 11:34:08','1111111111','指标名称1','指标权重1','指标内容1'),(12,'2022-03-28 11:34:08','2222222222','指标名称2','指标权重2','指标内容2'),(13,'2022-03-28 11:34:08','3333333333','指标名称3','指标权重3','指标内容3'),(14,'2022-03-28 11:34:08','4444444444','指标名称4','指标权重4','指标内容4'),(15,'2022-03-28 11:34:08','5555555555','指标名称5','指标权重5','指标内容5'),(16,'2022-03-28 11:34:08','6666666666','指标名称6','指标权重6','指标内容6');
    366. /*!40000 ALTER TABLE `zhibiaoxinxi` ENABLE KEYS */;
    367. UNLOCK TABLES;
    368.  
    369. --
    370. -- Table structure for table `zhuanjia`
    371. --
    372.  
    373. DROP TABLE IF EXISTS `zhuanjia`;
    374. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    375. /*!40101 SET character_set_client = utf8 */;
    376. CREATE TABLE `zhuanjia` (
    377.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    378.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    379.   `zhuanjiazhanghao` varchar(200) NOT NULL COMMENT '专家账号',
    380.   `mima` varchar(200) NOT NULL COMMENT '密码',
    381.   `zhuanjiaxingming` varchar(200) DEFAULT NULL COMMENT '专家姓名',
    382.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    383.   `zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',
    384.   `dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
    385.   PRIMARY KEY (`id`),
    386.   UNIQUE KEY `zhuanjiazhanghao` (`zhuanjiazhanghao`)
    387. ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='专家';
    388. /*!40101 SET character_set_client = @saved_cs_client */;
    389.  
    390. --
    391. -- Dumping data for table `zhuanjia`
    392. --
    393.  
    394. LOCK TABLES `zhuanjia` WRITE;
    395. /*!40000 ALTER TABLE `zhuanjia` DISABLE KEYS */;
    396. INSERT INTO `zhuanjia` VALUES (71,'2022-03-28 11:34:08','专家账号1','123456','专家姓名1','男','职称1','13823888881'),(72,'2022-03-28 11:34:08','专家账号2','123456','专家姓名2','男','职称2','13823888882'),(73,'2022-03-28 11:34:08','专家账号3','123456','专家姓名3','男','职称3','13823888883'),(74,'2022-03-28 11:34:08','专家账号4','123456','专家姓名4','男','职称4','13823888884'),(75,'2022-03-28 11:34:08','专家账号5','123456','专家姓名5','男','职称5','13823888885'),(76,'2022-03-28 11:34:08','专家账号6','123456','专家姓名6','男','职称6','13823888886');
    397. /*!40000 ALTER TABLE `zhuanjia` ENABLE KEYS */;
    398. UNLOCK TABLES;
    399.  
    400. --
    401. -- Table structure for table `zhuanjiapingjia`
    402. --
    403.  
    404. DROP TABLE IF EXISTS `zhuanjiapingjia`;
    405. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    406. /*!40101 SET character_set_client = utf8 */;
    407. CREATE TABLE `zhuanjiapingjia` (
    408.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    409.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    410.   `kecheng` varchar(200) DEFAULT NULL COMMENT '课程',
    411.   `jiaoxuenengli` varchar(200) NOT NULL COMMENT '教学能力',
    412.   `jiaoxuexiaoguo` varchar(200) NOT NULL COMMENT '教学效果',
    413.   `xueshengzhuangtai` varchar(200) NOT NULL COMMENT '学生状态',
    414.   `jiaoxuepingfen` int(11) NOT NULL COMMENT '教学评分',
    415.   `jiaoxuepingji` varchar(200) NOT NULL COMMENT '教学评级',
    416.   `pingjianeirong` longtext NOT NULL COMMENT '评价内容',
    417.   `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
    418.   `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
    419.   `pingjiariqi` date DEFAULT NULL COMMENT '评价日期',
    420.   `zhuanjiazhanghao` varchar(200) DEFAULT NULL COMMENT '专家账号',
    421.   `zhuanjiaxingming` varchar(200) DEFAULT NULL COMMENT '专家姓名',
    422.   `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
    423.   `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
    424.   PRIMARY KEY (`id`)
    425. ) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='专家评价';
    426. /*!40101 SET character_set_client = @saved_cs_client */;
    427.  
    428. --
    429. -- Dumping data for table `zhuanjiapingjia`
    430. --
    431.  
    432. LOCK TABLES `zhuanjiapingjia` WRITE;
    433. /*!40000 ALTER TABLE `zhuanjiapingjia` DISABLE KEYS */;
    434. INSERT INTO `zhuanjiapingjia` VALUES (111,'2022-03-28 11:34:08','课程1','1','1','1',1,'优秀','评价内容1','教师工号1','教师姓名1','2022-03-28','专家账号1','专家姓名1',1,1),(112,'2022-03-28 11:34:08','课程2','1','1','1',2,'优秀','评价内容2','教师工号2','教师姓名2','2022-03-28','专家账号2','专家姓名2',2,2),(113,'2022-03-28 11:34:08','课程3','1','1','1',3,'优秀','评价内容3','教师工号3','教师姓名3','2022-03-28','专家账号3','专家姓名3',3,3),(114,'2022-03-28 11:34:08','课程4','1','1','1',4,'优秀','评价内容4','教师工号4','教师姓名4','2022-03-28','专家账号4','专家姓名4',4,4),(115,'2022-03-28 11:34:08','课程5','1','1','1',5,'优秀','评价内容5','教师工号5','教师姓名5','2022-03-28','专家账号5','专家姓名5',5,5),(116,'2022-03-28 11:34:08','课程6','1','1','1',6,'优秀','评价内容6','教师工号6','教师姓名6','2022-03-28','专家账号6','专家姓名6',6,6);
    435. /*!40000 ALTER TABLE `zhuanjiapingjia` ENABLE KEYS */;
    436. UNLOCK TABLES;
    437.  
    438. --
    439. -- Table structure for table `zhuanye`
    440. --
    441.  
    442. DROP TABLE IF EXISTS `zhuanye`;
    443. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    444. /*!40101 SET character_set_client = utf8 */;
    445. CREATE TABLE `zhuanye` (
    446.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    447.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    448.   `zhuanye` varchar(200) NOT NULL COMMENT '专业',
    449.   PRIMARY KEY (`id`),
    450.   UNIQUE KEY `zhuanye` (`zhuanye`)
    451. ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='专业';
    452. /*!40101 SET character_set_client = @saved_cs_client */;
    453.  
    454. --
    455. -- Dumping data for table `zhuanye`
    456. --
    457.  
    458. LOCK TABLES `zhuanye` WRITE;
    459. /*!40000 ALTER TABLE `zhuanye` DISABLE KEYS */;
    460. INSERT INTO `zhuanye` VALUES (41,'2022-03-28 11:34:08','专业1'),(42,'2022-03-28 11:34:08','专业2'),(43,'2022-03-28 11:34:08','专业3'),(44,'2022-03-28 11:34:08','专业4'),(45,'2022-03-28 11:34:08','专业5'),(46,'2022-03-28 11:34:08','专业6');
    461. /*!40000 ALTER TABLE `zhuanye` ENABLE KEYS */;
    462. UNLOCK TABLES;
    463. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    464.  
    465. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    466. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    467. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    468. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    469. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    470. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    471. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    472.  
    473. -- Dump completed on 2022-03-28 21:20:45

    五.关键代码

    1. package com.controller;
    2.  
    3.  
    4. import java.util.Arrays;
    5. import java.util.Calendar;
    6. import java.util.Date;
    7. import java.util.Map;
    8.  
    9. import javax.servlet.http.HttpServletRequest;
    10.  
    11. import org.springframework.beans.factory.annotation.Autowired;
    12. import org.springframework.stereotype.Controller;
    13. import org.springframework.web.bind.annotation.GetMapping;
    14. import org.springframework.web.bind.annotation.PathVariable;
    15. import org.springframework.web.bind.annotation.PostMapping;
    16. import org.springframework.web.bind.annotation.RequestBody;
    17. import org.springframework.web.bind.annotation.RequestMapping;
    18. import org.springframework.web.bind.annotation.RequestParam;
    19. import org.springframework.web.bind.annotation.ResponseBody;
    20. import org.springframework.web.bind.annotation.RestController;
    21.  
    22. import com.annotation.IgnoreAuth;
    23. import com.baomidou.mybatisplus.mapper.EntityWrapper;
    24. import com.entity.TokenEntity;
    25. import com.entity.UserEntity;
    26. import com.service.TokenService;
    27. import com.service.UserService;
    28. import com.utils.CommonUtil;
    29. import com.utils.MD5Util;
    30. import com.utils.MPUtil;
    31. import com.utils.PageUtils;
    32. import com.utils.R;
    33. import com.utils.ValidatorUtils;
    34.  
    35. /**
    36.  * 登录相关
    37.  */
    38. @RequestMapping("users")
    39. @RestController
    40. public class UserController{
    41. 	
    42. 	@Autowired
    43. 	private UserService userService;
    44. 	
    45. 	@Autowired
    46. 	private TokenService tokenService;
    47.  
    48. 	/**
    49. 	 * 登录
    50. 	 */
    51. 	@IgnoreAuth
    52. 	@PostMapping(value = "/login")
    53. 	public R login(String username, String password, String captcha, HttpServletRequest request) {
    54. 		UserEntity user = userService.selectOne(new EntityWrapper().eq("username", username));
    55. 		if(user==null || !user.getPassword().equals(password)) {
    56. 			return R.error("账号或密码不正确");
    57. 		}
    58. 		String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());
    59. 		return R.ok().put("token", token);
    60. 	}
    61. 	
    62. 	/**
    63. 	 * 注册
    64. 	 */
    65. 	@IgnoreAuth
    66. 	@PostMapping(value = "/register")
    67. 	public R register(@RequestBody UserEntity user){
    68. //    	ValidatorUtils.validateEntity(user);
    69.     	if(userService.selectOne(new EntityWrapper().eq("username", user.getUsername())) !=null) {
    70.     		return R.error("用户已存在");
    71.     	}
    72.         userService.insert(user);
    73.         return R.ok();
    74.     }
    75.  
    76. 	/**
    77. 	 * 退出
    78. 	 */
    79. 	@GetMapping(value = "logout")
    80. 	public R logout(HttpServletRequest request) {
    81. 		request.getSession().invalidate();
    82. 		return R.ok("退出成功");
    83. 	}
    84. 	
    85. 	/**
    86.      * 密码重置
    87.      */
    88.     @IgnoreAuth
    89. 	@RequestMapping(value = "/resetPass")
    90.     public R resetPass(String username, HttpServletRequest request){
    91.     	UserEntity user = userService.selectOne(new EntityWrapper().eq("username", username));
    92.     	if(user==null) {
    93.     		return R.error("账号不存在");
    94.     	}
    95.     	user.setPassword("123456");
    96.         userService.update(user,null);
    97.         return R.ok("密码已重置为：123456");
    98.     }
    99. 	
    100. 	/**
    101.      * 列表
    102.      */
    103.     @RequestMapping("/page")
    104.     public R page(@RequestParam Map params,UserEntity user){
    105.         EntityWrapper ew = new EntityWrapper();
    106.     	PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));
    107.         return R.ok().put("data", page);
    108.     }
    109.  
    110. 	/**
    111.      * 列表
    112.      */
    113.     @RequestMapping("/list")
    114.     public R list( UserEntity user){
    115.        	EntityWrapper ew = new EntityWrapper();
    116.       	ew.allEq(MPUtil.allEQMapPre( user, "user")); 
    117.         return R.ok().put("data", userService.selectListView(ew));
    118.     }
    119.  
    120.     /**
    121.      * 信息
    122.      */
    123.     @RequestMapping("/info/{id}")
    124.     public R info(@PathVariable("id") String id){
    125.         UserEntity user = userService.selectById(id);
    126.         return R.ok().put("data", user);
    127.     }
    128.     
    129.     /**
    130.      * 获取用户的session用户信息
    131.      */
    132.     @RequestMapping("/session")
    133.     public R getCurrUser(HttpServletRequest request){
    134.     	Long id = (Long)request.getSession().getAttribute("userId");
    135.         UserEntity user = userService.selectById(id);
    136.         return R.ok().put("data", user);
    137.     }
    138.  
    139.     /**
    140.      * 保存
    141.      */
    142.     @PostMapping("/save")
    143.     public R save(@RequestBody UserEntity user){
    144. //    	ValidatorUtils.validateEntity(user);
    145.     	if(userService.selectOne(new EntityWrapper().eq("username", user.getUsername())) !=null) {
    146.     		return R.error("用户已存在");
    147.     	}
    148.         userService.insert(user);
    149.         return R.ok();
    150.     }
    151.  
    152.     /**
    153.      * 修改
    154.      */
    155.     @RequestMapping("/update")
    156.     public R update(@RequestBody UserEntity user){
    157. //        ValidatorUtils.validateEntity(user);
    158.     	UserEntity u = userService.selectOne(new EntityWrapper().eq("username", user.getUsername()));
    159.     	if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
    160.     		return R.error("用户名已存在。");
    161.     	}
    162.         userService.updateById(user);//全部更新
    163.         return R.ok();
    164.     }
    165.  
    166.     /**
    167.      * 删除
    168.      */
    169.     @RequestMapping("/delete")
    170.     public R delete(@RequestBody Long[] ids){
    171.         userService.deleteBatchIds(Arrays.asList(ids));
    172.         return R.ok();
    173.     }
    174. }

    六.论文目录参考

    七.源码获取

    感谢大家的阅读，如有不懂的问题可以评论区交流或私聊！

    喜欢文章可以点赞、收藏、关注、评论啦

    获取源码请私信

  • 相关阅读:
    JavaFx学习问题2--音频、视频播放失败情况
    淘宝/天猫api 获取淘宝商品详情高级版 API接口
    数据结构 | 算法的时间复杂度和空间复杂度【详解】
    flutter 手机卡住，需要等待，主线程被占用
    计算机网络-网络文件共享协议
    云链商城连锁门店新零售O20系统以零售商城
    牛客TOP101-BM51
    8c安装手册四
    BLE学习(1)：蓝牙协议栈的介绍
    C. 3SUM Closure
  • 原文地址：https://blog.csdn.net/qq_35219282/article/details/132841728