源码获取:博客首页 "资源" 里下载!
功能介绍:
学生成绩管理系统成绩表
用户管理操作:
/**
* 用户管理操作
*/
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
/**
* 用户添加页面
* @return
*/
@GetMapping("/add")
public String create() {
return "user/add";
}
/**
* 用户添加操作
* @param user
* @return
*/
@PostMapping("/add")
@ResponseBody
public Map<String, Object> add(@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.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().success().getMap();
}
//批量删除
@PostMapping("/delete")
@ResponseBody
public Map<String, Object> delete(String ids) {
int result = userService.delete(ids);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
}
/**
* 编辑用户信息操作
* @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();
}
/**
* 根据id查询,跳转修改页面
* @param id
* @param modelMap
* @return
*/
@GetMapping("/edit/{id}")
public String edit(@PathVariable("id") Integer id, ModelMap modelMap) {
User user = userService.detail(id);
modelMap.addAttribute("user", user);
return "user/edit";
}
//查询所有
@PostMapping("/query")
@ResponseBody
public Map<String, Object> query(@RequestBody User user) {
List<User> list = userService.query(user);
Integer count = userService.count(user);
return MapControl.getInstance().success().page(list, count).getMap();
}
//跳转列表页面
@GetMapping("/list")
public String list() {
return "user/list";
}
}
学生业务操作:
@Controller
@RequestMapping("/student")
public class StudentController {
private static final String LIST = "student/list";
@Autowired
private StudentService studentService;
@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) {
if(StringUtils.isEmpty(student.getStuName())){
return MapControl.getInstance().error("请填写姓名").getMap();
}
if(StringUtils.isEmpty(student.getJoinDate())){
return MapControl.getInstance().error("请填写入学时间").getMap();
}
if(StringUtils.isEmpty(student.getStuPwd())){
return MapControl.getInstance().error("请填写密码").getMap();
}
if(StringUtils.isEmpty(student.getCardNo())){
return MapControl.getInstance().error("请填写身份证号").getMap();
}
if(StringUtils.isEmpty(student.getPhone())){
return MapControl.getInstance().error("请填写手机号码").getMap();
}
Integer maxId = studentService.maxId();
if(maxId==null){
maxId=0;
}
student.setStuNo(StringUtil.randomNumber("",maxId));
//设置学生的状态
student.setStatus(Student.StatusType.type_1);
int result = studentService.create(student);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
}
//根据id查询
@PostMapping("/delete/{id}")
@ResponseBody
public Map<String, Object> delete(@PathVariable("id") Integer id) {
int result = studentService.delete(id);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
}
//删除操作
@PostMapping("/delete")
@ResponseBody
public Map<String, Object> delete(String ids) {
int result = studentService.delete(ids);
if (result <= 0) {
return MapControl.getInstance().error().getMap();
}
return MapControl.getInstance().success().getMap();
}
/**
* 学生修改操作
* @param student
* @return
*/
@PostMapping("/edit")
@ResponseBody
public Map<String, Object> edit(@RequestBody Student student) {
if(StringUtils.isEmpty(student.getStuName())){
return MapControl.getInstance().error("请填写姓名").getMap();
}
if(StringUtils.isEmpty(student.getJoinDate())){
return MapControl.getInstance().error("请填写入学时间").getMap();
}
if(StringUtils.isEmpty(student.getCardNo())){
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")
@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);
}
});
clazzes.forEach(clazz -> {
//判断学生表中的clazzId和班级表的id是否一致
if (clazz.getId() == entity.getClazzId()) {
entity.setClazz(clazz);
}
});
});
//查询总记录条数
Integer count = studentService.count(student);
return MapControl.getInstance().success().page(list, count).getMap();
}
//跳转列表页面
@GetMapping("/list")
public String list() {
return "student/list";
}
//跳转查询学生页面
@GetMapping("/teacher_student")
public String teacher_student(ModelMap modelMap, HttpSession session) {
//查询所有的专业
List<Subject> subjects = subjectService.query(null);
//查询所有的班级
List<Clazz> clazzes = clazzService.query(null);
Teacher teacher = (Teacher) session.getAttribute("user");
modelMap.addAttribute("subjects", subjects);
modelMap.addAttribute("clazzes", clazzes);
modelMap.addAttribute("teacher", teacher);
return "student/teacher_student";
}
//老师查询学生
@PostMapping("/teacher_student")
@ResponseBody
public Map<String, Object> teacher_student(Integer clazzId, Integer subjectId, ModelMap modelMap, HttpSession session) {
Teacher teacher = (Teacher) session.getAttribute("user");
List<Student> students = studentService.queryStudentByTeacher(teacher.getId(), clazzId, subjectId);
List<Subject> subjects = subjectService.query(null);
List<Clazz> clazzes = clazzService.query(null);
//设置关联
students.forEach(entity -> {
subjects.forEach(subject -> {
//判断学生表的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();
}
}
源码获取:博客首页 "资源" 里下载!