updatewatermeterrecservlet.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:   UpdateWaterMeterRecServlet.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:
//            UpdateWaterMeterRecDBBean

public class UpdateWaterMeterRecServlet extends ParentServlet
{

    public UpdateWaterMeterRecServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            UpdateWaterMeterRecDBBean updatewatermeterrecdbbean = new UpdateWaterMeterRecDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            StatWaterPayDBBean statwaterpaydbbean = new StatWaterPayDBBean();
            Vector vector = (Vector)getServletContext().getAttribute("Para");
            updatewatermeterrecdbbean.setUserID((String)vector.elementAt(0));
            updatewatermeterrecdbbean.setPassword((String)vector.elementAt(1));
            updatewatermeterrecdbbean.setURL((String)vector.elementAt(2));
            updatewatermeterrecdbbean.setDriver((String)vector.elementAt(3));
            updatewatermeterrecdbbean.setDataSourceName((String)vector.elementAt(4));
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
            updatewatermeterrecdbbean.setNumber(vector1.elementAt(0).toString().trim());
            updatewatermeterrecdbbean.setSubareanumb(vector1.elementAt(1).toString().trim());
            updatewatermeterrecdbbean.setBuildingnumb(vector1.elementAt(2).toString().trim());
            updatewatermeterrecdbbean.setDoornumb(vector1.elementAt(3).toString().trim());
            updatewatermeterrecdbbean.setFloornumb(vector1.elementAt(4).toString().trim());
            updatewatermeterrecdbbean.setCellnumb(vector1.elementAt(5).toString().trim());
            updatewatermeterrecdbbean.setMeternum(vector1.elementAt(6).toString().trim());
            updatewatermeterrecdbbean.setMeterdate(vector1.elementAt(7).toString().trim() + "-" + vector1.elementAt(8).toString().trim() + "-" + vector1.elementAt(9).toString().trim());
            updatewatermeterrecdbbean.setMeterdata(vector1.elementAt(10).toString().trim());
            updatewatermeterrecdbbean.setMeterman(vector1.elementAt(11).toString().trim());
            updatewatermeterrecdbbean.setCycle(vector1.elementAt(12).toString().trim());
            String s1 = vector1.elementAt(13).toString();
            String s2 = vector1.elementAt(14).toString();
            String s3 = vector1.elementAt(15).toString();
            String s4 = vector1.elementAt(16).toString();
            String s5 = vector1.elementAt(17).toString();
            String s6 = vector1.elementAt(18).toString();
            String s7 = vector1.elementAt(19).toString();
            String s8 = vector1.elementAt(20).toString();
            String s9 = vector1.elementAt(21).toString().trim();
            String s10 = vector1.elementAt(22).toString().trim();
            String s11 = vector1.elementAt(23).toString().trim();
            String s12 = vector1.elementAt(24).toString().trim();
            String s13 = vector1.elementAt(25).toString().trim();
            String s14 = vector1.elementAt(26).toString().trim();
            try
            {
                updatewatermeterrecdbbean.initialize();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            try
            {
                updatewatermeterrecdbbean.setDelflag("0");
                updatewatermeterrecdbbean.setTableName("watermeterinfo");
                updatewatermeterrecdbbean.setUpdateSQL01(" UPDATE " + updatewatermeterrecdbbean.getTableName() + " SET SUBAREANUMB = ?, BUILDINGNUMB = ?, DOORNUMB = ?, FLOORNUMB = ?, CELLNUMB = ?, METERNUM = ?, METERDATE = ?,CYCLE = ?, METERDATA = ?, METERMAN = ? WHERE (NUMBER = ? AND DELFLAG = ?)");
                try
                {
                    if(!updatewatermeterrecdbbean.getSubareanumb().trim().equals("") || !updatewatermeterrecdbbean.getBuildingnumb().trim().equals("") || !updatewatermeterrecdbbean.getDoornumb().trim().equals("") || !updatewatermeterrecdbbean.getFloornumb().trim().equals("") || !updatewatermeterrecdbbean.getCellnumb().trim().equals(""))
                        updatewatermeterrecdbbean.setFlag2("0");
                    else
                        updatewatermeterrecdbbean.setFlag2("1");
                    updatewatermeterrecdbbean.setTableName("apparatusfit");
                    updatewatermeterrecdbbean.setTableName1("apparatusinfo");
                    if(!updatewatermeterrecdbbean.getMeternum().trim().equals(""))
                    {
                        updatewatermeterrecdbbean.setFlag1("0");
                        updatewatermeterrecdbbean.setSelectSQL02("select apparatusfit.subareanumb,apparatusfit.buildingnumb,apparatusfit.doornumb,apparatusfit.floornumb,apparatusfit.cellnumb from " + updatewatermeterrecdbbean.getTableName() + "," + updatewatermeterrecdbbean.getTableName1() + " where apparatusfit.apparatusnumb = apparatusinfo.apparatusnumb and apparatusinfo.delflag = '0' and apparatusfit.delflag = '0' and apparatusinfo.apparatuskind = '水表' and apparatusfit.apparatus = ?");
                        updatewatermeterrecdbbean.select02();
                        updatewatermeterrecdbbean.getDataFromResult02();
                        if(updatewatermeterrecdbbean.getStatusCode() == 7807)
                            if(updatewatermeterrecdbbean.getFlag2().equals("0"))
                            {
                                if(((String)updatewatermeterrecdbbean.vecQ1.elementAt(0)).trim().equals(updatewatermeterrecdbbean.getSubareanumb()) && ((String)updatewatermeterrecdbbean.vecQ2.elementAt(0)).trim().equals(updatewatermeterrecdbbean.getBuildingnumb()) && ((String)updatewatermeterrecdbbean.vecQ3.elementAt(0)).trim().equals(updatewatermeterrecdbbean.getDoornumb()) && ((String)updatewatermeterrecdbbean.vecQ4.elementAt(0)).trim().equals(updatewatermeterrecdbbean.getFloornumb()) && ((String)updatewatermeterrecdbbean.vecQ5.elementAt(0)).trim().equals(updatewatermeterrecdbbean.getCellnumb()))
                                {
                                    updatewatermeterrecdbbean.setStatusCode(7807);
                                } else
                                {
                                    updatewatermeterrecdbbean.setStatusCode(7810);
                                    updatewatermeterrecdbbean.setStatusMessage("输入的地址和表编号不匹配，请核实");
                                }
                            } else
                            if(updatewatermeterrecdbbean.vecQ1.size() == 1)
                            {
                                updatewatermeterrecdbbean.setSubareanumb(updatewatermeterrecdbbean.vecQ1.elementAt(0).toString().trim());
                                updatewatermeterrecdbbean.setBuildingnumb(updatewatermeterrecdbbean.vecQ2.elementAt(0).toString().trim());
                                updatewatermeterrecdbbean.setDoornumb(updatewatermeterrecdbbean.vecQ3.elementAt(0).toString().trim());
                                updatewatermeterrecdbbean.setFloornumb(updatewatermeterrecdbbean.vecQ4.elementAt(0).toString().trim());
                                updatewatermeterrecdbbean.setCellnumb(updatewatermeterrecdbbean.vecQ5.elementAt(0).toString().trim());