batchaddcellservlet.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:   BatchAddCellServlet.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:
//            AddCellDBBean

public class BatchAddCellServlet extends ParentServlet
{

    public BatchAddCellServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            AddCellDBBean addcelldbbean = new AddCellDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            parseinputstringbean.setMaxFileSize(0x19000);
            String s = "";
            int i = 0;
            try
            {
                s = parseinputstringbean.parseSpecialFormatIS(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception1)
            {
                System.out.println("[beaseinfo.BatchAddCellServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "][" + exception1 + "]");
            }
            if(parseinputstringbean.getStatusCode() == 9001)
            {
                Vector vector = (Vector)getServletContext().getAttribute("Para");
                addcelldbbean.setUserID((String)vector.elementAt(0));
                addcelldbbean.setPassword((String)vector.elementAt(1));
                addcelldbbean.setURL((String)vector.elementAt(2));
                addcelldbbean.setDriver((String)vector.elementAt(3));
                addcelldbbean.setDataSourceName((String)vector.elementAt(4));
                Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
                try
                {
                    addcelldbbean.initialize();
                }
                catch(Exception exception2)
                {
                    throw exception2;
                }
                addcelldbbean.setFloornumb((String)vector1.elementAt(2));
                addcelldbbean.setDoornumb((String)vector1.elementAt(3));
                addcelldbbean.setBuildingnumb((String)vector1.elementAt(4));
                addcelldbbean.setSubareanumb((String)vector1.elementAt(5));
                addcelldbbean.setTableName("cellinfo");
                addcelldbbean.setSelectSQL01("SELECT CELLNUMB FROM " + addcelldbbean.getTableName() + " WHERE (CELLNUMB= ?)AND(FLOORNUMB=?)AND(DOORNUMB=?)AND(BUILDINGNUMB=?)AND (SUBAREANUMB=?)AND(DELFLAG='0')");
                try
                {
                    String s4 = (String)vector1.elementAt(0);
                    int j = s4.indexOf(",");
                    if(j == -1)
                    {
                        addcelldbbean.setCellnumb(s4);
                        addcelldbbean.select01();
                    } else
                    {
                        while(j < s4.length() && j >= 0) 
                        {
                            String s1 = s4.substring(0, j);
                            s4 = s4.substring(j + 1);
                            addcelldbbean.setCellnumb(s1);
                            addcelldbbean.select01();
                            if(addcelldbbean.getStatusCode() == 1102)
                                break;
                            j = s4.indexOf(",");
                            if(j == -1)
                            {
                                String s2 = s4;
                                addcelldbbean.setCellnumb(s2);
                                addcelldbbean.select01();
                            }
                        }
                    }
                }
                catch(Exception exception3)
                {
                    System.out.println("baseinfo.BatchAddCellServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + addcelldbbean.getStatusMessage());
                    throw new Exception(exception3.getMessage());
                }
                if(addcelldbbean.getStatusCode() == 1102)
                {
                    httpservletrequest.setAttribute("subareanumb", (String)vector1.elementAt(5));
                    httpservletrequest.setAttribute("buildnumb", (String)vector1.elementAt(4));
                    httpservletrequest.setAttribute("doornumb", (String)vector1.elementAt(3));
                    httpservletrequest.setAttribute("anumb", String.valueOf(i));
                    httpservletrequest.setAttribute("flag", String.valueOf(addcelldbbean.getStatusCode()));
                    httpservletrequest.setAttribute("statusMessage", addcelldbbean.getStatusMessage());
                } else
                {
                    addcelldbbean.setFloortype((String)vector1.elementAt(1));
                    addcelldbbean.setFloornumb((String)vector1.elementAt(2));
                    addcelldbbean.setDoornumb((String)vector1.elementAt(3));
                    addcelldbbean.setBuildingnumb((String)vector1.elementAt(4));
                    addcelldbbean.setSubareanumb((String)vector1.elementAt(5));
                    addcelldbbean.setUse((String)vector1.elementAt(6));
                    addcelldbbean.setStructure((String)vector1.elementAt(7));
                    addcelldbbean.setArchitecturearea((String)vector1.elementAt(8));
                    addcelldbbean.setUsingarea((String)vector1.elementAt(9));
                    addcelldbbean.setDirection((String)vector1.elementAt(10));
                    addcelldbbean.setBedroom((String)vector1.elementAt(11));
                    addcelldbbean.setHall((String)vector1.elementAt(12));
                    addcelldbbean.setLoo((String)vector1.elementAt(13));
                    addcelldbbean.setAddfixture((String)vector1.elementAt(14));
                    addcelldbbean.setCookroom((String)vector1.elementAt(15));
                    addcelldbbean.setBalcony((String)vector1.elementAt(16));
                    addcelldbbean.setElseroom((String)vector1.elementAt(17));
                    addcelldbbean.setCandr((String)vector1.elementAt(18));
                    addcelldbbean.setCrdate((String)vector1.elementAt(22));
                    addcelldbbean.setUseflag((String)vector1.elementAt(23));
                    addcelldbbean.setPrice((String)vector1.elementAt(24));
                    addcelldbbean.setPaymentway((String)vector1.elementAt(25));
                    addcelldbbean.setPaycontent((String)vector1.elementAt(26));
                    addcelldbbean.setEnterdate((String)vector1.elementAt(30));
                    addcelldbbean.setFitment((String)vector1.elementAt(31));
                    addcelldbbean.setRemark((String)vector1.elementAt(33));
                    addcelldbbean.setDelflag("0");
                    String s3 = (String)vector1.elementAt(32);
                    if(s3.equals(""))
                        s3 = "无";
                    addcelldbbean.setOwner(s3);
                    Vector vector2 = parseinputstringbean.Size;
                    Vector vector3 = parseinputstringbean.FileName;
                    Vector vector4 = parseinputstringbean.FileContent;
                    addcelldbbean.setTableName("cellinfo");
                    addcelldbbean.setInsertSQL01(" INSERT INTO " + addcelldbbean.getTableName() + " (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, DELFLAG ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
                    try
                    {
                        String s7 = (String)vector1.elementAt(0);
                        int k = s7.indexOf(",");
                        if(k == -1)
                        {
                            addcelldbbean.setCellnumb(s7);
                            addcelldbbean.selectMaxnum();
                            addcelldbbean.insert01();
                            i++;
                        } else
                        {
                            while(k < s7.length() && k >= 0) 
                            {
                                String s5 = s7.substring(0, k);
                                s7 = s7.substring(k + 1);
                                addcelldbbean.setCellnumb(s5);
                                addcelldbbean.selectMaxnum();
                                addcelldbbean.insert01();
                                i++;
                                k = s7.indexOf(",");
                                if(k == -1)
                                {
                                    String s6 = s7;
                                    addcelldbbean.setCellnumb(s6);
                                    addcelldbbean.selectMaxnum();
                                    addcelldbbean.insert01();
                                    i++;
                                }
                            }
                        }
                        int l = i;
                        int i1 = Integer.parseInt(addcelldbbean.getNumber());
                        for(int j1 = 0; j1 < l; j1++)
                            if(vector2.size() > 0)
                            {
                                addcelldbbean.setNum(String.valueOf(i1 - j1));
                                addcelldbbean.setTableName("cellinfo1");
                                addcelldbbean.setInsertSQL02(" INSERT INTO " + addcelldbbean.getTableName() + " (NUMBER, NUM, PICCONTENT, PICNAME, PICDESCRIBE) VALUES (?,?,?,?,?)");
                                int k1 = 0;
                                for(int l1 = 34; l1 < vector1.size(); l1 += 3)
                                    if(((String)vector1.elementAt(l1)).trim().equals("1"))
                                    {
                                        byte abyte0[] = new byte[Integer.parseInt((String)vector2.elementAt(k1))];
                                        addcelldbbean.setPicname((String)vector3.elementAt(k1));
                                        abyte0 = (byte[])vector4.elementAt(k1);
                                        addcelldbbean.setPiccontent(abyte0);
                                        addcelldbbean.setPicdescribe((String)vector1.elementAt(l1 + 2));
                                        addcelldbbean.selectMaxnum();
                                        String s8 = getServletConfig().getServletContext().getRealPath("/baseinfo/pictures/");
                                        s8 = s8 + addcelldbbean.getTableName() + "-" + addcelldbbean.getNumber() + "-";
                                        parseinputstringbean.generate(k1, s8);
                                        addcelldbbean.insert02();
                                        k1++;
                                    }

                            }

                        addcelldbbean.commitToDB();
                    }
                    catch(Exception exception5)
                    {
                        addcelldbbean.rollbackFromDB();
                        System.out.println("baseinfo.BatchAddCellServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + addcelldbbean.getStatusMessage());
                        throw new Exception(exception5.getMessage());
                    }
                    finally
                    {
                        addcelldbbean.releaseConnection();
                    }
                    httpservletrequest.setAttribute("subareanumb", (String)vector1.elementAt(5));
                    httpservletrequest.setAttribute("buildnumb", (String)vector1.elementAt(4));
                    httpservletrequest.setAttribute("doornumb", (String)vector1.elementAt(3));
                    httpservletrequest.setAttribute("anumb", String.valueOf(i));
                    httpservletrequest.setAttribute("flag", String.valueOf(addcelldbbean.getStatusCode()));
                    httpservletrequest.setAttribute("statusMessage", addcelldbbean.getStatusMessage());
                }
            } else
            {
                httpservletrequest.setAttribute("subareanumb", "");
                httpservletrequest.setAttribute("buildnumb", "");
                httpservletrequest.setAttribute("doornumb", "");
                httpservletrequest.setAttribute("anumb", String.valueOf(i));
                httpservletrequest.setAttribute("statusMessage", parseinputstringbean.getStatusMessage());
                httpservletrequest.setAttribute("flag", String.valueOf(parseinputstringbean.getStatusCode()));
            }
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/baseinfo/BatchAddCellResult.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());
            }
        }
    }
}