statwaterpayservlet.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:   StatWaterPayServlet.java

package finance.statistic;

import common.*;
import finance.FormatBean;
import java.io.*;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

// Referenced classes of package finance.statistic:
//            StatWaterPayDBBean

public class StatWaterPayServlet extends ParentServlet
{

    public StatWaterPayServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            StatWaterPayDBBean statwaterpaydbbean = new StatWaterPayDBBean();
            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");
            statwaterpaydbbean.setUserID((String)vector1.elementAt(0));
            statwaterpaydbbean.setPassword((String)vector1.elementAt(1));
            statwaterpaydbbean.setURL((String)vector1.elementAt(2));
            statwaterpaydbbean.setDriver((String)vector1.elementAt(3));
            statwaterpaydbbean.setDataSourceName((String)vector1.elementAt(4));
            statwaterpaydbbean.setSubAreaNumb((String)vector.elementAt(0));
            statwaterpaydbbean.setCycleNum((String)vector.elementAt(1));
            try
            {
                statwaterpaydbbean.initialize();
            }
            catch(Exception exception1)
            {
                statwaterpaydbbean.setStatusCode(7602);
                statwaterpaydbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            try
            {
                statwaterpaydbbean.setTableName("feecycle");
                statwaterpaydbbean.setSelectSQL02("select feecycle,startdate,enddate,paystartdate,payenddate from " + statwaterpaydbbean.getTableName() + " where  number = ? and delflag = '0'");
                statwaterpaydbbean.select02();
                statwaterpaydbbean.getDataFromResult02();
                statwaterpaydbbean.setTableName("payfeelog");
                statwaterpaydbbean.setSelectSQL01("select distinct buildingnumb, doornumb, floornumb, cellnumb from " + statwaterpaydbbean.getTableName() + " where (feenum = 1) and paydate >= ? and paydate <= ? and subareanumb = ? and delflag = '0' order by buildingnumb asc,doornumb asc,floornumb asc,cellnumb asc");
                statwaterpaydbbean.select01();
                statwaterpaydbbean.getDataFromResult01();
                statwaterpaydbbean.setTableName1("feecycle");
                statwaterpaydbbean.setSelectSQL04("select distinct payfeelog.cyclenum, feecycle.startdate, feecycle.enddate from " + statwaterpaydbbean.getTableName() + "," + statwaterpaydbbean.getTableName1() + " where payfeelog.feenum = 1 and payfeelog.paydate >= ? and payfeelog.paydate <= ? and payfeelog.subareanumb = ? and payfeelog.delflag = '0' and payfeelog.cyclenum=feecycle.number order by feecycle.startdate asc");
                statwaterpaydbbean.select04();
                statwaterpaydbbean.getDataFromResult04();
                statwaterpaydbbean.setTableName("feeitem");
                statwaterpaydbbean.setSelectSQL06("select feestandard from " + statwaterpaydbbean.getTableName() + " where number = 1 and delflag='0'");
                statwaterpaydbbean.select06();
                statwaterpaydbbean.getDataFromResult06();
                String as[][] = new String[statwaterpaydbbean.vaddress.size() + 2][statwaterpaydbbean.vcycle.size() + 9];
                for(int i = 1; i < statwaterpaydbbean.vaddress.size() + 1; i++)
                {
                    as[i][0] = String.valueOf(i);
                    as[i][1] = (String)statwaterpaydbbean.vaddress.elementAt(i - 1);
                    as[i][7] = statwaterpaydbbean.getFeeStandard();
                }

                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 < statwaterpaydbbean.vcycle.size(); j++)
                    if(j == statwaterpaydbbean.vcycle.size() - 1)
                        as[0][8] = String.valueOf(statwaterpaydbbean.vcycle.elementAt(j)) + "月实收金额";
                    else
                        as[0][9 + j] = String.valueOf(statwaterpaydbbean.vcycle.elementAt(j)) + "月欠费";

                as[0][8 + statwaterpaydbbean.vcycle.size()] = "合计";
                if(!statwaterpaydbbean.vaddress.isEmpty())
                {
                    as[statwaterpaydbbean.vaddress.size() + 1][1] = "合计";
                    statwaterpaydbbean.setTableName("payfeelog");
                    statwaterpaydbbean.setTableName1("feecycle");
                    statwaterpaydbbean.setTableName2("livein");
                    String s1 = "select payfeelog.buildingnumb, payfeelog.doornumb, payfeelog.floornumb, payfeelog.cellnumb, payfeelog.allfee,payfeelog.cyclenum, livein.tenement ";
                    s1 = s1 + " from " + statwaterpaydbbean.getTableName() + "," + statwaterpaydbbean.getTableName1() + "," + statwaterpaydbbean.getTableName2();
                    s1 = s1 + " where payfeelog.cyclenum = feecycle.number and payfeelog.subareanumb = livein.subarea and payfeelog.buildingnumb = livein.building and payfeelog.doornumb = livein.stair and payfeelog.floornumb = livein.floor and payfeelog.cellnumb = livein.cell and payfeelog.delflag='0' and feecycle.delflag='0' and livein.delflag = '0' ";
                    s1 = s1 + " and (payfeelog.feenum = 1) and payfeelog.paydate >= ? and payfeelog.paydate <= ? and payfeelog.subareanumb = ? ";
                    s1 = s1 + " order by payfeelog.buildingnumb asc,payfeelog.doornumb asc,payfeelog.floornumb asc,payfeelog.cellnumb asc,feecycle.startdate asc";
                    statwaterpaydbbean.setSelectSQL03(s1);
                    statwaterpaydbbean.select03();
                    statwaterpaydbbean.getDataFromResult03();
                    for(int k = 0; k < statwaterpaydbbean.vbuilding.size(); k++)
                    {
                        statwaterpaydbbean.setBuildingNumb((String)statwaterpaydbbean.vbuilding.elementAt(k));
                        statwaterpaydbbean.setDoorNumb((String)statwaterpaydbbean.vdoor.elementAt(k));
                        statwaterpaydbbean.setFloorNumb((String)statwaterpaydbbean.vfloor.elementAt(k));
                        statwaterpaydbbean.setCellNumb((String)statwaterpaydbbean.vcell.elementAt(k));
                        statwaterpaydbbean.setTableName("watermeterinfo");
                        statwaterpaydbbean.setSelectSQL05("select meterdata from " + statwaterpaydbbean.getTableName() + " where cycle = ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        statwaterpaydbbean.select05();
                        statwaterpaydbbean.getDataFromResult05();
                        as[k + 1][5] = statwaterpaydbbean.getMeterData();
                        statwaterpaydbbean.setMeterData("");
                        statwaterpaydbbean.setSelectSQL05("select max(meterdata) from " + statwaterpaydbbean.getTableName() + " where cycle < ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        statwaterpaydbbean.select05();
                        statwaterpaydbbean.getDataFromResult05();
                        as[k + 1][4] = statwaterpaydbbean.getMeterData();
                        statwaterpaydbbean.setMeterData("");
                        statwaterpaydbbean.setTableName("waterbasefeelog");
                        statwaterpaydbbean.setSelectSQL05("select meterdata from " + statwaterpaydbbean.getTableName() + " where cyclenum = ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        statwaterpaydbbean.select05();
                        statwaterpaydbbean.getDataFromResult05();
                        as[k + 1][6] = statwaterpaydbbean.getMeterData();
                        statwaterpaydbbean.setMeterData("");
                        if(as[k + 1][4] == null || as[k + 1][4].equals(""))
                        {
                            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();
                            as[k + 1][3] = statwaterpaydbbean.getMeterData();
                            statwaterpaydbbean.setMeterData("");