JSP+MYSQL SSH房屋中介系统

package com.action; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.ServletActionContext; import com.dao.TChushouDAO; import com.dao.TChuzuDAO; import com.dao.TUserDAO; import com.model.TChushou; import com.model.TChuzu; import com.model.TUser; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; import com.util.Pagesize; import com.util.Pagination; public class chushouAction extends ActionSupport { private Integer id; private String huxing; private int mianji; private String zhuangxiu; private int jiage; private String dizhi; private String lianxiren; private String lianxihua; private String fujian; private String fabushi; private String zt; private TChushouDAO chushouDAO; public String chushouAdd() { HttpServletRequest request=ServletActionContext.getRequest(); TUser user=(TUser)(request.getSession().getAttribute("user")); TChushou chushou=new TChushou(); chushou.setHuxing(huxing); chushou.setMianji(mianji); chushou.setZhuangxiu(zhuangxiu); chushou.setJiage(jiage); chushou.setDizhi(dizhi); chushou.setLianxiren(lianxiren); chushou.setLianxihua(lianxihua); chushou.setFujian(fujian); chushou.setFabushi(fabushi); chushou.setZt("等待审核"); chushou.setUserId(user.getUserId()); chushouDAO.save(chushou); request.setAttribute("msg", "信息发布完毕，等待管理员审核"); return "msg"; } public String chushou_mana_user() { HttpServletRequest request=ServletActionContext.getRequest(); TUser user=(TUser)(request.getSession().getAttribute("user")); String sql="from TChushou where userId="+user.getUserId()+" order by fabushi"; List chushouList=chushouDAO.getHibernateTemplate().find(sql); request.setAttribute("chushouList", chushouList); return ActionSupport.SUCCESS; } public String chushou_mana_admin() { String sql="from TChushou order by fabushi"; List chushouList=chushouDAO.getHibernateTemplate().find(sql); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("chushouList", chushouList); return ActionSupport.SUCCESS; } public String chushouShenhe() { TChushou chushou=chushouDAO.findById(id); chushou.setZt(zt); chushouDAO.attachDirty(chushou); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("msg", "信息审核完毕"); return "msg"; } public String chushouDel() { TChushou chushou=chushouDAO.findById(id); chushouDAO.delete(chushou); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("msg", "信息删除完毕"); return "msg"; } public String chushou_all() { HttpServletRequest request=ServletActionContext.getRequest(); String sql="from TChushou where zt='审核通过' order by fabushi"; List chushouList=chushouDAO.getHibernateTemplate().find(sql); int index=0; if(request.getParameter("index")==null) { index=1; } else { index=Integer.parseInt(request.getParameter("index")); } int fromIndex = (index - 1) * Pagesize.size; int toIndex = Math.min(fromIndex + Pagesize.size, chushouList.size()); List chushouList1 = chushouList.subList(fromIndex, toIndex); Pagination p = new Pagination();//创建 分页对象 p.setIndex(index);//设置页数 p.setPageSize(Pagesize.size); p.setTotle(chushouList.size());//设置总共的条数 p.setData(chushouList1);//设置数据 request.setAttribute("page", p); return ActionSupport.SUCCESS; } public String chushou_detail_qian() { TChushou chushou=chushouDAO.findById(id); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("chushou", chushou); return ActionSupport.SUCCESS; } public String chushou_search() { String sql="from TChushou where huxing like '%"+huxing.trim()+"%'"+" and dizhi like '%"+dizhi.trim()+"%'"; List chushouList=chushouDAO.getHibernateTemplate().find(sql); HttpServletRequest request=ServletActionContext.getRequest(); request.setAttribute("chushouList", chushouList); return ActionSupport.SUCCESS; } public String getDizhi() { return dizhi; } public void setDizhi(String dizhi) { this.dizhi = dizhi; } public TChushouDAO getChushouDAO() { return chushouDAO; } public void setChushouDAO(TChushouDAO chushouDAO) { this.chushouDAO = chushouDAO; } public String getFabushi() { return fabushi; } public void setFabushi(String fabushi) { this.fabushi = fabushi; } public String getFujian() { return fujian; } public void setFujian(String fujian) { this.fujian = fujian; } public String getHuxing() { return huxing; } public void setHuxing(String huxing) { this.huxing = huxing; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getLianxihua() { return lianxihua; } public void setLianxihua(String lianxihua) { this.lianxihua = lianxihua; } public String getLianxiren() { return lianxiren; } public void setLianxiren(String lianxiren) { this.lianxiren = lianxiren; } public int getJiage() { return jiage; } public void setJiage(int jiage) { this.jiage = jiage; } public int getMianji() { return mianji; } public void setMianji(int mianji) { this.mianji = mianji; } public String getZhuangxiu() { return zhuangxiu; } public void setZhuangxiu(String zhuangxiu) { this.zhuangxiu = zhuangxiu; } public String getZt() { return zt; } public void setZt(String zt) { this.zt = zt; } }