JSP宿舍管理系统myeclipse开发mysql数据库SH框架编程java语言

package com.action; import java.util.ArrayList; import java.util.List; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; import com.bean.gly; import com.bean.xuesheng; import com.dao.glyDao; import com.dao.xueshengDao; /* 对管理员功能进行维护 */ @SuppressWarnings("serial") public class glyAction extends ActionSupport { private static final long serialVersionUID = 1L; private glyDao dao=new glyDao(); private xueshengDao xsdao=new xueshengDao(); private gly gly=new gly();////对管理员进行管理bean private List<gly> glys=new ArrayList<gly>();//对管理员进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public gly getGly() { return gly; } public void setDao(glyDao dao) { this.dao = dao; } public void setGly(gly gly) { this.gly = gly; } public List<gly> getGlys() { return glys; } public String out() { ServletActionContext.getRequest().getSession().removeAttribute("yhm"); ServletActionContext.getRequest().getSession().removeAttribute("mm"); ServletActionContext.getRequest().getSession().removeAttribute("xm"); return "login"; } public String login(){ String yhm=ServletActionContext.getRequest().getParameter("yhm").toString(); String mm=ServletActionContext.getRequest().getParameter("mm").toString(); String qx=ServletActionContext.getRequest().getParameter("qx").toString(); String sql=""; if(qx.equals("管理员")){ sql=" from gly where yhm='"+yhm+"' and mm='"+mm+"'"; gly u=new gly(); u=dao.getgly(sql); if(u!=null){ ServletActionContext.getRequest().getSession().setAttribute("id", u.getGlyid()); ServletActionContext.getRequest().getSession().setAttribute("yhm", yhm); ServletActionContext.getRequest().getSession().setAttribute("mm", u.getMm()); ServletActionContext.getRequest().getSession().setAttribute("xm", u.getXm()); ServletActionContext.getRequest().getSession().setAttribute("qx", u.getQx()); return "index"; }else { ServletActionContext.getRequest().setAttribute("msg", "<script>alert('用户名或者密码输入不正确');</script>"); return "login"; } }else if(qx.equals("学生")){ sql=" from xuesheng where yhm='"+yhm+"' and mm='"+mm+"'"; xuesheng xs=new xuesheng(); xs=xsdao.getxuesheng(sql); if(xs!=null){ ServletActionContext.getRequest().getSession().setAttribute("id", xs.getXsid()); ServletActionContext.getRequest().getSession().setAttribute("yhm", yhm); ServletActionContext.getRequest().getSession().setAttribute("mm", xs.getMm()); ServletActionContext.getRequest().getSession().setAttribute("xm", xs.getXm()); ServletActionContext.getRequest().getSession().setAttribute("ss", xs.getSs()); ServletActionContext.getRequest().getSession().setAttribute("qx", "学生"); return "index"; }else { ServletActionContext.getRequest().setAttribute("msg", "<script>alert('用户名或者密码输入不正确');</script>"); return "login"; } }else{ return "login"; } // return ""; } public String execute() {//默认管理员功能 添加 暂时留空 return ""; } public String addPage(){ //管理员添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "glyaddPage"; } public String add() {//对表gly进行添加操作 try{ dao.addgly(gly); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); return "glyadd"; } public String list() {//对管理员进行管理 对表gly进行页面查询 int size=10;//分页个数 try{ String hql=" from gly where 1=1"; int count=dao.getglys(hql).size(); pageCount=count%size==0?count/size:(count/size+1); if(pageNum<1) { pageNum=1; }else if(pageNum>pageCount) { pageNum=pageCount; } glys=dao.getglys(hql, pageNum, size); }catch(Exception e){ System.out.println(e.toString()); } return "glylist"; } public String listp() {//对管理员进行管理 对表gly进行查询 try{ glys=dao.getglys(" from gly where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "glylistp"; } public String del() {//对管理员进行删除 对表gly进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); gly tempbean=dao.getgly("from gly where glyid="+keyid); try{ dao.delgly(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对管理员修改页面 对表gly进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ gly=dao.getgly("from gly where glyid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "glymodPage"; } public String detail(){ ////对管理员修改页面 对表gly进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ gly=dao.getgly("from gly where glyid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "glydetail"; } public String mod(){ ////对管理员进行修改操作 对表gly进行修改 try{ dao.modifygly(gly); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('修改成功');</script>");//location.href='bookmanage'; return list(); } public String getKey() { return key; } public void setKey(String key) { this.key = key; } public int getPageNum() { return pageNum; } public void setPageNum(int pageNum) { this.pageNum = pageNum; } public int getPageCount() { return pageCount; } }