三亚网络网站建设,海外网络连接,网站备案完成通知书,软件开发流程管理系统博主介绍#xff1a;✌从事软件开发10年之余#xff0c;专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ #x1f345;文末获取源码联系#x1f345; #x1f447;#x1f3fb; 精… 博主介绍✌从事软件开发10年之余专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ 文末获取源码联系 精彩专栏推荐订阅 不然下次找不到哟 ———————————————— 计算机毕业设计题目《1000套》✌ 目录
一.前言介绍
二.功能设计
三.功能截图
四.数据库表结构设计
五.关键代码
六.论文目录参考
七.源码获取 一.前言介绍 网络的广泛应用给生活带来了十分的便利。所以把高校课程评价管理与现在网络相结合利用java技术建设高校课程评价系统实现高校课程评价的信息化。则对于进一步提高高校课程评价管理发展丰富高校课程评价管理经验能起到不少的促进作用。高校课程评价系统能够通过互联网得到广泛的、全面的宣传让尽可能多的学生、教师和专家了解和熟知高校课程评价系统的便捷高效不仅为学校提供了服务而且也推广了自己让更多的群众了解自己。对于高校课程评价而言若拥有自己的系统通过系统得到更好的管理同时提升了形象。 二.功能设计 本系统设计的现状和趋势从需求、结构、数据库等方面的设计到系统的实现分别为管理员、学生、专家和教师的实现。论文的内容从系统的设计、描述、实现、分析、测试方面来表明开发的过程。本系统根据现实情况来选择一种可行的开发方案借助java编程语言和MySQL数据库等实现系统的全部功能接下来对系统进行测试测试系统是否有漏洞和测试用户权限来完善系统最终系统完成达到相关标准。 三.功能截图 四.数据库表结构设计 CREATE DATABASE /*!32312 IF NOT EXISTS*/ ssmnc4nx /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE ssmnc4nx;--
-- Table structure for table banji
--DROP TABLE IF EXISTS banji;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE banji (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,banji varchar(200) NOT NULL COMMENT 班级,PRIMARY KEY (id),UNIQUE KEY banji (banji)
) ENGINEInnoDB AUTO_INCREMENT57 DEFAULT CHARSETutf8 COMMENT班级;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table banji
--LOCK TABLES banji WRITE;
/*!40000 ALTER TABLE banji DISABLE KEYS */;
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);
/*!40000 ALTER TABLE banji ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table config
--DROP TABLE IF EXISTS config;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE config (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,name varchar(100) NOT NULL COMMENT 配置参数名称,value varchar(100) DEFAULT NULL COMMENT 配置参数值,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT配置文件;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table config
--LOCK TABLES config WRITE;
/*!40000 ALTER TABLE config DISABLE KEYS */;
INSERT INTO config VALUES (1,picture1,upload/picture1.jpg),(2,picture2,upload/picture2.jpg),(3,picture3,upload/picture3.jpg);
/*!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table jiaoshi
--DROP TABLE IF EXISTS jiaoshi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE jiaoshi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,jiaoshigonghao varchar(200) NOT NULL COMMENT 教师工号,mima varchar(200) NOT NULL COMMENT 密码,jiaoshixingming varchar(200) NOT NULL COMMENT 教师姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,yuanxi varchar(200) DEFAULT NULL COMMENT 院系,zhuanye varchar(200) NOT NULL COMMENT 专业,zhicheng varchar(200) DEFAULT NULL COMMENT 职称,lianxidianhua varchar(200) DEFAULT NULL COMMENT 联系电话,jiaoshiyouxiang varchar(200) DEFAULT NULL COMMENT 教师邮箱,PRIMARY KEY (id),UNIQUE KEY jiaoshigonghao (jiaoshigonghao)
) ENGINEInnoDB AUTO_INCREMENT67 DEFAULT CHARSETutf8 COMMENT教师;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table jiaoshi
--LOCK TABLES jiaoshi WRITE;
/*!40000 ALTER TABLE jiaoshi DISABLE KEYS */;
INSERT INTO jiaoshi VALUES (61,2022-03-28 11:34:08,教师工号1,123456,教师姓名1,男,院系1,专业1,职称1,13823888881,773890001qq.com),(62,2022-03-28 11:34:08,教师工号2,123456,教师姓名2,男,院系2,专业2,职称2,13823888882,773890002qq.com),(63,2022-03-28 11:34:08,教师工号3,123456,教师姓名3,男,院系3,专业3,职称3,13823888883,773890003qq.com),(64,2022-03-28 11:34:08,教师工号4,123456,教师姓名4,男,院系4,专业4,职称4,13823888884,773890004qq.com),(65,2022-03-28 11:34:08,教师工号5,123456,教师姓名5,男,院系5,专业5,职称5,13823888885,773890005qq.com),(66,2022-03-28 11:34:08,教师工号6,123456,教师姓名6,男,院系6,专业6,职称6,13823888886,773890006qq.com);
/*!40000 ALTER TABLE jiaoshi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table jiaoshiziping
--DROP TABLE IF EXISTS jiaoshiziping;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE jiaoshiziping (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,kecheng varchar(200) DEFAULT NULL COMMENT 课程,quweixing varchar(200) NOT NULL COMMENT 趣味性,hudongxing varchar(200) NOT NULL COMMENT 互动性,kechengpingfen int(11) NOT NULL COMMENT 课程评分,zongtipingjia varchar(200) NOT NULL COMMENT 总体评价,pingjianeirong longtext COMMENT 评价内容,pingjiariqi date DEFAULT NULL COMMENT 评价日期,jiaoshigonghao varchar(200) DEFAULT NULL COMMENT 教师工号,crossuserid bigint(20) DEFAULT NULL COMMENT 跨表用户id,crossrefid bigint(20) DEFAULT NULL COMMENT 跨表主键id,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT107 DEFAULT CHARSETutf8 COMMENT教师自评;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table jiaoshiziping
--LOCK TABLES jiaoshiziping WRITE;
/*!40000 ALTER TABLE jiaoshiziping DISABLE KEYS */;
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);
/*!40000 ALTER TABLE jiaoshiziping ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table kecheng
--DROP TABLE IF EXISTS kecheng;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE kecheng (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,kecheng varchar(200) NOT NULL COMMENT 课程,PRIMARY KEY (id),UNIQUE KEY kecheng (kecheng)
) ENGINEInnoDB AUTO_INCREMENT27 DEFAULT CHARSETutf8 COMMENT课程;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table kecheng
--LOCK TABLES kecheng WRITE;
/*!40000 ALTER TABLE kecheng DISABLE KEYS */;
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);
/*!40000 ALTER TABLE kecheng ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table kechengxinxi
--DROP TABLE IF EXISTS kechengxinxi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE kechengxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,mingcheng varchar(200) NOT NULL COMMENT 名称,kecheng varchar(200) DEFAULT NULL COMMENT 课程,banji varchar(200) DEFAULT NULL COMMENT 班级,kechengtupian varchar(200) DEFAULT NULL COMMENT 课程图片,jiaoxuedagang varchar(200) DEFAULT NULL COMMENT 教学大纲,kechengjindu varchar(200) DEFAULT NULL COMMENT 课程进度,kechengshipin varchar(200) DEFAULT NULL COMMENT 课程视频,kechengxiangqing longtext COMMENT 课程详情,jiaoshigonghao varchar(200) DEFAULT NULL COMMENT 教师工号,jiaoshixingming varchar(200) DEFAULT NULL COMMENT 教师姓名,lianxidianhua varchar(200) DEFAULT NULL COMMENT 联系电话,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT97 DEFAULT CHARSETutf8 COMMENT课程信息;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table kechengxinxi
--LOCK TABLES kechengxinxi WRITE;
/*!40000 ALTER TABLE kechengxinxi DISABLE KEYS */;
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);
/*!40000 ALTER TABLE kechengxinxi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table token
--DROP TABLE IF EXISTS token;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE token (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,userid bigint(20) NOT NULL COMMENT 用户id,username varchar(100) NOT NULL COMMENT 用户名,tablename varchar(100) DEFAULT NULL COMMENT 表名,role varchar(100) DEFAULT NULL COMMENT 角色,token varchar(200) NOT NULL COMMENT 密码,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,expiratedtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 过期时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENTtoken表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table token
--LOCK TABLES token WRITE;
/*!40000 ALTER TABLE token DISABLE KEYS */;
INSERT INTO token VALUES (1,61,教师工号1,jiaoshi,管理员,vpmgcrg9serfzovx026ga0ovj86o5kox,2022-03-28 11:37:49,2022-03-28 12:37:50);
/*!40000 ALTER TABLE token ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table users
--DROP TABLE IF EXISTS users;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE users (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(100) NOT NULL COMMENT 用户名,password varchar(100) NOT NULL COMMENT 密码,role varchar(100) DEFAULT 管理员 COMMENT 角色,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT用户表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table users
--LOCK TABLES users WRITE;
/*!40000 ALTER TABLE users DISABLE KEYS */;
INSERT INTO users VALUES (1,abo,abo,管理员,2022-03-28 11:34:08);
/*!40000 ALTER TABLE users ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table xuesheng
--DROP TABLE IF EXISTS xuesheng;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE xuesheng (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,xuehao varchar(200) NOT NULL COMMENT 学号,mima varchar(200) NOT NULL COMMENT 密码,xingming varchar(200) NOT NULL COMMENT 姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,shouji varchar(200) DEFAULT NULL COMMENT 手机,yuanxi varchar(200) DEFAULT NULL COMMENT 院系,zhuanye varchar(200) DEFAULT NULL COMMENT 专业,banji varchar(200) DEFAULT NULL COMMENT 班级,youxiang varchar(200) DEFAULT NULL COMMENT 邮箱,PRIMARY KEY (id),UNIQUE KEY xuehao (xuehao)
) ENGINEInnoDB AUTO_INCREMENT87 DEFAULT CHARSETutf8 COMMENT学生;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table xuesheng
--LOCK TABLES xuesheng WRITE;
/*!40000 ALTER TABLE xuesheng DISABLE KEYS */;
INSERT INTO xuesheng VALUES (81,2022-03-28 11:34:08,学号1,123456,姓名1,男,13823888881,院系1,专业1,班级1,773890001qq.com),(82,2022-03-28 11:34:08,学号2,123456,姓名2,男,13823888882,院系2,专业2,班级2,773890002qq.com),(83,2022-03-28 11:34:08,学号3,123456,姓名3,男,13823888883,院系3,专业3,班级3,773890003qq.com),(84,2022-03-28 11:34:08,学号4,123456,姓名4,男,13823888884,院系4,专业4,班级4,773890004qq.com),(85,2022-03-28 11:34:08,学号5,123456,姓名5,男,13823888885,院系5,专业5,班级5,773890005qq.com),(86,2022-03-28 11:34:08,学号6,123456,姓名6,男,13823888886,院系6,专业6,班级6,773890006qq.com);
/*!40000 ALTER TABLE xuesheng ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table xueshengpingjia
--DROP TABLE IF EXISTS xueshengpingjia;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE xueshengpingjia (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,kecheng varchar(200) DEFAULT NULL COMMENT 课程,banji varchar(200) DEFAULT NULL COMMENT 班级,jiaoxuenengli varchar(200) NOT NULL COMMENT 教学能力,jiaoxuexiaoguo varchar(200) NOT NULL COMMENT 教学效果,quweixing varchar(200) NOT NULL COMMENT 趣味性,hudongxing varchar(200) NOT NULL COMMENT 互动性,jiaoxuepingfen int(11) NOT NULL COMMENT 教学评分,jiaoxuepingji varchar(200) NOT NULL COMMENT 教学评级,jiaoxuepingjia longtext COMMENT 教学评价,jiaoshigonghao varchar(200) DEFAULT NULL COMMENT 教师工号,xuehao varchar(200) DEFAULT NULL COMMENT 学号,xingming varchar(200) DEFAULT NULL COMMENT 姓名,crossuserid bigint(20) DEFAULT NULL COMMENT 跨表用户id,crossrefid bigint(20) DEFAULT NULL COMMENT 跨表主键id,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT127 DEFAULT CHARSETutf8 COMMENT学生评价;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table xueshengpingjia
--LOCK TABLES xueshengpingjia WRITE;
/*!40000 ALTER TABLE xueshengpingjia DISABLE KEYS */;
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);
/*!40000 ALTER TABLE xueshengpingjia ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yuanxi
--DROP TABLE IF EXISTS yuanxi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yuanxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yuanxi varchar(200) NOT NULL COMMENT 院系,PRIMARY KEY (id),UNIQUE KEY yuanxi (yuanxi)
) ENGINEInnoDB AUTO_INCREMENT37 DEFAULT CHARSETutf8 COMMENT院系;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yuanxi
--LOCK TABLES yuanxi WRITE;
/*!40000 ALTER TABLE yuanxi DISABLE KEYS */;
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);
/*!40000 ALTER TABLE yuanxi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zhibiaoxinxi
--DROP TABLE IF EXISTS zhibiaoxinxi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zhibiaoxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhibiaohao varchar(200) DEFAULT NULL COMMENT 指标号,zhibiaomingcheng varchar(200) DEFAULT NULL COMMENT 指标名称,zhibiaoquanzhong varchar(200) DEFAULT NULL COMMENT 指标权重,zhibiaoneirong longtext COMMENT 指标内容,PRIMARY KEY (id),UNIQUE KEY zhibiaohao (zhibiaohao)
) ENGINEInnoDB AUTO_INCREMENT17 DEFAULT CHARSETutf8 COMMENT指标信息;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zhibiaoxinxi
--LOCK TABLES zhibiaoxinxi WRITE;
/*!40000 ALTER TABLE zhibiaoxinxi DISABLE KEYS */;
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);
/*!40000 ALTER TABLE zhibiaoxinxi ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zhuanjia
--DROP TABLE IF EXISTS zhuanjia;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zhuanjia (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhuanjiazhanghao varchar(200) NOT NULL COMMENT 专家账号,mima varchar(200) NOT NULL COMMENT 密码,zhuanjiaxingming varchar(200) DEFAULT NULL COMMENT 专家姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,zhicheng varchar(200) DEFAULT NULL COMMENT 职称,dianhua varchar(200) DEFAULT NULL COMMENT 电话,PRIMARY KEY (id),UNIQUE KEY zhuanjiazhanghao (zhuanjiazhanghao)
) ENGINEInnoDB AUTO_INCREMENT77 DEFAULT CHARSETutf8 COMMENT专家;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zhuanjia
--LOCK TABLES zhuanjia WRITE;
/*!40000 ALTER TABLE zhuanjia DISABLE KEYS */;
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);
/*!40000 ALTER TABLE zhuanjia ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zhuanjiapingjia
--DROP TABLE IF EXISTS zhuanjiapingjia;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zhuanjiapingjia (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,kecheng varchar(200) DEFAULT NULL COMMENT 课程,jiaoxuenengli varchar(200) NOT NULL COMMENT 教学能力,jiaoxuexiaoguo varchar(200) NOT NULL COMMENT 教学效果,xueshengzhuangtai varchar(200) NOT NULL COMMENT 学生状态,jiaoxuepingfen int(11) NOT NULL COMMENT 教学评分,jiaoxuepingji varchar(200) NOT NULL COMMENT 教学评级,pingjianeirong longtext NOT NULL COMMENT 评价内容,jiaoshigonghao varchar(200) DEFAULT NULL COMMENT 教师工号,jiaoshixingming varchar(200) DEFAULT NULL COMMENT 教师姓名,pingjiariqi date DEFAULT NULL COMMENT 评价日期,zhuanjiazhanghao varchar(200) DEFAULT NULL COMMENT 专家账号,zhuanjiaxingming varchar(200) DEFAULT NULL COMMENT 专家姓名,crossuserid bigint(20) DEFAULT NULL COMMENT 跨表用户id,crossrefid bigint(20) DEFAULT NULL COMMENT 跨表主键id,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT117 DEFAULT CHARSETutf8 COMMENT专家评价;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zhuanjiapingjia
--LOCK TABLES zhuanjiapingjia WRITE;
/*!40000 ALTER TABLE zhuanjiapingjia DISABLE KEYS */;
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);
/*!40000 ALTER TABLE zhuanjiapingjia ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zhuanye
--DROP TABLE IF EXISTS zhuanye;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zhuanye (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,zhuanye varchar(200) NOT NULL COMMENT 专业,PRIMARY KEY (id),UNIQUE KEY zhuanye (zhuanye)
) ENGINEInnoDB AUTO_INCREMENT47 DEFAULT CHARSETutf8 COMMENT专业;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zhuanye
--LOCK TABLES zhuanye WRITE;
/*!40000 ALTER TABLE zhuanye DISABLE KEYS */;
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);
/*!40000 ALTER TABLE zhuanye ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONEOLD_TIME_ZONE */;/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENTOLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTSOLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTIONOLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;-- Dump completed on 2022-03-28 21:20:45 五.关键代码 package com.controller;import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UserEntity;
import com.service.TokenService;
import com.service.UserService;
import com.utils.CommonUtil;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;/*** 登录相关*/
RequestMapping(users)
RestController
public class UserController{Autowiredprivate UserService userService;Autowiredprivate TokenService tokenService;/*** 登录*/IgnoreAuthPostMapping(value /login)public R login(String username, String password, String captcha, HttpServletRequest request) {UserEntity user userService.selectOne(new EntityWrapperUserEntity().eq(username, username));if(usernull || !user.getPassword().equals(password)) {return R.error(账号或密码不正确);}String token tokenService.generateToken(user.getId(),username, users, user.getRole());return R.ok().put(token, token);}/*** 注册*/IgnoreAuthPostMapping(value /register)public R register(RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);if(userService.selectOne(new EntityWrapperUserEntity().eq(username, user.getUsername())) !null) {return R.error(用户已存在);}userService.insert(user);return R.ok();}/*** 退出*/GetMapping(value logout)public R logout(HttpServletRequest request) {request.getSession().invalidate();return R.ok(退出成功);}/*** 密码重置*/IgnoreAuthRequestMapping(value /resetPass)public R resetPass(String username, HttpServletRequest request){UserEntity user userService.selectOne(new EntityWrapperUserEntity().eq(username, username));if(usernull) {return R.error(账号不存在);}user.setPassword(123456);userService.update(user,null);return R.ok(密码已重置为123456);}/*** 列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,UserEntity user){EntityWrapperUserEntity ew new EntityWrapperUserEntity();PageUtils page userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));return R.ok().put(data, page);}/*** 列表*/RequestMapping(/list)public R list( UserEntity user){EntityWrapperUserEntity ew new EntityWrapperUserEntity();ew.allEq(MPUtil.allEQMapPre( user, user)); return R.ok().put(data, userService.selectListView(ew));}/*** 信息*/RequestMapping(/info/{id})public R info(PathVariable(id) String id){UserEntity user userService.selectById(id);return R.ok().put(data, user);}/*** 获取用户的session用户信息*/RequestMapping(/session)public R getCurrUser(HttpServletRequest request){Long id (Long)request.getSession().getAttribute(userId);UserEntity user userService.selectById(id);return R.ok().put(data, user);}/*** 保存*/PostMapping(/save)public R save(RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);if(userService.selectOne(new EntityWrapperUserEntity().eq(username, user.getUsername())) !null) {return R.error(用户已存在);}userService.insert(user);return R.ok();}/*** 修改*/RequestMapping(/update)public R update(RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);UserEntity u userService.selectOne(new EntityWrapperUserEntity().eq(username, user.getUsername()));if(u!null u.getId()!user.getId() u.getUsername().equals(user.getUsername())) {return R.error(用户名已存在。);}userService.updateById(user);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){userService.deleteBatchIds(Arrays.asList(ids));return R.ok();}
}六.论文目录参考 七.源码获取 感谢大家的阅读如有不懂的问题可以评论区交流或私聊 喜欢文章可以点赞、收藏、关注、评论啦 、获取源码Vjsjbysj88
