基于javaweb和mysql的ssm+maven学生信息管理系统(java+ssm+jsp+mysql+maven)

私信源码获取及调试交流

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

基于javaweb的SSM+Maven学生信息管理系统(java+ssm+jsp+mysql+maven)

一、项目简述

功能包括: 用户的登录注册,学生信息管理,教师信息管理,班级信 息管理,采用mvcx项目架构,覆盖增删改查,包括学生, 教币班级的信息导出上传导入等等功能。

二、项目运行

环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术: JSP +Spring + SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax + maven等等。

			this.excludeJSP = Arrays.asList(excludesArray);
		}
	}

}

public class StopLoginInterceptor implements HandlerInterceptor {
	
	private List<String> excludeURIS;//白名单:未登录的情况下允许访问
	public List<String> getExcludeURIS() {
		return excludeURIS;
	}

	public void setExcludeURIS(List<String> excludeURIS) {
		this.excludeURIS = excludeURIS;
	}
	public boolean preHandle(HttpServletRequest request,
			HttpServletResponse response, Object handler) throws Exception {
		boolean isok = false;
		//1.获得请求的uri
		String baseuri=request.getRequestURI();
		String projecturi = request.getContextPath();
		String uri = baseuri.replace(projecturi, "");
		
		//2.请求URI是否在白名单中,是则放行,否则判断并拦截
		if(this.excludeURIS.contains(uri)){
			isok = true;
		}else{
		//3.判断session内置对象中是否在suserK-V
			HttpSession session = request.getSession();
			UserOA user= session.getAttribute("userOA")==null?null:(UserOA)session.getAttribute("userOA");
		    if(user != null){
		    	isok = true;
		    }else{
	/*@RequestMapping("Select")
	public ModelAndView getFinan(Integer id) {
		ModelAndView view = new ModelAndView();
		OAStudent list=oaUserdaoBiz.getupdate(id);
		if (list != null) {
			view.addObject("list", list);
			view.setViewName("/StudentUpdate.jsp");
		}
		return view;
	}*/
    //修改Student
    @RequestMapping("Studentupdate")
    public String Studentupdate(Model model, Integer id, int sid, String name, String sex, String age, String tel, String grade) {
        OAStudent bizz = new OAStudent();
        bizz.setId(id);
        bizz.setSid(sid);
        bizz.setName(name);
        bizz.setSex(sex);
        bizz.setAge(age);
        bizz.setTel(tel);
        bizz.setGrade(grade);
        int ret = oaUserdaoBiz.updateStudent(bizz);
        if (ret == 1) {
            model.addAttribute("mywo", "修改成功");
            return "/StudentOAselect";
        }
        return "/StudentOAselect";
    }

    //Class班级查询
    @RequestMapping("ClassOAselect")
    public String ClassSelect(String text3, String text4, Model model, HttpSession session,
                              @RequestParam(value = "pageNo", defaultValue = "1") Integer curPage,
                              @RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize) {
        PageHelper.startPage(curPage, pageSize);
        List<OAClass> list = oaUserdaoBiz.ClassSelect(text3, text4);
        PageInfo<OAClass> pageInfo = new PageInfo<OAClass>(list);
        PagerMySQL<OAClass> pager = new PagerMySQL<OAClass>(
                curPage, pageSize, new Long(pageInfo.getTotal()).intValue());
        pager.setEntitiesList(list);
        if (text3 != null && text4 != null) {
            model.addAttribute("huixianName", text3);
            model.addAttribute("huixianNames", text4);
        }
        session.setAttribute("ggsmd", list);
        model.addAttribute("pagerBooks", pager);
        model.addAttribute("mainPage", "/Class.jsp");
        return "/Class.jsp";
    }

    //删除
    @RequestMapping("deleteClass")
		if(excludes !=null && excludes.length()>0){
			String[] excludesArray = excludes.split(";");
			this.excludeJSP = Arrays.asList(excludesArray);
		}
	}

}

public class StopLoginInterceptor implements HandlerInterceptor {
	
	private List<String> excludeURIS;//白名单:未登录的情况下允许访问
	public List<String> getExcludeURIS() {
		return excludeURIS;
	}

	public void setExcludeURIS(List<String> excludeURIS) {
		this.excludeURIS = excludeURIS;
	}
	public boolean preHandle(HttpServletRequest request,
			HttpServletResponse response, Object handler) throws Exception {
		boolean isok = false;
		//1.获得请求的uri
		String baseuri=request.getRequestURI();
		String projecturi = request.getContextPath();
		String uri = baseuri.replace(projecturi, "");
		
		//2.请求URI是否在白名单中,是则放行,否则判断并拦截
		if(this.excludeURIS.contains(uri)){
			isok = true;
		}else{
		//3.判断session内置对象中是否在suserK-V
			HttpSession session = request.getSession();
			UserOA user= session.getAttribute("userOA")==null?null:(UserOA)session.getAttribute("userOA");
		    if(user != null){
		    	isok = true;
		    }else{
    public String Classupdate(Model model, int id, String password) {
        UserOA bizz = new UserOA();
        bizz.setId(id);
        bizz.setPassword(password);
        int ret = oaUserdaoBiz.UserOAs(bizz);
        if (ret == 1) {
            return "/login.jsp";
        } else {
            return "/PasswordUpdate.jsp";
        }
    }

    /**
     * 下载
     *
     * @param model
     * @param session
     * @return
     */
    @RequestMapping("xiazai")
    public String xiazai(Model model, HttpSession session) {
        List<OAStudent> list = (List<OAStudent>) session
                .getAttribute("ggsmd");
        ExcelTemplate et = ExcelTemplate.getInstance().readTemplateByClasspath(
                "/excel/Students"
                        + ".xls");
        for (OAStudent kcb : list) {
            et.createNewRow();
            et.createCell(kcb.getSid());
            et.createCell(kcb.getName());
            et.createCell(kcb.getSex());
            et.createCell(kcb.getAge());
            et.createCell(kcb.getTel());
            et.createCell(kcb.getGrade());
        }
        Map<String, String> map = new HashMap<String, String>();
        map.put("title", "测试用例标题");
        map.put("date", new Date().toString());
        map.put("dept", "学生基本信息");
        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test1.xls");
        model.addAttribute("msg", "导出成功");
        return "StudentOAselect";
    }
                "/excel/teacher"
                        + ".xls");
        for (TeacherOA kcb : list) {
            et.createNewRow();
            et.createCell(kcb.getTname());
            et.createCell(kcb.getTsex());
            et.createCell(kcb.getTcard());
            et.createCell(kcb.getTadd());
            et.createCell(kcb.getTlesson());
            et.createCell(kcb.getTtext());
        }
        Map<String, String> map = new HashMap<String, String>();
        map.put("title", "测试用例标题");
        map.put("date", new Date().toString());
        map.put("dept", "老师基本信息");
        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test3.xls");
        model.addAttribute("msg", "导出成功");
        return "TeacherSelect";
    }

    @RequestMapping("/Savazhuce")
    public ModelAndView Savezhuce(UserOA userOA, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int rets = oaUserdaoBiz.SavaZhuce(userOA);
        if (rets == 1) {
            modelAndView.addObject("biz", rets);
            model.addAttribute("zhuce", "注册成功");
            modelAndView.setViewName("/login.jsp");
        }
        return modelAndView;
    }

    //Log信息查询
    @RequestMapping("LogOAselect")
    public String getSelectLog(String text7, String text8, Model model, HttpSession session,
                               @RequestParam(value = "pageNo", defaultValue = "1") Integer curPage,
                               @RequestParam(value = "pageSize", defaultValue = "7") Integer pageSize) {
        PageHelper.startPage(curPage, pageSize);
        List<UserLog> list = oaUserdaoBiz.UserLogs(text7, text8);
        if (rets == 1) {
            modelAndView.addObject("biz", rets);
            model.addAttribute("mywo", "保存成功");
            modelAndView.setViewName("/TeacherSelect");
        }
        return modelAndView;
    }

    //修改Student
    @RequestMapping("Teacherupdate")
    public String Teacherupdate(Model model, Integer id, String tid, String tname, String tcard, String tsex, String tlesson, String ttext, String age) {
        TeacherOA bizz = new TeacherOA();
        bizz.setTid(id);
        bizz.setTname(tid);
        bizz.setTcard(tname);
        bizz.setTsex(tcard);
        bizz.setTlesson(tlesson);
        bizz.setTtext(ttext);
        bizz.setTadd(age);
        int ret = oaUserdaoBiz.updateTeacher(bizz);
        if (ret == 1) {
            model.addAttribute("mywo", "修改成功√");
            return "/TeacherSelect";
        }
        return "/TeacherSelect";
    }

    //修改密码
    @RequestMapping("OAUserupdates")
    public String Classupdate(Model model, int id, String password) {
        UserOA bizz = new UserOA();
        bizz.setId(id);
        bizz.setPassword(password);
        int ret = oaUserdaoBiz.UserOAs(bizz);
        if (ret == 1) {
            return "/login.jsp";
        } else {
            return "/PasswordUpdate.jsp";
        }
    }

    /**
     * 下载
     *
     * @param model
     * @param session
     * @return
     */
    @RequestMapping("xiazai")
    public String xiazai(Model model, HttpSession session) {
        List<OAStudent> list = (List<OAStudent>) session
    }

    //教師表出查詢
    @RequestMapping("TeacherSelect")
    public String getSelect(String text5, String text6, Model model, HttpSession session,
                            @RequestParam(value = "pageNo", defaultValue = "1") Integer curPage,
                            @RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize) {
        PageHelper.startPage(curPage, pageSize);
        List<TeacherOA> list = oaUserdaoBiz.TeacherSelect(text5, text6);
        PageInfo<TeacherOA> pageInfo = new PageInfo<TeacherOA>(list);
        PagerMySQL<TeacherOA> pager = new PagerMySQL<TeacherOA>(
                curPage, pageSize, new Long(pageInfo.getTotal()).intValue());
        pager.setEntitiesList(list);
        if (text5 != null && text6 != null) {
            model.addAttribute("huixianName", text5);
            model.addAttribute("huixianNames", text6);
        }
        session.setAttribute("ggsmd", list);
        model.addAttribute("pagerBooks", pager);
        model.addAttribute("mainPage", "/Teacher.jsp");
        return "/Teacher.jsp";
    }

    //删除
    @RequestMapping("deleteTeacher")
    public ModelAndView deleteTeacher(Integer[] tid, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int num = oaUserdaoBiz.deleteTeacher(tid);
        if (num == 1) {
            model.addAttribute("deletes", "删除成功√");
            modelAndView.setViewName("/TeacherSelect");
        }
        return modelAndView;
    }

    //删除
    @RequestMapping("/deletTeachers")
    public String deleteTeachers(Model model, Integer[] tid) {
        int num = oaUserdaoBiz.deleteTeacher(tid);
        if (num == 1) {
            return "/TeacherSelect";
        } else {
            return "/TeacherSelect";
        }
    }

    //添加
                        + ".xls");
        for (OAClass kcb : list) {
            et.createNewRow();
            et.createCell(kcb.getClassid());
            et.createCell(kcb.getClassname());
            et.createCell(kcb.getClassexplain());
        }
        Map<String, String> map = new HashMap<String, String>();
        map.put("title", "测试用例标题");
        map.put("date", new Date().toString());
        map.put("dept", "班级基本信息");
        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test2.xls");
        model.addAttribute("msg", "导出成功");
        return "ClassOAselect";
    }

    /**
     * 下载
     *
     * @param model
     * @param session
     * @return
     */
    @RequestMapping("xiazaiss")
    public String xiazaiss(Model model, HttpSession session) {
        List<TeacherOA> list = (List<TeacherOA>) session
                .getAttribute("ggsmd");
        ExcelTemplate et = ExcelTemplate.getInstance().readTemplateByClasspath(
                "/excel/teacher"
                        + ".xls");
        for (TeacherOA kcb : list) {
            et.createNewRow();
            et.createCell(kcb.getTname());
            et.createCell(kcb.getTsex());
            et.createCell(kcb.getTcard());
            et.createCell(kcb.getTadd());
            et.createCell(kcb.getTlesson());
            et.createCell(kcb.getTtext());
        }
        Map<String, String> map = new HashMap<String, String>();
        map.put("title", "测试用例标题");
        map.put("date", new Date().toString());
        map.put("dept", "老师基本信息");
        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test3.xls");
    @RequestMapping("Allclass")
    public ModelAndView getAllclass() {
        List<OAClass> list = new ArrayList<OAClass>();
        list = oaUserdaoBiz.getAllClass();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("list", list);
        modelAndView.setViewName("Student.jsp");
        return modelAndView;
    }

    @RequestMapping("/kechengbiao")
    public ModelAndView handleFileUpload(@RequestParam("file") MultipartFile file,Model model) {
        ModelAndView modelAndView = new ModelAndView("result");  // Assuming you have a view named "result"
        try {
            List<OAStudent> students = ExcelFileReader.readExcel(file.getInputStream());
            for (OAStudent student : students) {
                int rets = oaUserdaoBiz.saveStudent(student);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        model.addAttribute("mywo", "导入成功");
        modelAndView.setViewName("/StudentOAselect");
        return modelAndView;
    }

}

        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test3.xls");
        model.addAttribute("msg", "导出成功");
        return "TeacherSelect";
    }

    @RequestMapping("/Savazhuce")
    public ModelAndView Savezhuce(UserOA userOA, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int rets = oaUserdaoBiz.SavaZhuce(userOA);
        if (rets == 1) {
            modelAndView.addObject("biz", rets);
            model.addAttribute("zhuce", "注册成功");
            modelAndView.setViewName("/login.jsp");
        }
        return modelAndView;
    }

    //Log信息查询
    @RequestMapping("LogOAselect")
    public String getSelectLog(String text7, String text8, Model model, HttpSession session,
                               @RequestParam(value = "pageNo", defaultValue = "1") Integer curPage,
                               @RequestParam(value = "pageSize", defaultValue = "7") Integer pageSize) {
        PageHelper.startPage(curPage, pageSize);
        List<UserLog> list = oaUserdaoBiz.UserLogs(text7, text8);
        PageInfo<UserLog> pageInfo = new PageInfo<UserLog>(list);
        PagerMySQL<UserLog> pager = new PagerMySQL<UserLog>(
                curPage, pageSize, new Long(pageInfo.getTotal()).intValue());
        pager.setEntitiesList(list);
        if (text7 != null && text8 != null) {
            model.addAttribute("huixianName", text7);
            model.addAttribute("huixianNames", text8);
        }
        model.addAttribute("pagerBooks", pager);
        session.setAttribute("ggsmd", list);
        model.addAttribute("mainPage", "/index.jsp");
        return "/index.jsp";
    }

    //下拉框查询班级
    @RequestMapping("Allclass")
    public ModelAndView getAllclass() {
        List<OAClass> list = new ArrayList<OAClass>();
        list = oaUserdaoBiz.getAllClass();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("list", list);
        modelAndView.setViewName("Student.jsp");
        return modelAndView;
			String[] excludesArray = excludes.split(";");
			this.excludeJSP = Arrays.asList(excludesArray);
		}
	}

}

public class StopLoginInterceptor implements HandlerInterceptor {
	
