siretrievepeopledbbean.java

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

        statementmetadata.addColumn("building", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("stair", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("floor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("cell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("regdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("livenum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("sex", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("birthday", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("nation", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("native1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("idno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("address", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("duty", 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("number2", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("relation", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("picname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("police", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("doortype", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("area", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("contractno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("enterno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("usage", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("remark", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("reladress", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("zip", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("usearea", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("direction", 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);
        selectSql01.setParameter("number", new Integer(getNumber()));
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectSql01.execute();
            result = selectSql01.getResult();
            setStatusCode(2052);
            setStatusMessage("查询指定业主及其家庭成员记录失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(2053);
            setStatusMessage("查询指定业主及其家庭成员记录的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(2054);
                setStatusMessage("查询指定业主及其家庭成员记录的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAddress(String s)
    {
        address = s;
    }

    public void setArea(String s)
    {
        area = s;
    }

    public void setBirthday(String s)
    {
        birthday = s;
    }

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

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

    public void setContractno(String s)
    {
        contractno = s;
    }

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

    public void setDirection(String s)
    {
        direction = s;
    }

    public void setDoortype(String s)
    {
        doortype = s;
    }

    public void setDuty(String s)
    {
        duty = s;
    }

    public void setEnterno(String s)
    {
        enterno = s;
    }

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

    public void setIdno(String s)
    {
        idno = s;
    }

    public void setLivenum(String s)
    {
        livenum = s;
    }

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

    public void setName(String s)
    {
        name = s;
    }

    public void setNation(String s)
    {
        nation = s;
    }

    public void setNative1(String s)
    {
        native1 = s;
    }

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

    public void setNumber2(String s)
    {
        number2 = s;
    }

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

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

    public void setPicname(String s)
    {
        picname = s;
    }

    public void setPicture(String s)
    {
        picture = s;
    }

    public void setPolice(String s)
    {
        police = s;
    }

    public void setRegdate(String s)
    {
        regdate = s;
    }

    public void setRelAdress(String s)
    {
        reladress = s;
    }

    public void setRelation(String s)
    {
        relation = s;
    }

    public void setRemark(String s)
    {
        remark = s;
    }

    public void setResult01()
        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"));
                setRegdate(result.getColumnValueToString("regdate"));
                setName(result.getColumnValueToString("name"));
                setLivenum(result.getColumnValueToString("livenum"));
                setSex(result.getColumnValueToString("sex"));
                if(result.getColumnValue("birthday") != null)
                    setBirthday(result.getColumnValueToString("birthday"));
                setNation(result.getColumnValueToString("nation"));
                setNative1(result.getColumnValueToString("native1"));
                setIdno(result.getColumnValueToString("idno"));
                setAddress(result.getColumnValueToString("address"));
                setDuty(result.getColumnValueToString("duty"));
                setTel(result.getColumnValueToString("tel"));
                setNumber2(result.getColumnValueToString("number2"));
                setRelation(result.getColumnValueToString("relation"));
                setPicname(result.getColumnValueToString("picname"));
                setPolice(result.getColumnValueToString("police"));
                setDoortype(result.getColumnValueToString("doortype"));
                if(result.getColumnValue("area") != null)
                    setArea(result.getColumnValueToString("area"));
                setContractno(result.getColumnValueToString("contractno"));
                setEnterno(result.getColumnValueToString("enterno"));
                setUsage(result.getColumnValueToString("usage"));
                setRemark(result.getColumnValueToString("remark"));
                setRelAdress(result.getColumnValueToString("reladress"));
                setZip(result.getColumnValueToString("zip"));
                if(result.getColumnValue("usearea") != null)
                    setUseArea(result.getColumnValueToString("usearea"));
                setDirection(result.getColumnValueToString("direction"));
                setStatusCode(2055);
                setStatusMessage("查询指定业主及其家庭成员记录成功");
            } else
            {
                setStatusCode(2056);
                setStatusMessage("对不起，没有符合条件的业主及其家庭成员记录");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(2057);
            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 setSelect01(String s)
    {
        select01 = s;
    }

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

    public void setSex(String s)
    {
        sex = s;
    }

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

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

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

    public void setUsage(String s)
    {
        usage = s;
    }

    public void setUseArea(String s)
    {
        usearea = s;
    }

    public void setZip(String s)
    {
        zip = s;
    }
}