dspthreefeeservlet.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:   DspThreeFeeServlet.java

package finance;

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 finance:
//            DspThreeFeeDBBean, FormatBean

public class DspThreeFeeServlet extends ParentServlet
{

    public DspThreeFeeServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            DspThreeFeeDBBean dspthreefeedbbean = new DspThreeFeeDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            dspthreefeedbbean.setUserID((String)vector1.elementAt(0));
            dspthreefeedbbean.setPassword((String)vector1.elementAt(1));
            dspthreefeedbbean.setURL((String)vector1.elementAt(2));
            dspthreefeedbbean.setDriver((String)vector1.elementAt(3));
            dspthreefeedbbean.setDataSourceName((String)vector1.elementAt(4));
            dspthreefeedbbean.setSubAreaNumb((String)vector.elementAt(0));
            dspthreefeedbbean.setBuildingNumb((String)vector.elementAt(1));
            dspthreefeedbbean.setDoorNumb((String)vector.elementAt(2));
            dspthreefeedbbean.setFloorNumb((String)vector.elementAt(3));
            dspthreefeedbbean.setCellNumb((String)vector.elementAt(4));
            dspthreefeedbbean.setOwnerName((String)vector.elementAt(5));
            dspthreefeedbbean.setItem((String)vector.elementAt(6));
            try
            {
                dspthreefeedbbean.initialize();
            }
            catch(Exception exception1)
            {
                dspthreefeedbbean.setStatusCode(7602);
                dspthreefeedbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            switch(Integer.parseInt(dspthreefeedbbean.getItem().trim()))
            {
            case 0: // '\0'
                dspthreefeedbbean.setTableName("waterbasefeelog");
                dspthreefeedbbean.setTableName1("waterotherfeelog");
                dspthreefeedbbean.setFeeName("水费");
                break;

            case 1: // '\001'
                dspthreefeedbbean.setTableName("electricbasefeelog");
                dspthreefeedbbean.setTableName1("electricotherfeelog");
                dspthreefeedbbean.setFeeName("电费");
                break;

            case 2: // '\002'
                dspthreefeedbbean.setTableName("gasbasefeelog");
                dspthreefeedbbean.setTableName1("gasotherfeelog");
                dspthreefeedbbean.setFeeName("煤气费");
                break;
            }
            try
            {
                dspthreefeedbbean.setTableName2("livein");
                dspthreefeedbbean.setSelectSQL03("select tenement from " + dspthreefeedbbean.getTableName2() + " where  subarea = ? and building = ? and stair = ? and floor = ? and cell = ? and delflag = '0'");
                dspthreefeedbbean.select03();
                dspthreefeedbbean.getDataFromResult03();
                if(dspthreefeedbbean.getStatusCode() == 7601)
                {
                    dspthreefeedbbean.setTableName2("feecycle");
                    dspthreefeedbbean.setSelectSQL01("select " + dspthreefeedbbean.getTableName() + ".number, " + dspthreefeedbbean.getTableName() + ".cyclenum," + dspthreefeedbbean.getTableName() + ".meterdata," + dspthreefeedbbean.getTableName() + ".basefee," + dspthreefeedbbean.getTableName() + ".otherfee," + dspthreefeedbbean.getTableName() + ".allfee," + dspthreefeedbbean.getTableName() + ".flag," + dspthreefeedbbean.getTableName() + ".cashflag,feecycle.startdate,feecycle.enddate,feecycle.paystartdate,feecycle.payenddate from " + dspthreefeedbbean.getTableName() + "," + dspthreefeedbbean.getTableName2() + " where " + dspthreefeedbbean.getTableName() + ".cyclenum = feecycle.number and feecycle.delflag = '0' and " + dspthreefeedbbean.getTableName() + ".subareanumb = ? and " + dspthreefeedbbean.getTableName() + ".buildingnumb = ? and " + dspthreefeedbbean.getTableName() + ".doornumb = ? and " + dspthreefeedbbean.getTableName() + ".floornumb = ? and " + dspthreefeedbbean.getTableName() + ".cellnumb = ? and " + dspthreefeedbbean.getTableName() + ".delflag = '0' and " + dspthreefeedbbean.getTableName() + ".flag = '1'");
                    dspthreefeedbbean.select01();
                    dspthreefeedbbean.getDataFromResult01();
                    if(dspthreefeedbbean.getStatusCode() == 7601)
                    {
                        dspthreefeedbbean.setTableName2("feeitem");
                        dspthreefeedbbean.setSelectSQL04("select number,latefeerate,feeunit,feestandard,latefeedays from " + dspthreefeedbbean.getTableName2() + " where feename = ?");
                        dspthreefeedbbean.select04();
                        dspthreefeedbbean.getDataFromResult04();
                        if(dspthreefeedbbean.getStatusCode() == 7601)
                        {
                            for(int i = 0; i < dspthreefeedbbean.vecQ10.size(); i++)
                            {
                                dspthreefeedbbean.setBaseFeeNum((String)dspthreefeedbbean.vecQ10.elementAt(i));
                                dspthreefeedbbean.setTableName2("apportionitem");
                                dspthreefeedbbean.setSelectSQL02("select " + dspthreefeedbbean.getTableName1() + ".basefeenum," + dspthreefeedbbean.getTableName1() + ".itemfee, apportionitem.name from " + dspthreefeedbbean.getTableName1() + "," + dspthreefeedbbean.getTableName2() + " where apportionitem.number = " + dspthreefeedbbean.getTableName1() + ".itemnum and " + dspthreefeedbbean.getTableName1() + ".delflag = '0'  and " + dspthreefeedbbean.getTableName1() + ".basefeenum = ?");
                                dspthreefeedbbean.select02();
                                dspthreefeedbbean.getDataFromResult02();
                                dspthreefeedbbean.setLateDays(i);
                            }

                        } else
                        {
                            throw new Exception("收费项目表中没有该项收费，请核实");
                        }
                    }
                }
            }
            catch(Exception exception3)
            {
                dspthreefeedbbean.rollbackFromDB();
                throw exception3;
            }
            finally
            {
                dspthreefeedbbean.releaseConnection();
            }
            String s1 = "";
            FormatBean formatbean = new FormatBean();
            for(int j = 0; j < dspthreefeedbbean.vecQ3.size(); j++)
            {
                String s2 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ3.elementAt(j));
                s2 = formatbean.fomatMoney(s2);
                dspthreefeedbbean.vecQ3.setElementAt(s2, j);
            }

