countgasfeeservlet.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:   CountGasFeeServlet.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:
//            CountGasFeeDBBean, FormatBean

public class CountGasFeeServlet extends ParentServlet
{

    public CountGasFeeServlet()
    {
    }

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