javaWebssh酒店客房管理系统myeclipse开发mysql数据库MVC模式java编程计算机网页设计源码

package com.action; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import org.apache.struts2.ServletActionContext; import com.opensymphony.xwork2.ActionSupport; import com.util.DBO; import com.bean.yuangong; import com.dao.yuangongDao; /* 对员工功能进行维护 */ @SuppressWarnings("serial") public class yuangongAction extends ActionSupport { private static final long serialVersionUID = 1L; private yuangongDao dao=null; private yuangong yuangong=new yuangong();////对员工进行管理bean private List<yuangong> yuangongs=new ArrayList<yuangong>();//对员工进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public yuangong getYuangong() { return yuangong; } public void setDao(yuangongDao dao) { this.dao = dao; } public void setYuangong(yuangong yuangong) { this.yuangong = yuangong; } public List<yuangong> getYuangongs() { return yuangongs; } public String execute() {//默认员工功能 添加 暂时留空 return ""; } public String addPage(){ //员工添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "yuangongaddPage"; } public String add() {//对表yuangong进行添加操作 String sql=""; ResultSet rs=null; int num=0; DBO db=new DBO(); try{ sql="select count(1) as num from yonghu where yhm='"+yuangong.getYhm()+"'"; rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num>0){ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加失败、用户名重复');</script>"); }else{ dao.addyuangong(yuangong); ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); } }catch(Exception e){ System.out.println(e.toString()); }finally{ db.close(); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); return "yuangongadd"; } public String list() {//对员工进行管理 对表yuangong进行查询 try{ String sql=" from yuangong where 1=1"; String yhm=(String)ServletActionContext.getRequest().getParameter("yhm"); if(yhm!=null&&!yhm.equals("")){ sql+=" and yhm='"+yhm+"'"; } yuangongs=dao.getyuangongs(sql); }catch(Exception e){ System.out.println(e.toString()); } return "yuangonglist"; } public String listp() {//对员工进行管理 对表yuangong进行查询 try{ yuangongs=dao.getyuangongs(" from yuangong where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "yuangonglistp"; } public String del() {//对员工进行删除 对表yuangong进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); yuangong tempbean=dao.getyuangong("from yuangong where ygid="+keyid); try{ dao.delyuangong(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对员工修改页面 对表yuangong进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ yuangong=dao.getyuangong("from yuangong where ygid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yuangongmodPage"; } public String modp(){ ////对员工修改页面 对表yuangong进行修改 String keyid=ServletActionContext.getRequest().getSession().getAttribute("id").toString(); try{ yuangong=dao.getyuangong("from yuangong where ygid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yuangongmodp"; } public String upd(){ ////对员工进行修改操作 对表yuangong进行修改 try{ dao.modifyyuangong(yuangong); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('修改成功');</script>");//location.href='bookmanage'; return modp(); } public String mod(){ ////对员工进行修改操作 对表yuangong进行修改 try{ dao.modifyyuangong(yuangong); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('修改成功');</script>");//location.href='bookmanage'; return list(); } public String detail(){ ////对员工修改页面 对表yuangong进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ yuangong=dao.getyuangong("from yuangong where ygid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "yuangongdetail"; } 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; } }