updategasmeterrecservlet.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:   UpdateGasMeterRecServlet.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:
//            UpdateGasMeterRecDBBean

public class UpdateGasMeterRecServlet extends ParentServlet
{

    public UpdateGasMeterRecServlet()
    {
    }

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