manageoutservlet.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:   ManageOutServlet.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:
//            ManageOutDBBean, FormatBean

public class ManageOutServlet extends ParentServlet
{

    public ManageOutServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            ManageOutDBBean manageoutdbbean = new ManageOutDBBean();
            FormatBean formatbean = new FormatBean();
            DateTimeBean datetimebean1 = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            manageoutdbbean.setUserID((String)vector1.elementAt(0));
            manageoutdbbean.setPassword((String)vector1.elementAt(1));
            manageoutdbbean.setURL((String)vector1.elementAt(2));
            manageoutdbbean.setDriver((String)vector1.elementAt(3));
            manageoutdbbean.setDataSourceName((String)vector1.elementAt(4));
            manageoutdbbean.setSubAreaNumb((String)vector.elementAt(0));
            manageoutdbbean.setCycleNum(String.valueOf(Integer.parseInt((String)vector.elementAt(1)) + 2));
            try
            {
                manageoutdbbean.initialize();
            }
            catch(Exception exception1)
            {
                manageoutdbbean.setStatusCode(7602);
                manageoutdbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            try
            {
                manageoutdbbean.setTableName("feecycle");
                manageoutdbbean.setSelectSQL02("select feecycle,startdate,enddate,paystartdate,payenddate from " + manageoutdbbean.getTableName() + " where  number = ? and delflag = '0'");
                manageoutdbbean.select02();
                manageoutdbbean.getDataFromResult02();
                manageoutdbbean.setTableName("feelog");
                manageoutdbbean.setSelectSQL01("select distinct buildingnumb, doornumb, floornumb, cellnumb from " + manageoutdbbean.getTableName() + " where (feenum = 4 or feenum = 5 or feenum = 6 ) and cyclenum <= ? and subareanumb = ? and delflag = '0' and flag='1' order by buildingnumb asc,doornumb asc,floornumb asc,cellnumb asc");
                manageoutdbbean.select01();
                manageoutdbbean.getDataFromResult01();
                if(!manageoutdbbean.vaddress.isEmpty())
                {
                    String as[][] = new String[manageoutdbbean.vaddress.size() + 1][18];
                    for(int j = 0; j < manageoutdbbean.vaddress.size(); j++)
                    {
                        as[j][0] = String.valueOf(j);
                        as[j][1] = (String)manageoutdbbean.vaddress.elementAt(j);
                    }

                    as[manageoutdbbean.vaddress.size()][1] = "合计";
                    manageoutdbbean.setTableName("feelog");
                    manageoutdbbean.setTableName1("feecycle");
                    manageoutdbbean.setTableName2("livein");
                    String s3 = "select feelog.buildingnumb, feelog.doornumb, feelog.floornumb, feelog.cellnumb, feelog.fee,feecycle.startdate, livein.tenement,livein.account ";
                    s3 = s3 + " from " + manageoutdbbean.getTableName() + "," + manageoutdbbean.getTableName1() + "," + manageoutdbbean.getTableName2();
                    s3 = s3 + " where feelog.cyclenum = feecycle.number and feelog.subareanumb = livein.subarea and feelog.buildingnumb = livein.building and feelog.doornumb = livein.stair and feelog.floornumb = livein.floor and feelog.cellnumb = livein.cell and feelog.delflag='0' and feecycle.delflag='0' and livein.delflag = '0'";
                    s3 = s3 + " and (feelog.feenum = 4 or feelog.feenum = 5 or feelog.feenum = 6) and feelog.cyclenum <= ? and feelog.subareanumb = ? and feelog.flag='1' ";
                    s3 = s3 + " order by feelog.buildingnumb asc,feelog.doornumb asc,feelog.floornumb asc,feelog.cellnumb asc";
                    manageoutdbbean.setSelectSQL03(s3);
                    manageoutdbbean.select03();
                    manageoutdbbean.getDataFromResult03();
                    int k = 0;
                    double d = 0.0D;
                    String s4 = "";
                    boolean flag = false;
                    for(int i1 = 0; i1 < manageoutdbbean.vtaddress.size(); i1++)
                    {
                        for(int j1 = k; j1 < manageoutdbbean.vaddress.size(); j1++)
                        {
                            if(!((String)manageoutdbbean.vtaddress.elementAt(i1)).equals((String)manageoutdbbean.vaddress.elementAt(j1)))
                                continue;
                            String s5 = (String)manageoutdbbean.vtstartdate.elementAt(i1);
                            int l;
                            if(s5.substring(0, 4).equals(manageoutdbbean.getStartDate().substring(0, 4)))
                            {
                                s5 = s5.substring(5, 7);
                                l = Integer.parseInt(s5);
                            } else
                            {
                                l = 0;
                            }
                            if(as[j1][l + 3] == null)
                            {
                                as[j1][l + 3] = (String)manageoutdbbean.vtsalefee.elementAt(i1);
                            } else
                            {
                                double d1 = Double.parseDouble(as[j1][l + 3]);
                                d1 += Double.parseDouble((String)manageoutdbbean.vtsalefee.elementAt(i1));
                                as[j1][l + 3] = String.valueOf(d1);
                            }
                            if(as[j1][2] == null)
                                as[j1][2] = (String)manageoutdbbean.vttenement.elementAt(i1);
                            if(as[manageoutdbbean.vaddress.size()][l + 3] == null)
                            {
                                as[manageoutdbbean.vaddress.size()][l + 3] = (String)manageoutdbbean.vtsalefee.elementAt(i1);
                            } else
                            {
                                double d2 = Double.parseDouble(as[manageoutdbbean.vaddress.size()][l + 3]);
                                d2 += Double.parseDouble((String)manageoutdbbean.vtsalefee.elementAt(i1));
                                as[manageoutdbbean.vaddress.size()][l + 3] = String.valueOf(d2);
                            }
                            if(as[j1][16] == null)
                            {
                                as[j1][16] = (String)manageoutdbbean.vtsalefee.elementAt(i1);
                            } else
                            {
                                double d3 = Double.parseDouble(as[j1][16]);
                                d3 += Double.parseDouble((String)manageoutdbbean.vtsalefee.elementAt(i1));
                                as[j1][16] = String.valueOf(d3);
                            }
                            if(as[manageoutdbbean.vaddress.size()][16] == null)
                            {
                                as[manageoutdbbean.vaddress.size()][16] = (String)manageoutdbbean.vtsalefee.elementAt(i1);
                            } else
                            {
                                double d4 = Double.parseDouble(as[manageoutdbbean.vaddress.size()][16]);
                                d4 += Double.parseDouble((String)manageoutdbbean.vtsalefee.elementAt(i1));
                                as[manageoutdbbean.vaddress.size()][16] = String.valueOf(d4);
                            }
                            if(as[j1][17] == null)
                                as[j1][17] = (String)manageoutdbbean.vtaccount.elementAt(i1);
                            k = j1;
                            break;
                        }

                    }

                    httpservletrequest.setAttribute("stat", as);
                    for(int k1 = 0; k1 < manageoutdbbean.vaddress.size() + 1; k1++)
                    {
                        for(int l1 = 0; l1 < 18; l1++)
                            if(as[k1][l1] == null)
                                as[k1][l1] = "";

                    }

                    for(int i2 = 4; i2 < 17; i2++)
                    {
                        String s6 = "";
                        s6 = formatbean.fomatDouble(as[manageoutdbbean.vaddress.size()][i2]);
                        as[manageoutdbbean.vaddress.size()][i2] = s6;
                    }

                    String s7 = "";
                    for(int j2 = 0; j2 < manageoutdbbean.vaddress.size() + 1; j2++)
                    {
                        s7 = s7 + as[j2][1] + "\t" + as[j2][2] + "\t";
                        for(int k2 = 4; k2 < 17; k2++)
                            s7 = s7 + as[j2][k2] + "\t";

                        s7 = s7 + as[j2][17] + "\n";
                    }

                    manageoutdbbean.setTemp(s7);
                    manageoutdbbean.setMailContent("\\WebSphere\\AppServer\\hosts\\pms_host\\pmsApp\\pages\\interfacedata\\manage.pms");
                }
            }
            catch(Exception exception3)
            {
                manageoutdbbean.rollbackFromDB();
                throw exception3;
            }
            finally
            {
                manageoutdbbean.releaseConnection();
            }
            String s1 = "";
            for(int i = 0; i < manageoutdbbean.vtsalefee.size(); i++)
            {
                String s2 = formatbean.fomatDouble((String)manageoutdbbean.vtsalefee.elementAt(i));
                s2 = formatbean.fomatMoney(s2);
                s2 = formatbean.parseIndex(Double.parseDouble(s2));
                manageoutdbbean.vtsalefee.setElementAt(s2, i);
            }

            httpservletrequest.setAttribute("subarea", (String)vector.elementAt(0));
            httpservletrequest.setAttribute("cycledate", manageoutdbbean.getStartDate());
            httpservletrequest.setAttribute("nowdate", datetimebean1.getYear() + "年" + datetimebean1.getMonth() + "月");
            httpservletrequest.setAttribute("size", String.valueOf(manageoutdbbean.vaddress.size()));
            httpservletrequest.setAttribute("statusCode", (new Integer(manageoutdbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", manageoutdbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/interfacedata/ManageOutResults.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable throwable)
        {
            try
            {
                DateTimeBean datetimebean = new DateTimeBean();
                System.out.println("[StatManagePayServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "][" + throwable + "]");
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}