retrievebycservlet.java

JSP物业管理系统 一份比较完整的物业管理系统源码。 对于初学者可以有一定的借鉴。

                            vector6.addElement(String.valueOf(j));
                        }

                    }
                    catch(Exception exception9)
                    {
                        System.out.println("baseinfo.RetrieveByCServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + retrievebycdbbean.getStatusMessage());
                        retrievebycdbbean.releaseConnection();
                        throw new Exception(exception9.getMessage());
                    }
                    finally
                    {
                        retrievebycdbbean.releaseConnection();
                    }
                    httpservletrequest.setAttribute("flag", String.valueOf(retrievebycdbbean.getStatusCode()));
                    httpservletrequest.setAttribute("statusMessage", retrievebycdbbean.getStatusMessage());
                    httpservletrequest.setAttribute("vecNum", vector6);
                    httpservletrequest.setAttribute("file", vector3);
                    httpservletrequest.setAttribute("picname", retrievebycdbbean.vecPicname);
                    httpservletrequest.setAttribute("picdescribe", retrievebycdbbean.vecPicdescribe);
                    httpservletrequest.setAttribute("buildingnumb", retrievebycdbbean.vecQ1);
                    httpservletrequest.setAttribute("subareanumb", retrievebycdbbean.vecQ2);
                    httpservletrequest.setAttribute("buildingname", retrievebycdbbean.vecQ3);
                    httpservletrequest.setAttribute("btype", retrievebycdbbean.vecQ4);
                    httpservletrequest.setAttribute("buse", retrievebycdbbean.vecQ5);
                    httpservletrequest.setAttribute("doorcount", retrievebycdbbean.vecQ6);
                    httpservletrequest.setAttribute("structure", retrievebycdbbean.vecQ7);
                    httpservletrequest.setAttribute("height", retrievebycdbbean.vecQ8);
                    httpservletrequest.setAttribute("floorcount", retrievebycdbbean.vecQ9);
                    httpservletrequest.setAttribute("startdate", retrievebycdbbean.vecQ10);
                    httpservletrequest.setAttribute("enddate", retrievebycdbbean.vecQ11);
                    httpservletrequest.setAttribute("developer", retrievebycdbbean.vecQ12);
                    httpservletrequest.setAttribute("architecture", retrievebycdbbean.vecQ13);
                    httpservletrequest.setAttribute("takearea", retrievebycdbbean.vecQ14);
                    httpservletrequest.setAttribute("architecturearea", retrievebycdbbean.vecQ15);
                    httpservletrequest.setAttribute("usingarea", retrievebycdbbean.vecQ16);
                    httpservletrequest.setAttribute("virescencearea", retrievebycdbbean.vecQ17);
                    httpservletrequest.setAttribute("cellcount", retrievebycdbbean.vecQ18);
                    httpservletrequest.setAttribute("salerate", retrievebycdbbean.vecQ19);
                    httpservletrequest.setAttribute("hirerate", retrievebycdbbean.vecQ20);
                    httpservletrequest.setAttribute("handover", retrievebycdbbean.vecQ21);
                    httpservletrequest.setAttribute("handoverdate", retrievebycdbbean.vecQ22);
                    httpservletrequest.setAttribute("handoverman", retrievebycdbbean.vecQ23);
                    httpservletrequest.setAttribute("remark", retrievebycdbbean.vecQ24);
                }
                RequestDispatcher requestdispatcher2 = getServletContext().getRequestDispatcher("/baseinfo/RetrieveBuildResult.jsp");
                requestdispatcher2.forward(httpservletrequest, httpservletresponse);
            }
            if(s1.equals("单元资料"))
            {
                retrievebycdbbean.setPara("2");
                retrievebycdbbean.setSubareanumb((String)vector.elementAt(1));
                retrievebycdbbean.setBuildingnumb((String)vector.elementAt(2));
                retrievebycdbbean.setDoornumb((String)vector.elementAt(3));
                retrievebycdbbean.setFloornumb((String)vector.elementAt(4));
                retrievebycdbbean.setCellnumb((String)vector.elementAt(5));
                retrievebycdbbean.setTableName("cellinfo");
                retrievebycdbbean.setSelectSQL01("SELECT NUMBER,CELLNUMB,FLOORTYPE,FLOORNUMB,DOORNUMB,BUILDINGNUMB,SUBAREANUMB,USE,STRUCTURE,ARCHITECTUREAREA,USINGAREA,DIRECTION,BEDROOM,HALL,LOO,COOKROOM,BALCONY,ELSE,ADDFIXTURE,CANDR,CRDATE,USEFLAG,PRICE,PAYMENTWAY,PAYCONTENT,ENTERDATE,FITMENT,OWNER,REMARK FROM " + retrievebycdbbean.getTableName() + " WHERE (SUBAREANUMB= ? )AND(BUILDINGNUMB=?)AND(DOORNUMB=?)AND(FLOORNUMB=?)AND(CELLNUMB=?)AND(DELFLAG='0')");
                try
                {
                    retrievebycdbbean.select01();
                    retrievebycdbbean.getDataFromResult01();
                }
                catch(Exception exception4)
                {
                    System.out.println("baseinfo.RetrieveByCServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + retrievebycdbbean.getStatusMessage());
                    retrievebycdbbean.releaseConnection();
                    throw new Exception(exception4.getMessage());
                }
                if(retrievebycdbbean.getStatusCode() == 1068)
                {
                    httpservletrequest.setAttribute("flag", String.valueOf(retrievebycdbbean.getStatusCode()));
                    httpservletrequest.setAttribute("statusMessage", retrievebycdbbean.getStatusMessage());
                } else
                {
                    retrievebycdbbean.setTableName("cellinfo1");
                    retrievebycdbbean.setSelectSQL02("SELECT NUMBER,PICNAME,PICDESCRIBE FROM " + retrievebycdbbean.getTableName() + " WHERE (NUM= ? )");
                    Vector vector4 = new Vector();
                    Vector vector7 = new Vector();
                    try
                    {
                        retrievebycdbbean.setNumber((String)retrievebycdbbean.vecNumb.elementAt(0));
                        retrievebycdbbean.select02();
                        retrievebycdbbean.getDataFromResult02();
                        for(int j1 = 0; j1 < retrievebycdbbean.vecNum.size(); j1++)
                        {
                            int k = Integer.parseInt((String)retrievebycdbbean.vecNum.elementAt(j1));
                            String s4 = ((String)retrievebycdbbean.vecPicname.elementAt(j1)).trim();
                            String s7 = getServletConfig().getServletContext().getRealPath("/baseinfo/pictures/");
                            vector4.addElement("/pmsApp/baseinfo/pictures/" + retrievebycdbbean.getTableName() + "-" + String.valueOf(k) + "-" + s4);
                            vector7.addElement(String.valueOf(k));
                        }

                    }
                    catch(Exception exception10)
                    {
                        System.out.println("baseinfo.RetrieveByCServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + retrievebycdbbean.getStatusMessage());
                        retrievebycdbbean.releaseConnection();
                        throw new Exception(exception10.getMessage());
                    }
                    finally
                    {
                        retrievebycdbbean.releaseConnection();
                    }
                    httpservletrequest.setAttribute("flag", String.valueOf(retrievebycdbbean.getStatusCode()));
                    httpservletrequest.setAttribute("statusMessage", retrievebycdbbean.getStatusMessage());
                    httpservletrequest.setAttribute("vecNum", vector7);
                    httpservletrequest.setAttribute("file", vector4);
                    httpservletrequest.setAttribute("picname", retrievebycdbbean.vecPicname);
                    httpservletrequest.setAttribute("picdescribe", retrievebycdbbean.vecPicdescribe);
                    httpservletrequest.setAttribute("cellnumb", retrievebycdbbean.vecQ1);
                    httpservletrequest.setAttribute("floortype", retrievebycdbbean.vecQ28);
                    httpservletrequest.setAttribute("floornumb", retrievebycdbbean.vecQ2);
                    httpservletrequest.setAttribute("doornumb", retrievebycdbbean.vecQ3);
                    httpservletrequest.setAttribute("buildingnumb", retrievebycdbbean.vecQ4);
                    httpservletrequest.setAttribute("subareanumb", retrievebycdbbean.vecQ5);
                    httpservletrequest.setAttribute("use", retrievebycdbbean.vecQ6);
                    httpservletrequest.setAttribute("structure", retrievebycdbbean.vecQ7);
                    httpservletrequest.setAttribute("architecturearea", retrievebycdbbean.vecQ8);
                    httpservletrequest.setAttribute("usingarea", retrievebycdbbean.vecQ9);
                    httpservletrequest.setAttribute("direction", retrievebycdbbean.vecQ10);
                    httpservletrequest.setAttribute("bedroom", retrievebycdbbean.vecQ11);
                    httpservletrequest.setAttribute("hall", retrievebycdbbean.vecQ12);
                    httpservletrequest.setAttribute("loo", retrievebycdbbean.vecQ13);
                    httpservletrequest.setAttribute("cookroom", retrievebycdbbean.vecQ14);
                    httpservletrequest.setAttribute("balcony", retrievebycdbbean.vecQ15);
                    httpservletrequest.setAttribute("elseroom", retrievebycdbbean.vecQ16);
                    httpservletrequest.setAttribute("addfixture", retrievebycdbbean.vecQ17);
                    httpservletrequest.setAttribute("candr", retrievebycdbbean.vecQ18);
                    httpservletrequest.setAttribute("crdate", retrievebycdbbean.vecQ19);
                    httpservletrequest.setAttribute("useflag", retrievebycdbbean.vecQ20);
                    httpservletrequest.setAttribute("price", retrievebycdbbean.vecQ21);
                    httpservletrequest.setAttribute("paymentway", retrievebycdbbean.vecQ22);
                    httpservletrequest.setAttribute("paycontent", retrievebycdbbean.vecQ23);
                    httpservletrequest.setAttribute("enterdate", retrievebycdbbean.vecQ24);
                    httpservletrequest.setAttribute("fitment", retrievebycdbbean.vecQ25);
                    httpservletrequest.setAttribute("owner", retrievebycdbbean.vecQ26);
                    httpservletrequest.setAttribute("remark", retrievebycdbbean.vecQ27);
                }
                RequestDispatcher requestdispatcher3 = getServletContext().getRequestDispatcher("/baseinfo/RetrieveCellResult.jsp");
                requestdispatcher3.forward(httpservletrequest, httpservletresponse);
            }
        }
        catch(Throwable _ex)
        {
            try
            {
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}