wateroutservlet.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:   WaterOutServlet.java

package interfacedata;

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 interfacedata:
//            FormatBean, WaterOutDBBean

public class WaterOutServlet extends ParentServlet
{

    public WaterOutServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            WaterOutDBBean wateroutdbbean = new WaterOutDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            FormatBean formatbean = new FormatBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            wateroutdbbean.setUserID((String)vector1.elementAt(0));
            wateroutdbbean.setPassword((String)vector1.elementAt(1));
            wateroutdbbean.setURL((String)vector1.elementAt(2));
            wateroutdbbean.setDriver((String)vector1.elementAt(3));
            wateroutdbbean.setDataSourceName((String)vector1.elementAt(4));
            wateroutdbbean.setSubAreaNumb((String)vector.elementAt(0));
            wateroutdbbean.setCycleNum((String)vector.elementAt(1));
            try
            {
                wateroutdbbean.initialize();
            }
            catch(Exception exception1)
            {
                wateroutdbbean.setStatusCode(7602);
                wateroutdbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            try
            {
                wateroutdbbean.setTableName("feecycle");
                wateroutdbbean.setSelectSQL02("select feecycle,startdate,enddate,paystartdate,payenddate from " + wateroutdbbean.getTableName() + " where  number = ? and delflag = '0'");
                wateroutdbbean.select02();
                wateroutdbbean.getDataFromResult02();
                wateroutdbbean.setTableName("waterbasefeelog");
                wateroutdbbean.setSelectSQL01("select distinct buildingnumb, doornumb, floornumb, cellnumb from " + wateroutdbbean.getTableName() + " where   cyclenum <= ? and subareanumb = ? and delflag = '0' and flag='1' order by buildingnumb asc,doornumb asc,floornumb asc,cellnumb asc");
                wateroutdbbean.select01();
                wateroutdbbean.getDataFromResult01();
                wateroutdbbean.setTableName1("feecycle");
                wateroutdbbean.setSelectSQL04("select distinct waterbasefeelog.cyclenum, feecycle.startdate, feecycle.enddate from " + wateroutdbbean.getTableName() + "," + wateroutdbbean.getTableName1() + " where    waterbasefeelog.flag='1' and waterbasefeelog.cyclenum <= ? and waterbasefeelog.subareanumb = ? and waterbasefeelog.delflag = '0' and waterbasefeelog.cyclenum=feecycle.number order by feecycle.startdate asc");
                wateroutdbbean.select04();
                wateroutdbbean.getDataFromResult04();
                if(!wateroutdbbean.vaddress.isEmpty())
                {
                    wateroutdbbean.setTableName("feeitem");
                    wateroutdbbean.setSelectSQL06("select feestandard from " + wateroutdbbean.getTableName() + " where number = 1 and delflag='0'");
                    wateroutdbbean.select06();
                    wateroutdbbean.getDataFromResult06();
                    String as[][] = new String[wateroutdbbean.vaddress.size() + 2][wateroutdbbean.vcycle.size() + 10];
                    for(int i = 1; i < wateroutdbbean.vaddress.size() + 1; i++)
                    {
                        as[i][0] = String.valueOf(i);
                        as[i][1] = (String)wateroutdbbean.vaddress.elementAt(i - 1);
                        as[i][7] = wateroutdbbean.getFeeStandard();
                    }

                    as[wateroutdbbean.vaddress.size() + 1][1] = "合计";
                    as[0][0] = "序号";
                    as[0][1] = "单元号";
                    as[0][2] = "户名";
                    as[0][3] = "水表底数";
                    as[0][4] = "上一次抄表读数";
                    as[0][5] = "本次抄表读数";
                    as[0][6] = "记费读数";
                    as[0][7] = "单价";
                    for(int j = 0; j < wateroutdbbean.vcycle.size(); j++)
                        if(j == wateroutdbbean.vcycle.size() - 1)
                            as[0][8] = String.valueOf(wateroutdbbean.vcycle.elementAt(j)) + "月实收金额";
                        else
                            as[0][9 + j] = String.valueOf(wateroutdbbean.vcycle.elementAt(j)) + "月欠费";

                    as[0][8 + wateroutdbbean.vcycle.size()] = "合计";
                    as[0][9 + wateroutdbbean.vcycle.size()] = "银行账号";
                    wateroutdbbean.setTableName("waterbasefeelog");
                    wateroutdbbean.setTableName1("feecycle");
                    wateroutdbbean.setTableName2("livein");
                    String s1 = "select waterbasefeelog.buildingnumb, waterbasefeelog.doornumb, waterbasefeelog.floornumb, waterbasefeelog.cellnumb, waterbasefeelog.allfee,waterbasefeelog.cyclenum, livein.tenement,livein.account ";
                    s1 = s1 + " from " + wateroutdbbean.getTableName() + "," + wateroutdbbean.getTableName1() + "," + wateroutdbbean.getTableName2();
                    s1 = s1 + " where waterbasefeelog.cyclenum = feecycle.number and waterbasefeelog.subareanumb = livein.subarea and waterbasefeelog.buildingnumb = livein.building and waterbasefeelog.doornumb = livein.stair and waterbasefeelog.floornumb = livein.floor and waterbasefeelog.cellnumb = livein.cell and waterbasefeelog.delflag='0' and feecycle.delflag='0' and livein.delflag = '0' ";
                    s1 = s1 + " and  waterbasefeelog.flag='1' and waterbasefeelog.cyclenum <= ? and waterbasefeelog.subareanumb = ? ";
                    s1 = s1 + " order by waterbasefeelog.buildingnumb asc,waterbasefeelog.doornumb asc,waterbasefeelog.floornumb asc,waterbasefeelog.cellnumb asc,feecycle.startdate asc";
                    wateroutdbbean.setSelectSQL03(s1);
                    wateroutdbbean.select03();
                    wateroutdbbean.getDataFromResult03();
                    for(int k = 0; k < wateroutdbbean.vbuilding.size(); k++)
                    {
                        wateroutdbbean.setBuildingNumb((String)wateroutdbbean.vbuilding.elementAt(k));
                        wateroutdbbean.setDoorNumb((String)wateroutdbbean.vdoor.elementAt(k));
                        wateroutdbbean.setFloorNumb((String)wateroutdbbean.vfloor.elementAt(k));
                        wateroutdbbean.setCellNumb((String)wateroutdbbean.vcell.elementAt(k));
                        wateroutdbbean.setTableName("watermeterinfo");
                        wateroutdbbean.setSelectSQL05("select meterdata from " + wateroutdbbean.getTableName() + " where cycle = ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        wateroutdbbean.select05();
                        wateroutdbbean.getDataFromResult05();
                        as[k + 1][5] = wateroutdbbean.getMeterData();
                        wateroutdbbean.setMeterData("");
                        wateroutdbbean.setSelectSQL05("select max(meterdata) from " + wateroutdbbean.getTableName() + " where cycle < ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        wateroutdbbean.select05();
                        wateroutdbbean.getDataFromResult05();
                        as[k + 1][4] = wateroutdbbean.getMeterData();
                        wateroutdbbean.setMeterData("");
                        wateroutdbbean.setTableName("waterbasefeelog");
                        wateroutdbbean.setSelectSQL05("select meterdata from " + wateroutdbbean.getTableName() + " where cyclenum = ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        wateroutdbbean.select05();
                        wateroutdbbean.getDataFromResult05();
                        as[k + 1][6] = wateroutdbbean.getMeterData();
                        wateroutdbbean.setMeterData("");
                        if(as[k + 1][4] == null && as[k + 1][4].equals(""))
                        {
                            wateroutdbbean.setTableName("roomexam");
                            wateroutdbbean.setSelectSQL07("select max(waternumber) from " + wateroutdbbean.getTableName() + " where subarea = ? and building = ? and stair=? and floor=? and cell=? and delflag='0'");
                            wateroutdbbean.select07();
                            wateroutdbbean.getDataFromResult07();
                            as[k + 1][3] = wateroutdbbean.getMeterData();
                            wateroutdbbean.setMeterData("");
                        }
                    }