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.fangdong; import com.dao.fangdongDao; /* 对房东功能进行维护 */ @SuppressWarnings("serial") public class fangdongAction extends ActionSupport { private static final long serialVersionUID = 1L; private fangdongDao dao=null; private fangdong fangdong=new fangdong();////对房东进行管理bean private List<fangdong> fangdongs=new ArrayList<fangdong>();//对房东进行管理获得结果集返回list private String key=""; private int pageNum=1; private int pageCount=0; public fangdong getFangdong() { return fangdong; } public void setDao(fangdongDao dao) { this.dao = dao; } public void setFangdong(fangdong fangdong) { this.fangdong = fangdong; } public List<fangdong> getFangdongs() { return fangdongs; } public String execute() {//默认房东功能 添加 暂时留空 return ""; } public String addPage(){ //房东添加页面 try{ }catch(Exception e){ System.out.println(e.toString()); } return "fangdongaddPage"; } public String add() {//对表fangdong进行添加操作 DBO db=new DBO(); ResultSet rs=null; int num=0; String sql="select count(1) as num from fangdong where yhm='"+fangdong.getYhm()+"'"; try{ rs=db.query(sql); if(rs.next()){ num=rs.getInt("num"); } if(num>0){ ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加失败、用户名重复');</script>"); }else{ dao.addfangdong(fangdong); ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); } }catch(Exception e){ System.out.println(e.toString()); } // ServletActionContext.getRequest().setAttribute("msg", "<script>alert('添加成功');</script>"); return "fangdongadd"; } public String list() {//对房东进行管理 对表fangdong进行页面查询 int size=10;//分页个数 try{ String hql=" from fangdong where 1=1"; int count=dao.getfangdongs(hql).size(); pageCount=count%size==0?count/size:(count/size+1); if(pageNum<1) { pageNum=1; }else if(pageNum>pageCount) { pageNum=pageCount; } fangdongs=dao.getfangdongs(hql, pageNum, size); }catch(Exception e){ System.out.println(e.toString()); } return "fangdonglist"; } public String listp() {//对房东进行管理 对表fangdong进行查询 try{ fangdongs=dao.getfangdongs(" from fangdong where 1=1"); }catch(Exception e){ System.out.println(e.toString()); } return "fangdonglistp"; } public String del() {//对房东进行删除 对表fangdong进行删除 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); fangdong tempbean=dao.getfangdong("from fangdong where fdid="+keyid); try{ dao.delfangdong(tempbean); }catch(Exception e){ System.out.println(e.toString()); } ServletActionContext.getRequest().setAttribute("msg", "<script>alert('删除成功');</script>"); return list(); } public String modPage(){ ////对房东修改页面 对表fangdong进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ fangdong=dao.getfangdong("from fangdong where fdid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "fangdongmodPage"; } public String detail(){ ////对房东修改页面 对表fangdong进行修改 String keyid=ServletActionContext.getRequest().getParameter("keyid").toString(); try{ fangdong=dao.getfangdong("from fangdong where fdid="+keyid); }catch(Exception e){ System.out.println(e.toString()); } return "fangdongdetail"; } public String mod(){ ////对房东进行修改操作 对表fangdong进行修改 try{ dao.modifyfangdong(fangdong); }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; } }