	private List<String> excludeURIS;//白名单:未登录的情况下允许访问
	public List<String> getExcludeURIS() {
		return excludeURIS;
	}

	public void setExcludeURIS(List<String> excludeURIS) {
		this.excludeURIS = excludeURIS;
	}
	public boolean preHandle(HttpServletRequest request,
			HttpServletResponse response, Object handler) throws Exception {
		boolean isok = false;
		//1.获得请求的uri
		String baseuri=request.getRequestURI();
		String projecturi = request.getContextPath();
		String uri = baseuri.replace(projecturi, "");
		
		//2.请求URI是否在白名单中,是则放行,否则判断并拦截
		if(this.excludeURIS.contains(uri)){
			isok = true;
		}else{
		//3.判断session内置对象中是否在suserK-V
			HttpSession session = request.getSession();
			UserOA user= session.getAttribute("userOA")==null?null:(UserOA)session.getAttribute("userOA");
		    if(user != null){
		    	isok = true;
		    }else{
     * @param model
     * @param session
     * @return
     */
    @RequestMapping("xiazais")
    public String xiazais(Model model, HttpSession session) {
        List<OAClass> list = (List<OAClass>) session
                .getAttribute("ggsmd");
        ExcelTemplate et = ExcelTemplate.getInstance().readTemplateByClasspath(
                "/excel/Class"
                        + ".xls");
        for (OAClass kcb : list) {
            et.createNewRow();
            et.createCell(kcb.getClassid());
            et.createCell(kcb.getClassname());
            et.createCell(kcb.getClassexplain());
        }
        Map<String, String> map = new HashMap<String, String>();
        map.put("title", "测试用例标题");
        map.put("date", new Date().toString());
        map.put("dept", "班级基本信息");
        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test2.xls");
        model.addAttribute("msg", "导出成功");
        return "ClassOAselect";
    }

    /**
     * 下载
     *
     * @param model
     * @param session
     * @return
     */
    @RequestMapping("xiazaiss")
    public String xiazaiss(Model model, HttpSession session) {
        List<TeacherOA> list = (List<TeacherOA>) session
                .getAttribute("ggsmd");
        ExcelTemplate et = ExcelTemplate.getInstance().readTemplateByClasspath(
                "/excel/teacher"
                        + ".xls");
        for (TeacherOA kcb : list) {
            et.createNewRow();
            modelAndView.setViewName("/StudentOAselect");
        }
        return modelAndView;
    }

    //删除
    @RequestMapping("/delet")
    public String getdelete(Model model, Integer[] id) {
        int num = oaUserdaoBiz.deleteStudent(id);
        if (num == 1) {
            return "/StudentOAselect";
        } else {
            return "/StudentOAselect";
        }
    }

    //添加
    @RequestMapping("saveStudent")
    public ModelAndView saveStudent(OAStudent oaStudent, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int rets = oaUserdaoBiz.saveStudent(oaStudent);
        if (rets == 1) {
            modelAndView.addObject("oaUserdaoBiz", oaUserdaoBiz);
            model.addAttribute("mywo", "保存成功");
            modelAndView.setViewName("/StudentOAselect");
        }
        return modelAndView;
    }

    //修改传值
	/*@RequestMapping("Select")
	public ModelAndView getFinan(Integer id) {
		ModelAndView view = new ModelAndView();
		OAStudent list=oaUserdaoBiz.getupdate(id);
		if (list != null) {
			view.addObject("list", list);
			view.setViewName("/StudentUpdate.jsp");
		}
		return view;
	}*/
    //修改Student
    @RequestMapping("Studentupdate")
    public String Studentupdate(Model model, Integer id, int sid, String name, String sex, String age, String tel, String grade) {
        OAStudent bizz = new OAStudent();
        bizz.setId(id);
        bizz.setSid(sid);
        bizz.setName(name);
            modelAndView.setViewName("/StudentOAselect");
        }
        return modelAndView;
    }

    //删除
    @RequestMapping("/delet")
    public String getdelete(Model model, Integer[] id) {
        int num = oaUserdaoBiz.deleteStudent(id);
        if (num == 1) {
            return "/StudentOAselect";
        } else {
            return "/StudentOAselect";
        }
    }

    //添加
    @RequestMapping("saveStudent")
    public ModelAndView saveStudent(OAStudent oaStudent, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int rets = oaUserdaoBiz.saveStudent(oaStudent);
        if (rets == 1) {
            modelAndView.addObject("oaUserdaoBiz", oaUserdaoBiz);
            model.addAttribute("mywo", "保存成功");
            modelAndView.setViewName("/StudentOAselect");
        }
        return modelAndView;
    }

    //修改传值
	/*@RequestMapping("Select")
	public ModelAndView getFinan(Integer id) {
		ModelAndView view = new ModelAndView();
		OAStudent list=oaUserdaoBiz.getupdate(id);
		if (list != null) {
			view.addObject("list", list);
			view.setViewName("/StudentUpdate.jsp");
		}
		return view;
	}*/
    //修改Student
    @RequestMapping("Studentupdate")
    public String Studentupdate(Model model, Integer id, int sid, String name, String sex, String age, String tel, String grade) {
        OAStudent bizz = new OAStudent();
        UserOA bizz = new UserOA();
        bizz.setId(id);
        bizz.setPassword(password);
        int ret = oaUserdaoBiz.UserOAs(bizz);
        if (ret == 1) {
            return "/login.jsp";
        } else {
            return "/PasswordUpdate.jsp";
        }
    }

    /**
     * 下载
     *
     * @param model
     * @param session
     * @return
     */
    @RequestMapping("xiazai")
    public String xiazai(Model model, HttpSession session) {
        List<OAStudent> list = (List<OAStudent>) session
                .getAttribute("ggsmd");
        ExcelTemplate et = ExcelTemplate.getInstance().readTemplateByClasspath(
                "/excel/Students"
                        + ".xls");
        for (OAStudent kcb : list) {
            et.createNewRow();
            et.createCell(kcb.getSid());
            et.createCell(kcb.getName());
            et.createCell(kcb.getSex());
            et.createCell(kcb.getAge());
            et.createCell(kcb.getTel());
            et.createCell(kcb.getGrade());
        }
        Map<String, String> map = new HashMap<String, String>();
        map.put("title", "测试用例标题");
        map.put("date", new Date().toString());
        map.put("dept", "学生基本信息");
        et.replaceFinalData(map);
        et.insertSer();
        et.writeToFile("E:\\test1.xls");

public class StopJSPFilter implements Filter {
private List<String> excludeJSP;//白名单:未登录的情况下允许访问
	
	public void destroy() {
		// TODO Auto-generated method stub
		
	}

	public void doFilter(ServletRequest arg0, ServletResponse arg1,
			FilterChain chain) throws IOException, ServletException {
				
		HttpServletRequest request = (HttpServletRequest)arg0;
		HttpServletResponse response = (HttpServletResponse)arg1;
		//1.获得请求的uri
		String baseuri=request.getRequestURI();
		String projecturi = request.getContextPath();
		String uri = baseuri.replace(projecturi, "");
		
		if(this.excludeJSP.contains(uri)){
			chain.doFilter(arg0, arg1);
		}else{
			HttpSession session = request.getSession();
			UserOA users=session.getAttribute("userOA")==null?null:(UserOA)session.getAttribute("userOA");
		    if(users != null){
		    	chain.doFilter(arg0, arg1);
		    }else{
		    	//放置“提示信息”
		    	session.setAttribute("errmsg", "会话异常,请重新登录!!");
		    	response.sendRedirect(projecturi+"/login.jsp");
		    }
		}
	}

	public void init(FilterConfig filterConfig) throws ServletException {
		//完成“白名单”的赋值
    @RequestMapping("/logindos")
    public ModelAndView oaLogin(HttpServletRequest request, UserOA userOA, Model model, HttpSession session) {
        ModelAndView modelAndView = new ModelAndView();
        UserOA userOAs = oaUserdaoBiz.OaLogin(userOA);
        String pwd = userOA.getPassword();
        session.setAttribute("password", pwd);
        if (userOAs != null) {
            session.setAttribute("id", userOAs.getId());
            session.setAttribute("userOA", userOA);
            modelAndView.addObject("userOA", userOAs);
            modelAndView.addObject("mainpage", null);
            modelAndView.setViewName("/LogOAselect");
        } else {
            request.setAttribute("error", "请输入正确的用户名或密码!");
            modelAndView.setViewName("/login.jsp");
        }
        return modelAndView;
    }

    //按班级查询所有学生
    @RequestMapping("AllStduentclass")
    public String AllStudent(String one, String two, Model model, Integer id,
                             @RequestParam(value = "pageNo", defaultValue = "1") Integer curPage,
                             @RequestParam(value = "pageSize", defaultValue = "20") Integer pageSize) {
        PageHelper.startPage(curPage, pageSize);
        List<OAStudent> list = oaUserdaoBiz.AllclassStudent(one, two, id);
        PageInfo<OAStudent> pageInfo = new PageInfo<OAStudent>(list);
        PagerMySQL<OAStudent> pager = new PagerMySQL<OAStudent>(
                curPage, pageSize, new Long(pageInfo.getTotal()).intValue());
        pager.setEntitiesList(list);
        if (one != null && two != null) {
            model.addAttribute("huixianName", one);
            model.addAttribute("huixianNames", two);
        }
        model.addAttribute("pagerBooks", pager);
        model.addAttribute("mainPage", "/AllStudent.jsp");
        return "/AllStudent.jsp";
    }

    //Student信息查询
    @RequestMapping("StudentOAselect")
    public String getSelectMess(String text1, String text2, Model model, HttpSession session,
                                @RequestParam(value = "pageNo", defaultValue = "1") Integer curPage,
                                @RequestParam(value = "pageSize", defaultValue = "7") Integer pageSize) {
        PageHelper.startPage(curPage, pageSize);
                curPage, pageSize, new Long(pageInfo.getTotal()).intValue());
        pager.setEntitiesList(list);
        if (text1 != null && text2 != null) {
            model.addAttribute("huixianName", text1);
            model.addAttribute("huixianNames", text2);
        }
        model.addAttribute("pagerBooks", pager);
        session.setAttribute("ggsmd", list);
        model.addAttribute("mainPage", "/Student.jsp");
        return "/Student.jsp";
    }

    //删除
    @RequestMapping("deleteStudent")
    public ModelAndView deleteStudent(Integer[] id, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int num = oaUserdaoBiz.deleteStudent(id);
        if (num == 1) {
            model.addAttribute("deletes", "删除成功√");
            modelAndView.setViewName("/StudentOAselect");
        }
        return modelAndView;
    }

    //删除
    @RequestMapping("/delet")
    public String getdelete(Model model, Integer[] id) {
        int num = oaUserdaoBiz.deleteStudent(id);
        if (num == 1) {
            return "/StudentOAselect";
        } else {
            return "/StudentOAselect";
        }
    }

    //添加
    @RequestMapping("saveStudent")
    public ModelAndView saveStudent(OAStudent oaStudent, Model model) {
        ModelAndView modelAndView = new ModelAndView();
        int rets = oaUserdaoBiz.saveStudent(oaStudent);
        if (rets == 1) {
            modelAndView.addObject("oaUserdaoBiz", oaUserdaoBiz);
            model.addAttribute("mywo", "保存成功");
            modelAndView.setViewName("/StudentOAselect");
        }
        return modelAndView;
    }

    //修改传值
	/*@RequestMapping("Select")
	public ModelAndView getFinan(Integer id) {
		ModelAndView view = new ModelAndView();
		OAStudent list=oaUserdaoBiz.getupdate(id);

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

Logo

汇聚全球AI编程工具,助力开发者即刻编程。

更多推荐