retrievecellservlet.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:   RetrieveCellServlet.java

package baseinfo;

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

// Referenced classes of package baseinfo:
//            RetrieveCellDBBean

public class RetrieveCellServlet extends ParentServlet
{

    public RetrieveCellServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            RetrieveCellDBBean retrievecelldbbean = new RetrieveCellDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            retrievecelldbbean.setNumber((String)vector.elementAt(0));
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            retrievecelldbbean.setUserID((String)vector1.elementAt(0));
            retrievecelldbbean.setPassword((String)vector1.elementAt(1));
            retrievecelldbbean.setURL((String)vector1.elementAt(2));
            retrievecelldbbean.setDriver((String)vector1.elementAt(3));
            retrievecelldbbean.setDataSourceName((String)vector1.elementAt(4));
            try
            {
                retrievecelldbbean.initialize();
            }
            catch(Exception exception1)
            {
                throw exception1;
            }
            retrievecelldbbean.setTableName("cellinfo");
            retrievecelldbbean.setSelectSQL01("SELECT 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 " + retrievecelldbbean.getTableName() + " WHERE (NUMBER= ? )");
            try
            {
                retrievecelldbbean.select01();
                retrievecelldbbean.getDataFromResult01();
            }
            catch(Exception exception2)
            {
                System.out.println("baseinfo.RetrieveCellServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + retrievecelldbbean.getStatusMessage());
                retrievecelldbbean.releaseConnection();
                throw new Exception(exception2.getMessage());
            }
            retrievecelldbbean.setTableName("cellinfo1");
            retrievecelldbbean.setSelectSQL02("SELECT NUMBER,PICNAME,PICDESCRIBE FROM " + retrievecelldbbean.getTableName() + " WHERE (NUM= ? )");
            Vector vector2 = new Vector();
            Vector vector3 = new Vector();
            try
            {
                retrievecelldbbean.select02();
                retrievecelldbbean.getDataFromResult02();
                for(int j = 0; j < retrievecelldbbean.vecNum.size(); j++)
                {
                    int i = Integer.parseInt((String)retrievecelldbbean.vecNum.elementAt(j));
                    String s1 = ((String)retrievecelldbbean.vecPicname.elementAt(j)).trim();
                    String s2 = getServletConfig().getServletContext().getRealPath("/baseinfo/pictures/");
                    vector2.addElement("/pmsApp/baseinfo/pictures/" + retrievecelldbbean.getTableName() + "-" + String.valueOf(i) + "-" + s1);
                    vector3.addElement(String.valueOf(i));
                }

            }
            catch(Exception exception4)
            {
                System.out.println("baseinfo.RetrieveCellServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + retrievecelldbbean.getStatusMessage());
                throw new Exception(exception4.getMessage());
            }
            finally
            {
                retrievecelldbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("flag", String.valueOf(retrievecelldbbean.getStatusCode()));
            httpservletrequest.setAttribute("statusMessage", retrievecelldbbean.getStatusMessage());
            httpservletrequest.setAttribute("vecNum", vector3);
            httpservletrequest.setAttribute("file", vector2);
            httpservletrequest.setAttribute("picname", retrievecelldbbean.vecPicname);
            httpservletrequest.setAttribute("picdescribe", retrievecelldbbean.vecPicdescribe);
            httpservletrequest.setAttribute("number", retrievecelldbbean.getNumber());
            httpservletrequest.setAttribute("cellnumb", retrievecelldbbean.vecQ1);
            httpservletrequest.setAttribute("floortype", retrievecelldbbean.vecQ2);
            httpservletrequest.setAttribute("floornumb", retrievecelldbbean.vecQ3);
            httpservletrequest.setAttribute("doornumb", retrievecelldbbean.vecQ4);
            httpservletrequest.setAttribute("buildingnumb", retrievecelldbbean.vecQ5);
            httpservletrequest.setAttribute("subareanumb", retrievecelldbbean.vecQ6);
            httpservletrequest.setAttribute("use", retrievecelldbbean.vecQ7);
            httpservletrequest.setAttribute("structure", retrievecelldbbean.vecQ8);
            httpservletrequest.setAttribute("architecturearea", retrievecelldbbean.vecQ9);
            httpservletrequest.setAttribute("usingarea", retrievecelldbbean.vecQ10);
            httpservletrequest.setAttribute("direction", retrievecelldbbean.vecQ11);
            httpservletrequest.setAttribute("bedroom", retrievecelldbbean.vecQ12);
            httpservletrequest.setAttribute("hall", retrievecelldbbean.vecQ13);
            httpservletrequest.setAttribute("loo", retrievecelldbbean.vecQ14);
            httpservletrequest.setAttribute("cookroom", retrievecelldbbean.vecQ15);
            httpservletrequest.setAttribute("balcony", retrievecelldbbean.vecQ16);
            httpservletrequest.setAttribute("elseroom", retrievecelldbbean.vecQ17);
            httpservletrequest.setAttribute("addfixture", retrievecelldbbean.vecQ18);
            httpservletrequest.setAttribute("candr", retrievecelldbbean.vecQ19);
            httpservletrequest.setAttribute("crdate", retrievecelldbbean.vecQ20);
            httpservletrequest.setAttribute("useflag", retrievecelldbbean.vecQ21);
            httpservletrequest.setAttribute("price", retrievecelldbbean.vecQ22);
            httpservletrequest.setAttribute("paymentway", retrievecelldbbean.vecQ23);
            httpservletrequest.setAttribute("paycontent", retrievecelldbbean.vecQ24);
            httpservletrequest.setAttribute("enterdate", retrievecelldbbean.vecQ25);
            httpservletrequest.setAttribute("fitment", retrievecelldbbean.vecQ26);
            httpservletrequest.setAttribute("owner", retrievecelldbbean.vecQ27);
            httpservletrequest.setAttribute("remark", retrievecelldbbean.vecQ28);
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/baseinfo/RetrieveCellResult.jsp");
            requestdispatcher1.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());
            }
        }
    }
}