小区物业管理系统（含数据库文件）源代码

package action; import java.io.IOException; import java.util.Date; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.Fangchan; import model.Jiaofei; import model.Tousu; import model.User; import model.Weixiu; import model.Zhuhu; import org.apache.struts2.ServletActionContext; import util.Pager; import util.Util; import com.opensymphony.xwork2.ActionSupport; import dao.FangchanDao; import dao.JiaofeiDao; import dao.TousuDao; import dao.UserDao; import dao.WeixiuDao; import dao.ZhuhuDao; public class ManageAction extends ActionSupport{ private static final long serialVersionUID = -4304509122548259589L; private UserDao userDao; private String url = "./"; public UserDao getUserDao() { return userDao; } public void setUserDao(UserDao userDao) { this.userDao = userDao; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } //程序入口界面 public String index(){ HttpServletRequest request = ServletActionContext.getRequest(); Util.init(request); HttpSession session = request.getSession(); User user = (User)session.getAttribute("user"); if(user==null){ return "success2"; }else{ return "success1"; } } //用户登录操作 public String login() throws IOException { HttpServletRequest request = ServletActionContext.getRequest(); String username = request.getParameter("username"); String password = request.getParameter("password"); String role = request.getParameter("role"); User user = userDao.selectBean(" where username = '"+username +"' and password= '"+password +"' and userlock=0 and role="+role); if (user!=null) { HttpSession session = request.getSession(); session.setAttribute("user", user); this.setUrl("index"); return "redirect"; } else { HttpServletResponse response = ServletActionContext.getResponse(); response.setCharacterEncoding("gbk");response.setContentType("text/html; charset=gbk"); response .getWriter() .print( "<script language=javascript>alert('用户名或者密码错误');window.location.href='login.jsp';</script>"); } return null; } //用户退出操作 public String loginout() { HttpServletRequest request = ServletActionContext.getRequest(); HttpSession session = request.getSession(); session.removeAttribute("user"); this.setUrl("login.jsp"); return SUCCESS; } //跳转到修改密码页面 public String changepwd() { this.setUrl("user/password.jsp"); return SUCCESS; } //修改密码操作 public void changepwd2() throws IOException { HttpServletRequest request = ServletActionContext.getRequest(); HttpSession session = request.getSession(); User u = (User)session.getAttribute("user"); String password1 = request.getParameter("password1"); String password2 = request.getParameter("password2"); User bean = userDao.selectBean(" where username= '"+u.getUsername()+"' and password= '"+password1+"'"); if(bean!=null){ bean.setPassword(password2); userDao.updateBean(bean); HttpServletResponse response = ServletActionContext.getResponse(); response.setCharacterEncoding("gbk");response.setContentType("text/html; charset=gbk"); response .getWriter() .print( "<script language=javascript>alert('修改成功');</script>"); }else{ HttpServletResponse response = ServletActionContext.getResponse(); response.setCharacterEncoding("gbk");response.setContentType("text/html; charset=gbk"); response .getWriter() .print( "<script language=javascript>alert('用户名或者密码错误');</script>"); } } private ZhuhuDao zhuhuDao; public ZhuhuDao getZhuhuDao() { return zhuhuDao; } public void setZhuhuDao(ZhuhuDao zhuhuDao) { this.zhuhuDao = zhuhuDao; } //业主列表 public String zhuhulist() { HttpServletRequest request = ServletActionContext.getRequest(); String huzhuxingming = request.getParameter("huzhuxingming"); StringBuffer sb = new StringBuffer(); sb.append(" where "); StringBuffer sb2 = new StringBuffer(); sb2.append(" where "); if(huzhuxingming!=null&&!"".equals(huzhuxingming)){ sb.append("huzhuxingming like '%"+huzhuxingming+"%'"); sb.append(" and "); sb2.append("huzhuxingming like '%"+huzhuxingming+"%'"); sb2.append(" and "); request.setAttribute("huzhuxingming", huzhuxingming); } sb.append(" zhuhulock=0 order by id desc"); String where = sb.toString(); sb2.append(" zhuhulock=0 "); String where2 = sb2.toString(); int currentpage = 1; int pagesize =10; if(request.getParameter("pagenum")!=null){ currentpage = Integer.parseInt(request.getParameter("pagenum")); } int total = zhuhuDao.selectBeanCount(where2); request.setAttribute("list", zhuhuDao.selectBeanList((currentpage - 1) * pagesize, pagesize, where)); request.setAttribute("pagerinfo", Pager.getPagerNormal(total, pagesize, currentpage, "method!zhuhulist", "共有" + total + "条记录")); this.setUrl("zhuhu/zhuhulist.jsp"); return SUCCESS; } //跳转到添加业主页面 public String zhuhuadd() { this.setUrl("zhuhu/zhuhuadd.jsp"); return SUCCESS; } //添加业主操作 public void zhuhuadd2() throws IOException { HttpServletRequest request = ServletActionContext.getRequest(); String username = request.getParameter("username"); String dianhuahaoma = request.getParameter("dianhuahaoma"); String huzhusfz = request.getParameter("huzhusfz"); String huzhuxingming = request.getParameter("huzhuxingming"); String ruzhushijian = request.getParameter("ruzhushijian"); String zhuzhi = request.getParameter("zhuzhi"); User user = userDao.selectBean(" where username='"+username+"' and userlock=0"); if(user!=null){ HttpServletResponse response = ServletActionContext.getResponse(); response.setCharacterEncoding("gbk");response.setContentType("text/html; charset=gbk"); response .getWriter() .print( "<script language=javascript>alert('操作失败，该身份证已经存在');window.location.href='method!zhuhulist';</script>"); return; } Zhuhu bean = new Zhuhu(); bean.setDianhuahaoma(dianhuahaoma); bean.setHuzhusfz(huzhusfz); bean.setHuzhuxingming(huzhuxingming); bean.setRuzhushijian(ruzhushijian); bean.setZhuzhi(zhuzhi); zhuhuDao.insertBean(bean); user = new User(); user.setCreatetime(new Date()); user.setPassword("111111"); user.setTruename(huzhuxingming); user.setUsername(username); user.setZhuhu(bean); userDao.insertBean(user); HttpServletResponse response = ServletActionContext.getResponse(); response.setCharacterEncoding("gbk");response.setContentType("text/html; charset=gbk"); response .getWriter() .print( "<script language=javascript>alert('操作成功');window.location.href='method!zhuhulist';</script>"); } //跳转到更新业主页面 public String zhuhuupdate() { HttpServletRequest request = ServletActionContext.getRequest(); Zhuhu bean = zhuhuDao.selectBean(" where id= "+request.getParameter("id")); request.setAttribute("bean", bean); this.setUrl("zhuhu/zhuhuupdate.jsp"); return SUCCESS; } //更新业主操作 public void zhuhuupdate2() throws IOException { HttpServletRequest request = ServletActionContext.getRequest(); String dianhuahaoma = request.getParameter("dianhuahaoma"); String huzhusfz = request.getParameter("huzhusfz"); String huzhuxingming = request.getParameter("huzhuxingming"); String ruzhushijian = request.getParameter("ruzhushijian"); String zhuzhi = request.getParameter("zhuzhi"); Zhuhu bean = zhuhuDao.selectBean(" where id= "+request.getParamet