treeservlet.java

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

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   TreeServlet.java

package personaladmin;

import common.*;
import java.io.PrintStream;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.*;

// Referenced classes of package personaladmin:
//            TreeDBBean

public class TreeServlet extends ParentServlet
{

    public TreeServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        TreeDBBean treedbbean = new TreeDBBean();
        try
        {
            HttpSession httpsession = httpservletrequest.getSession(false);
            if(httpsession == null)
            {
                RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher1.forward(httpservletrequest, httpservletresponse);
            }
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            treedbbean.setUserID((String)vector1.elementAt(0));
            treedbbean.setPassword((String)vector1.elementAt(1));
            treedbbean.setURL((String)vector1.elementAt(2));
            treedbbean.setDriver((String)vector1.elementAt(3));
            treedbbean.setDataSourceName((String)vector1.elementAt(4));
            treedbbean.setDelFlag("0");
            int i = vector.size();
            String s1 = "";
            if(i == 1)
                s1 = (String)vector.elementAt(0);
            if(s1.equals("1"))
            {
                httpsession.putValue("planflag", "0");
                httpsession.putValue("ortflag", "0");
                httpsession.putValue("padainflag", "0");
                httpsession.putValue("documenttop", "0");
            }
            try
            {
                treedbbean.initialize();
            }
            catch(Exception exception1)
            {
                throw exception1;
            }
            Vector vector2 = new Vector();
            treedbbean.setTableName("deptinfo");
            treedbbean.setSelectSQL01("SELECT NUMBER,DEPTNAME FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? ORDER BY NUMBER ");
            try
            {
                boolean flag = false;
                treedbbean.select01();
                treedbbean.getDataFromResult01();
                if(s1.equals("1"))
                {
                    httpsession.putValue("vdeptnum", treedbbean.vdeptnum);
                    httpsession.putValue("vdeptname", treedbbean.vdeptname);
                    int j = treedbbean.vdeptnum.size();
                    for(int k = 0; k < j; k++)
                        vector2.add(k, "0");

                    httpsession.putValue("deptflag", vector2);
                    httpsession.putValue("pdeptflag", vector2);
                }
                if(s1.equals("a"))
                {
                    Vector vector5 = (Vector)httpsession.getValue("vdeptnum");
                    int i1 = vector5.size();
                    httpsession.putValue("vdeptnum", treedbbean.vdeptnum);
                    httpsession.putValue("vdeptname", treedbbean.vdeptname);
                    int j1 = treedbbean.vdeptnum.size();
                    Vector vector3 = (Vector)httpsession.getValue("deptflag");
                    for(int k1 = 0; k1 < j1 - i1; k1++)
                        vector3.add(i1 + k1, "0");

                    httpsession.putValue("deptflag", vector3);
                    Vector vector6 = (Vector)httpsession.getValue("pdeptflag");
                    for(int j2 = 0; j2 < j1 - i1; j2++)
                        vector6.add(i1 + j2, "0");

                    httpsession.putValue("pdeptflag", vector6);
                }
                if(s1.equals("2"))
                {
                    httpsession.putValue("vdeptnum", treedbbean.vdeptnum);
                    httpsession.putValue("vdeptname", treedbbean.vdeptname);
                }
            }
            catch(Exception exception2)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception2.getMessage());
            }
            treedbbean.setTableName("relationcominfo");
            treedbbean.setSelectSQL02("SELECT NUMBER,COMPANY FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? ");
            try
            {
                treedbbean.select02();
                treedbbean.getDataFromResult02();
                httpsession.putValue("vrelcomnum", treedbbean.vrelcomnum);
                httpsession.putValue("vcompany", treedbbean.vcompany);
                if(s1.equals("1"))
                    httpsession.putValue("relcomflag", "0");
            }
            catch(Exception exception3)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception3.getMessage());
            }
            treedbbean.setTableName("meetinginfo");
            treedbbean.setSelectSQL03("SELECT NUMBER,MEETINGTOPIC FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? ");
            try
            {
                treedbbean.select03();
                treedbbean.getDataFromResult03();
                httpsession.putValue("vmeetingnum", treedbbean.vmeetingnum);
                httpsession.putValue("vmeetingtopic", treedbbean.vmeetingtopic);
                if(s1.equals("1"))
                    httpsession.putValue("meetflag", "0");
            }
            catch(Exception exception4)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception4.getMessage());
            }
            treedbbean.setTableName("documentkind");
            treedbbean.setSelectSQL04("SELECT NUMBER,KINDNAME FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? ");
            try
            {
                treedbbean.select04();
                treedbbean.getDataFromResult04();
                httpsession.putValue("vDocukindnum", treedbbean.vDocukindnum);
                httpsession.putValue("vDocukindname", treedbbean.vDocukindname);
                if(s1.equals("1"))
                    httpsession.putValue("docuflag", "0");
            }
            catch(Exception exception5)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception5.getMessage());
            }
            treedbbean.setTableName("dossierkind");
            treedbbean.setSelectSQL05("SELECT NUMBER,KINDNAME FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? ");
            try
            {
                treedbbean.select05();
                treedbbean.getDataFromResult05();
                httpsession.putValue("vDosskindnum", treedbbean.vDosskindnum);
                httpsession.putValue("vDosskindname", treedbbean.vDosskindname);
                if(s1.equals("1"))
                    httpsession.putValue("dossflag", "0");
            }
            catch(Exception exception6)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception6.getMessage());
            }
            treedbbean.setTableName("contractkind");
            treedbbean.setSelectSQL06("SELECT NUMBER,KINDNAME FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? ");
            try
            {
                treedbbean.select06();
                treedbbean.getDataFromResult06();
                httpsession.putValue("vContkindnum", treedbbean.vContkindnum);
                httpsession.putValue("vContkindname", treedbbean.vContkindname);
                if(s1.equals("1"))
                    httpsession.putValue("contflag", "0");
            }
            catch(Exception exception7)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception7.getMessage());
            }
            Vector vector4 = treedbbean.vdeptnum;
            int l = vector4.size();
            String as[][] = new String[l][100];
            String as1[][] = new String[l][100];
            treedbbean.setTableName("jobinfo");
            treedbbean.setSelectSQL07("SELECT NUMBER,JOBNAME FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? AND DEPTNAME= ? ORDER BY NUMBER");
            try
            {
                for(int l1 = 0; l1 < l; l1++)
                {
                    treedbbean.vjobnum.clear();
                    treedbbean.vjobname.clear();
                    treedbbean.setDeptname(((String)treedbbean.vdeptname.elementAt(l1)).trim());
                    treedbbean.select07(l1);
                    treedbbean.getDataFromResult07(l1);
                    int i2 = treedbbean.vjobnum.size();
                    for(int k2 = 0; k2 < i2; k2++)
                    {
                        as[l1][k2] = (String)treedbbean.vjobnum.elementAt(k2);
                        as1[l1][k2] = (String)treedbbean.vjobname.elementAt(k2);
                    }

                }

            }
            catch(Exception exception8)
            {
                throw new Exception(exception8.getMessage());
            }
            httpsession.putValue("jobnum", as);
            httpsession.putValue("jobname", as1);
            String as2[][] = new String[l][100];
            String as3[][] = new String[l][100];
            String as4[][] = new String[l][100];
            treedbbean.setTableName("personnelinfo");
            treedbbean.setSelectSQL08("SELECT NUMBER,PERSNAME,PERSNUMB FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? AND DEPT= ? ORDER BY NUMBER");
            try
            {
                for(int l2 = 0; l2 < l; l2++)
                {
                    treedbbean.vpersnum.clear();
                    treedbbean.vpersname.clear();
                    treedbbean.vpersnumb.clear();
                    treedbbean.setDeptname((String)treedbbean.vdeptname.elementAt(l2));
                    treedbbean.select08(l2);
                    treedbbean.getDataFromResult08(l2);
                    int i3 = treedbbean.vpersnum.size();
                    for(int j3 = 0; j3 < i3; j3++)
                    {
                        as2[l2][j3] = (String)treedbbean.vpersnum.elementAt(j3);
                        as3[l2][j3] = (String)treedbbean.vpersname.elementAt(j3);
                        as4[l2][j3] = (String)treedbbean.vpersnumb.elementAt(j3);
                    }

                }

            }
            catch(Exception exception9)
            {
                treedbbean.releaseConnection();
                throw new Exception(exception9.getMessage());
            }
            httpsession.putValue("persnum", as2);
            httpsession.putValue("persname1", as3);
            httpsession.putValue("persnumb1", as4);
            treedbbean.setTableName("personnelinfo");
            treedbbean.setSelectSQL09("SELECT NUMBER,PERSNAME,PERSNUMB FROM " + treedbbean.getTableName() + " WHERE DELFLAG = ? AND DEPT = '' ");
            try
            {
                treedbbean.select09();
                treedbbean.getDataFromResult09();
                httpsession.putValue("vpersnum1", treedbbean.vpersnum1);
                httpsession.putValue("vpersname1", treedbbean.vpersname1);
                httpsession.putValue("vpersonnumb", treedbbean.vpersonnumb);
                if(s1.equals("1"))
                    httpsession.putValue("otherpflag", "0");
            }
            catch(Exception exception11)
            {
                throw new Exception(exception11.getMessage());
            }
            finally
            {
                treedbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("flag", (new Integer(treedbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", treedbbean.getStatusMessage());
            RequestDispatcher requestdispatcher2 = getServletContext().getRequestDispatcher("/personaladmin/TreeResult.jsp");
            requestdispatcher2.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());
            }
        }
    }
}