JSPssh药品进销存管理系统ssh框架 MVC模式myeclipse开发mysql数据库

package com.action; import java.util.ArrayList; import java.util.List; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; import com.bean.yonghu; import com.bean.yuangong; import com.dao.yonghuDao; import com.dao.yuangongDao; /* 对用户功能进行维护 */ @SuppressWarnings("serial") public class yonghuAction extends ActionSupport { private static final long serialVersionUID = 1L; private yonghuDao dao=null; private yuangongDao ygdao=null;//员工dao private yonghu yonghu=new yonghu();////对用户进行管理bean private List<yonghu> yonghus=new ArrayList<yonghu>();//对用户进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public yonghu getYonghu() { return yonghu; } public yuangongDao getYgdao() { return ygdao; } public void setYgdao(yuangongDao ygdao) { this.ygdao = ygdao; } public void setDao(yonghuDao dao) { this.dao = dao; } public void setYonghu(yonghu yonghu) { this.yonghu = yonghu; } public List<yonghu> getYonghus() { return yonghus; } public String out() { ServletActionContext.getRequest().getSession().removeAttribute("yhm"); ServletActionContext.getRequest().getSession().removeAttribute("mm"); ServletActionContext.getRequest().getSession().removeAttribute("yonghu"); return "login"; } public String execute() {//默认用户功能 添加 暂时留空 return ""; } public String addPage(){ //用户添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "yonghuaddPage"; } public String add() {//对表yonghu进行添加操作 try{ dao.addyonghu(yonghu); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); return "yonghuadd"; } public String login(){ String yhm=ServletActionContext.getRequest().getParameter("yhm").toString(); String pwd=ServletActionContext.getRequest().getParameter("pwd").toString(); String qx=ServletActionContext.getRequest().getParameter("qx").toString(); System.out.println("yhm="+yhm); System.out.println("pwd=="+pwd); System.out.println("qx=="+qx); if(qx.equals("管理员")){ String hql="from yonghu where yhm='"+yhm+"' and mm='"+pwd+"'"; yonghu u=dao.getyonghu(hql); if(u!=null) { ServletActionContext.getRequest().getSession().setAttribute("yhid", u.getYhid()); ServletActionContext.getRequest().getSession().setAttribute("yhm", yhm); ServletActionContext.getRequest().getSession().setAttribute("mm", u.getMm()); ServletActionContext.getRequest().getSession().setAttribute("qx", "管理员"); return "index"; } else { ServletActionContext.getRequest().setAttribute("msg", "<script>alert('用户名或者密码输入不正确');</script>"); return "login"; } }else if(qx.equals("员工")){ String sql=" from yuangong where yhm='"+yhm+"' and mm='"+pwd+"'"; yuangong c=ygdao.getyuangong(sql); if(c!=null){ ServletActionContext.getRequest().getSession().setAttribute("yhid", c.getYgid()); ServletActionContext.getRequest().getSession().setAttribute("yhm", yhm); ServletActionContext.getRequest().getSession().setAttribute("mm", pwd); ServletActionContext.getRequest().getSession().setAttribute("qx", "员工"); return "index"; }else{ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('用户名或者密码输入不正确');</script>"); return "login"; } }else { return "login"; } } public String list() {//对用户进行管理 对表yonghu进行查询 try{ yonghus=dao.getyonghus(" from yonghu where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "yonghulist"; } public String del() {//对用户进行删除 对表yonghu进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); yonghu tempbean=dao.getyonghu("from yonghu where yhid="+keyid); try{ dao.delyonghu(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对用户修改页面 对表yonghu进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ yonghu=dao.getyonghu("from yonghu where yhid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yonghumodPage"; } public String pwd(){ ////对用户修改页面密码修改 String yhid=ServletActionContext.getRequest().getParameter("yhid").toString(); String mm=ServletActionContext.getRequest().getParameter("new1").toString(); String qx=ServletActionContext.getRequest().getParameter("qx").toString(); try{ if(qx.equals("管理员")){ yonghu=dao.getyonghu("from yonghu where yhid="+yhid); yonghu.setMm(mm); dao.modifyyonghu(yonghu); } if(qx.equals("员工")){ yuangong bean=new yuangong(); bean=ygdao.getyuangong("from yuangong where ygid="+yhid); bean.setMm(mm); ygdao.modifyyuangong(bean); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('密码成功');</script>"); // yonghu=dao.getyonghu("from yonghu where yhid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yonghupwd"; } public String mod(){ ////对用户进行修改操作 对表yonghu进行修改 try{ dao.modifyyonghu(yonghu); }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; } }