基于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等等。
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
.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());
}
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;
}
}
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
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";
}
}
//添加
@RequestMapping("saveTeacher")
public ModelAndView saveTeacher(TeacherOA teacherOA, Model model) {
ModelAndView modelAndView = new ModelAndView();
int rets = oaUserdaoBiz.saveTeacher(teacherOA);
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);
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 {
//完成“白名单”的赋值
String excludes = filterConfig.getInitParameter("excludes");
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;
}
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
int num = oaUserdaoBiz.deleteClass(id);
if (num == 1) {
return "/ClassOAselect";
} else {
return "/ClassOAselect";
}
}
//添加
@RequestMapping("saveClass")
public ModelAndView saveClass(OAClass oaClass, Model model) {
ModelAndView modelAndView = new ModelAndView();
int rets = oaUserdaoBiz.saveClass(oaClass);
if (rets == 1) {
modelAndView.addObject("biz", rets);
model.addAttribute("mywo", "保存成功");
modelAndView.setViewName("/ClassOAselect");
}
return modelAndView;
}
//修改传值
/* @RequestMapping("Selects")
public ModelAndView getFinans(Integer id) {
ModelAndView view = new ModelAndView();
OAClass list=oaUserdaoBiz.getupdateOAClass(id);
if (list != null) {
view.addObject("list", list);
view.setViewName("/ClassUpdate.jsp");
}
return view;
}*/
//修改Student
@RequestMapping("Classupdate")
public String Classupdate(Model model, Integer id, String classid, String classname, String classexplain) {
OAClass bizz = new OAClass();
bizz.setId(id);
bizz.setClassid(classid);
bizz.setClassname(classname);
bizz.setClassexplain(classexplain);
int ret = oaUserdaoBiz.updateClass(bizz);
if (ret == 1) {
model.addAttribute("mywo", "修改成功√");
@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";
}
}
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);
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";
}
//下拉框查询班级
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);
List<OAStudent> list = oaUserdaoBiz.getSelectMess(text1, text2);
PageInfo<OAStudent> pageInfo = new PageInfo<OAStudent>(list);
PagerMySQL<OAStudent> pager = new PagerMySQL<OAStudent>(
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";
}
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";
}
/**
* 下载
*
* @param model
* @param session
* @return
*/
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")
model.addAttribute("pagerBooks", pager);
model.addAttribute("mainPage", "/Class.jsp");
return "/Class.jsp";
}
//删除
@RequestMapping("deleteClass")
public ModelAndView deleteClass(Integer[] id, Model model) {
ModelAndView modelAndView = new ModelAndView();
int num = oaUserdaoBiz.deleteClass(id);
if (num == 1) {
model.addAttribute("deletes", "删除成功√");
modelAndView.setViewName("/ClassOAselect");
}
return modelAndView;
}
//删除
@RequestMapping("/deletss")
public String getdeletes(Model model, Integer[] id) {
int num = oaUserdaoBiz.deleteClass(id);
if (num == 1) {
return "/ClassOAselect";
} else {
return "/ClassOAselect";
}
}
//添加
@RequestMapping("saveClass")
public ModelAndView saveClass(OAClass oaClass, Model model) {
ModelAndView modelAndView = new ModelAndView();
int rets = oaUserdaoBiz.saveClass(oaClass);
if (rets == 1) {
modelAndView.addObject("biz", rets);
model.addAttribute("mywo", "保存成功");
modelAndView.setViewName("/ClassOAselect");
}
return modelAndView;
}
//修改传值
/* @RequestMapping("Selects")
public ModelAndView getFinans(Integer id) {
ModelAndView view = new ModelAndView();
OAClass list=oaUserdaoBiz.getupdateOAClass(id);
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";
}
}
//添加
@RequestMapping("saveTeacher")
public ModelAndView saveTeacher(TeacherOA teacherOA, Model model) {
ModelAndView modelAndView = new ModelAndView();
int rets = oaUserdaoBiz.saveTeacher(teacherOA);
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);
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);
List<OAStudent> list = oaUserdaoBiz.getSelectMess(text1, text2);
PageInfo<OAStudent> pageInfo = new PageInfo<OAStudent>(list);
PagerMySQL<OAStudent> pager = new PagerMySQL<OAStudent>(
curPage, pageSize, new Long(pageInfo.getTotal()).intValue());
pager.setEntitiesList(list);
if (text1 != null && text2 != null) {
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{
//放置“提示信息”
session.setAttribute("errmsg", "会话异常,请重新登录!");
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");
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());
// 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 {
//完成“白名单”的赋值
String excludes = filterConfig.getInitParameter("excludes");
if(excludes !=null && excludes.length()>0){
String[] excludesArray = excludes.split(";");
this.excludeJSP = Arrays.asList(excludesArray);
}
}
}
@Controller
public class ControllerOA {
private OAUserdaoBiz oaUserdaoBiz;
@Resource(name = "oaUserdaoBiz")
public void setBiz(OAUserdaoBiz oaUserdaoBiz) {
this.oaUserdaoBiz = oaUserdaoBiz;
}
//登录
@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());