dspupdgenthreefeeservlet.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:   DspUpdGenThreeFeeServlet.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:
//            DspUpdGenThreeFeeDBBean, FormatBean

public class DspUpdGenThreeFeeServlet extends ParentServlet
{

    public DspUpdGenThreeFeeServlet()
    {
    }

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

                case 1: // '\001'
                    dspupdgenthreefeedbbean.setTableName("electricbasefeelog");
                    dspupdgenthreefeedbbean.setTableName1("electricotherfeelog");
                    break;

                case 2: // '\002'
                    dspupdgenthreefeedbbean.setTableName("gasbasefeelog");
                    dspupdgenthreefeedbbean.setTableName1("gasotherfeelog");
                    break;
                }
                String s5 = "";
                if(i == 0)
                {
                    String s6 = "(number=" + vector.elementAt(2);
                    for(int k = 3; k < vector.size() - 1; k++)
                        s6 = s6 + " or number=" + vector.elementAt(k);

                    s6 = s6 + ")";
                    dspupdgenthreefeedbbean.setSelectSQL02("select number, subareanumb,buildingnumb,doornumb,floornumb,cellnumb,meterdata,basefee,otherfee,allfee,flag from " + dspupdgenthreefeedbbean.getTableName() + " where " + s6 + " and delflag='0' order by subareanumb asc,buildingnumb asc,doornumb asc,floornumb asc,cellnumb asc");
                    dspupdgenthreefeedbbean.select02();
                    dspupdgenthreefeedbbean.getDataFromResult02();
                } else
                {
                    String s7 = "(" + dspupdgenthreefeedbbean.getTableName() + ".number=" + vector.elementAt(2);
                    for(int l = 3; l < vector.size() - 1; l++)
                        s7 = s7 + " or " + dspupdgenthreefeedbbean.getTableName() + ".number=" + vector.elementAt(l);

                    s7 = s7 + ")";
                    dspupdgenthreefeedbbean.setTableName2("apportionitem");
                    String s8 = "select " + dspupdgenthreefeedbbean.getTableName() + ".number," + dspupdgenthreefeedbbean.getTableName() + ".subareanumb," + dspupdgenthreefeedbbean.getTableName() + ".buildingnumb," + dspupdgenthreefeedbbean.getTableName() + ".doornumb," + dspupdgenthreefeedbbean.getTableName() + ".floornumb," + dspupdgenthreefeedbbean.getTableName() + ".cellnumb," + dspupdgenthreefeedbbean.getTableName() + ".meterdata," + dspupdgenthreefeedbbean.getTableName() + ".basefee," + dspupdgenthreefeedbbean.getTableName() + ".otherfee," + dspupdgenthreefeedbbean.getTableName() + ".allfee," + dspupdgenthreefeedbbean.getTableName() + ".flag," + dspupdgenthreefeedbbean.getTableName1() + ".number," + dspupdgenthreefeedbbean.getTableName1() + ".basefeenum," + dspupdgenthreefeedbbean.getTableName2() + ".name," + dspupdgenthreefeedbbean.getTableName1() + ".itemfee from " + dspupdgenthreefeedbbean.getTableName2() + "," + dspupdgenthreefeedbbean.getTableName1() + "," + dspupdgenthreefeedbbean.getTableName() + " where ";
                    s8 = s8 + dspupdgenthreefeedbbean.getTableName1() + ".delflag='0' and " + dspupdgenthreefeedbbean.getTableName1() + ".basefeenum=" + dspupdgenthreefeedbbean.getTableName() + ".number and " + dspupdgenthreefeedbbean.getTableName1() + ".itemnum=" + dspupdgenthreefeedbbean.getTableName2() + ".number and " + dspupdgenthreefeedbbean.getTableName() + ".delflag='0' and " + dspupdgenthreefeedbbean.getTableName2() + ".delflag='0' and " + s7 + " order by " + dspupdgenthreefeedbbean.getTableName() + ".subareanumb asc," + dspupdgenthreefeedbbean.getTableName() + ".buildingnumb asc," + dspupdgenthreefeedbbean.getTableName() + ".doornumb asc," + dspupdgenthreefeedbbean.getTableName() + ".floornumb asc," + dspupdgenthreefeedbbean.getTableName() + ".cellnumb asc," + dspupdgenthreefeedbbean.getTableName1() + ".itemnum asc";
                    dspupdgenthreefeedbbean.setSelectSQL03(s8);
                    dspupdgenthreefeedbbean.select03();
                    dspupdgenthreefeedbbean.getDataFromResult03();
                }
            }
            catch(Exception exception3)
            {
                dspupdgenthreefeedbbean.rollbackFromDB();
                throw exception3;
            }
            finally
            {
                dspupdgenthreefeedbbean.releaseConnection();
            }
            String s1 = "";
            FormatBean formatbean = new FormatBean();
            for(int j = 0; j < dspupdgenthreefeedbbean.vitemfee.size(); j++)
            {
                String s2 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.vitemfee.elementAt(j));
                s2 = formatbean.fomatMoney(s2);
                s2 = formatbean.parseIndex(Double.parseDouble(s2));
                dspupdgenthreefeedbbean.vitemfee.setElementAt(s2, j);
            }

            for(int i1 = 0; i1 < dspupdgenthreefeedbbean.vbasefee.size(); i1++)
            {
                String s3 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.vbasefee.elementAt(i1));
                s3 = formatbean.fomatMoney(s3);
                s3 = formatbean.parseIndex(Double.parseDouble(s3));
                dspupdgenthreefeedbbean.vbasefee.setElementAt(s3, i1);
                s3 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.votherfee.elementAt(i1));
                s3 = formatbean.fomatMoney(s3);
                s3 = formatbean.parseIndex(Double.parseDouble(s3));
                dspupdgenthreefeedbbean.votherfee.setElementAt(s3, i1);
                s3 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.vallfee.elementAt(i1));
                s3 = formatbean.fomatMoney(s3);
                s3 = formatbean.parseIndex(Double.parseDouble(s3));
                dspupdgenthreefeedbbean.vallfee.setElementAt(s3, i1);
            }

            for(int j1 = 0; j1 < dspupdgenthreefeedbbean.vtbasefee.size(); j1++)
            {
                String s4 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.vtbasefee.elementAt(j1));
                s4 = formatbean.fomatMoney(s4);
                s4 = formatbean.parseIndex(Double.parseDouble(s4));
                dspupdgenthreefeedbbean.vtbasefee.setElementAt(s4, j1);
                s4 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.vtotherfee.elementAt(j1));
                s4 = formatbean.fomatMoney(s4);
                s4 = formatbean.parseIndex(Double.parseDouble(s4));
                dspupdgenthreefeedbbean.vtotherfee.setElementAt(s4, j1);
                s4 = formatbean.fomatDouble((String)dspupdgenthreefeedbbean.vtallfee.elementAt(j1));
                s4 = formatbean.fomatMoney(s4);
                s4 = formatbean.parseIndex(Double.parseDouble(s4));
                dspupdgenthreefeedbbean.vtallfee.setElementAt(s4, j1);
            }

            httpservletrequest.setAttribute("item", dspupdgenthreefeedbbean.getItem());
            httpservletrequest.setAttribute("ccyclenum", (String)vector.elementAt(vector.size() - 1));
            httpservletrequest.setAttribute("vi", String.valueOf(i));
            httpservletrequest.setAttribute("startdate", dspupdgenthreefeedbbean.startdate);
            httpservletrequest.setAttribute("enddate", dspupdgenthreefeedbbean.enddate);
            httpservletrequest.setAttribute("paystartdate", dspupdgenthreefeedbbean.paystartdate);
            httpservletrequest.setAttribute("payenddate", dspupdgenthreefeedbbean.payenddate);
            if(i == 0)
            {
                httpservletrequest.setAttribute("vtqbnumber", dspupdgenthreefeedbbean.vtqbnumber);
                httpservletrequest.setAttribute("vtaddress", dspupdgenthreefeedbbean.vtaddress);
                httpservletrequest.setAttribute("vtmeterdata", dspupdgenthreefeedbbean.vtmeterdata);
                httpservletrequest.setAttribute("vtbasefee", dspupdgenthreefeedbbean.vtbasefee);
                httpservletrequest.setAttribute("vtotherfee", dspupdgenthreefeedbbean.vtotherfee);
                httpservletrequest.setAttribute("vtallfee", dspupdgenthreefeedbbean.vtallfee);
                httpservletrequest.setAttribute("vtflag", dspupdgenthreefeedbbean.vtflag);
            } else
            {
                httpservletrequest.setAttribute("vqbnumber", dspupdgenthreefeedbbean.vqbnumber);
                httpservletrequest.setAttribute("vaddress", dspupdgenthreefeedbbean.vaddress);
                httpservletrequest.setAttribute("vmeterdata", dspupdgenthreefeedbbean.vmeterdata);
                httpservletrequest.setAttribute("vbasefee", dspupdgenthreefeedbbean.vbasefee);
                httpservletrequest.setAttribute("votherfee", dspupdgenthreefeedbbean.votherfee);
                httpservletrequest.setAttribute("vallfee", dspupdgenthreefeedbbean.vallfee);
                httpservletrequest.setAttribute("vflag", dspupdgenthreefeedbbean.vflag);
                httpservletrequest.setAttribute("vonumber", dspupdgenthreefeedbbean.vonumber);
                httpservletrequest.setAttribute("vobnum", dspupdgenthreefeedbbean.vobnum);
                httpservletrequest.setAttribute("vitemname", dspupdgenthreefeedbbean.vitemname);
                httpservletrequest.setAttribute("vitemfee", dspupdgenthreefeedbbean.vitemfee);
            }
            httpservletrequest.setAttribute("statusCode", (new Integer(dspupdgenthreefeedbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", dspupdgenthreefeedbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/UpdateGenThreeFeeInput.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable throwable)
        {
            try
            {
                DateTimeBean datetimebean1 = new DateTimeBean();
                System.out.println("[DspUpdGenThreeFeeServlet][" + datetimebean1.getDate() + " " + datetimebean1.getTime() + "][" + throwable + "]");
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}