Java期末大作业基础项目--在线学生选课系统_javaee期末大作业项目

VALUES (‘1’, ‘C语言程序设计’, ‘1001’, ‘周二’, ‘科401’, ‘18’, ‘必修课’, ‘1’, ‘3’);VALUES (‘3’, ‘数据结构’, ‘1001’, ‘周四’, ‘科401’, ‘18’, ‘必修课’, ‘1’, ‘2’);VALUES (‘5’, ‘英语’, ‘1002’, ‘周四’, ‘X302’, ‘18’, ‘必修课’, ‘2’, ‘2’);t

2401_84181340

984人浏览 · 2024-04-27 02:18:04

2401_84181340 · 2024-04-27 02:18:04 发布

    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行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！**