            for(int k = 0; k < dspthreefeedbbean.vecQ8.size(); k++)
            {
                String s3 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ8.elementAt(k));
                s3 = formatbean.fomatMoney(s3);
                s3 = dspthreefeedbbean.parseIndex(Double.parseDouble(s3));
                dspthreefeedbbean.vecQ8.setElementAt(s3, k);
            }

            for(int l = 0; l < dspthreefeedbbean.vecQ18.size(); l++)
            {
                String s4 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ18.elementAt(l));
                s4 = formatbean.fomatMoney(s4);
                dspthreefeedbbean.vecQ18.setElementAt(s4, l);
            }

            for(int i1 = 0; i1 < dspthreefeedbbean.vecQ19.size(); i1++)
            {
                String s5 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ19.elementAt(i1));
                s5 = formatbean.fomatMoney(s5);
                dspthreefeedbbean.vecQ19.setElementAt(s5, i1);
            }

            for(int j1 = 0; j1 < dspthreefeedbbean.vecQ21.size(); j1++)
            {
                String s6 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ21.elementAt(j1));
                s6 = formatbean.fomatMoney(s6);
                s6 = dspthreefeedbbean.parseIndex(Double.parseDouble(s6));
                dspthreefeedbbean.vecQ21.setElementAt(s6, j1);
            }

            for(int k1 = 0; k1 < dspthreefeedbbean.vecQ22.size(); k1++)
            {
                String s7 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ22.elementAt(k1));
                dspthreefeedbbean.vecQ22.setElementAt(s7, k1);
            }

            for(int l1 = 0; l1 < dspthreefeedbbean.vecQ24.size(); l1++)
            {
                String s8 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ24.elementAt(l1));
                s8 = formatbean.fomatMoney(s8);
                dspthreefeedbbean.vecQ24.setElementAt(s8, l1);
            }

            for(int i2 = 0; i2 < dspthreefeedbbean.vecQ12.size(); i2++)
            {
                String s9 = formatbean.fomatDouble((String)dspthreefeedbbean.vecQ12.elementAt(i2));
                s9 = formatbean.fomatMoney(s9);
                dspthreefeedbbean.vecQ12.setElementAt(s9, i2);
            }

            httpservletrequest.setAttribute("vecQ1", dspthreefeedbbean.vecQ1);
            httpservletrequest.setAttribute("vecQ2", dspthreefeedbbean.vecQ2);
            httpservletrequest.setAttribute("vecQ3", dspthreefeedbbean.vecQ3);
            httpservletrequest.setAttribute("vecQ4", dspthreefeedbbean.vecQ4);
            httpservletrequest.setAttribute("vecQ5", dspthreefeedbbean.vecQ5);
            httpservletrequest.setAttribute("vecQ6", dspthreefeedbbean.vecQ6);
            httpservletrequest.setAttribute("vecQ7", dspthreefeedbbean.vecQ7);
            httpservletrequest.setAttribute("vecQ8", dspthreefeedbbean.vecQ8);
            httpservletrequest.setAttribute("vecQ9", dspthreefeedbbean.vecQ9);
            httpservletrequest.setAttribute("vecQ10", dspthreefeedbbean.vecQ10);
            httpservletrequest.setAttribute("vecQ11", dspthreefeedbbean.vecQ11);
            httpservletrequest.setAttribute("vecQ12", dspthreefeedbbean.vecQ12);
            httpservletrequest.setAttribute("vecQ13", dspthreefeedbbean.vecQ13);
            httpservletrequest.setAttribute("vecQ14", dspthreefeedbbean.vecQ14);
            httpservletrequest.setAttribute("vecQ15", dspthreefeedbbean.vecQ15);
            httpservletrequest.setAttribute("vecQ16", dspthreefeedbbean.vecQ16);
            httpservletrequest.setAttribute("vecQ12", dspthreefeedbbean.vecQ12);
            httpservletrequest.setAttribute("vecQ17", dspthreefeedbbean.vecQ17);
            httpservletrequest.setAttribute("vecQ18", dspthreefeedbbean.vecQ18);
            httpservletrequest.setAttribute("vecQ19", dspthreefeedbbean.vecQ19);
            httpservletrequest.setAttribute("vecQ20", dspthreefeedbbean.vecQ20);
            httpservletrequest.setAttribute("vecQ21", dspthreefeedbbean.vecQ21);
            httpservletrequest.setAttribute("vecQ22", dspthreefeedbbean.vecQ22);
            httpservletrequest.setAttribute("vecQ23", dspthreefeedbbean.vecQ23);
            httpservletrequest.setAttribute("vecQ24", dspthreefeedbbean.vecQ24);
            httpservletrequest.setAttribute("meterstyle", dspthreefeedbbean.getTableName());
            httpservletrequest.setAttribute("SubAreaNumb", vector.elementAt(0));
            httpservletrequest.setAttribute("BuildingNumb", vector.elementAt(1));
            httpservletrequest.setAttribute("DoorNumb", vector.elementAt(2));
            httpservletrequest.setAttribute("FloorNumb", vector.elementAt(3));
            httpservletrequest.setAttribute("CellNumb", vector.elementAt(4));
            httpservletrequest.setAttribute("OwnerName", vector.elementAt(5));
            httpservletrequest.setAttribute("ItemNum", vector.elementAt(6));
            httpservletrequest.setAttribute("statusCode", (new Integer(dspthreefeedbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", dspthreefeedbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/AddThreeFeeInput.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable throwable)
        {
            try
            {
                DateTimeBean datetimebean1 = new DateTimeBean();
                System.out.println("[DspThreeFeeServlet][" + datetimebean1.getDate() + " " + datetimebean1.getTime() + "][" + throwable + "]");
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}