treeservlet.java

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

                    vector7.remove(j1);
                    vector6 = treedbbean.vsubareanumb;
                    vector7 = treedbbean.vanumber;
                    httpsession.putValue("vsubareanumb", vector6);
                    httpsession.putValue("vanumber", vector7);
                }
                if(s1.equals("2"))
                {
                    httpsession.putValue("vsubareanumb", treedbbean.vsubareanumb);
                    httpsession.putValue("vanumber", treedbbean.vanumber);
                }
            }
            catch(Exception exception7)
            {
                throw new Exception(exception7.getMessage());
            }
            Vector vector4 = treedbbean.vsubareanumb;
            int k1 = vector4.size();
            boolean flag2 = false;
            String as3[][] = new String[k1][100];
            String as4[][] = new String[k1][100];
            String as5[][] = new String[k1][100];
            treedbbean.setTableName3("buildinginfo");
            treedbbean.setSelectSQL06("SELECT NUMBER,BUILDINGNUMB,DOORCOUNT FROM " + treedbbean.getTableName3() + " WHERE  SUBAREANUMB=? AND DELFLAG = ? ORDER BY NUMBER");
            for(int i3 = 0; i3 < k1; i3++)
            {
                treedbbean.vnumberb.clear();
                treedbbean.vbuildingnumb.clear();
                treedbbean.vdoorcount.clear();
                try
                {
                    treedbbean.setSubAreaNumb1((String)vector4.elementAt(i3));
                    treedbbean.select06(i3);
                    treedbbean.getDataFromResult06(i3);
                    int i2 = treedbbean.vbuildingnumb.size();
                    if(s1.equals((String)vector4.elementAt(i3)))
                    {
                        if(httpsession.getValue("buildingflag") != null)
                            as = (String[][])httpsession.getValue("buildingflag");
                        for(int j3 = i2 - j; j3 < i2; j3++)
                            as[i3][j3] = "0";

                        httpsession.putValue("buildingflag", as);
                    }
                    for(int k3 = 0; k3 < i2; k3++)
                    {
                        as4[i3][k3] = (String)treedbbean.vnumberb.elementAt(k3);
                        as3[i3][k3] = (String)treedbbean.vbuildingnumb.elementAt(k3);
                        as5[i3][k3] = (String)treedbbean.vdoorcount.elementAt(k3);
                        if(s1.equals("1"))
                        {
                            as[i3][k3] = "0";
                            for(int l3 = 0; l3 < 10; l3++)
                                as1[i3][k3][l3] = "0";

                            httpsession.putValue("buildingflag", as);
                            httpsession.putValue("doorflag", as1);
                        }
                        if(s1.equals((String)vector4.elementAt(i3)))
                        {
                            if(httpsession.getValue("doorflag") != null)
                                as1 = (String[][][])httpsession.getValue("doorflag");
                            for(int i4 = 0; i4 < 10; i4++)
                            {
                                as1[i3][k3][i4] = "0";
                                if(httpsession.getValue("cellflag") != null)
                                    as2 = (String[][][][])httpsession.getValue("cellflag");
                                for(int j4 = 0; j4 < 10; j4++)
                                    as2[i3][k3][i4][j4] = "0";

                            }

                            httpsession.putValue("doorflag", as1);
                            httpsession.putValue("cellflag", as2);
                        }
                    }

                }
                catch(Exception exception8)
                {
                    throw new Exception(exception8.getMessage());
                }
            }

            httpsession.removeValue("vnumberb");
            httpsession.removeValue("vbuildingnumb");
            httpsession.removeValue("vdoorcount");
            httpsession.putValue("vnumberb", as4);
            httpsession.putValue("vbuildingnumb", as3);
            httpsession.putValue("vdoorcount", as5);
            String as6[][][][] = new String[k1][100][100][100];
            String as7[][][][] = new String[k1][100][10][100];
            String as8[][][][] = new String[k1][100][10][100];
            String as9[][][][] = new String[k1][100][10][100];
            treedbbean.setTableName4("cellinfo");
            treedbbean.setSelectSQL07("SELECT NUMBER,FLOORNUMB,CELLNUMB,OWNER FROM " + treedbbean.getTableName4() + " WHERE  SUBAREANUMB=? AND BUILDINGNUMB=? AND DOORNUMB=? AND DELFLAG = ? ORDER BY NUMBER");
            treedbbean.setTableName5("livepeople");
            treedbbean.setSelectSQL08("SELECT NUMBER,NAME FROM " + treedbbean.getTableName5() + " WHERE  SUBAREA=? AND BUILDING=? AND stair=? AND floor = ? AND cell = ? AND DELFLAG = ? AND NUMBER2=1 ORDER BY NUMBER");
            Vector vector8 = new Vector();
            int k4 = 0;
            for(int l4 = 0; l4 < k1; l4++)
                try
                {
                    treedbbean.setSubAreaNumb1((String)vector4.elementAt(l4));
                    for(int i5 = 0; i5 < 100; i5++)
                        if(as3[l4][i5] != null)
                        {
                            treedbbean.setBuildingNumb1(as3[l4][i5]);
                            int j5 = Integer.parseInt(as5[l4][i5]);
                            int k5 = 1;
                            for(int l5 = 0; l5 < j5; l5++)
                            {
                                treedbbean.vnumberc.clear();
                                treedbbean.vfloornumb.clear();
                                treedbbean.vcellnumb.clear();
                                treedbbean.setDoorNumb1(String.valueOf(k5));
                                k5++;
                                treedbbean.select07(k4);
                                treedbbean.getDataFromResult07(k4);
                                int i6 = treedbbean.vcellnumb.size();
                                k4++;
                                vector8.clear();
                                for(int j6 = 0; j6 < i6; j6++)
                                {
                                    treedbbean.vnumberco = "";
                                    treedbbean.vownername = "";
                                    treedbbean.setFloorNumb1((String)treedbbean.vfloornumb.elementAt(j6));
                                    treedbbean.setCellNumb1((String)treedbbean.vcellnumb.elementAt(j6));
                                    treedbbean.select08();
                                    treedbbean.getDataFromResult08();
                                    String s5 = (String)treedbbean.vfloornumb.elementAt(j6) + (String)treedbbean.vcellnumb.elementAt(j6);
                                    vector8.add(j6, s5);
                                    as7[l4][i5][l5][j6] = (String)vector8.elementAt(j6);
                                    as8[l4][i5][l5][j6] = treedbbean.vownername;
                                    as9[l4][i5][l5][j6] = treedbbean.vnumberco;
                                    as6[l4][i5][l5][j6] = (String)treedbbean.vnumberc.elementAt(j6);
                                    if(s1.equals("1"))
                                    {
                                        as2[l4][i5][l5][j6] = "0";
                                        httpsession.putValue("cellflag", as2);
                                        httpsession.putValue("once", s1);
                                    }
                                }

                                if(s2.equals((String)vector4.elementAt(l4)) && s3.equals(as3[l4][i5]) && s4.equals(String.valueOf(l5 + 1)))
                                {
                                    if(httpsession.getValue("cellflag") != null)
                                        as2 = (String[][][][])httpsession.getValue("cellflag");
                                    for(int k6 = i6 - j; k6 < i6; k6++)
                                        as2[l4][i5][l5][k6] = "0";

                                    httpsession.putValue("cellflag", as2);
                                }
                            }

                        }

                }
                catch(Exception exception9)
                {
                    throw new Exception(exception9.getMessage());
                }

            httpsession.removeValue("vnumberc");
            httpsession.removeValue("vcellnumb");
            httpsession.removeValue("vcellowner");
            httpsession.removeValue("vnumberco");
            httpsession.putValue("vnumberc", as6);
            httpsession.putValue("vcellnumb", as7);
            httpsession.putValue("vcellowner", as8);
            httpsession.putValue("vnumberco", as9);
            httpservletrequest.setAttribute("flag", (new Integer(treedbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", treedbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/baseinfo/TreeResults.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable _ex)
        {
            try
            {
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception1)
            {
                System.out.println(exception1.getMessage());
            }
        }
        finally
        {
            treedbbean.releaseConnection();
        }
    }
}