响应式网站建设软文,建设h网站风险大吗,国内购物平台,时尚大气的网站设计博主介绍#xff1a;✌从事软件开发10年之余#xff0c;专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ #x1f345;文末获取源码联系#x1f345; #x1f447;#x1f3fb; 精… 博主介绍✌从事软件开发10年之余专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ 文末获取源码联系 精彩专栏推荐订阅 不然下次找不到哟 ————————————————计算机毕业设计《1000套》✌ 目录
1、项目介绍及开发技术
1.1 项目介绍
1.2 开发技术
2、系统功能模块设计
3、功能截图
3.1 前台功能
3.2 后台功能
4、数据库表结构设计
5、关键代码
5.1 学生管理Controller模块
5.2 学生管理Service模块
5.3 学生管理ServiceImpl模块
5.4 学生管理Dao模块
6、论文目录结构
7、源码获取 1、项目介绍及开发技术 1.1 项目介绍
网络的广泛应用给生活带来了十分的便利。所以把实训管理与现在网络相结合利用java技术建设实训管理系统实现实训管理的信息化。则对于进一步提高实训管理发展对实训管理系统能起到不少的促进作用。本系统能够通过互联网得到广泛的、全面的宣传让尽可能多的用户了解和熟知实训管理系统的便捷高效不仅为群众提供了服务而且也推广了自己让更多的群众了解自己。
本系统设计的现状和趋势从需求、结构、数据库等方面的设计到系统的实现分别为管理员、教师和学生的实现。论文的内容从系统的设计、描述、实现、分析、测试方面来表明开发的过程。本系统根据现实情况来选择一种可行的开发方案借助java编程语言和MySQL数据库等实现系统的全部功能接下来对系统进行测试测试系统是否有漏洞和测试用户权限来完善系统最终系统完成达到相关标准。
1.2 开发技术
Java开发语言、SpringBoot、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8、Vue、HTML、CSS、JS。 2、系统功能模块设计 学生注册登录、首页、论坛、公告信息、实训模块、实训实施、个人中心个人信息、成绩、考勤、请假、实训成果。
老师注册登录、个人中心、学生管理、成绩管理、论坛管理、公告信息管理、考勤管理、请假管理、实训模块管理、实训实施管理、实训成果管理、轮播图管理。
管理员首页、个人中心、管理员管理、老师管理、学生管理、成绩管理、论坛管理、公告信息管理、考勤管理、请假管理、实训模块管理、实训实施管理。 3、功能截图 3.1 前台功能
首页 论坛 公告信息 实训模块 实训实施 个人中心 3.2 后台功能
个人中心 学生管理 成绩管理 论坛管理 公告信息管理 考勤管理 请假管理 实训模块管理 实训实施管理 实训成果管理 4、数据库表结构设计 CREATE TABLE chengji (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,chengji_uuid_number varchar(200) DEFAULT NULL COMMENT 报名唯一编号 Search111 ,laoshi_id int(11) DEFAULT NULL COMMENT 老师,yonghu_id int(11) DEFAULT NULL COMMENT 学生,chengji_kemu varchar(200) DEFAULT NULL COMMENT 实训模块 ,chengji_pigai int(11) DEFAULT NULL COMMENT 分数,insert_time timestamp NULL DEFAULT NULL COMMENT 作业提交时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show3 listShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT成绩;/*Data for the table chengji */insert into chengji(id,chengji_uuid_number,laoshi_id,yonghu_id,chengji_kemu,chengji_pigai,insert_time,create_time) values (1,1683535083878,3,1,实训模块1,253,2023-05-08 16:38:03,2023-05-08 16:38:03),(2,1683535083848,3,3,实训模块2,73,2023-05-08 16:38:03,2023-05-08 16:38:03),(3,1683535083924,1,2,实训模块3,192,2023-05-08 16:38:03,2023-05-08 16:38:03),(4,1683535083929,2,2,实训模块4,405,2023-05-08 16:38:03,2023-05-08 16:38:03),(5,1683535083854,1,2,实训模块5,300,2023-05-08 16:38:03,2023-05-08 16:38:03),(6,1683535083935,2,2,实训模块6,441,2023-05-08 16:38:03,2023-05-08 16:38:03),(7,1683535083900,3,2,实训模块7,272,2023-05-08 16:38:03,2023-05-08 16:38:03),(8,1683535083847,1,1,实训模块8,112,2023-05-08 16:38:03,2023-05-08 16:38:03),(9,1683535083883,1,3,实训模块9,255,2023-05-08 16:38:03,2023-05-08 16:38:03),(10,1683535083893,1,1,实训模块10,492,2023-05-08 16:38:03,2023-05-08 16:38:03),(11,1683535083913,1,3,实训模块11,221,2023-05-08 16:38:03,2023-05-08 16:38:03),(12,1683535083916,1,3,实训模块12,366,2023-05-08 16:38:03,2023-05-08 16:38:03),(13,1683535083848,1,2,实训模块13,107,2023-05-08 16:38:03,2023-05-08 16:38:03),(14,1683535083911,3,2,实训模块14,285,2023-05-08 16:38:03,2023-05-08 16:38:03);/*Table structure for table config */DROP TABLE IF EXISTS config;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配置文件;/*Data for the table config */insert into config(id,name,value) values (1,轮播图1,upload/config1.jpg),(2,轮播图2,upload/config2.jpg),(3,轮播图3,upload/config3.jpg);/*Table structure for table dictionary */DROP TABLE IF EXISTS dictionary;CREATE TABLE dictionary (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,dic_code varchar(200) DEFAULT NULL COMMENT 字段,dic_name varchar(200) DEFAULT NULL COMMENT 字段名,code_index int(11) DEFAULT NULL COMMENT 编码,index_name varchar(200) DEFAULT NULL COMMENT 编码名字 Search111 ,super_id int(11) DEFAULT NULL COMMENT 父字段id,beizhu varchar(200) DEFAULT NULL COMMENT 备注,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT22 DEFAULT CHARSETutf8 COMMENT字典;/*Data for the table dictionary */insert into dictionary(id,dic_code,dic_name,code_index,index_name,super_id,beizhu,create_time) values (1,sex_types,性别类型,1,男,NULL,NULL,2023-05-08 16:37:55),(2,sex_types,性别类型,2,女,NULL,NULL,2023-05-08 16:37:55),(3,gonggao_types,公告类型,1,公告类型1,NULL,NULL,2023-05-08 16:37:55),(4,gonggao_types,公告类型,2,公告类型2,NULL,NULL,2023-05-08 16:37:55),(5,qingjia_types,请假类型,1,生病,NULL,NULL,2023-05-08 16:37:55),(6,qingjia_types,请假类型,2,有事,NULL,NULL,2023-05-08 16:37:55),(7,qingjia_yesno_types,申请状态,1,待审核,NULL,NULL,2023-05-08 16:37:55),(8,qingjia_yesno_types,申请状态,2,同意,NULL,NULL,2023-05-08 16:37:55),(9,qingjia_yesno_types,申请状态,3,拒绝,NULL,NULL,2023-05-08 16:37:55),(10,qingjia_yesno_types,申请状态,4,销假,NULL,NULL,2023-05-08 16:37:55),(11,yonghu_kaoqin_types,学生考勤类型,1,日常考勤,NULL,NULL,2023-05-08 16:37:55),(12,yonghu_kaoqin_types,学生考勤类型,2,考勤类型2,NULL,NULL,2023-05-08 16:37:55),(13,yonghu_kaoqin_list_types,打卡状态,1,未打卡,NULL,NULL,2023-05-08 16:37:55),(14,yonghu_kaoqin_list_types,打卡状态,2,已打卡,NULL,NULL,2023-05-08 16:37:55),(15,zuoye_types,实训模块类型,1,实训模块类型1,NULL,NULL,2023-05-08 16:37:55),(16,zuoye_types,实训模块类型,2,实训模块类型2,NULL,NULL,2023-05-08 16:37:55),(17,zuoye_types,实训模块类型,3,实训模块类型3,NULL,NULL,2023-05-08 16:37:55),(18,zuoye_types,实训模块类型,4,实训模块类型4,NULL,NULL,2023-05-08 16:37:55),(19,zuoye_tijiao_yesno_types,提交状态,1,待批改,NULL,NULL,2023-05-08 16:37:55),(20,zuoye_tijiao_yesno_types,提交状态,2,已批改,NULL,NULL,2023-05-08 16:37:55),(21,zuoye_tijiao_yesno_types,提交状态,3,未批改,NULL,NULL,2023-05-08 16:37:55);/*Table structure for table gonggao */DROP TABLE IF EXISTS gonggao;CREATE TABLE gonggao (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,gonggao_name varchar(200) DEFAULT NULL COMMENT 公告名称 Search111 ,gonggao_photo varchar(200) DEFAULT NULL COMMENT 公告图片 ,gonggao_types int(11) NOT NULL COMMENT 公告类型 Search111 ,insert_time timestamp NULL DEFAULT NULL COMMENT 发布时间,gonggao_content longtext COMMENT 公告详情 ,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show1 show2 nameShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT公告信息;/*Data for the table gonggao */insert into gonggao(id,gonggao_name,gonggao_photo,gonggao_types,insert_time,gonggao_content,create_time) values (1,公告名称1,upload/gonggao1.jpg,1,2023-05-08 16:38:03,公告详情1,2023-05-08 16:38:03),(2,公告名称2,upload/gonggao2.jpg,2,2023-05-08 16:38:03,公告详情2,2023-05-08 16:38:03),(3,公告名称3,upload/gonggao3.jpg,1,2023-05-08 16:38:03,公告详情3,2023-05-08 16:38:03),(4,公告名称4,upload/gonggao4.jpg,1,2023-05-08 16:38:03,公告详情4,2023-05-08 16:38:03),(5,公告名称5,upload/gonggao5.jpg,1,2023-05-08 16:38:03,公告详情5,2023-05-08 16:38:03),(6,公告名称6,upload/gonggao6.jpg,2,2023-05-08 16:38:03,公告详情6,2023-05-08 16:38:03),(7,公告名称7,upload/gonggao7.jpg,1,2023-05-08 16:38:03,公告详情7,2023-05-08 16:38:03),(8,公告名称8,upload/gonggao8.jpg,2,2023-05-08 16:38:03,公告详情8,2023-05-08 16:38:03),(9,公告名称9,upload/gonggao9.jpg,2,2023-05-08 16:38:03,公告详情9,2023-05-08 16:38:03),(10,公告名称10,upload/gonggao10.jpg,2,2023-05-08 16:38:03,公告详情10,2023-05-08 16:38:03),(11,公告名称11,upload/gonggao11.jpg,2,2023-05-08 16:38:03,公告详情11,2023-05-08 16:38:03),(12,公告名称12,upload/gonggao12.jpg,2,2023-05-08 16:38:03,公告详情12,2023-05-08 16:38:03),(13,公告名称13,upload/gonggao13.jpg,1,2023-05-08 16:38:03,公告详情13,2023-05-08 16:38:03),(14,公告名称14,upload/gonggao14.jpg,1,2023-05-08 16:38:03,公告详情14,2023-05-08 16:38:03);/*Table structure for table laoshi */DROP TABLE IF EXISTS laoshi;CREATE TABLE laoshi (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(200) DEFAULT NULL COMMENT 账户,password varchar(200) DEFAULT NULL COMMENT 密码,laoshi_uuid_number varchar(200) DEFAULT NULL COMMENT 老师编号 Search111 ,laoshi_name varchar(200) DEFAULT NULL COMMENT 老师姓名 Search111 ,laoshi_phone varchar(200) DEFAULT NULL COMMENT 老师手机号,laoshi_id_number varchar(200) DEFAULT NULL COMMENT 老师身份证号,laoshi_photo varchar(200) DEFAULT NULL COMMENT 老师头像,sex_types int(11) DEFAULT NULL COMMENT 性别,laoshi_email varchar(200) DEFAULT NULL COMMENT 老师邮箱,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT老师;/*Data for the table laoshi */insert into laoshi(id,username,password,laoshi_uuid_number,laoshi_name,laoshi_phone,laoshi_id_number,laoshi_photo,sex_types,laoshi_email,create_time) values (1,a1,123456,1683535083859,老师姓名1,17703786901,410224199010102001,upload/laoshi1.jpg,2,1qq.com,2023-05-08 16:38:03),(2,a2,123456,1683535083949,老师姓名2,17703786902,410224199010102002,upload/laoshi2.jpg,2,2qq.com,2023-05-08 16:38:03),(3,a3,123456,1683535083901,老师姓名3,17703786903,410224199010102003,upload/laoshi3.jpg,2,3qq.com,2023-05-08 16:38:03);/*Table structure for table qingjia */DROP TABLE IF EXISTS qingjia;CREATE TABLE qingjia (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,yonghu_id int(11) DEFAULT NULL COMMENT 学生,laoshi_id int(11) DEFAULT NULL COMMENT 老师,qingjia_name varchar(200) DEFAULT NULL COMMENT 请假标题 Search111 ,qingjia_text longtext COMMENT 请假缘由,qingjia_types int(11) DEFAULT NULL COMMENT 请假类型 Search111,insert_time timestamp NULL DEFAULT NULL COMMENT 申请时间,qingjia_time timestamp NULL DEFAULT NULL COMMENT 请假时间,qingjia_number int(200) DEFAULT NULL COMMENT 请假天数,qingjia_yesno_types int(11) DEFAULT NULL COMMENT 申请状态 Search111 ,qingjia_yesno_text longtext COMMENT 处理意见,qingjia_shenhe_time timestamp NULL DEFAULT NULL COMMENT 审核时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show3 listShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT请假;/*Data for the table qingjia */insert into qingjia(id,yonghu_id,laoshi_id,qingjia_name,qingjia_text,qingjia_types,insert_time,qingjia_time,qingjia_number,qingjia_yesno_types,qingjia_yesno_text,qingjia_shenhe_time,create_time) values (1,3,1,请假标题1,请假缘由1,1,2023-05-08 16:38:03,2023-05-08 16:38:03,166,1,NULL,NULL,2023-05-08 16:38:03),(2,2,2,请假标题2,请假缘由2,2,2023-05-08 16:38:03,2023-05-08 16:38:03,214,1,NULL,NULL,2023-05-08 16:38:03),(3,3,2,请假标题3,请假缘由3,2,2023-05-08 16:38:03,2023-05-08 16:38:03,49,1,NULL,NULL,2023-05-08 16:38:03),(4,1,3,请假标题4,请假缘由4,2,2023-05-08 16:38:03,2023-05-08 16:38:03,360,1,NULL,NULL,2023-05-08 16:38:03),(5,3,3,请假标题5,请假缘由5,2,2023-05-08 16:38:03,2023-05-08 16:38:03,261,1,NULL,NULL,2023-05-08 16:38:03),(6,1,3,请假标题6,请假缘由6,2,2023-05-08 16:38:03,2023-05-08 16:38:03,492,1,NULL,NULL,2023-05-08 16:38:03),(7,3,1,请假标题7,请假缘由7,1,2023-05-08 16:38:03,2023-05-08 16:38:03,127,1,NULL,NULL,2023-05-08 16:38:03),(8,3,1,请假标题8,请假缘由8,1,2023-05-08 16:38:03,2023-05-08 16:38:03,35,1,NULL,NULL,2023-05-08 16:38:03),(9,3,2,请假标题9,请假缘由9,2,2023-05-08 16:38:03,2023-05-08 16:38:03,408,1,NULL,NULL,2023-05-08 16:38:03),(10,2,1,请假标题10,请假缘由10,1,2023-05-08 16:38:03,2023-05-08 16:38:03,73,1,NULL,NULL,2023-05-08 16:38:03),(11,1,2,请假标题11,请假缘由11,1,2023-05-08 16:38:03,2023-05-08 16:38:03,372,1,NULL,NULL,2023-05-08 16:38:03),(12,2,2,请假标题12,请假缘由12,1,2023-05-08 16:38:03,2023-05-08 16:38:03,149,1,NULL,NULL,2023-05-08 16:38:03),(13,1,1,请假标题13,请假缘由13,1,2023-05-08 16:38:03,2023-05-08 16:38:03,66,2,大,2023-05-08 17:22:18,2023-05-08 16:38:03),(14,2,2,请假标题14,请假缘由14,2,2023-05-08 16:38:03,2023-05-08 16:38:03,235,1,NULL,NULL,2023-05-08 16:38:03);/*Table structure for table token */DROP TABLE IF EXISTS token;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_INCREMENT4 DEFAULT CHARSETutf8 COMMENTtoken表;/*Data for the table token */insert into token(id,userid,username,tablename,role,token,addtime,expiratedtime) values (1,1,a1,yonghu,学生,41ipbb99auhifklf4023gxvjv96d072f,2023-05-08 16:41:52,2023-05-08 18:18:26),(2,1,admin,users,管理员,rn18jhbym351xlc2e1wl8ytogwmhk4fc,2023-05-08 16:44:36,2023-05-08 18:23:30),(3,1,a1,laoshi,老师,ocv4r1q63c4h33nmuqjhz4iaf7om20s0,2023-05-08 16:55:31,2023-05-08 18:21:53);/*Table structure for table users */DROP TABLE IF EXISTS users;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管理员;/*Data for the table users */insert into users(id,username,password,role,addtime) values (1,admin,admin,管理员,2023-05-08 16:37:55);/*Table structure for table yonghu */DROP TABLE IF EXISTS yonghu;CREATE TABLE yonghu (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(200) DEFAULT NULL COMMENT 账户,password varchar(200) DEFAULT NULL COMMENT 密码,yonghu_uuid_number varchar(200) DEFAULT NULL COMMENT 学生编号 Search111 ,yonghu_name varchar(200) DEFAULT NULL COMMENT 学生姓名 Search111 ,yonghu_phone varchar(200) DEFAULT NULL COMMENT 学生手机号,yonghu_id_number varchar(200) DEFAULT NULL COMMENT 学生身份证号,yonghu_photo varchar(200) DEFAULT NULL COMMENT 学生头像,sex_types int(11) DEFAULT NULL COMMENT 性别,yonghu_email varchar(200) DEFAULT NULL COMMENT 学生邮箱,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT学生;/*Data for the table yonghu */insert into yonghu(id,username,password,yonghu_uuid_number,yonghu_name,yonghu_phone,yonghu_id_number,yonghu_photo,sex_types,yonghu_email,create_time) values (1,a1,123456,1683535083894,学生姓名1,17703786901,410224199010102001,upload/yonghu1.jpg,1,1qq.com,2023-05-08 16:38:03),(2,a2,123456,1683535083865,学生姓名2,17703786902,410224199010102002,upload/yonghu2.jpg,2,2qq.com,2023-05-08 16:38:03),(3,a3,123456,1683535083934,学生姓名3,17703786903,410224199010102003,upload/yonghu3.jpg,2,3qq.com,2023-05-08 16:38:03);/*Table structure for table yonghu_kaoqin */DROP TABLE IF EXISTS yonghu_kaoqin;CREATE TABLE yonghu_kaoqin (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,laoshi_id int(11) DEFAULT NULL COMMENT 老师,yonghu_kaoqin_uuid_number varchar(200) DEFAULT NULL COMMENT 考勤唯一编号 Search111 ,yonghu_kaoqin_name varchar(200) DEFAULT NULL COMMENT 考勤标题 Search111 ,yonghu_kaoqin_types int(11) DEFAULT NULL COMMENT 学生考勤类型 Search111,yonghu_kaoqin_content longtext COMMENT 考勤详情,insert_time timestamp NULL DEFAULT NULL COMMENT 考勤发起时间,jiezhi_time timestamp NULL DEFAULT NULL COMMENT 考勤截止时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT学生考勤;/*Data for the table yonghu_kaoqin */insert into yonghu_kaoqin(id,laoshi_id,yonghu_kaoqin_uuid_number,yonghu_kaoqin_name,yonghu_kaoqin_types,yonghu_kaoqin_content,insert_time,jiezhi_time,create_time) values (1,3,1683535083885,考勤标题1,1,考勤详情1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(2,1,1683535083949,考勤标题2,1,考勤详情2,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(3,3,1683535083948,考勤标题3,1,考勤详情3,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(4,3,1683535083878,考勤标题4,1,考勤详情4,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(5,2,1683535083908,考勤标题5,1,考勤详情5,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(6,2,1683535083856,考勤标题6,1,考勤详情6,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(7,3,1683535083881,考勤标题7,1,考勤详情7,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(8,3,1683535083929,考勤标题8,1,考勤详情8,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(9,2,1683535083909,考勤标题9,2,考勤详情9,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(10,1,1683535083953,考勤标题10,2,考勤详情10,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(11,3,1683535083942,考勤标题11,1,考勤详情11,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(12,1,1683535083875,考勤标题12,1,考勤详情12,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(13,2,1683535083933,考勤标题13,2,考勤详情13,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(14,3,1683535083921,考勤标题14,1,考勤详情14,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03);/*Table structure for table yonghu_kaoqin_list */DROP TABLE IF EXISTS yonghu_kaoqin_list;CREATE TABLE yonghu_kaoqin_list (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,yonghu_id int(11) DEFAULT NULL COMMENT 学生,yonghu_kaoqin_id int(11) DEFAULT NULL COMMENT 考勤,yonghu_kaoqin_list_types int(11) DEFAULT NULL COMMENT 打卡状态,insert_time timestamp NULL DEFAULT NULL COMMENT 添加时间,update_time timestamp NULL DEFAULT NULL COMMENT 打卡时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show3 listShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT17 DEFAULT CHARSETutf8 COMMENT学生考勤详情;/*Data for the table yonghu_kaoqin_list */insert into yonghu_kaoqin_list(id,yonghu_id,yonghu_kaoqin_id,yonghu_kaoqin_list_types,insert_time,update_time,create_time) values (1,3,1,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(2,1,2,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(3,2,3,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(4,1,4,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(5,1,5,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(6,3,6,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(7,1,7,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(8,2,8,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(9,1,9,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(10,2,10,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(11,2,11,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(12,3,12,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(13,3,13,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(14,3,14,1,2023-05-08 16:38:03,2023-05-08 16:38:03,2023-05-08 16:38:03),(15,1,13,2,2023-05-08 17:21:05,NULL,2023-05-08 17:21:05),(16,1,12,2,2023-05-08 17:22:50,NULL,2023-05-08 17:22:50);/*Table structure for table zuoye */DROP TABLE IF EXISTS zuoye;CREATE TABLE zuoye (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,laoshi_id int(11) DEFAULT NULL COMMENT 老师,zuoye_name varchar(200) DEFAULT NULL COMMENT 实训模块名称 Search111 ,zuoye_uuid_number varchar(200) DEFAULT NULL COMMENT 实训模块编号,zuoye_address varchar(200) DEFAULT NULL COMMENT 实训模块地点,zuoye_photo varchar(200) DEFAULT NULL COMMENT 实训模块照片,zuoye_types int(11) DEFAULT NULL COMMENT 实训模块类型 Search111,zuoye_video varchar(200) DEFAULT NULL COMMENT 视频,zuoye_file varchar(200) DEFAULT NULL COMMENT 文件,zuoye_content longtext COMMENT 实训模块介绍 ,zuoye_delete int(11) DEFAULT NULL COMMENT 逻辑删除,insert_time timestamp NULL DEFAULT NULL COMMENT 录入时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show1 show2 photoShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT实训模块;/*Data for the table zuoye */insert into zuoye(id,laoshi_id,zuoye_name,zuoye_uuid_number,zuoye_address,zuoye_photo,zuoye_types,zuoye_video,zuoye_file,zuoye_content,zuoye_delete,insert_time,create_time) values (1,2,实训模块名称1,1683535083911,实训模块地点1,upload/zuoye1.jpg,3,upload/video.mp4,upload/file.rar,实训模块介绍1,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(2,3,实训模块名称2,1683535083950,实训模块地点2,upload/zuoye2.jpg,3,upload/video.mp4,upload/file.rar,实训模块介绍2,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(3,1,实训模块名称3,1683535083858,实训模块地点3,upload/zuoye3.jpg,2,upload/video.mp4,upload/file.rar,实训模块介绍3,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(4,3,实训模块名称4,1683535083900,实训模块地点4,upload/zuoye4.jpg,2,upload/video.mp4,upload/file.rar,实训模块介绍4,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(5,1,实训模块名称5,1683535083890,实训模块地点5,upload/zuoye5.jpg,1,upload/video.mp4,upload/file.rar,实训模块介绍5,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(6,3,实训模块名称6,1683535083939,实训模块地点6,upload/zuoye6.jpg,4,upload/video.mp4,upload/file.rar,实训模块介绍6,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(7,2,实训模块名称7,1683535083861,实训模块地点7,upload/zuoye7.jpg,4,upload/video.mp4,upload/file.rar,实训模块介绍7,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(8,2,实训模块名称8,1683535083886,实训模块地点8,upload/zuoye8.jpg,3,upload/video.mp4,upload/file.rar,实训模块介绍8,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(9,3,实训模块名称9,1683535083869,实训模块地点9,upload/zuoye9.jpg,2,upload/video.mp4,upload/file.rar,实训模块介绍9,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(10,3,实训模块名称10,1683535083886,实训模块地点10,upload/zuoye10.jpg,4,upload/video.mp4,upload/file.rar,实训模块介绍10,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(11,1,实训模块名称11,1683535083930,实训模块地点11,upload/zuoye11.jpg,1,upload/video.mp4,upload/file.rar,实训模块介绍11,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(12,1,实训模块名称12,1683535083861,实训模块地点12,upload/zuoye12.jpg,3,upload/video.mp4,upload/file.rar,实训模块介绍12,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(13,1,实训模块名称13,1683535083930,实训模块地点13,upload/zuoye13.jpg,3,upload/video.mp4,upload/file.rar,实训模块介绍13,1,2023-05-08 16:38:03,2023-05-08 16:38:03),(14,3,实训模块名称14,1683535083941,实训模块地点14,upload/zuoye14.jpg,1,upload/video.mp4,upload/file.rar,实训模块介绍14,1,2023-05-08 16:38:03,2023-05-08 16:38:03);/*Table structure for table zuoye_tijiao */DROP TABLE IF EXISTS zuoye_tijiao;CREATE TABLE zuoye_tijiao (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,zuoye_tijiao_uuid_number varchar(200) DEFAULT NULL COMMENT 报名唯一编号 Search111 ,zuoye_id int(11) DEFAULT NULL COMMENT 实训模块,laoshi_id int(11) DEFAULT NULL COMMENT 老师,yonghu_id int(11) DEFAULT NULL COMMENT 学生,zuoye_tijiao_text text COMMENT 内容,zuoye_shangchuan_file varchar(200) DEFAULT NULL COMMENT 作业上传,zuoye_tijiao_yesno_types int(11) DEFAULT NULL COMMENT 提交状态 Search111 ,zuoye_tijiao_pigai int(11) DEFAULT NULL COMMENT 批改分数,insert_time timestamp NULL DEFAULT NULL COMMENT 作业提交时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show3 listShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT16 DEFAULT CHARSETutf8 COMMENT实训成果;/*Data for the table zuoye_tijiao */insert into zuoye_tijiao(id,zuoye_tijiao_uuid_number,zuoye_id,laoshi_id,yonghu_id,zuoye_tijiao_text,zuoye_shangchuan_file,zuoye_tijiao_yesno_types,zuoye_tijiao_pigai,insert_time,create_time) values (1,1683535083916,1,2,3,内容1,upload/file.rar,1,206,2023-05-08 16:38:03,2023-05-08 16:38:03),(2,1683535083891,2,2,3,内容2,upload/file.rar,1,377,2023-05-08 16:38:03,2023-05-08 16:38:03),(3,1683535083863,3,1,3,内容3,upload/file.rar,1,232,2023-05-08 16:38:03,2023-05-08 16:38:03),(4,1683535083891,4,1,2,内容4,upload/file.rar,1,239,2023-05-08 16:38:03,2023-05-08 16:38:03),(5,1683535083887,5,3,1,内容5,upload/file.rar,1,352,2023-05-08 16:38:03,2023-05-08 16:38:03),(6,1683535083910,6,3,1,内容6,upload/file.rar,1,177,2023-05-08 16:38:03,2023-05-08 16:38:03),(7,1683535083921,7,2,3,内容7,upload/file.rar,1,143,2023-05-08 16:38:03,2023-05-08 16:38:03),(8,1683535083879,8,1,3,内容8,upload/file.rar,1,78,2023-05-08 16:38:03,2023-05-08 16:38:03),(9,1683535083876,9,1,2,内容9,upload/file.rar,1,306,2023-05-08 16:38:03,2023-05-08 16:38:03),(10,1683535083877,10,1,3,内容10,upload/file.rar,1,146,2023-05-08 16:38:03,2023-05-08 16:38:03),(11,1683535083942,11,3,1,内容11,upload/file.rar,1,250,2023-05-08 16:38:03,2023-05-08 16:38:03),(12,1683535083914,12,1,2,内容12,upload/file.rar,1,439,2023-05-08 16:38:03,2023-05-08 16:38:03),(13,1683535083953,13,3,3,内容13,upload/file.rar,1,184,2023-05-08 16:38:03,2023-05-08 16:38:03),(14,1683535083959,14,2,2,内容14,upload/file.rar,1,56,2023-05-08 16:38:03,2023-05-08 16:38:03),(15,1683537627977,13,1,1,测试,upload/1683537634369.jpg,2,50,2023-05-08 17:20:36,2023-05-08 17:20:36);/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;5、关键代码 5.1 学生管理Controller模块
package com.controller;import java.io.File;
import java.math.BigDecimal;
import java.net.URL;
import java.text.SimpleDateFormat;
import com.alibaba.fastjson.JSONObject;
import java.util.*;
import org.springframework.beans.BeanUtils;
import javax.servlet.http.HttpServletRequest;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import com.service.TokenService;
import com.utils.*;
import java.lang.reflect.InvocationTargetException;import com.service.DictionaryService;
import org.apache.commons.lang3.StringUtils;
import com.annotation.IgnoreAuth;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.*;
import com.entity.view.*;
import com.service.*;
import com.utils.PageUtils;
import com.utils.R;
import com.alibaba.fastjson.*;/*** 学生* 后端接口* author* email
*/
RestController
Controller
RequestMapping(/yonghu)
public class YonghuController {private static final Logger logger LoggerFactory.getLogger(YonghuController.class);private static final String TABLE_NAME yonghu;Autowiredprivate YonghuService yonghuService;Autowiredprivate TokenService tokenService;Autowiredprivate ChengjiService chengjiService;//成绩Autowiredprivate DictionaryService dictionaryService;//字典Autowiredprivate GonggaoService gonggaoService;//公告信息Autowiredprivate LaoshiService laoshiService;//老师Autowiredprivate QingjiaService qingjiaService;//请假Autowiredprivate YonghuKaoqinService yonghuKaoqinService;//学生考勤Autowiredprivate YonghuKaoqinListService yonghuKaoqinListService;//学生考勤详情Autowiredprivate ZuoyeService zuoyeService;//实训模块Autowiredprivate ZuoyeTijiaoService zuoyeTijiaoService;//实训成果Autowiredprivate UsersService usersService;//管理员/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(page方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永不会进入);else if(学生.equals(role))params.put(yonghuId,request.getSession().getAttribute(userId));else if(老师.equals(role))params.put(laoshiId,request.getSession().getAttribute(userId));CommonUtil.checkMap(params);PageUtils page yonghuService.queryPage(params);//字典表数据转换ListYonghuView list (ListYonghuView)page.getList();for(YonghuView c:list){//修改对应字典表字段dictionaryService.dictionaryConvert(c, request);}return R.ok().put(data, page);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id, HttpServletRequest request){logger.debug(info方法:,,Controller:{},,id:{},this.getClass().getName(),id);YonghuEntity yonghu yonghuService.selectById(id);if(yonghu !null){//entity转viewYonghuView view new YonghuView();BeanUtils.copyProperties( yonghu , view );//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody YonghuEntity yonghu, HttpServletRequest request){logger.debug(save方法:,,Controller:{},,yonghu:{},this.getClass().getName(),yonghu.toString());String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永远不会进入);WrapperYonghuEntity queryWrapper new EntityWrapperYonghuEntity().eq(username, yonghu.getUsername()).or().eq(yonghu_phone, yonghu.getYonghuPhone()).or().eq(yonghu_id_number, yonghu.getYonghuIdNumber());logger.info(sql语句:queryWrapper.getSqlSegment());YonghuEntity yonghuEntity yonghuService.selectOne(queryWrapper);if(yonghuEntitynull){yonghu.setCreateTime(new Date());yonghu.setPassword(123456);yonghuService.insert(yonghu);return R.ok();}else {return R.error(511,账户或者学生手机号或者学生身份证号已经被使用);}}/*** 后端修改*/RequestMapping(/update)public R update(RequestBody YonghuEntity yonghu, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {logger.debug(update方法:,,Controller:{},,yonghu:{},this.getClass().getName(),yonghu.toString());YonghuEntity oldYonghuEntity yonghuService.selectById(yonghu.getId());//查询原先数据String role String.valueOf(request.getSession().getAttribute(role));
// if(false)
// return R.error(511,永远不会进入);if(.equals(yonghu.getYonghuPhoto()) || null.equals(yonghu.getYonghuPhoto())){yonghu.setYonghuPhoto(null);}yonghuService.updateById(yonghu);//根据id更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Integer[] ids, HttpServletRequest request){logger.debug(delete:,,Controller:{},,ids:{},this.getClass().getName(),ids.toString());ListYonghuEntity oldYonghuList yonghuService.selectBatchIds(Arrays.asList(ids));//要删除的数据yonghuService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 批量上传*/RequestMapping(/batchInsert)public R save( String fileName, HttpServletRequest request){logger.debug(batchInsert方法:,,Controller:{},,fileName:{},this.getClass().getName(),fileName);Integer yonghuId Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId)));SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd HH:mm:ss);//.eq(time, new SimpleDateFormat(yyyy-MM-dd).format(new Date()))try {ListYonghuEntity yonghuList new ArrayList();//上传的东西MapString, ListString seachFields new HashMap();//要查询的字段Date date new Date();int lastIndexOf fileName.lastIndexOf(.);if(lastIndexOf -1){return R.error(511,该文件没有后缀);}else{String suffix fileName.substring(lastIndexOf);if(!.xls.equals(suffix)){return R.error(511,只支持后缀为xls的excel文件);}else{URL resource this.getClass().getClassLoader().getResource(static/upload/ fileName);//获取文件路径File file new File(resource.getFile());if(!file.exists()){return R.error(511,找不到上传文件请联系管理员);}else{ListListString dataList PoiUtil.poiImport(file.getPath());//读取xls文件dataList.remove(0);//删除第一行因为第一行是提示for(ListString data:dataList){//循环YonghuEntity yonghuEntity new YonghuEntity();
// yonghuEntity.setUsername(data.get(0)); //账户 要改的
// yonghuEntity.setPassword(123456);//密码
// yonghuEntity.setYonghuUuidNumber(data.get(0)); //学生编号 要改的
// yonghuEntity.setYonghuName(data.get(0)); //学生姓名 要改的
// yonghuEntity.setYonghuPhone(data.get(0)); //学生手机号 要改的
// yonghuEntity.setYonghuIdNumber(data.get(0)); //学生身份证号 要改的
// yonghuEntity.setYonghuPhoto();//详情和图片
// yonghuEntity.setSexTypes(Integer.valueOf(data.get(0))); //性别 要改的
// yonghuEntity.setYonghuEmail(data.get(0)); //学生邮箱 要改的
// yonghuEntity.setCreateTime(date);//时间yonghuList.add(yonghuEntity);//把要查询是否重复的字段放入map中//账户if(seachFields.containsKey(username)){ListString username seachFields.get(username);username.add(data.get(0));//要改的}else{ListString username new ArrayList();username.add(data.get(0));//要改的seachFields.put(username,username);}//学生编号if(seachFields.containsKey(yonghuUuidNumber)){ListString yonghuUuidNumber seachFields.get(yonghuUuidNumber);yonghuUuidNumber.add(data.get(0));//要改的}else{ListString yonghuUuidNumber new ArrayList();yonghuUuidNumber.add(data.get(0));//要改的seachFields.put(yonghuUuidNumber,yonghuUuidNumber);}//学生手机号if(seachFields.containsKey(yonghuPhone)){ListString yonghuPhone seachFields.get(yonghuPhone);yonghuPhone.add(data.get(0));//要改的}else{ListString yonghuPhone new ArrayList();yonghuPhone.add(data.get(0));//要改的seachFields.put(yonghuPhone,yonghuPhone);}//学生身份证号if(seachFields.containsKey(yonghuIdNumber)){ListString yonghuIdNumber seachFields.get(yonghuIdNumber);yonghuIdNumber.add(data.get(0));//要改的}else{ListString yonghuIdNumber new ArrayList();yonghuIdNumber.add(data.get(0));//要改的seachFields.put(yonghuIdNumber,yonghuIdNumber);}}//查询是否重复//账户ListYonghuEntity yonghuEntities_username yonghuService.selectList(new EntityWrapperYonghuEntity().in(username, seachFields.get(username)));if(yonghuEntities_username.size() 0 ){ArrayListString repeatFields new ArrayList();for(YonghuEntity s:yonghuEntities_username){repeatFields.add(s.getUsername());}return R.error(511,数据库的该表中的 [账户] 字段已经存在 存在数据为:repeatFields.toString());}//学生编号ListYonghuEntity yonghuEntities_yonghuUuidNumber yonghuService.selectList(new EntityWrapperYonghuEntity().in(yonghu_uuid_number, seachFields.get(yonghuUuidNumber)));if(yonghuEntities_yonghuUuidNumber.size() 0 ){ArrayListString repeatFields new ArrayList();for(YonghuEntity s:yonghuEntities_yonghuUuidNumber){repeatFields.add(s.getYonghuUuidNumber());}return R.error(511,数据库的该表中的 [学生编号] 字段已经存在 存在数据为:repeatFields.toString());}//学生手机号ListYonghuEntity yonghuEntities_yonghuPhone yonghuService.selectList(new EntityWrapperYonghuEntity().in(yonghu_phone, seachFields.get(yonghuPhone)));if(yonghuEntities_yonghuPhone.size() 0 ){ArrayListString repeatFields new ArrayList();for(YonghuEntity s:yonghuEntities_yonghuPhone){repeatFields.add(s.getYonghuPhone());}return R.error(511,数据库的该表中的 [学生手机号] 字段已经存在 存在数据为:repeatFields.toString());}//学生身份证号ListYonghuEntity yonghuEntities_yonghuIdNumber yonghuService.selectList(new EntityWrapperYonghuEntity().in(yonghu_id_number, seachFields.get(yonghuIdNumber)));if(yonghuEntities_yonghuIdNumber.size() 0 ){ArrayListString repeatFields new ArrayList();for(YonghuEntity s:yonghuEntities_yonghuIdNumber){repeatFields.add(s.getYonghuIdNumber());}return R.error(511,数据库的该表中的 [学生身份证号] 字段已经存在 存在数据为:repeatFields.toString());}yonghuService.insertBatch(yonghuList);return R.ok();}}}}catch (Exception e){e.printStackTrace();return R.error(511,批量插入数据异常请联系管理员);}}/*** 登录*/IgnoreAuthRequestMapping(value /login)public R login(String username, String password, String captcha, HttpServletRequest request) {YonghuEntity yonghu yonghuService.selectOne(new EntityWrapperYonghuEntity().eq(username, username));if(yonghunull || !yonghu.getPassword().equals(password))return R.error(账号或密码不正确);String token tokenService.generateToken(yonghu.getId(),username, yonghu, 学生);R r R.ok();r.put(token, token);r.put(role,学生);r.put(username,yonghu.getYonghuName());r.put(tableName,yonghu);r.put(userId,yonghu.getId());return r;}/*** 注册*/IgnoreAuthPostMapping(value /register)public R register(RequestBody YonghuEntity yonghu, HttpServletRequest request) {
// ValidatorUtils.validateEntity(user);WrapperYonghuEntity queryWrapper new EntityWrapperYonghuEntity().eq(username, yonghu.getUsername()).or().eq(yonghu_phone, yonghu.getYonghuPhone()).or().eq(yonghu_id_number, yonghu.getYonghuIdNumber());YonghuEntity yonghuEntity yonghuService.selectOne(queryWrapper);if(yonghuEntity ! null)return R.error(账户或者学生手机号或者学生身份证号已经被使用);yonghu.setYonghuUuidNumber(String.valueOf(new Date().getTime()));yonghu.setCreateTime(new Date());yonghuService.insert(yonghu);return R.ok();}/*** 重置密码*/GetMapping(value /resetPassword)public R resetPassword(Integer id, HttpServletRequest request) {YonghuEntity yonghu yonghuService.selectById(id);yonghu.setPassword(123456);yonghuService.updateById(yonghu);return R.ok();}/*** 修改密码*/GetMapping(value /updatePassword)public R updatePassword(String oldPassword, String newPassword, HttpServletRequest request) {YonghuEntity yonghu yonghuService.selectById((Integer)request.getSession().getAttribute(userId));if(newPassword null){return R.error(新密码不能为空) ;}if(!oldPassword.equals(yonghu.getPassword())){return R.error(原密码输入错误);}if(newPassword.equals(yonghu.getPassword())){return R.error(新密码不能和原密码一致) ;}yonghu.setPassword(newPassword);yonghuService.updateById(yonghu);return R.ok();}/*** 忘记密码*/IgnoreAuthRequestMapping(value /resetPass)public R resetPass(String username, HttpServletRequest request) {YonghuEntity yonghu yonghuService.selectOne(new EntityWrapperYonghuEntity().eq(username, username));if(yonghu!null){yonghu.setPassword(123456);yonghuService.updateById(yonghu);return R.ok();}else{return R.error(账号不存在);}}/*** 获取用户的session用户信息*/RequestMapping(/session)public R getCurrYonghu(HttpServletRequest request){Integer id (Integer)request.getSession().getAttribute(userId);YonghuEntity yonghu yonghuService.selectById(id);if(yonghu !null){//entity转viewYonghuView view new YonghuView();BeanUtils.copyProperties( yonghu , view );//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 退出*/GetMapping(value logout)public R logout(HttpServletRequest request) {request.getSession().invalidate();return R.ok(退出成功);}/*** 前端列表*/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(list方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));CommonUtil.checkMap(params);PageUtils page yonghuService.queryPage(params);//字典表数据转换ListYonghuView list (ListYonghuView)page.getList();for(YonghuView c:list)dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段return R.ok().put(data, page);}/*** 前端详情*/RequestMapping(/detail/{id})public R detail(PathVariable(id) Integer id, HttpServletRequest request){logger.debug(detail方法:,,Controller:{},,id:{},this.getClass().getName(),id);YonghuEntity yonghu yonghuService.selectById(id);if(yonghu !null){//entity转viewYonghuView view new YonghuView();BeanUtils.copyProperties( yonghu , view );//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody YonghuEntity yonghu, HttpServletRequest request){logger.debug(add方法:,,Controller:{},,yonghu:{},this.getClass().getName(),yonghu.toString());WrapperYonghuEntity queryWrapper new EntityWrapperYonghuEntity().eq(username, yonghu.getUsername()).or().eq(yonghu_phone, yonghu.getYonghuPhone()).or().eq(yonghu_id_number, yonghu.getYonghuIdNumber())
// .notIn(yonghu_types, new Integer[]{102});logger.info(sql语句:queryWrapper.getSqlSegment());YonghuEntity yonghuEntity yonghuService.selectOne(queryWrapper);if(yonghuEntitynull){yonghu.setCreateTime(new Date());yonghu.setPassword(123456);yonghuService.insert(yonghu);return R.ok();}else {return R.error(511,账户或者学生手机号或者学生身份证号已经被使用);}}}
5.2 学生管理Service模块
package com.service;import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.YonghuEntity;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.lang.Nullable;
import java.util.List;/*** 学生 服务类*/
public interface YonghuService extends IServiceYonghuEntity {/*** param params 查询参数* return 带分页的查询出来的数据*/PageUtils queryPage(MapString, Object params);}
5.3 学生管理ServiceImpl模块
package com.service.impl;import com.utils.StringUtil;
import com.service.DictionaryService;
import com.utils.ClazzDiff;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.lang.reflect.Field;
import java.util.*;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import org.springframework.transaction.annotation.Transactional;
import com.utils.PageUtils;
import com.utils.Query;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import org.springframework.lang.Nullable;
import org.springframework.util.Assert;
import com.dao.YonghuDao;
import com.entity.YonghuEntity;
import com.service.YonghuService;
import com.entity.view.YonghuView;/*** 学生 服务实现类*/
Service(yonghuService)
Transactional
public class YonghuServiceImpl extends ServiceImplYonghuDao, YonghuEntity implements YonghuService {Overridepublic PageUtils queryPage(MapString,Object params) {PageYonghuView page new QueryYonghuView(params).getPage();page.setRecords(baseMapper.selectListView(page,params));return new PageUtils(page);}}5.4 学生管理Dao模块
package com.dao;import com.entity.YonghuEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;import org.apache.ibatis.annotations.Param;
import com.entity.view.YonghuView;/*** 学生 Dao 接口** author */
public interface YonghuDao extends BaseMapperYonghuEntity {ListYonghuView selectListView(Pagination page,Param(params)MapString,Object params);}6、论文目录结构 7、源码获取 感谢大家的阅读如有不懂的问题可以评论区交流或私聊! 喜欢文章可以点赞、收藏、关注、评论啦 →获取源码请私信←
