Eclipse+Tomcat+SQLServer2008开发基于MVC框架的房地产信息管理系统+运用gis技术实现地产和地图结合

package com.realty.base.servlet; import java.io.File; import java.io.IOException; import java.io.PrintWriter; import java.math.BigDecimal; import java.util.Date; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Enumeration; import java.util.HashMap; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.swing.JOptionPane; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import net.sf.json.JsonConfig; import com.realty.base.model.*; import com.realty.base.utils.JsonDateValueProcessor; import com.realty.base.utils.QueryUtils; import com.realty.base.action.BuildingAction; import com.realty.base.action.BuildingUsageAction; import com.realty.base.dao.BuildingDao; import com.realty.base.dao.impl.BuildingDaoImpl; import com.oreilly.servlet.MultipartRequest; /** * Servlet implementation class BuildingServlet */ @WebServlet("/BuildingServlet") public class BuildingServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public BuildingServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request,response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub request.setCharacterEncoding("utf-8"); response.setHeader("Cache-Control", "no-store"); response.setHeader("Pragma", "no-cache"); response.setDateHeader("Expires", 0); response.setContentType("text/html;charset=UTF-8");//解决乱码问题,没有这句，回调函数的内容可能乱码 String buildingName=null;String buildingAlias=null;int regionId=0;String propertyAdress=null; String propertyName=null;int usageId=0;int buildtimeId=0;String developers=null;Double floorArea=0.0; Double buildingArea=0.0;int structureId=0;String formId=null;String plotRatio=null;Date landuseTime=null; String buildingDensity=null;String greeningRate=null;BigDecimal parkingRatio=null;int decorateId=0;Date openTime=null; String propertyService=null;Double initialPrice=0.0;Double averagePrice=0.0;Double perPrice=0.0; Double totalPrice=0.0;String locationphoto=null;int landId=0;int buildintroId=0;Double longitude=0.0; Double latitude=0.0;int entryId=1;String entryName=null;Date entryTime=null;String auditName=null; Date auditTime=null;int status=0;String remarks=null; String buildtimeOne=null;String buildtimeTwo=null;String buildtimeThree=null;String buildtimeOther=null; String buildingtimeFinish=null;String buildRegion=null;String projectFeature=null; int zipCode=0;String buildingStruc=null;String buildingType=null;Double propertyFee=0.0; String proWorkaddress=null;String proPhone=null;String proOtherinfor=null;String propertyRight=null; String buildingintro=null;String editer=null; SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); try { landuseTime = sdf.parse("0001-01-01"); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { openTime = sdf.parse("0001-01-01"); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } int floorId=0; int buildingId=0; String address=null; String buildingEast=null; String buildingWest=null; String buildingSouth=null; String buildingNorth=null; String landLevel=null; String neighborhood=null; String buildingInfor=null; String nearRoad=null; String publicTransport=null; String commercialFacility=null; String financingNstitution=null; String school=null; String hospital=null; String other=null; String internalFacility=null; String electricityFacility=null; String parkFacility=null; String propertyManagement=null; String environment=null; Date collectTime=null; int buildNum=0; String floors=null; int cells=0; String networks=null; int onehouses=0; String waterSupply=null; String electricitySupply=null; String heatSupply=null; String gas=null; String communications=null; String elevato=null; String security=null; String hygienism=null; String parking=null; String communityEnter=null; int unitNum=0;int houseNum=0; Double houseArea=null; String present=null;int floorTotle=0; int floorSaid=0;int floorActual=0;String houseType=null; String orientation=null;Double exchangePrice=null;Double exchangeTotle=null;Date exchangeTime=null; PrintWriter out = response.getWriter(); String flag=request.getParameter("flag"); if(flag.equals("1")){ buildingName=request.getParameter("buildingName"); buildingAlias=request.getParameter("buildingAlias"); String regionId1=request.getParameter("regionId"); regionId = Integer.parseInt(regionId1); propertyAdress=request.getParameter("propertyAdress"); propertyName=request.getParameter("propertyName"); String usageId1=request.getParameter("usageId"); usageId = Integer.parseInt(usageId1); developers=request.getParameter("developers"); String floorArea1=request.getParameter("floorArea"); if(floorArea1.equals("")) floorArea=0.0; else floorArea = Double.parseDouble(floorArea1); String buildingArea1=request.getParameter("buildingArea"); if(buildingArea1.equals("")) buildingArea=0.0; else buildingArea = Double.parseDouble(buildingArea1); String structureId1=request.getParameter("structureId"); structureId = Integer.parseInt(structureId1); formId=request.getParameter("formId"); String decorateId1=request.getParameter("decorateId"); decorateId = Integer.parseInt(decorateId1); entryName=request.getParameter("entryName"); String entryTime1=request.getParameter("entryTime"); SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); try { entryTime = sdf1.parse(entryTime1); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } remarks=request.getParameter("remarks"); BuildingAction buildingaction=new BuildingAction(); boolean outcome=buildingaction.buildingAdd(buildingName, buildingAlias, regionId, propertyAdress, propertyName, usageId, buildtimeId, developers, floorArea, buildingArea, structureId, formId, plotRatio, landuseTime, buildingDensity, greeningRate, parkingRatio, decorateId, openTime, propertyService, initialPrice, averagePrice, perPrice, totalPrice, locationphoto, landId, buildintroId, longitude, latitude, entryId, entryName, entryTime, auditName, auditTime, status, remarks); if(outcome){ int i=buildingaction.buildingList().size()-1; int BuildingId=buildingaction.buildingList().get(i).getBuildingId(); buildingaction.buildingintroAdd(BuildingId, buildingName, address, buildingEast, buildingWest, buildingSouth, buildingNorth, landLevel, neighborhood, buildingInfor, nearRoad, publicTransport, commercialFacility, financingNstitution, school, hospital, other, internalFacility, electricityFacility, parkFacility, propertyManagement, environment, collectTime, e