batchfitapparatusservlet.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:   BatchFitApparatusServlet.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:
//            BatchFitApparatusDBBean

public class BatchFitApparatusServlet extends ParentServlet
{

    public BatchFitApparatusServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            BatchFitApparatusDBBean batchfitapparatusdbbean = new BatchFitApparatusDBBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            Vector vector = (Vector)getServletContext().getAttribute("Para");
            batchfitapparatusdbbean.setUserID((String)vector.elementAt(0));
            batchfitapparatusdbbean.setPassword((String)vector.elementAt(1));
            batchfitapparatusdbbean.setURL((String)vector.elementAt(2));
            batchfitapparatusdbbean.setDriver((String)vector.elementAt(3));
            batchfitapparatusdbbean.setDataSourceName((String)vector.elementAt(4));
            String s = httpservletrequest.getParameter("inputString");
            Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
            batchfitapparatusdbbean.setApparatusNumb((String)vector1.elementAt(0));
            batchfitapparatusdbbean.setDelFlag("0");
            try
            {
                batchfitapparatusdbbean.initialize();
            }
            catch(Exception exception1)
            {
                throw exception1;
            }
            int i = vector1.size();
            try
            {
                for(int j = 1; j < i; j++)
                {
                    String s1 = (String)vector1.elementAt(j);
                    batchfitapparatusdbbean.setSubAreaNumb(s1.substring(0, 2).trim());
                    batchfitapparatusdbbean.setBuildingNumb(s1.substring(2, 5).trim());
                    batchfitapparatusdbbean.setDoorNumb(s1.substring(5, 6));
                    batchfitapparatusdbbean.setFloorNumb(s1.substring(6, 8));
                    batchfitapparatusdbbean.setCellNumb(s1.substring(8));
                    s1 = s1.substring(0, 2).trim() + s1.substring(2, 5).trim() + s1.substring(5, 6).trim() + s1.substring(6, 8).trim() + s1.substring(8).trim();
                    batchfitapparatusdbbean.setApparatus(s1 + ((String)vector1.elementAt(0)).trim() + "%");
                    batchfitapparatusdbbean.setTableName("apparatusfit");
                    batchfitapparatusdbbean.setSelectSQL01("SELECT  apparatus FROM " + batchfitapparatusdbbean.getTableName() + " WHERE  apparatus like ? ");
                    try
                    {
                        batchfitapparatusdbbean.select01();
                        batchfitapparatusdbbean.getDataFromResult01();
                    }
                    catch(Exception exception4)
                    {
                        batchfitapparatusdbbean.releaseConnection();
                        throw new Exception(exception4.getMessage());
                    }
                    if(!batchfitapparatusdbbean.vecQ1.isEmpty())
                    {
                        int k = batchfitapparatusdbbean.vecQ1.size();
                        String s2 = (String)batchfitapparatusdbbean.vecQ1.elementAt(k - 1);
                        int l = s2.length();
                        String s3 = s2.substring(l - 1);
                        int i1 = Integer.parseInt(s3);
                        batchfitapparatusdbbean.setApparatus(s1 + ((String)vector1.elementAt(0)).trim() + (i1 + 1));
                    } else
                    {
                        batchfitapparatusdbbean.setApparatus(s1 + ((String)vector1.elementAt(0)).trim() + "0");
                    }
                    batchfitapparatusdbbean.setTableName("apparatusfit");
                    batchfitapparatusdbbean.setInsertSQL01(" INSERT INTO " + batchfitapparatusdbbean.getTableName() + " (NUMBER, APPARATUS, SUBAREANUMB, BUILDINGNUMB, DOORNUMB, FLOORNUMB, CELLNUMB, APPARATUSNUMB, DELFLAG ) VALUES (?,?,?,?,?,?,?,?,?)");
                    try
                    {
                        batchfitapparatusdbbean.selectMaxnum();
                        batchfitapparatusdbbean.insert01();
                        batchfitapparatusdbbean.commitToDB();
                        batchfitapparatusdbbean.setStatusCode(1001);
                        batchfitapparatusdbbean.setStatusMessage("成功增加三表资料！");
                    }
                    catch(Exception exception5)
                    {
                        batchfitapparatusdbbean.rollbackFromDB();
                        throw new Exception(exception5.getMessage());
                    }
                }

            }
            catch(Exception exception3)
            {
                throw new Exception(exception3.getMessage());
            }
            finally
            {
                batchfitapparatusdbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("flag", String.valueOf(batchfitapparatusdbbean.getStatusCode()));
            httpservletrequest.setAttribute("statusMessage", batchfitapparatusdbbean.getStatusMessage());
            httpservletrequest.setAttribute("vapparatusnumb", (String)vector1.elementAt(0));
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/baseinfo/BatchFitApparatusResults.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());
            }
        }
    }
}