updateelectricmeterrecservlet.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:   UpdateElectricMeterRecServlet.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:
//            UpdateElectricMeterRecDBBean

public class UpdateElectricMeterRecServlet extends ParentServlet
{

    public UpdateElectricMeterRecServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            UpdateElectricMeterRecDBBean updateelectricmeterrecdbbean = new UpdateElectricMeterRecDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            StatWaterPayDBBean statwaterpaydbbean = new StatWaterPayDBBean();
            Vector vector = (Vector)getServletContext().getAttribute("Para");
            updateelectricmeterrecdbbean.setUserID((String)vector.elementAt(0));
            updateelectricmeterrecdbbean.setPassword((String)vector.elementAt(1));
            updateelectricmeterrecdbbean.setURL((String)vector.elementAt(2));
            updateelectricmeterrecdbbean.setDriver((String)vector.elementAt(3));
            updateelectricmeterrecdbbean.setDataSourceName((String)vector.elementAt(4));
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
            updateelectricmeterrecdbbean.setNumber(vector1.elementAt(0).toString().trim());
            updateelectricmeterrecdbbean.setSubareanumb(vector1.elementAt(1).toString().trim());
            updateelectricmeterrecdbbean.setBuildingnumb(vector1.elementAt(2).toString().trim());
            updateelectricmeterrecdbbean.setDoornumb(vector1.elementAt(3).toString().trim());
            updateelectricmeterrecdbbean.setFloornumb(vector1.elementAt(4).toString().trim());
            updateelectricmeterrecdbbean.setCellnumb(vector1.elementAt(5).toString().trim());
            updateelectricmeterrecdbbean.setMeternum(vector1.elementAt(6).toString().trim());
            updateelectricmeterrecdbbean.setMeterdate(vector1.elementAt(7).toString().trim() + "-" + vector1.elementAt(8).toString().trim() + "-" + vector1.elementAt(9).toString().trim());
            updateelectricmeterrecdbbean.setMeterdata(vector1.elementAt(10).toString().trim());
            updateelectricmeterrecdbbean.setMeterman(vector1.elementAt(11).toString().trim());
            updateelectricmeterrecdbbean.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
            {
                updateelectricmeterrecdbbean.initialize();
            }
            catch(Exception exception)
            {
                throw exception;
            }
            try
            {
                updateelectricmeterrecdbbean.setDelflag("0");
                updateelectricmeterrecdbbean.setTableName("electricmeterinfo");
                updateelectricmeterrecdbbean.setUpdateSQL01(" UPDATE " + updateelectricmeterrecdbbean.getTableName() + " SET SUBAREANUMB = ?, BUILDINGNUMB = ?, DOORNUMB = ?, FLOORNUMB = ?, CELLNUMB = ?, METERNUM = ?, METERDATE = ?,CYCLE = ?, METERDATA = ?, METERMAN = ? WHERE (NUMBER = ? AND DELFLAG = ?)");
                try
                {
                    if(!updateelectricmeterrecdbbean.getSubareanumb().trim().equals("") || !updateelectricmeterrecdbbean.getBuildingnumb().trim().equals("") || !updateelectricmeterrecdbbean.getDoornumb().trim().equals("") || !updateelectricmeterrecdbbean.getFloornumb().trim().equals("") || !updateelectricmeterrecdbbean.getCellnumb().trim().equals(""))
                        updateelectricmeterrecdbbean.setFlag2("0");
                    else
                        updateelectricmeterrecdbbean.setFlag2("1");
                    updateelectricmeterrecdbbean.setTableName("apparatusfit");
                    updateelectricmeterrecdbbean.setTableName1("apparatusinfo");
                    if(!updateelectricmeterrecdbbean.getMeternum().trim().equals(""))
                    {
                        updateelectricmeterrecdbbean.setFlag1("0");
                        updateelectricmeterrecdbbean.setSelectSQL02("select apparatusfit.subareanumb,apparatusfit.buildingnumb,apparatusfit.doornumb,apparatusfit.floornumb,apparatusfit.cellnumb from " + updateelectricmeterrecdbbean.getTableName() + "," + updateelectricmeterrecdbbean.getTableName1() + " where apparatusfit.apparatusnumb = apparatusinfo.apparatusnumb and apparatusinfo.delflag = '0' and apparatusfit.delflag = '0' and apparatusinfo.apparatuskind = '电表' and apparatusfit.apparatus = ?");
                        updateelectricmeterrecdbbean.select02();
                        updateelectricmeterrecdbbean.getDataFromResult02();
                        if(updateelectricmeterrecdbbean.getStatusCode() == 7827)
                            if(updateelectricmeterrecdbbean.getFlag2().equals("0"))
                            {
                                if(((String)updateelectricmeterrecdbbean.vecQ1.elementAt(0)).trim().equals(updateelectricmeterrecdbbean.getSubareanumb()) && ((String)updateelectricmeterrecdbbean.vecQ2.elementAt(0)).trim().equals(updateelectricmeterrecdbbean.getBuildingnumb()) && ((String)updateelectricmeterrecdbbean.vecQ3.elementAt(0)).trim().equals(updateelectricmeterrecdbbean.getDoornumb()) && ((String)updateelectricmeterrecdbbean.vecQ4.elementAt(0)).trim().equals(updateelectricmeterrecdbbean.getFloornumb()) && ((String)updateelectricmeterrecdbbean.vecQ5.elementAt(0)).trim().equals(updateelectricmeterrecdbbean.getCellnumb()))
                                {
                                    updateelectricmeterrecdbbean.setStatusCode(7827);
                                } else
                                {
                                    updateelectricmeterrecdbbean.setStatusCode(7830);
                                    updateelectricmeterrecdbbean.setStatusMessage("输入的地址和表编号不匹配，请核实");
                                }
                            } else
                            if(updateelectricmeterrecdbbean.vecQ1.size() == 1)
                            {
                                updateelectricmeterrecdbbean.setSubareanumb(updateelectricmeterrecdbbean.vecQ1.elementAt(0).toString().trim());
                                updateelectricmeterrecdbbean.setBuildingnumb(updateelectricmeterrecdbbean.vecQ2.elementAt(0).toString().trim());
                                updateelectricmeterrecdbbean.setDoornumb(updateelectricmeterrecdbbean.vecQ3.elementAt(0).toString().trim());
                                updateelectricmeterrecdbbean.setFloornumb(updateelectricmeterrecdbbean.vecQ4.elementAt(0).toString().trim());
                                updateelectricmeterrecdbbean.setCellnumb(updateelectricmeterrecdbbean.vecQ5.elementAt(0).toString().trim());
                            } else
                            {
                                updateelectricmeterrecdbbean.setStatusCode(7831);
                                updateelectricmeterrecdbbean.setStatusMessage("您输入的地址安装了多块电表，请输入表编号以便区分");
                            }