genarrearageblacklistservlet.java

华磊物业管理系统源码 (仅供参考)

// 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:   GenArrearageBlacklistServlet.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:
//            GenArrearageBlacklistDBBean

public class GenArrearageBlacklistServlet extends ParentServlet
{

    public GenArrearageBlacklistServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            GenArrearageBlacklistDBBean genarrearageblacklistdbbean = new GenArrearageBlacklistDBBean();
            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");
            genarrearageblacklistdbbean.setUserID((String)vector1.elementAt(0));
            genarrearageblacklistdbbean.setPassword((String)vector1.elementAt(1));
            genarrearageblacklistdbbean.setURL((String)vector1.elementAt(2));
            genarrearageblacklistdbbean.setDriver((String)vector1.elementAt(3));
            genarrearageblacklistdbbean.setDataSourceName((String)vector1.elementAt(4));
            try
            {
                genarrearageblacklistdbbean.initialize();
            }
            catch(Exception exception1)
            {
                genarrearageblacklistdbbean.setStatusCode(7682);
                genarrearageblacklistdbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            try
            {
                genarrearageblacklistdbbean.setTableName("feeitem");
                genarrearageblacklistdbbean.setSelectSQL01("select number,feename from " + genarrearageblacklistdbbean.getTableName() + " where delflag='0' and cycleflag = '1' order by number asc");
                genarrearageblacklistdbbean.select01();
                genarrearageblacklistdbbean.getDataFromResult01();
                genarrearageblacklistdbbean.setTableName("livein");
                genarrearageblacklistdbbean.setSelectLive("select subarea,building,stair,floor,cell,tenement from " + genarrearageblacklistdbbean.getTableName() + " where delflag = '0' order by subarea asc,building asc,stair asc,floor asc,cell asc ");
                genarrearageblacklistdbbean.SelectLive();
                genarrearageblacklistdbbean.getDataLive();
                String as[][] = new String[genarrearageblacklistdbbean.liveSubarea.size() + 1][genarrearageblacklistdbbean.feenumber.size() + 3];
                as[0][0] = "住址";
                as[0][1] = "业主";
                httpservletrequest.setAttribute("alli", String.valueOf(genarrearageblacklistdbbean.liveSubarea.size() + 1));
                httpservletrequest.setAttribute("allj", String.valueOf(genarrearageblacklistdbbean.feenumber.size() + 3));
                genarrearageblacklistdbbean.setNowdate(datetimebean.getDate());
                for(int i = 0; i < genarrearageblacklistdbbean.liveSubarea.size(); i++)
                {
                    genarrearageblacklistdbbean.setSubarea((String)genarrearageblacklistdbbean.liveSubarea.elementAt(i));
                    genarrearageblacklistdbbean.setBuilding((String)genarrearageblacklistdbbean.liveBuilding.elementAt(i));
                    genarrearageblacklistdbbean.setStair((String)genarrearageblacklistdbbean.liveStair.elementAt(i));
                    genarrearageblacklistdbbean.setFloor((String)genarrearageblacklistdbbean.liveFloor.elementAt(i));
                    genarrearageblacklistdbbean.setCell((String)genarrearageblacklistdbbean.liveCell.elementAt(i));
                    as[i + 1][0] = genarrearageblacklistdbbean.getSubarea() + genarrearageblacklistdbbean.getBuilding() + "-" + genarrearageblacklistdbbean.getStair() + "-" + genarrearageblacklistdbbean.getFloor() + genarrearageblacklistdbbean.getCell();
                    as[i + 1][1] = (String)genarrearageblacklistdbbean.livetenement.elementAt(i);
                }

                for(int j = 0; j < genarrearageblacklistdbbean.feenumber.size(); j++)
                {
                    as[0][j + 2] = (String)genarrearageblacklistdbbean.feename.elementAt(j);
                    genarrearageblacklistdbbean.setTableName("feecycle");
                    switch(j)
                    {
                    case 0: // '\0'
                        genarrearageblacklistdbbean.setTableName1("waterbasefeelog");
                        genarrearageblacklistdbbean.setSelectSQL02("select waterbasefeelog.number,waterbasefeelog.subareanumb,waterbasefeelog.buildingnumb,waterbasefeelog.doornumb,waterbasefeelog.floornumb,waterbasefeelog.cellnumb,waterbasefeelog.allfee from " + genarrearageblacklistdbbean.getTableName() + "," + genarrearageblacklistdbbean.getTableName1() + " where waterbasefeelog.delflag = '0' and waterbasefeelog.flag='1' and feecycle.number=waterbasefeelog.cyclenum and feecycle.payenddate<? and feecycle.delflag='0' order by waterbasefeelog.subareanumb asc,waterbasefeelog.buildingnumb asc,waterbasefeelog.doornumb asc,waterbasefeelog.floornumb asc,waterbasefeelog.cellnumb asc,waterbasefeelog.number asc");
                        genarrearageblacklistdbbean.select02();
                        genarrearageblacklistdbbean.getDataFromResult02();
                        genarrearageblacklistdbbean.parseotherdata();
                        break;

                    case 1: // '\001'
                        genarrearageblacklistdbbean.setTableName1("electricbasefeelog");
                        genarrearageblacklistdbbean.setSelectSQL02("select electricbasefeelog.number,electricbasefeelog.subareanumb,electricbasefeelog.buildingnumb,electricbasefeelog.doornumb,electricbasefeelog.floornumb,electricbasefeelog.cellnumb,electricbasefeelog.allfee from " + genarrearageblacklistdbbean.getTableName() + "," + genarrearageblacklistdbbean.getTableName1() + " where  electricbasefeelog.delflag = '0' and electricbasefeelog.flag='1' and feecycle.number=electricbasefeelog.cyclenum and feecycle.payenddate<? and feecycle.delflag='0' order by electricbasefeelog.subareanumb asc,electricbasefeelog.buildingnumb asc,electricbasefeelog.doornumb asc,electricbasefeelog.floornumb asc,electricbasefeelog.cellnumb asc,electricbasefeelog.number asc");
                        genarrearageblacklistdbbean.select02();
                        genarrearageblacklistdbbean.getDataFromResult02();
                        genarrearageblacklistdbbean.parseotherdata();
                        break;

                    case 2: // '\002'
                        genarrearageblacklistdbbean.setTableName1("gasbasefeelog");
                        genarrearageblacklistdbbean.setSelectSQL02("select gasbasefeelog.number,gasbasefeelog.subareanumb,gasbasefeelog.buildingnumb,gasbasefeelog.doornumb,gasbasefeelog.floornumb,gasbasefeelog.cellnumb,gasbasefeelog.allfee from " + genarrearageblacklistdbbean.getTableName() + "," + genarrearageblacklistdbbean.getTableName1() + " where gasbasefeelog.delflag = '0' and gasbasefeelog.flag='1' and feecycle.number=gasbasefeelog.cyclenum and feecycle.payenddate<? and feecycle.delflag='0' order by gasbasefeelog.subareanumb asc,gasbasefeelog.buildingnumb asc,gasbasefeelog.doornumb asc,gasbasefeelog.floornumb asc,gasbasefeelog.cellnumb asc,gasbasefeelog.number asc");
                        genarrearageblacklistdbbean.select02();
                        genarrearageblacklistdbbean.getDataFromResult02();
                        genarrearageblacklistdbbean.parseotherdata();
                        break;

                    default:
                        genarrearageblacklistdbbean.setTableName2("feelog");
                        genarrearageblacklistdbbean.setSelectSQL03("select feelog.subareanumb,feelog.buildingnumb,feelog.doornumb,feelog.floornumb,feelog.cellnumb,feelog.fee from " + genarrearageblacklistdbbean.getTableName() + "," + genarrearageblacklistdbbean.getTableName2() + " where feelog.delflag = '0' and feelog.flag='1' and feecycle.number=feelog.cyclenum and feecycle.payenddate<? and feelog.feenum = ? ");
                        genarrearageblacklistdbbean.setFeeNum((String)genarrearageblacklistdbbean.feenumber.elementAt(j));
                        genarrearageblacklistdbbean.select03();
                        genarrearageblacklistdbbean.getDataFromResult03();
                        genarrearageblacklistdbbean.parseotherdata();
                        break;
                    }
                    for(int k = 0; k < genarrearageblacklistdbbean.vitemaddress.size(); k++)
                    {
                        boolean flag = false;
                        for(int l = 1; l < genarrearageblacklistdbbean.liveSubarea.size() + 1; l++)
                        {
                            if(!((String)genarrearageblacklistdbbean.vitemaddress.elementAt(k)).equals(as[l][0]))
                                continue;
                            String s3 = (String)genarrearageblacklistdbbean.vitemallfee.elementAt(k);
                            s3 = formatbean.fomatDouble(s3);
                            s3 = formatbean.parseIndex(Double.parseDouble(s3));
                            as[l][j + 2] = s3;
                            boolean flag1 = true;
                            break;
                        }

                    }

                    genarrearageblacklistdbbean.vitemaddress.removeAllElements();
                    genarrearageblacklistdbbean.vitemallfee.removeAllElements();
                }

                httpservletrequest.setAttribute("all", as);
                String s1 = getServletConfig().getServletContext().getRealPath("/finance/statistic/");
                String s2 = s1 + "PrtBlackList.html";
                PrintWriter printwriter = new PrintWriter(new FileWriter(s2));
                printwriter.println("<html>");
                printwriter.println("<head>");
                printwriter.println("<title>");
                printwriter.println("光大花园物业管理系统财务子系统");
                printwriter.println("</title>");
                printwriter.println("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">");
                printwriter.println("</head>");
                printwriter.println("<body> ");
                printwriter.println("<table>");
                printwriter.println("  <tr> <td align=\"center\" colspan=\"10\" >收费管理—欠费黑名单</td></tr>");
                printwriter.println("  <tr> <td align=\"right\" colspan=\"10\" >统计时间:" + datetimebean.getDate() + "&nbsp;" + datetimebean.getTime() + "</td></tr>");
                double d = 0.0D;
                boolean flag2 = false;
                printwriter.println("<tr>");
                for(int i1 = 0; i1 < (genarrearageblacklistdbbean.feenumber.size() + 3) - 1; i1++)
                    printwriter.println("<td>" + as[0][i1] + " </td>");

                printwriter.println("<td>合计</td>");
                printwriter.println("</tr>");
                for(int j1 = 1; j1 < genarrearageblacklistdbbean.liveSubarea.size() + 1; j1++)
                {
                    for(int k1 = 2; k1 < (genarrearageblacklistdbbean.feenumber.size() + 3) - 1; k1++)
                        if(as[j1][k1] != null)
                        {
                            d += Double.parseDouble(as[j1][k1]);
                            flag2 = true;
                        }

                    if(flag2)
                        as[j1][(genarrearageblacklistdbbean.feenumber.size() + 3) - 1] = String.valueOf(d);
                    if(flag2)
                    {
                        printwriter.println("<tr>");
                        for(int l1 = 0; l1 < genarrearageblacklistdbbean.feenumber.size() + 3; l1++)
                        {
                            printwriter.println("<td>");
                            if(as[j1][l1] != null)
                                if(as[j1][l1].equals("0.00"))
                                    printwriter.println("欠");
                                else
                                    printwriter.println(as[j1][l1]);
                            printwriter.println("&nbsp");
                            printwriter.println("</td>");
                        }

                        printwriter.println("</tr>");
                    }
                    flag2 = false;
                    d = 0.0D;
                }

                printwriter.println("</table>");
                printwriter.println("</body>");
                printwriter.println("</html>");
                printwriter.flush();
                printwriter.close();
            }
            catch(Exception exception3)
            {
                genarrearageblacklistdbbean.rollbackFromDB();
                throw exception3;
            }
            finally
            {
                genarrearageblacklistdbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("statusCode", (new Integer(genarrearageblacklistdbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", genarrearageblacklistdbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/statistic/PrtBlackList.exe");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable throwable)
        {
            try
            {
                DateTimeBean datetimebean1 = new DateTimeBean();
                System.out.println("[GenArrearageBlacklistServlet][" + datetimebean1.getDate() + " " + datetimebean1.getTime() + "][" + throwable + "]");
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}