updateelectricmeterrecservlet.java

JSP物业管理系统 一份比较完整的物业管理系统源码。 对于初学者可以有一定的借鉴。

                    } else
                    {
                        updateelectricmeterrecdbbean.setFlag1("1");
                        updateelectricmeterrecdbbean.setSelectSQL02("select apparatusfit.apparatus from " + updateelectricmeterrecdbbean.getTableName() + "," + updateelectricmeterrecdbbean.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 = ? ");
                        updateelectricmeterrecdbbean.select02();
                        updateelectricmeterrecdbbean.getDataFromResult02();
                        if(updateelectricmeterrecdbbean.getStatusCode() == 7827)
                            if(updateelectricmeterrecdbbean.vecQ1.size() == 1)
                            {
                                updateelectricmeterrecdbbean.setMeternum(updateelectricmeterrecdbbean.vecQ1.elementAt(0).toString().trim());
                            } else
                            {
                                updateelectricmeterrecdbbean.setStatusCode(7831);
                                updateelectricmeterrecdbbean.setStatusMessage("您输入的地址安装了多块电表，请输入表编号以便区分");
                            }
                    }
                    if(updateelectricmeterrecdbbean.getStatusCode() == 7827)
                    {
                        updateelectricmeterrecdbbean.setTableName("electricmeterinfo");
                        updateelectricmeterrecdbbean.setSelectSQL01("select  number from " + updateelectricmeterrecdbbean.getTableName() + " where(  subareanumb = ?  and buildingnumb = ? and doornumb = ? and floornumb = ? and cellnumb = ? and meternum = ? and cycle = ? and number <> ? and delflag = ? ) ");
                        try
                        {
                            updateelectricmeterrecdbbean.select01();
                            updateelectricmeterrecdbbean.getDataFromResult01();
                        }
                        catch(Exception _ex)
                        {
                            throw new Exception("[finance.AddWaterMeterRecServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "][" + updateelectricmeterrecdbbean.getStatusMessage() + "]");
                        }
                        if(updateelectricmeterrecdbbean.getStatusCode() == 7823)
                        {
                            statwaterpaydbbean.connBean = ((ParentDBBean) (updateelectricmeterrecdbbean)).connBean;
                            statwaterpaydbbean.setTableName("electricmeterinfo");
                            statwaterpaydbbean.setSubAreaNumb(updateelectricmeterrecdbbean.getSubareanumb());
                            statwaterpaydbbean.setBuildingNumb(updateelectricmeterrecdbbean.getBuildingnumb());
                            statwaterpaydbbean.setDoorNumb(updateelectricmeterrecdbbean.getDoornumb());
                            statwaterpaydbbean.setFloorNumb(updateelectricmeterrecdbbean.getFloornumb());
                            statwaterpaydbbean.setCellNumb(updateelectricmeterrecdbbean.getCellnumb());
                            statwaterpaydbbean.setCycleNum(updateelectricmeterrecdbbean.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(updateelectricmeterrecdbbean.getMeterdata()))
                            {
                                updateelectricmeterrecdbbean.setStatusCode(7772);
                                updateelectricmeterrecdbbean.setStatusMessage("本次抄表读数有误，比以前的抄表读数小，请核实");
                            }
                            if(updateelectricmeterrecdbbean.getStatusCode() != 7772)
                            {
                                updateelectricmeterrecdbbean.update01();
                                updateelectricmeterrecdbbean.setOpcontent("修改电表抄表记录");
                                HttpSession httpsession = httpservletrequest.getSession(false);
                                try
                                {
                                    updateelectricmeterrecdbbean.setOperator((String)httpsession.getValue("persname"));
                                }
                                catch(NullPointerException _ex) { }
                                updateelectricmeterrecdbbean.setOpdate(datetimebean.getDate());
                                updateelectricmeterrecdbbean.setOptime(datetimebean.getTime());
                                updateelectricmeterrecdbbean.insertLog();
                                updateelectricmeterrecdbbean.commitToDB();
                                updateelectricmeterrecdbbean.setStatusCode(7825);
                            }
                        }
                    }
                }
                catch(Exception _ex)
                {
                    updateelectricmeterrecdbbean.rollbackFromDB();
                    throw new Exception("[finance.UpdateWaterMeterRecServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + updateelectricmeterrecdbbean.getStatusMessage());
                }
            }
            catch(Exception exception2)
            {
                throw exception2;
            }
            finally
            {
                updateelectricmeterrecdbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("statusMessage", updateelectricmeterrecdbbean.getStatusMessage());
            httpservletrequest.setAttribute("flag", (new Integer(updateelectricmeterrecdbbean.getStatusCode())).toString());
            if(updateelectricmeterrecdbbean.getStatusCode() == 7831)
            {
                httpservletrequest.setAttribute("vec", vector1);
                httpservletrequest.setAttribute("vecQ1", updateelectricmeterrecdbbean.vecQ1);
                RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/UpdateElectricMeterRecReInput.jsp");
                requestdispatcher1.forward(httpservletrequest, httpservletresponse);
            } else
            {
                httpservletrequest.setAttribute("subareanumb", s1);
                httpservletrequest.setAttribute("buildingnumb", s2);
                httpservletrequest.setAttribute("doornumb", s3);
                httpservletrequest.setAttribute("floornumb", s4);
                httpservletrequest.setAttribute("cellnumb", s5);
                httpservletrequest.setAttribute("rdefaultcycleflag", s6);
                httpservletrequest.setAttribute("rfeecycle", s7);
                httpservletrequest.setAttribute("meterman", s8);
                RequestDispatcher requestdispatcher2 = getServletContext().getRequestDispatcher("/finance/UpdateElectricMeterRecResult.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) { }
        }
    }
}