retrievegenmanagefeeservlet.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:   RetrieveGenManageFeeServlet.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, RetrieveGenManageFeeDBBean

public class RetrieveGenManageFeeServlet extends ParentServlet
{

    public RetrieveGenManageFeeServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            RetrieveGenManageFeeDBBean retrievegenmanagefeedbbean = new RetrieveGenManageFeeDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            retrievegenmanagefeedbbean.setUserID((String)vector1.elementAt(0));
            retrievegenmanagefeedbbean.setPassword((String)vector1.elementAt(1));
            retrievegenmanagefeedbbean.setURL((String)vector1.elementAt(2));
            retrievegenmanagefeedbbean.setDriver((String)vector1.elementAt(3));
            retrievegenmanagefeedbbean.setDataSourceName((String)vector1.elementAt(4));
            retrievegenmanagefeedbbean.setSubAreaNumb("%" + (String)vector.elementAt(0) + "%");
            retrievegenmanagefeedbbean.setBuildingNumb("%" + (String)vector.elementAt(1) + "%");
            retrievegenmanagefeedbbean.setDoorNumb("%" + (String)vector.elementAt(2) + "%");
            retrievegenmanagefeedbbean.setFloorNumb("%" + (String)vector.elementAt(3) + "%");
            retrievegenmanagefeedbbean.setCellNumb("%" + (String)vector.elementAt(4) + "%");
            retrievegenmanagefeedbbean.setCycleNum((String)vector.elementAt(5));
            try
            {
                retrievegenmanagefeedbbean.initialize();
            }
            catch(Exception exception1)
            {
                retrievegenmanagefeedbbean.setStatusCode(7602);
                retrievegenmanagefeedbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            try
            {
                retrievegenmanagefeedbbean.setTableName("feelog");
                retrievegenmanagefeedbbean.setTableName1("feeitem");
                retrievegenmanagefeedbbean.setTableName2("feecycle");
                retrievegenmanagefeedbbean.setSelectSQL01("select startdate,enddate,paystartdate,payenddate from " + retrievegenmanagefeedbbean.getTableName2() + " where number = ?");
                retrievegenmanagefeedbbean.select01();
                retrievegenmanagefeedbbean.getDataFromResult01();
                String s4 = "select feelog.number, feelog.subareanumb,feelog.buildingnumb,feelog.doornumb,feelog.floornumb,feelog.cellnumb,feelog.feeunits,feelog.fee,feelog.flag,feeitem.feename from " + retrievegenmanagefeedbbean.getTableName() + "," + retrievegenmanagefeedbbean.getTableName1() + " where feelog.feenum=feeitem.number and feelog.subareanumb like ? and feelog.buildingnumb like ? and feelog.doornumb like ? and feelog.floornumb like ? and feelog.cellnumb like ? and ";
                s4 = s4 + "(feelog.cyclenum=" + retrievegenmanagefeedbbean.getCycleNum();
                retrievegenmanagefeedbbean.setCycleNum(String.valueOf(Integer.parseInt(retrievegenmanagefeedbbean.getCycleNum()) + 1));
                s4 = s4 + " or feelog.cyclenum = " + retrievegenmanagefeedbbean.getCycleNum();
                retrievegenmanagefeedbbean.setCycleNum(String.valueOf(Integer.parseInt(retrievegenmanagefeedbbean.getCycleNum()) + 1));
                s4 = s4 + " or feelog.cyclenum = " + retrievegenmanagefeedbbean.getCycleNum() + ") and feelog.delflag='0' and feeitem.delflag='0' order by feelog.subareanumb asc,feelog.buildingnumb asc,feelog.doornumb asc,feelog.floornumb asc,feelog.cellnumb asc";
                retrievegenmanagefeedbbean.setSelectSQL02(s4);
                retrievegenmanagefeedbbean.select02();
                retrievegenmanagefeedbbean.getDataFromResult02();
                retrievegenmanagefeedbbean.setCycleNum(String.valueOf(Integer.parseInt(retrievegenmanagefeedbbean.getCycleNum()) - 2));
            }
            catch(Exception exception3)
            {
                retrievegenmanagefeedbbean.rollbackFromDB();
                throw exception3;
            }
            finally
            {
                retrievegenmanagefeedbbean.releaseConnection();
            }
            String s1 = "";
            FormatBean formatbean = new FormatBean();
            for(int i = 0; i < retrievegenmanagefeedbbean.vmeterdata.size(); i++)
            {
                String s2 = formatbean.fomatDouble((String)retrievegenmanagefeedbbean.vmeterdata.elementAt(i));
                s2 = formatbean.fomatMoney(s2);
                retrievegenmanagefeedbbean.vmeterdata.setElementAt(s2, i);
            }

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

            try
            {
                String s5 = (String)vector.elementAt(6);
                String s6 = getServletConfig().getServletContext().getRealPath("/finance/statistic/");
                String s7 = s6 + "PrtGenManageData.html";
                PrintWriter printwriter = new PrintWriter(new FileWriter(s7));
                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 colspan=\"17\">管理费批量计算表</td></tr>");
                printwriter.println("<tr><td colspan=\"17\">统计时间:" + datetimebean.getDate() + "&nbsp;" + datetimebean.getTime() + "</td></tr>");
                printwriter.println("<tr>");
                printwriter.println("<td>住址</td>");
                printwriter.println("<td>面积</td>");
                printwriter.println("<td>金额</td>");
                printwriter.println("<td>是否交费</td>");
                printwriter.println("</tr>");
                for(int k = 0; k < retrievegenmanagefeedbbean.vqbnumber.size(); k++)
                {
                    printwriter.println("<tr>");
                    printwriter.println("<td>" + retrievegenmanagefeedbbean.vaddress.elementAt(k) + "</td>");
                    printwriter.println("<td>" + retrievegenmanagefeedbbean.vmeterdata.elementAt(k) + "</td>");
                    printwriter.println("<td>" + retrievegenmanagefeedbbean.vbasefee.elementAt(k) + "</td>");
                    if(((String)retrievegenmanagefeedbbean.vflag.elementAt(k)).equals("0"))
                        printwriter.println("<td>已缴纳</td>");
                    else
                        printwriter.println("<td>未缴纳</td>");
                    printwriter.println("</tr>");
                }

                printwriter.println("</table>");
                printwriter.println("</body>");
                printwriter.println("</html>");
                printwriter.flush();
                printwriter.close();
                RequestDispatcher requestdispatcher2 = getServletContext().getRequestDispatcher("/finance/statistic/PrtGenManageData.exe");
                requestdispatcher2.forward(httpservletrequest, httpservletresponse);
            }
            catch(ArrayIndexOutOfBoundsException _ex)
            {
                httpservletrequest.setAttribute("startdate", retrievegenmanagefeedbbean.startdate);
                httpservletrequest.setAttribute("enddate", retrievegenmanagefeedbbean.enddate);
                httpservletrequest.setAttribute("paystartdate", retrievegenmanagefeedbbean.paystartdate);
                httpservletrequest.setAttribute("payenddate", retrievegenmanagefeedbbean.payenddate);
                httpservletrequest.setAttribute("vqbnumber", retrievegenmanagefeedbbean.vqbnumber);
                httpservletrequest.setAttribute("vaddress", retrievegenmanagefeedbbean.vaddress);
                httpservletrequest.setAttribute("vmeterdata", retrievegenmanagefeedbbean.vmeterdata);
                httpservletrequest.setAttribute("vbasefee", retrievegenmanagefeedbbean.vbasefee);
                httpservletrequest.setAttribute("vflag", retrievegenmanagefeedbbean.vflag);
                httpservletrequest.setAttribute("vfeename", retrievegenmanagefeedbbean.vfeename);
                httpservletrequest.setAttribute("cyclenum", retrievegenmanagefeedbbean.getCycleNum());
                httpservletrequest.setAttribute("statusCode", (new Integer(retrievegenmanagefeedbbean.getStatusCode())).toString());
                httpservletrequest.setAttribute("statusMessage", retrievegenmanagefeedbbean.getStatusMessage());
                RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/RetrieveGenManageFeeResult.jsp");
                requestdispatcher1.forward(httpservletrequest, httpservletresponse);
            }
        }
        catch(Throwable throwable)
        {
            try
            {
                DateTimeBean datetimebean1 = new DateTimeBean();
                System.out.println("[RetrieveGenManageFeeServlet][" + datetimebean1.getDate() + " " + datetimebean1.getTime() + "][" + throwable + "]");
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}