基于javaweb的学生选课系统(java+javaweb+jdbc)
功能介绍:
用户菜单、学生管理、教师管理、课程管理、成绩排名查询
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
if(StringUtils.isEmpty(user.getUserName())){
return MapControl.getInstance().error("请填写用户名").getMap();
}
if(StringUtils.isEmpty(user.getName())){
return MapControl.getInstance().error("请填写名称").getMap();
}
if(StringUtils.isEmpty(user.getUserPwd())){
return MapControl.getInstance().error("请填写密码").getMap();
}
int result = userService.create(user);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
}
/**
* 根据id删除
* @param id
* @return
*/
@PostMapping("/delete/{id}")
@ResponseBody
public Map<String, Object> delete(@PathVariable("id") Integer id) {
int result = userService.delete(id);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
return MapControl.getInstance().error("请填写身份证号").getMap();
}
if(StringUtils.isEmpty(student.getPhone())){
return MapControl.getInstance().error("请填写手机号码").getMap();
}
int result = studentService.saveU(student);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
}
//根据id查询,跳转修改页面
@GetMapping("/edit/{id}")
public String detail(@PathVariable("id") Integer id, ModelMap modelMap) {
//查询出要修改的学生的信息
Student student = studentService.detail(id);
//查询所有的专业
List<Subject> subjects = subjectService.query(null);
//将查询出来的数据存储到request域,实现表单回显
modelMap.addAttribute("student", student);
modelMap.addAttribute("subjects", subjects);
return "student/edit";
}
//查询所有
@PostMapping("/query")
//查询出要修改的学生的信息
Student student = studentService.detail(id);
//查询所有的专业
List<Subject> subjects = subjectService.query(null);
//将查询出来的数据存储到request域,实现表单回显
modelMap.addAttribute("student", student);
modelMap.addAttribute("subjects", subjects);
return "student/edit";
}
//查询所有
@PostMapping("/query")
@ResponseBody
public Map<String, Object> query(@RequestBody Student student) {
//查询所有的学生信息
List<Student> list = studentService.query(student);
//查询所有的专业
List<Subject> subjects = subjectService.query(null);
//查询所有的班级
List<Clazz> clazzes = clazzService.query(null);
//设置关联
list.forEach(entity -> {
subjects.forEach(subject -> {
//判断学生表中的subjectId和专业表的id是否一致
if (subject.getId() == entity.getSubjectId()) {
entity.setSubject(subject);
}
});
* 编辑用户信息操作
* @param user
* @return
*/
@PostMapping("/edit")
@ResponseBody
public Map<String, Object> edit(@RequestBody User user) {
if(StringUtils.isEmpty(user.getUserName())){
return MapControl.getInstance().error("请填写用户名").getMap();
}
if(StringUtils.isEmpty(user.getName())){
return MapControl.getInstance().error("请填写名称").getMap();
}
if(StringUtils.isEmpty(user.getUserPwd())){
return MapControl.getInstance().error("请填写密码").getMap();
}
int result = userService.update(user);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
//判断学生表的subjectId和专业表的id是否一致
if (subject.getId() == entity.getSubjectId()) {
entity.setSubject(subject);
}
});
clazzes.forEach(clazz -> {
//判断学生表的clazzId和班级表的id是否一致
if (clazz.getId() == entity.getClazzId()) {
entity.setClazz(clazz);
}
});
});
return MapControl.getInstance().success().add("data", students).getMap();
}
}
用户管理操作:
/**
* 用户管理操作
*/
@Controller
return MapControl.getInstance().success().add("data", user).getMap();
} else {
return MapControl.getInstance().error("用户名或密码错误").getMap();
}
}
if ("2".equals(type)) { //老师验证登录
Teacher teacher = teacherService.login(userName, MD5Utils.getMD5(password));
if (teacher != null) {
session.setAttribute("user", teacher);
session.setAttribute("type", "2");
return MapControl.getInstance().success().add("data", teacher).getMap();
} else {
return MapControl.getInstance().error("用户名或密码错误").getMap();
Teacher teacher = teacherService.login(userName, MD5Utils.getMD5(password));
if (teacher != null) {
session.setAttribute("user", teacher);
session.setAttribute("type", "2");
return MapControl.getInstance().success().add("data", teacher).getMap();
} else {
return MapControl.getInstance().error("用户名或密码错误").getMap();
}
}
if ("3".equals(type)) { //学生验证登录
Student student = studentService.login(userName, MD5Utils.getMD5(password));
if (student != null) {
session.setAttribute("user", student);
session.setAttribute("type", "3");
return MapControl.getInstance().success().add("data", student).getMap();
} else {
return MapControl.getInstance().error("用户名或密码错误").getMap();
}
}
return MapControl.getInstance().getMap();
}
学生管理控制层:
@Autowired
private SubjectService subjectService;
@Autowired
private ClazzService clazzService;
//跳转添加页面
@GetMapping("/add")
public String add(ModelMap modelMap) {
//查询所有的专业,存储到request域
List<Subject> subjects = subjectService.query(null);
modelMap.addAttribute("subjects", subjects);
return "student/add";
}
/**
* 学生添加操作
* @param student
* @return
*/
@PostMapping("/add")
@ResponseBody
public Map<String, Object> add(@RequestBody Student student) {
//判断学生表中的subjectId和专业表的id是否一致
if (subject.getId() == entity.getSubjectId()) {
entity.setSubject(subject);
}
});
clazzes.forEach(clazz -> {
//判断学生表中的clazzId和班级表的id是否一致
if (clazz.getId() == entity.getClazzId()) {
entity.setClazz(clazz);
}
});
});
//查询总记录条数
//查询所有的专业,存储到request域
List<Subject> subjects = subjectService.query(null);
modelMap.addAttribute("subjects", subjects);
return "student/add";
}
/**
* 学生添加操作
* @param student
* @return
*/
@PostMapping("/add")
@ResponseBody
public Map<String, Object> add(@RequestBody Student student) {