siretrievecommonfixingdbbean.java

华磊物业管理系统源码 (仅供参考)

        statementmetadata.addColumn("type", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("exponent", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("applydate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("applytime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
        statementmetadata.addColumn("applyman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("tel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("ldate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("ltime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
        statementmetadata.addColumn("acceptman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("recorder", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("sign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fixno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fixexponent", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fixman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fixdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("finishdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("stuff", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("fixfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("useridea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("check", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("checkman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        selectSqlThe.setParameter("number", new Integer(getNumber()));
    }

    public void selectThe()
        throws Exception
    {
        try
        {
            initSelectThe();
            selectSqlThe.execute();
            result = selectSqlThe.getResult();
            setStatusCode(0x6bb71);
            setStatusMessage("查询指定记录失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(0x6bb72);
            setStatusMessage("查询指定记录的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(0x6bb73);
                setStatusMessage("查询指定记录的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAcceptman(String s)
    {
        acceptman = s;
    }

    public void setApplydate(String s)
    {
        applydate = s;
    }

    public void setApplyman(String s)
    {
        applyman = s;
    }

    public void setApplytime(String s)
    {
        applytime = s;
    }

    public void setBuilding(String s)
    {
        building = s;
    }

    public void setCell(String s)
    {
        cell = s;
    }

    public void setCheck(String s)
    {
        check = s;
    }

    public void setCheckman(String s)
    {
        checkman = s;
    }

    public void setDelFlag(String s)
    {
        delflag = s;
    }

    public void setExponent(String s)
    {
        exponent = s;
    }

    public void setFinishdate(String s)
    {
        finishdate = s;
    }

    public void setFixdate(String s)
    {
        fixdate = s;
    }

    public void setFixexponent(String s)
    {
        fixexponent = s;
    }

    public void setFixfee(String s)
    {
        fixfee = s;
    }

    public void setFixman(String s)
    {
        fixman = s;
    }

    public void setFixno(String s)
    {
        fixno = s;
    }

    public void setFlag(String s)
    {
        flag = s;
    }

    public void setFloor(String s)
    {
        floor = s;
    }

    public void setLdate(String s)
    {
        ldate = s;
    }

    public void setLtime(String s)
    {
        ltime = s;
    }

    public void setMagicindex(String s)
    {
        magicindex = s;
    }

    public void setNumber(String s)
    {
        number = s;
    }

    public void setPagecount(String s)
    {
        pagecount = s;
    }

    public void setPageindex(String s)
    {
        pageindex = s;
    }

    public void setRecorder(String s)
    {
        recorder = s;
    }

    public void setResultThe()
        throws Exception
    {
        try
        {
            if(result.getNumRowsInCache() != 0)
            {
                result.firstRow();
                setSubArea(result.getColumnValueToString("subarea"));
                setBuilding(result.getColumnValueToString("building"));
                setStair(result.getColumnValueToString("stair"));
                setFloor(result.getColumnValueToString("floor"));
                setCell(result.getColumnValueToString("cell"));
                setFlag(result.getColumnValueToString("flag"));
                setType(result.getColumnValueToString("type"));
                setExponent(result.getColumnValueToString("exponent"));
                setApplydate(result.getColumnValueToString("applydate"));
                setApplytime(result.getColumnValueToString("applytime"));
                setApplyman(result.getColumnValueToString("applyman"));
                setTel(result.getColumnValueToString("tel"));
                if(result.getColumnValue("ldate") == null)
                    setLdate("");
                else
                    setLdate(result.getColumnValueToString("ldate"));
                if(result.getColumnValue("ltime") == null)
                    setLtime("");
                else
                    setLtime(result.getColumnValueToString("ltime"));
                setAcceptman(result.getColumnValueToString("acceptman"));
                setRecorder(result.getColumnValueToString("recorder"));
                setSign(result.getColumnValueToString("sign"));
                setFixno(result.getColumnValueToString("fixno"));
                setFixexponent(result.getColumnValueToString("fixexponent"));
                setFixman(result.getColumnValueToString("fixman"));
                setFixdate(result.getColumnValueToString("fixdate"));
                setFinishdate(result.getColumnValueToString("finishdate"));
                setStuff(result.getColumnValueToString("stuff"));
                if(result.getColumnValue("fixfee") == null)
                    setFixfee("");
                else
                    setFixfee(result.getColumnValueToString("fixfee"));
                setUseridea(result.getColumnValueToString("useridea"));
                setCheck(result.getColumnValueToString("check"));
                setCheckman(result.getColumnValueToString("checkman"));
                setStatusCode(0x6bb74);
                setStatusMessage("查询指定用记录成功");
            } else
            {
                setStatusCode(0x6bb75);
                setStatusMessage("对不起，没有符合条件的记录");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(0x6bb76);
            setStatusMessage("处理指定记录结果集出错");
            throw exception1;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void setRetrievecom(String s)
    {
        retrievecom = s;
    }

    public void setRetrievecon(String s)
    {
        retrievecon = s;
    }

    public void setRetrieveindex(String s)
    {
        retrieveindex = s;
    }

    public void setSelectThe(String s)
    {
        selectThe = s;
    }

    public void setSelectnum(String s)
    {
        selectnum = s;
    }

    public void setSign(String s)
    {
        sign = s;
    }

    public void setStair(String s)
    {
        stair = s;
    }

    public void setStuff(String s)
    {
        stuff = s;
    }

    public void setSubArea(String s)
    {
        subarea = s;
    }

    public void setTel(String s)
    {
        tel = s;
    }

    public void setType(String s)
    {
        type = s;
    }

    public void setUseridea(String s)
    {
        useridea = s;
    }
}