addelectricmeterrecservlet.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:   AddElectricMeterRecServlet.java

package finance;

import common.*;
import finance.statistic.StatWaterPayDBBean;
import java.io.PrintStream;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.*;

// Referenced classes of package finance:
//            AddElectricMeterRecDBBean

public class AddElectricMeterRecServlet extends ParentServlet
{

    public AddElectricMeterRecServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            AddElectricMeterRecDBBean addelectricmeterrecdbbean = new AddElectricMeterRecDBBean();
            StatWaterPayDBBean statwaterpaydbbean = new StatWaterPayDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            Vector vector = (Vector)getServletContext().getAttribute("Para");
            addelectricmeterrecdbbean.setUserID((String)vector.elementAt(0));
            addelectricmeterrecdbbean.setPassword((String)vector.elementAt(1));
            addelectricmeterrecdbbean.setURL((String)vector.elementAt(2));
            addelectricmeterrecdbbean.setDriver((String)vector.elementAt(3));
            addelectricmeterrecdbbean.setDataSourceName((String)vector.elementAt(4));
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
            addelectricmeterrecdbbean.setSubareanumb(vector1.elementAt(0).toString().trim());
            addelectricmeterrecdbbean.setBuildingnumb(vector1.elementAt(1).toString().trim());
            addelectricmeterrecdbbean.setDoornumb(vector1.elementAt(2).toString().trim());
            addelectricmeterrecdbbean.setFloornumb(vector1.elementAt(3).toString().trim());
            addelectricmeterrecdbbean.setCellnumb(vector1.elementAt(4).toString().trim());
            addelectricmeterrecdbbean.setMeternum(vector1.elementAt(5).toString().trim());
            addelectricmeterrecdbbean.setMeterdate(vector1.elementAt(6).toString().trim() + "-" + vector1.elementAt(7).toString().trim() + "-" + vector1.elementAt(8).toString().trim());
            addelectricmeterrecdbbean.setMeterdata(vector1.elementAt(9).toString().trim());
            addelectricmeterrecdbbean.setMeterman(vector1.elementAt(10).toString().trim());
            addelectricmeterrecdbbean.setCycle(vector1.elementAt(11).toString().trim());
            try
            {
                addelectricmeterrecdbbean.initialize();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            try
            {
                if(!addelectricmeterrecdbbean.getSubareanumb().trim().equals("") || !addelectricmeterrecdbbean.getBuildingnumb().trim().equals("") || !addelectricmeterrecdbbean.getDoornumb().trim().equals("") || !addelectricmeterrecdbbean.getFloornumb().trim().equals("") || !addelectricmeterrecdbbean.getCellnumb().trim().equals(""))
                    addelectricmeterrecdbbean.setFlag2("0");
                else
                    addelectricmeterrecdbbean.setFlag2("1");
                addelectricmeterrecdbbean.setDelflag1("0");
                addelectricmeterrecdbbean.setTableName("apparatusfit");
                addelectricmeterrecdbbean.setTableName1("apparatusinfo");
                if(!addelectricmeterrecdbbean.getMeternum().trim().equals(""))
                {
                    addelectricmeterrecdbbean.setFlag1("0");
                    addelectricmeterrecdbbean.setSelectSQL02("select apparatusfit.subareanumb,apparatusfit.buildingnumb,apparatusfit.doornumb,apparatusfit.floornumb,apparatusfit.cellnumb from " + addelectricmeterrecdbbean.getTableName() + "," + addelectricmeterrecdbbean.getTableName1() + " where apparatusfit.apparatusnumb = apparatusinfo.apparatusnumb and apparatusinfo.delflag = '0' and apparatusfit.delflag = '0' and apparatusinfo.apparatuskind = '电表' and apparatusfit.apparatus = ?");
                    addelectricmeterrecdbbean.select02();
                    addelectricmeterrecdbbean.getDataFromResult02();
                    if(addelectricmeterrecdbbean.getStatusCode() == 7767)
                        if(addelectricmeterrecdbbean.getFlag2().equals("0"))
                        {
                            if(((String)addelectricmeterrecdbbean.vecQ1.elementAt(0)).trim().equals(addelectricmeterrecdbbean.getSubareanumb()) && ((String)addelectricmeterrecdbbean.vecQ2.elementAt(0)).trim().equals(addelectricmeterrecdbbean.getBuildingnumb()) && ((String)addelectricmeterrecdbbean.vecQ3.elementAt(0)).trim().equals(addelectricmeterrecdbbean.getDoornumb()) && ((String)addelectricmeterrecdbbean.vecQ4.elementAt(0)).trim().equals(addelectricmeterrecdbbean.getFloornumb()) && ((String)addelectricmeterrecdbbean.vecQ5.elementAt(0)).trim().equals(addelectricmeterrecdbbean.getCellnumb()))
                            {
                                addelectricmeterrecdbbean.setStatusCode(7767);
                            } else
                            {
                                addelectricmeterrecdbbean.setStatusCode(7770);
                                addelectricmeterrecdbbean.setStatusMessage("输入的地址和表编号不匹配，请核实");
                            }
                        } else
                        if(addelectricmeterrecdbbean.vecQ1.size() == 1)
                        {
                            addelectricmeterrecdbbean.setSubareanumb(addelectricmeterrecdbbean.vecQ1.elementAt(0).toString().trim());
                            addelectricmeterrecdbbean.setBuildingnumb(addelectricmeterrecdbbean.vecQ2.elementAt(0).toString().trim());
                            addelectricmeterrecdbbean.setDoornumb(addelectricmeterrecdbbean.vecQ3.elementAt(0).toString().trim());
                            addelectricmeterrecdbbean.setFloornumb(addelectricmeterrecdbbean.vecQ4.elementAt(0).toString().trim());
                            addelectricmeterrecdbbean.setCellnumb(addelectricmeterrecdbbean.vecQ5.elementAt(0).toString().trim());
                        } else
                        {
                            addelectricmeterrecdbbean.setStatusCode(7771);
                            addelectricmeterrecdbbean.setStatusMessage("您输入的地址安装了多块电表，请输入表编号以便区分");
                        }
                } else
                {
                    addelectricmeterrecdbbean.setFlag1("1");
                    addelectricmeterrecdbbean.setSelectSQL02("select apparatusfit.apparatus from " + addelectricmeterrecdbbean.getTableName() + "," + addelectricmeterrecdbbean.getTableName1() + " where apparatusfit.apparatusnumb = apparatusinfo.apparatusnumb and apparatusinfo.delflag = '0' and apparatusfit.delflag = '0' and apparatusinfo.apparatuskind = '电表' and apparatusfit.subareanumb = ? and apparatusfit.buildingnumb = ? and apparatusfit.doornumb = ? and apparatusfit.floornumb = ? and apparatusfit.cellnumb = ? ");
                    addelectricmeterrecdbbean.select02();
                    addelectricmeterrecdbbean.getDataFromResult02();
                    if(addelectricmeterrecdbbean.getStatusCode() == 7767)
                        if(addelectricmeterrecdbbean.vecQ1.size() == 1)
                        {
                            addelectricmeterrecdbbean.setMeternum(addelectricmeterrecdbbean.vecQ1.elementAt(0).toString().trim());
                        } else
                        {
                            addelectricmeterrecdbbean.setStatusCode(7771);
                            addelectricmeterrecdbbean.setStatusMessage("您输入的地址安装了多块电表，请输入表编号以便区分");
                        }
                }
                if(addelectricmeterrecdbbean.getStatusCode() == 7767)
                {
                    addelectricmeterrecdbbean.setTableName("electricmeterinfo");
                    addelectricmeterrecdbbean.setSelectSQL01("select  number from " + addelectricmeterrecdbbean.getTableName() + " where(  subareanumb = ?  and buildingnumb = ? and doornumb = ? and floornumb = ? and cellnumb = ? and meternum = ? and cycle = ? and delflag = ? ) ");
                    try
                    {
                        addelectricmeterrecdbbean.select01();
                        addelectricmeterrecdbbean.getDataFromResult01();
                    }
                    catch(Exception _ex)
                    {
                        throw new Exception("[finance.AddElectricMeterRecServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "][" + addelectricmeterrecdbbean.getStatusMessage() + "]");
                    }
                    if(addelectricmeterrecdbbean.getStatusCode() == 7763)
                    {
                        addelectricmeterrecdbbean.setDelflag2("0");
                        addelectricmeterrecdbbean.setTableName("electricmeterinfo");
                        addelectricmeterrecdbbean.setInsertSQL01(" INSERT INTO " + addelectricmeterrecdbbean.getTableName() + " (NUMBER, SUBAREANUMB, BUILDINGNUMB, DOORNUMB, FLOORNUMB, CELLNUMB, METERNUM, METERDATE, CYCLE, METERDATA, METERMAN, DELFLAG) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)");
                        try
                        {
                            statwaterpaydbbean.connBean = ((ParentDBBean) (addelectricmeterrecdbbean)).connBean;
                            statwaterpaydbbean.setTableName("electricmeterinfo");
                            statwaterpaydbbean.setSubAreaNumb(addelectricmeterrecdbbean.getSubareanumb());
                            statwaterpaydbbean.setBuildingNumb(addelectricmeterrecdbbean.getBuildingnumb());
                            statwaterpaydbbean.setDoorNumb(addelectricmeterrecdbbean.getDoornumb());
                            statwaterpaydbbean.setFloorNumb(addelectricmeterrecdbbean.getFloornumb());
                            statwaterpaydbbean.setCellNumb(addelectricmeterrecdbbean.getCellnumb());
                            statwaterpaydbbean.setCycleNum(addelectricmeterrecdbbean.getCycle());
                            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();
                            if(!statwaterpaydbbean.getMeterData().equals("") && Double.parseDouble(statwaterpaydbbean.getMeterData()) > Double.parseDouble(addelectricmeterrecdbbean.getMeterdata()))
                            {
                                addelectricmeterrecdbbean.setStatusCode(7772);
                                addelectricmeterrecdbbean.setStatusMessage("本次抄表读数有误，比以前的抄表读数小，请核实");
                            }
                            if(addelectricmeterrecdbbean.getStatusCode() != 7772)
                            {
                                addelectricmeterrecdbbean.selectMaxnum();
                                addelectricmeterrecdbbean.insert01();
                                addelectricmeterrecdbbean.setOpcontent("增加电表抄表记录");
                                HttpSession httpsession = httpservletrequest.getSession(false);
                                try
                                {
                                    addelectricmeterrecdbbean.setOperator((String)httpsession.getValue("persname"));
                                }
                                catch(NullPointerException _ex) { }
                                addelectricmeterrecdbbean.setOpdate(datetimebean.getDate());
                                addelectricmeterrecdbbean.setOptime(datetimebean.getTime());
                                addelectricmeterrecdbbean.insertLog();
                                addelectricmeterrecdbbean.commitToDB();
                                addelectricmeterrecdbbean.setStatusCode(7768);
                                addelectricmeterrecdbbean.setStatusMessage("成功增加电表抄表信息！");
                            }
                        }
                        catch(Exception _ex)
                        {
                            throw new Exception("[finance.AddElectricMeterRecServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + addelectricmeterrecdbbean.getStatusMessage());
                        }
                    }
                }
            }
            catch(Exception exception2)
            {
                addelectricmeterrecdbbean.rollbackFromDB();
                throw exception2;
            }
            finally
            {
                addelectricmeterrecdbbean.releaseConnection();
            }
            if(addelectricmeterrecdbbean.getStatusCode() == 7771)
            {
                httpservletrequest.setAttribute("vec", vector1);
                httpservletrequest.setAttribute("vecQ1", addelectricmeterrecdbbean.vecQ1);
                RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/AddElectricMeterRecReInput.jsp");
                requestdispatcher1.forward(httpservletrequest, httpservletresponse);
            } else
            {
                httpservletrequest.setAttribute("statusMessage", addelectricmeterrecdbbean.getStatusMessage());
                httpservletrequest.setAttribute("flag", (new Integer(addelectricmeterrecdbbean.getStatusCode())).toString());
                RequestDispatcher requestdispatcher2 = getServletContext().getRequestDispatcher("/finance/AddElectricMeterRecResult.jsp");
                requestdispatcher2.forward(httpservletrequest, httpservletresponse);
            }
        }
        catch(Throwable throwable)
        {
            System.out.println(throwable.getMessage());
            try
            {
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception _ex) { }
        }
    }
}