PagingVO pagingVO = new PagingVO();
//设置总页数。。。。。。。。
pagingVO.setTotalCount(courseService.getCountCouse());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = courseService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = courseService.findByPaging(page);
}
model.addAttribute("courseList", list);
model.addAttribute("pagingVO", pagingVO);
return "admin/showCourse";
}
**教师查询:**
后台数据操作显示、后台封装数据以及分页处理数据
// 教师页面显示。。。。。。
@RequestMapping(“/showTeacher”)
public String showTeacher(Model model, Integer page) throws Exception {
List list = null;
//页码对象。。。。。
PagingVO pagingVO = new PagingVO();
//设置总页数。。。。。。。。。。。。。。
pagingVO.setTotalCount(teacherService.getCountTeacher());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = teacherService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = teacherService.findByPaging(page);
}
model.addAttribute(“teacherList”, list);
model.addAttribute(“pagingVO”, pagingVO);
return “admin/showTeacher”;
}
//获取分页查询老师信息。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
List findByPaging(Integer toPageNo) throws Exception;
**学生信息显示:**
// 学生信息显示。。。。。。。。
@RequestMapping(“/showStudent”)
public String showStudent(Model model, Integer page) throws Exception {
List list = null;
//页码对象。。。。。。。。。。。。。。
PagingVO pagingVO = new PagingVO();
//设置总页数。。。。。。。。。。。
pagingVO.setTotalCount(studentService.getCountStudent());
if (page == null || page == 0) {
pagingVO.setToPageNo(1);
list = studentService.findByPaging(1);
} else {
pagingVO.setToPageNo(page);
list = studentService.findByPaging(page);}
model.addAttribute(“studentList”, list);
model.addAttribute(“pagingVO”, pagingVO);
return “admin/showStudent”;
}
// 添加学生信息操作。。。。。。。
@RequestMapping(value = “/addStudent”, method = {RequestMethod.POST})
public String addStudent(StudentCustom studentCustom, Model model) throws Exception {
Boolean result = studentService.save(studentCustom);
if (!result) {
model.addAttribute(“message”, “学号重复”);
return “error”;
}
//添加成功后,也添加到登录表。。。。。。。。。。。。。。
Userlogin userlogin = new Userlogin();
userlogin.setUsername(studentCustom.getUserid().toString());
userlogin.setPassword(“123”);
userlogin.setRole(2);
userloginService.save(userlogin);
//重定向。。。。。。。。。。
return “redirect:/admin/showStudent”;
}
// 已修课程。。。。。。。。。。。。。。。。。。。。
@RequestMapping(value = “/overCourse”)
public String overCourse(Model model) throws Exception {
//获取当前用户名。。。。。。。。。。
Subject subject = SecurityUtils.getSubject();
StudentCustom studentCustom = studentService.findStudentAndSelectCourseListByName((String) subject.getPrincipal());
if (studentCustom==null){
throw new CustomException(“你还没有修完任何一门课,请先选课学习吧!”);
}
List<SelectedCourseCustom> list = studentCustom.getSelectedCourseList();
model.addAttribute("selectedCourseList", list);
return "student/overCourse";
}
**修改密码:**
// 本账户密码重置。。。。。。。。。。。。。。。。。。。
@RequestMapping(value = “/passwordRest”, method = {RequestMethod.POST})
public String passwordRest(String oldPassword, String password1) throws Exception {
Subject subject = SecurityUtils.getSubject();
String username = (String) subject.getPrincipal();
Userlogin userlogin = userloginService.findByName(username);
if (!oldPassword.equals(userlogin.getPassword())) {
throw new CustomException(“旧密码不正确。。。。。。。”);
} else {
userlogin.setPassword(password1);
userloginService.updateByName(username, userlogin);
}
return “redirect:/logout”;
}
>
> ### **部分数据库设计:**
>
>
>
DROP TABLE IF EXISTS college
;
CREATE TABLE college
(
collegeID
int(11) NOT NULL,
collegeName
varchar(200) NOT NULL COMMENT ‘课程名’,
PRIMARY KEY (collegeID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of college
INSERT INTO college
VALUES (‘1’, ‘计算机系’);
INSERT INTO college
VALUES (‘2’, ‘设计系’);
INSERT INTO college
VALUES (‘3’, ‘财经系’);
– Table structure for course
DROP TABLE IF EXISTS course
;
CREATE TABLE course
(
courseID
int(11) NOT NULL,
courseName
varchar(200) NOT NULL COMMENT ‘课程名称’,
teacherID
int(11) NOT NULL,
courseTime
varchar(200) DEFAULT NULL COMMENT ‘开课时间’,
classRoom
varchar(200) DEFAULT NULL COMMENT ‘开课地点’,
courseWeek
int(200) DEFAULT NULL COMMENT ‘学时’,
courseType
varchar(20) DEFAULT NULL COMMENT ‘课程类型’,
collegeID
int(11) NOT NULL COMMENT ‘所属院系’,
score
int(11) NOT NULL COMMENT ‘学分’,
PRIMARY KEY (courseID
),
KEY collegeID
(collegeID
),
KEY teacherID
(teacherID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of course
INSERT INTO course
VALUES (‘1’, ‘C语言程序设计’, ‘1001’, ‘周二’, ‘科401’, ‘18’, ‘必修课’, ‘1’, ‘3’);
INSERT INTO course
VALUES (‘2’, ‘Python爬虫技巧’, ‘1001’, ‘周四’, ‘X402’, ‘18’, ‘必修课’, ‘1’, ‘3’);
INSERT INTO course
VALUES (‘3’, ‘数据结构’, ‘1001’, ‘周四’, ‘科401’, ‘18’, ‘必修课’, ‘1’, ‘2’);
INSERT INTO course
VALUES (‘4’, ‘Java程序设计’, ‘1002’, ‘周五’, ‘科401’, ‘18’, ‘必修课’, ‘1’, ‘2’);
INSERT INTO course
VALUES (‘5’, ‘英语’, ‘1002’, ‘周四’, ‘X302’, ‘18’, ‘必修课’, ‘2’, ‘2’);
INSERT INTO course
VALUES (‘6’, ‘服装设计’, ‘1003’, ‘周一’, ‘科401’, ‘18’, ‘选修课’, ‘2’, ‘2’);
– Table structure for file
DROP TABLE IF EXISTS file
;
CREATE TABLE file
(
fileID
varchar(100) COLLATE utf8_bin NOT NULL,
fileName
varchar(255) COLLATE utf8_bin DEFAULT NULL,
fileDesc
varchar(255) COLLATE utf8_bin DEFAULT NULL,
filePath
varchar(255) COLLATE utf8_bin DEFAULT NULL,
userID
int(11) DEFAULT NULL,
fileExt1
varchar(255) COLLATE utf8_bin DEFAULT NULL,
fileExt2
varchar(255) COLLATE utf8_bin DEFAULT NULL,
fileExt3
varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (fileID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of file
INSERT INTO file
VALUES (‘3192d10378ea44d88d8b558562a480e3’, ‘理工类模板.docx’, ‘理工类模板.docx’, ‘E://upload/3192d10378ea44d88d8b558562a480e3.docx’, null, null, null, null);
INSERT INTO file
VALUES (‘59c0f03696be4e73a64c7625f1887e88’, ‘测测1231’, ‘十分大师傅十分213’, ‘E://upload/59c0f03696be4e73a64c7625f1887e88.jpg’, null, null, null, null);
INSERT INTO file
VALUES (‘8a1d671ba48f441ead14255e9fda3c96’, ‘测测123’, ‘wrwerwer’, ‘E://upload/8a1d671ba48f441ead14255e9fda3c96.sql’, null, null, null, null);
– Table structure for role
DROP TABLE IF EXISTS role
;
CREATE TABLE role
(
roleID
int(11) NOT NULL,
roleName
varchar(20) NOT NULL,
permissions
varchar(255) DEFAULT NULL COMMENT ‘权限’,
PRIMARY KEY (roleID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of role
INSERT INTO role
VALUES (‘0’, ‘admin’, null);
INSERT INTO role
VALUES (‘1’, ‘teacher’, null);
INSERT INTO role
VALUES (‘2’, ‘student’, null);
– Table structure for selectedcourse
DROP TABLE IF EXISTS selectedcourse
;
CREATE TABLE selectedcourse
(
courseID
int(11) NOT NULL,
studentID
int(11) NOT NULL,
mark
int(11) DEFAULT NULL COMMENT ‘成绩’,
KEY courseID
(courseID
),
KEY studentID
(studentID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of selectedcourse
INSERT INTO selectedcourse
VALUES (‘2’, ‘10001’, ‘12’);
INSERT INTO selectedcourse
VALUES (‘1’, ‘10001’, ‘95’);
INSERT INTO selectedcourse
VALUES (‘1’, ‘10002’, ‘66’);
INSERT INTO selectedcourse
VALUES (‘2’, ‘10003’, ‘99’);
INSERT INTO selectedcourse
VALUES (‘5’, ‘10001’, null);
INSERT INTO selectedcourse
VALUES (‘3’, ‘10001’, null);
INSERT INTO selectedcourse
VALUES (‘1’, ‘10003’, null);
INSERT INTO selectedcourse
VALUES (‘4’, ‘10003’, null);
– Table structure for student
DROP TABLE IF EXISTS student
;
CREATE TABLE student
(
userID
int(11) NOT NULL AUTO_INCREMENT,
userName
varchar(200) NOT NULL,
sex
varchar(20) DEFAULT NULL,
birthYear
date DEFAULT NULL COMMENT ‘出生日期’,
grade
date DEFAULT NULL COMMENT ‘入学时间’,
collegeID
int(11) NOT NULL COMMENT ‘院系id’,
PRIMARY KEY (userID
),
KEY collegeID
(collegeID
)
) ENGINE=InnoDB AUTO_INCREMENT=10006 DEFAULT CHARSET=utf8;
– Records of student
INSERT INTO student
VALUES (‘9999’, ‘mike1’, ‘男’, ‘1996-09-03’, ‘2019-11-13’, ‘3’);
INSERT INTO student
VALUES (‘10001’, ‘小红’, ‘男’, ‘2020-03-02’, ‘2020-03-02’, ‘1’);
INSERT INTO student
VALUES (‘10002’, ‘小绿’, ‘男’, ‘2020-03-10’, ‘2020-03-10’, ‘1’);
INSERT INTO student
VALUES (‘10003’, ‘小陈’, ‘女’, ‘1996-09-02’, ‘2015-09-02’, ‘2’);
INSERT INTO student
VALUES (‘10005’, ‘小左’, ‘女’, ‘1996-09-02’, ‘2015-09-02’, ‘2’);
– Table structure for teacher
DROP TABLE IF EXISTS teacher
;
CREATE TABLE teacher
(
userID
int(11) NOT NULL AUTO_INCREMENT,
userName
varchar(200) NOT NULL,
sex
varchar(20) DEFAULT NULL,
birthYear
date NOT NULL,
degree
varchar(20) DEFAULT NULL COMMENT ‘学历’,
title
varchar(255) DEFAULT NULL COMMENT ‘职称’,
grade
date DEFAULT NULL COMMENT ‘入职时间’,
collegeID
int(11) NOT NULL COMMENT ‘院系’,
PRIMARY KEY (userID
),
KEY collegeID
(collegeID
)
) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8;
– Records of teacher
INSERT INTO teacher
VALUES (‘1001’, ‘刘老师’, ‘女’, ‘1990-03-08’, ‘硕士’, ‘副教授’, ‘2015-09-02’, ‘2’);
INSERT INTO teacher
VALUES (‘1002’, ‘张老师’, ‘女’, ‘1996-09-02’, ‘博士’, ‘讲师’, ‘2015-09-02’, ‘1’);
INSERT INTO teacher
VALUES (‘1003’, ‘软老师’, ‘女’, ‘1996-09-02’, ‘硕士’, ‘助教’, ‘2017-07-07’, ‘1’);
– Table structure for userlogin
DROP TABLE IF EXISTS userlogin
;
CREATE TABLE userlogin
(
userID
int(11) NOT NULL AUTO_INCREMENT,
userName
varchar(200) NOT NULL,
password
varchar(200) NOT NULL,
role
int(11) NOT NULL DEFAULT ‘2’ COMMENT ‘角色权限’,
PRIMARY KEY (userID
),
KEY role
(role
)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
– Records of userlogin
INSERT INTO userlogin
VALUES (‘1’, ‘admin’, ‘123’, ‘0’);
INSERT INTO userlogin
VALUES (‘10’, ‘10003’, ‘123’, ‘2’);
INSERT INTO userlogin
VALUES (‘11’, ‘10005’, ‘123’, ‘2’);
INSERT INTO userlogin
VALUES (‘14’, ‘1001’, ‘123’, ‘1’);
INSERT INTO userlogin
VALUES (‘15’, ‘1002’, ‘123’, ‘1’);
INSERT INTO userlogin
VALUES (‘16’, ‘1003’, ‘123’, ‘1’);
INSERT INTO userlogin
VALUES (‘20’, ‘9999’, ‘123’, ‘2’);
INSERT INTO userlogin
VALUES (‘21’, ‘10001’, ‘123’, ‘2’);
INSERT INTO userlogin
VALUES (‘22’, ‘10002’, ‘123’, ‘2’);
#### **总体来说这个项目适合java大学生用来作为课程设计或者java毕业设计参考使用**
#### **好了、今天就分享到这儿吧,我是小奥、下期见~~**
>
> ### 获取完整源码:
>
![img](https://img-blog.csdnimg.cn/img_convert/ce57f13050b8020e5b803d7f5f6d2ae5.png)
![img](https://img-blog.csdnimg.cn/img_convert/f4b2fcfa1d6345a1202e2288637f04a5.png)
**网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。**
**[需要这份系统化资料的朋友,可以戳这里获取](https://bbs.csdn.net/topics/618545628)**
**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**
取完整源码:
>
[外链图片转存中...(img-HNp4TaLz-1714155466212)]
[外链图片转存中...(img-tfKYRyBd-1714155466213)]
**网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。**
**[需要这份系统化资料的朋友,可以戳这里获取](https://bbs.csdn.net/topics/618545628)**
**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**