retrievegenthreefeeservlet.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:   RetrieveGenThreeFeeServlet.java

package finance;

import common.*;
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:
//            FormatBean, RetrieveGenThreeFeeDBBean

public class RetrieveGenThreeFeeServlet extends ParentServlet
{

    public RetrieveGenThreeFeeServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            RetrieveGenThreeFeeDBBean retrievegenthreefeedbbean = new RetrieveGenThreeFeeDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            retrievegenthreefeedbbean.setUserID((String)vector1.elementAt(0));
            retrievegenthreefeedbbean.setPassword((String)vector1.elementAt(1));
            retrievegenthreefeedbbean.setURL((String)vector1.elementAt(2));
            retrievegenthreefeedbbean.setDriver((String)vector1.elementAt(3));
            retrievegenthreefeedbbean.setDataSourceName((String)vector1.elementAt(4));
            retrievegenthreefeedbbean.setItem((String)vector.elementAt(0));
            retrievegenthreefeedbbean.setSubAreaNumb("%" + (String)vector.elementAt(1) + "%");
            retrievegenthreefeedbbean.setBuildingNumb("%" + (String)vector.elementAt(2) + "%");
            retrievegenthreefeedbbean.setDoorNumb("%" + (String)vector.elementAt(3) + "%");
            retrievegenthreefeedbbean.setFloorNumb("%" + (String)vector.elementAt(4) + "%");
            retrievegenthreefeedbbean.setCellNumb("%" + (String)vector.elementAt(5) + "%");
            retrievegenthreefeedbbean.setCycleNum((String)vector.elementAt(6));
            try
            {
                retrievegenthreefeedbbean.initialize();
            }
            catch(Exception exception1)
            {
                retrievegenthreefeedbbean.setStatusCode(7602);
                retrievegenthreefeedbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            switch(Integer.parseInt(retrievegenthreefeedbbean.getItem().trim()))
            {
            case 0: // '\0'
                retrievegenthreefeedbbean.setTableName("waterbasefeelog");
                retrievegenthreefeedbbean.setTableName1("waterotherfeelog");
                retrievegenthreefeedbbean.setFeeName("水费");
                break;

            case 1: // '\001'
                retrievegenthreefeedbbean.setTableName("electricbasefeelog");
                retrievegenthreefeedbbean.setTableName1("electricotherfeelog");
                retrievegenthreefeedbbean.setFeeName("电费");
                break;

            case 2: // '\002'
                retrievegenthreefeedbbean.setTableName("gasbasefeelog");
                retrievegenthreefeedbbean.setTableName1("gasotherfeelog");
                retrievegenthreefeedbbean.setFeeName("煤气费");
                break;
            }
            try
            {
                retrievegenthreefeedbbean.setTableName2("feecycle");
                retrievegenthreefeedbbean.setSelectSQL01("select startdate,enddate,paystartdate,payenddate from " + retrievegenthreefeedbbean.getTableName2() + " where number = ?");
                retrievegenthreefeedbbean.select01();
                retrievegenthreefeedbbean.getDataFromResult01();
                retrievegenthreefeedbbean.setSelectSQL02("select number, subareanumb,buildingnumb,doornumb,floornumb,cellnumb,meterdata,basefee,otherfee,allfee,flag from " + retrievegenthreefeedbbean.getTableName() + " where subareanumb like ? and buildingnumb like ? and doornumb like ? and floornumb like ? and cellnumb like ? and cyclenum=? and delflag='0' order by subareanumb asc,buildingnumb asc,doornumb asc,floornumb asc,cellnumb asc");
                retrievegenthreefeedbbean.select02();
                retrievegenthreefeedbbean.getDataFromResult02();
                if(!retrievegenthreefeedbbean.vtqbnumber.isEmpty())
                {
                    retrievegenthreefeedbbean.setTableName2("apportionitem");
                    String s5 = "select " + retrievegenthreefeedbbean.getTableName() + ".number," + retrievegenthreefeedbbean.getTableName() + ".subareanumb," + retrievegenthreefeedbbean.getTableName() + ".buildingnumb," + retrievegenthreefeedbbean.getTableName() + ".doornumb," + retrievegenthreefeedbbean.getTableName() + ".floornumb," + retrievegenthreefeedbbean.getTableName() + ".cellnumb," + retrievegenthreefeedbbean.getTableName() + ".meterdata," + retrievegenthreefeedbbean.getTableName() + ".basefee," + retrievegenthreefeedbbean.getTableName() + ".otherfee," + retrievegenthreefeedbbean.getTableName() + ".allfee," + retrievegenthreefeedbbean.getTableName() + ".flag," + retrievegenthreefeedbbean.getTableName1() + ".number," + retrievegenthreefeedbbean.getTableName1() + ".basefeenum," + retrievegenthreefeedbbean.getTableName2() + ".name," + retrievegenthreefeedbbean.getTableName1() + ".itemfee from " + retrievegenthreefeedbbean.getTableName2() + "," + retrievegenthreefeedbbean.getTableName1() + "," + retrievegenthreefeedbbean.getTableName() + " where ";
                    s5 = s5 + retrievegenthreefeedbbean.getTableName1() + ".delflag='0' and " + retrievegenthreefeedbbean.getTableName1() + ".basefeenum=" + retrievegenthreefeedbbean.getTableName() + ".number and " + retrievegenthreefeedbbean.getTableName1() + ".itemnum=" + retrievegenthreefeedbbean.getTableName2() + ".number and " + retrievegenthreefeedbbean.getTableName() + ".delflag='0' and " + retrievegenthreefeedbbean.getTableName2() + ".delflag='0' and " + retrievegenthreefeedbbean.getTableName() + ".subareanumb like ? and " + retrievegenthreefeedbbean.getTableName() + ".buildingnumb like ? and " + retrievegenthreefeedbbean.getTableName() + ".doornumb like ? and " + retrievegenthreefeedbbean.getTableName() + ".floornumb like ? and " + retrievegenthreefeedbbean.getTableName() + ".cellnumb like ? and " + retrievegenthreefeedbbean.getTableName() + ".cyclenum=? order by " + retrievegenthreefeedbbean.getTableName() + ".subareanumb asc," + retrievegenthreefeedbbean.getTableName() + ".buildingnumb asc," + retrievegenthreefeedbbean.getTableName() + ".doornumb asc," + retrievegenthreefeedbbean.getTableName() + ".floornumb asc," + retrievegenthreefeedbbean.getTableName() + ".cellnumb asc," + retrievegenthreefeedbbean.getTableName1() + ".itemnum asc";
                    retrievegenthreefeedbbean.setSelectSQL03(s5);
                    retrievegenthreefeedbbean.select03();
                    retrievegenthreefeedbbean.getDataFromResult03();
                }
            }
            catch(Exception exception3)
            {
                retrievegenthreefeedbbean.rollbackFromDB();
                throw exception3;
            }
            finally
            {
                retrievegenthreefeedbbean.releaseConnection();
            }
            String s1 = "";
            FormatBean formatbean = new FormatBean();
            for(int i = 0; i < retrievegenthreefeedbbean.vitemfee.size(); i++)
            {
                String s2 = formatbean.fomatDouble((String)retrievegenthreefeedbbean.vitemfee.elementAt(i));
                s2 = formatbean.fomatMoney(s2);
                s2 = formatbean.parseIndex(Double.parseDouble(s2));
                retrievegenthreefeedbbean.vitemfee.setElementAt(s2, i);
            }

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

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

            try
            {
                String s6 = (String)vector.elementAt(7);
                Vector vector2 = new Vector();
                boolean flag = true;
                boolean flag2 = false;
                if(retrievegenthreefeedbbean.vitemname.size() > 0)
                {
                    vector2.addElement(((String)retrievegenthreefeedbbean.vitemname.elementAt(0)).trim());
                    for(int l = 1; l < retrievegenthreefeedbbean.vitemname.size(); l++)
                    {