基于Java web的小区(社区)人口信息管理系统（源码+数据库+文档+ppt+安装配置说明）.zip

package org.zfz.struts.action; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.PrintWriter; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import org.apache.struts.upload.FormFile; import org.zfz.common.Splitpageinfo; import org.zfz.operate.AllSortInforOperate; import org.zfz.operate.HomePeopleInforOperate; import org.zfz.struts.form.AllSortInforForm; import org.zfz.struts.form.HomePeopleInforForm; public class HomePeopleInforAction extends DispatchAction { // Ajax设值 public ActionForward getValue(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException { List<AllSortInforForm> sortDetailList = new ArrayList<AllSortInforForm>(); String conId = request.getParameter("id"); sortDetailList = HomePeopleInforOperate.getAllSortInforListById(conId); int tmpid, id; tmpid = id = Integer.parseInt(conId.substring(0, 1)); response.setCharacterEncoding("gb2312"); PrintWriter out = response.getWriter(); StringBuffer sb = new StringBuffer(); String[] tag = { "unit", "floor", "siteId" }; String condition = ""; for (int i = tmpid - 4; i <= 2; i++) { AllSortInforForm allSortInforForm = null; if (sortDetailList != null && sortDetailList.size() > 0) allSortInforForm = sortDetailList.get(0); // ------------------------------------------------------------------------ if (tmpid == 6 || id == 6) sb.append("<select name='" + tag[2] + "' onchange='autoEdit()'>"); else if (allSortInforForm != null) { sb.append("<select name='" + tag[i] + "' onchange='setHomeValue(" + allSortInforForm.getSortId() + ",this.value," + (id + 1) + ");autoEdit()'>"); } else { sb.append("<select name='" + tag[i] + "' onchange='autoEdit()'>"); } for (int j = 0; j < sortDetailList.size(); j++) { AllSortInforForm sortDetail = sortDetailList.get(j); sb.append("<option value=" + sortDetail.getSortdetailId() + ">" + sortDetail.getSortdetailName() + "</option>"); } sb.append("</select>"); if (allSortInforForm != null && tmpid != 6 && id != 6) { id++; condition = id + allSortInforForm.getSortId().trim() + allSortInforForm.getSortdetailId().trim(); sortDetailList = AllSortInforOperate .getAllSortInforList(condition); } sb.append("%"); } out.print(sb); out.flush(); out.close(); return null; } // 显示用户信息页面的方法------------------------------------------------------------- public ActionForward firstPage(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { return this.getPage(mapping, request, 1); } public ActionForward upPage(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { return this.getPage(mapping, request, 2); } public ActionForward nextPage(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { return this.getPage(mapping, request, 3); } public ActionForward lastPage(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { return this.getPage(mapping, request, 4); } // 查询 public ActionForward selectHomePeople(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { HomePeopleInforForm homePeopleInforForm = (HomePeopleInforForm) form; HttpSession session = request.getSession(true); String condition = ""; condition += " and A.homeId like '%" + homePeopleInforForm.getHomeId() + "%'"; String buildingNumber = homePeopleInforForm.getBuildingNumber().trim() .length() == 1 ? "0" + homePeopleInforForm.getBuildingNumber().trim() : homePeopleInforForm.getBuildingNumber().trim(); if (buildingNumber.trim().length() > 0) condition += " and substring(A.buildingNumber,1,2) = '" + buildingNumber + "'"; String unit = homePeopleInforForm.getUnit().trim().length() == 1 ? "0" + homePeopleInforForm.getUnit().trim() : homePeopleInforForm .getUnit().trim(); if (unit.trim().length() > 0) condition += " and substring(A.unit,1,2) = '" + unit + "'"; String floor = homePeopleInforForm.getFloor().trim(); if (floor.trim().length() > 0) condition += " and A.floor = '" + floor + "'"; String siteId = homePeopleInforForm.getSiteId().trim(); if (siteId.trim().length() > 0) condition += " and A.siteId = '" + siteId + "'"; condition += " and A.houseOwnerNationalId like '%" + homePeopleInforForm.getHouseOwnerNationalId() + "%'"; condition += " and A.houseOwnerName like '%" + homePeopleInforForm.getHouseOwnerName() + "%'"; if (!"-1".equals(homePeopleInforForm.getLodgmentType().trim())) condition += " and A.lodgmentType = '" + homePeopleInforForm.getLodgmentType().trim() + "'"; condition += " and B.nationalId like '%" + homePeopleInforForm.getNationalId() + "%'"; condition += " and B.name like '%" + homePeopleInforForm.getName() + "%'"; if (!"-1".equals(homePeopleInforForm.getSex())) { condition += " and B.sex = '" + homePeopleInforForm.getSex() + "'"; } HomePeopleInforForm homePeopleInfor = new HomePeopleInforForm( homePeopleInforForm.getHomeId(), homePeopleInforForm .getBuildingNumber(), homePeopleInforForm.getUnit(), homePeopleInforForm.getFloor(), homePeopleInforForm.getSiteId(), homePeopleInforForm .getHouseOwnerNationalId(), homePeopleInforForm .getHouseOwnerName(), homePeopleInforForm .getLodgmentType(), homePeopleInforForm.getNationalId(), homePeopleInforForm .getName(), homePeopleInforForm.getSex()); session.setAttribute("condition", condition); session.setAttribute("homePeopleInforForm", homePeopleInfor); return mapping.findForward("splitPage"); } // 页面显示公用方法 public ActionForward getPage(ActionMapping mapping, HttpServletRequest request, int flag) { // 得到默认路径 ActionForward forward = mapping.getInputForward(); // 获得Session对象 HttpSession session = request.getSession(true); // 得到Condition String condition = ""; // 首次进入需移除条件 if (request.getParameter("first") != null) { session.removeAttribute("homePeopleInforForm"); session.removeAttribute("condition"); } // 获取Select的条件Condition if (session.getAttribute("condition") != null) { condition = session.getAttribute("condition").toString(); } // 得到分页信息 Splitpageinfo splitpageinfo = null; if (request.getParameter("first") != null) { splitpageinfo = new Splitpageinfo(1, HomePeopleInforOperate .getCount(condition)); session.setAttribute("splitpageinfo", splitpageinfo); } else { splitpageinfo = (Splitpageinfo) session .getAttribute("splitpageinfo"); splitpageinfo.setTotalrecode(HomePeopleInforOperate .getCount(condition)); } int page = 1; switch (flag) { case 1: page = 1; break; case 2: page = splitpageinfo.getUppage(); break; case 3: page = splitpageinfo.getNextpage(); break; case 4: page = splitpageinfo.getTotalpage(); break; } splitpageinfo.setCurpage(page); // 存住条件项显示在页面上 request.setAttribute("homePeopleInforForm", session .getAttribute("homeP