countwaterfeeservlet.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:   CountWaterFeeServlet.java

package finance;

import common.*;
import finance.statistic.StatWaterPayDBBean;
import java.io.PrintStream;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.*;

// Referenced classes of package finance:
//            CountWaterFeeDBBean, FormatBean

public class CountWaterFeeServlet extends ParentServlet
{

    public CountWaterFeeServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            CountWaterFeeDBBean countwaterfeedbbean = new CountWaterFeeDBBean();
            StatWaterPayDBBean statwaterpaydbbean = new StatWaterPayDBBean();
            DateTimeBean datetimebean1 = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            FormatBean formatbean = new FormatBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            countwaterfeedbbean.setUserID((String)vector1.elementAt(0));
            countwaterfeedbbean.setPassword((String)vector1.elementAt(1));
            countwaterfeedbbean.setURL((String)vector1.elementAt(2));
            countwaterfeedbbean.setDriver((String)vector1.elementAt(3));
            countwaterfeedbbean.setDataSourceName((String)vector1.elementAt(4));
            countwaterfeedbbean.setFeecycle((String)vector.elementAt(0));
            countwaterfeedbbean.setCashflag("0");
            countwaterfeedbbean.setFlag1("1");
            countwaterfeedbbean.setDelflag("0");
            try
            {
                countwaterfeedbbean.initialize();
            }
            catch(Exception exception1)
            {
                throw exception1;
            }
            try
            {
                statwaterpaydbbean.connBean = ((ParentDBBean) (countwaterfeedbbean)).connBean;
                countwaterfeedbbean.setParaName("WaterCountBy");
                countwaterfeedbbean.selectPara();
                if(countwaterfeedbbean.getStatusCode() == 9013)
                    throw new Exception("在参数表中没有该参数" + countwaterfeedbbean.getParaName());
                countwaterfeedbbean.setCountby(Integer.parseInt(countwaterfeedbbean.getParaValue()));
                countwaterfeedbbean.setTableName("waterbasefeelog");
                countwaterfeedbbean.setFeename("水费");
                countwaterfeedbbean.setSelectSQL15(" SELECT  COUNT(NUMBER) FROM " + countwaterfeedbbean.getTableName() + " WHERE( CYCLENUM = ?  AND DELFLAG = '0') ");
                try
                {
                    countwaterfeedbbean.select15();
                    countwaterfeedbbean.getDataFromResult15();
                }
                catch(Exception exception3)
                {
                    throw exception3;
                }
                if(Integer.parseInt(countwaterfeedbbean.vecCount.elementAt(0).toString()) == 0)
                {
                    countwaterfeedbbean.setTableName("feeitem");
                    countwaterfeedbbean.setFeename("水费");
                    countwaterfeedbbean.setSelectSQL01(" SELECT  feestandard FROM " + countwaterfeedbbean.getTableName() + " WHERE( NUMBER = 1 AND FEENAME = ?  AND DELFLAG = '0') ");
                    try
                    {
                        countwaterfeedbbean.select01();
                        countwaterfeedbbean.getDataFromResult01();
                    }
                    catch(Exception exception4)
                    {
                        throw exception4;
                    }
                    if(countwaterfeedbbean.getStatusCode() != 8654)
                    {
                        countwaterfeedbbean.setTableName("apportionitem");
                        countwaterfeedbbean.setSelectSQL10(" SELECT  NUMBER, FLAG2, VALUE FROM " + countwaterfeedbbean.getTableName() + " WHERE( FLAG1= '0' AND FLAG3= '0' AND DELFLAG = '0')");
                        try
                        {
                            countwaterfeedbbean.select10();
                            countwaterfeedbbean.getDataFromResult10();
                        }
                        catch(Exception exception5)
                        {
                            throw exception5;
                        }
                        countwaterfeedbbean.setTableName("livein");
                        countwaterfeedbbean.setSelectSQL02(" SELECT  SUBAREA, BUILDING, STAIR, FLOOR, CELL FROM " + countwaterfeedbbean.getTableName() + " WHERE( DELFLAG = '0')");
                        try
                        {
                            countwaterfeedbbean.select02();
                            countwaterfeedbbean.getDataFromResult02();
                        }
                        catch(Exception exception6)
                        {
                            throw exception6;
                        }
                        if(countwaterfeedbbean.getStatusCode() != 8659)
                        {
                            if(countwaterfeedbbean.getCountby() == 0)
                            {
                                for(int i = 0; i < countwaterfeedbbean.vecL1.size(); i++)
                                {
                                    double d = 0.0D;
                                    countwaterfeedbbean.setSubareanumb(countwaterfeedbbean.vecL1.elementAt(i).toString());
                                    countwaterfeedbbean.setBuildingnumb(countwaterfeedbbean.vecL2.elementAt(i).toString());
                                    countwaterfeedbbean.setDoornumb(countwaterfeedbbean.vecL3.elementAt(i).toString());
                                    countwaterfeedbbean.setFloornumb(countwaterfeedbbean.vecL4.elementAt(i).toString());
                                    countwaterfeedbbean.setCellnumb(countwaterfeedbbean.vecL5.elementAt(i).toString());
                                    countwaterfeedbbean.setTableName("watermeterinfo");
                                    countwaterfeedbbean.setSelectSQL03(" SELECT  METERDATA FROM " + countwaterfeedbbean.getTableName() + " WHERE( SUBAREANUMB = ? AND BUILDINGNUMB = ? AND DOORNUMB = ? AND FLOORNUMB = ? AND CELLNUMB = ? AND CYCLE <= ? AND  DELFLAG = '0')");
                                    try
                                    {
                                        countwaterfeedbbean.select03();
                                        countwaterfeedbbean.getDataFromResult03();
                                    }
                                    catch(Exception exception8)
                                    {
                                        throw exception8;
                                    }
                                    if(countwaterfeedbbean.vecC1.size() == 0)
                                    {
                                        d = 0.0D;
                                        countwaterfeedbbean.setStatusCode(8672);
                                    } else
                                    if(countwaterfeedbbean.vecC1.size() == 1)
                                    {
                                        countwaterfeedbbean.setTableName("watermeterinfo");
                                        countwaterfeedbbean.setSelectSQL04(" SELECT  METERDATA FROM " + countwaterfeedbbean.getTableName() + " WHERE( SUBAREANUMB = ? AND BUILDINGNUMB = ? AND DOORNUMB = ? AND FLOORNUMB = ? AND CELLNUMB = ? AND CYCLE = ? AND  DELFLAG = '0') ");
                                        try
                                        {
                                            countwaterfeedbbean.select04();
                                            countwaterfeedbbean.getDataFromResult04();
                                        }
                                        catch(Exception exception9)
                                        {
                                            throw exception9;
                                        }
                                        if(countwaterfeedbbean.getStatusCode() == 8671)
                                        {
                                            d = 0.0D;
                                            countwaterfeedbbean.setStatusCode(8672);
                                        } else
                                        if(countwaterfeedbbean.vecM1.size() == 1)
                                        {
                                            statwaterpaydbbean.setSubAreaNumb(countwaterfeedbbean.getSubareanumb());
                                            statwaterpaydbbean.setBuildingNumb(countwaterfeedbbean.getBuildingnumb());
                                            statwaterpaydbbean.setDoorNumb(countwaterfeedbbean.getDoornumb());
                                            statwaterpaydbbean.setFloorNumb(countwaterfeedbbean.getFloornumb());
                                            statwaterpaydbbean.setCellNumb(countwaterfeedbbean.getCellnumb());
                                            statwaterpaydbbean.setTableName("roomexam");
                                            statwaterpaydbbean.setSelectSQL07("select max(waternumber) from " + statwaterpaydbbean.getTableName() + " where subarea = ? and building = ? and stair=? and floor=? and cell=? and delflag='0'");
                                            statwaterpaydbbean.select07();
                                            statwaterpaydbbean.getDataFromResult07();
                                            if(statwaterpaydbbean.getMeterData().equals(""))
                                                d = Double.parseDouble(countwaterfeedbbean.vecM1.elementAt(0).toString());
                                            else
                                                d = Double.parseDouble(countwaterfeedbbean.vecM1.elementAt(0).toString()) - Double.parseDouble(statwaterpaydbbean.getMeterData());