modifypersondbbean.java

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

        statementmetadata = selectStatement01.getMetaData();
        statementmetadata.setSQL(getSelectSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addColumn("persnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("persnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        selectStatement01.setParameter("persnumb", getPersNumb());
    }

    protected void initUpdate01(int i)
        throws DataException, IOException
    {
        StatementMetaData statementmetadata = null;
        updateStatement01 = new SQLStatement();
        updateStatement01.setConnection(connBean);
        statementmetadata = updateStatement01.getMetaData();
        statementmetadata.setSQL(getUpdateSQL01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("persnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("persname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("persgender", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        if(i == 0)
        {
            statementmetadata.addParameter("picture", array$B == null ? (array$B = class$("[B")) : array$B, -4);
            statementmetadata.addParameter("picturename", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        }
        statementmetadata.addParameter("nation", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("borndate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("address", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("edulevel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("technica", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("marriage", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("skill", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("like", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("identirycard", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("phone", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("school1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("staradate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("enddate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("specialty1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("school2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("staradate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("enddate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("specialty2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("school3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("staradate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("enddate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("specialty3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("compname1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cstartdate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cenddate1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("job1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("compname2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cstartdate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cenddate2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("job2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("compname3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cstartdate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cenddate3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("job3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fname1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("relation1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("addr1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fphone1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fname2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("relation2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("addr2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fphone2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fname3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("relation3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("addr3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("fphone3", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("date", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("dept", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("status", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        statementmetadata.addParameter("leavereason", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("linkman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("linktel", 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);
        updateStatement01.setParameter("persnumb", getPersNumb());
        updateStatement01.setParameter("persname", getPersName());
        updateStatement01.setParameter("persgender", getPersGender());
        if(i == 0)
        {
            updateStatement01.setParameter("picture", getPicture());
            updateStatement01.setParameter("picturename", getPictureName());
        }
        updateStatement01.setParameter("nation", getNation());
        updateStatement01.setParameter("borndate", getBornDate());
        updateStatement01.setParameter("address", getAddress());
        updateStatement01.setParameter("edulevel", getEduLevel());
        updateStatement01.setParameter("technica", getTechnica());
        updateStatement01.setParameter("marriage", getMarriage());
        updateStatement01.setParameter("skill", getSkill());
        updateStatement01.setParameter("like", getLike());
        updateStatement01.setParameter("identirycard", getIdentiryCard());
        updateStatement01.setParameter("phone", getPhone());
        updateStatement01.setParameter("school1", getSchool1());
        updateStatement01.setParameter("staradate1", getStaraDate1());
        updateStatement01.setParameter("enddate1", getEndDate1());
        updateStatement01.setParameter("specialty1", getSpecialty1());
        updateStatement01.setParameter("school2", getSchool2());
        updateStatement01.setParameter("staradate2", getStaraDate2());
        updateStatement01.setParameter("enddate2", getEndDate2());
        updateStatement01.setParameter("specialty2", getSpecialty2());
        updateStatement01.setParameter("school3", getSchool3());
        updateStatement01.setParameter("staradate3", getStaraDate3());
        updateStatement01.setParameter("enddate3", getEndDate3());
        updateStatement01.setParameter("specialty3", getSpecialty3());
        updateStatement01.setParameter("compname1", getCompName1());
        updateStatement01.setParameter("cstartdate1", getCStartDate1());
        updateStatement01.setParameter("cenddate1", getCEndDate1());
        updateStatement01.setParameter("job1", getJob1());
        updateStatement01.setParameter("compname2", getCompName2());
        updateStatement01.setParameter("cstartdate2", getCStartDate2());
        updateStatement01.setParameter("cenddate2", getCEndDate2());
        updateStatement01.setParameter("job2", getJob2());
        updateStatement01.setParameter("compname3", getCompName3());
        updateStatement01.setParameter("cstartdate3", getCStartDate3());
        updateStatement01.setParameter("cenddate3", getCEndDate3());
        updateStatement01.setParameter("job3", getJob3());
        updateStatement01.setParameter("fname1", getFName1());
        updateStatement01.setParameter("relation1", getRelation1());
        updateStatement01.setParameter("addr1", getAddr1());
        updateStatement01.setParameter("fphone1", getFPhone1());
        updateStatement01.setParameter("fname2", getFName2());
        updateStatement01.setParameter("relation2", getRelation2());
        updateStatement01.setParameter("addr2", getAddr2());
        updateStatement01.setParameter("fphone2", getFPhone2());
        updateStatement01.setParameter("fname3", getFName3());
        updateStatement01.setParameter("relation3", getRelation3());
        updateStatement01.setParameter("addr3", getAddr3());
        updateStatement01.setParameter("fphone3", getFPhone3());
        updateStatement01.setParameter("date", getDate());
        updateStatement01.setParameter("dept", getDept());
        updateStatement01.setParameter("status", getStatus());
        updateStatement01.setParameter("leavereason", getLeaveReason());
        updateStatement01.setParameter("linkman", getLinkMan());
        updateStatement01.setParameter("linktel", getLinkTel());
        updateStatement01.setParameter("number", new Integer(getNumber()));
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusCode(3117);
        }
        catch(DataException dataexception)
        {
            setStatusCode(3028);
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(3028);
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAddr1(String s)
    {
        addr1 = s;
    }

    public void setAddr2(String s)
    {
        addr2 = s;
    }

    public void setAddr3(String s)
    {
        addr3 = s;
    }

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

    public void setBornDate(String s)
    {
        borndate = s;
    }

    public void setCEndDate1(String s)
    {
        cenddate1 = s;
    }

    public void setCEndDate2(String s)
    {
        cenddate2 = s;
    }

    public void setCEndDate3(String s)
    {
        cenddate3 = s;
    }

    public void setCStartDate1(String s)
    {
        cstartdate1 = s;
    }

    public void setCStartDate2(String s)
    {
        cstartdate2 = s;
    }

    public void setCStartDate3(String s)
    {
        cstartdate3 = s;
    }

    public void setCompName1(String s)
    {
        compname1 = s;
    }

    public void setCompName2(String s)
    {
        compname2 = s;
    }

    public void setCompName3(String s)
    {
        compname3 = s;
    }

    public void setDate(String s)
    {
        date = s;
    }

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

    public void setDept(String s)
    {
        dept = s;
    }

    public void setEduLevel(String s)
    {
        edulevel = s;
    }

    public void setEndDate1(String s)
    {
        enddate1 = s;
    }

    public void setEndDate2(String s)
    {
        enddate2 = s;
    }

    public void setEndDate3(String s)
    {
        enddate3 = s;
    }

    public void setFName1(String s)
    {
        fname1 = s;
    }

    public void setFName2(String s)
    {
        fname2 = s;
    }

    public void setFName3(String s)
    {
        fname3 = s;
    }

    public void setFPhone1(String s)
    {
        fphone1 = s;
    }

    public void setFPhone2(String s)
    {
        fphone2 = s;
    }

    public void setFPhone3(String s)
    {
        fphone3 = s;
    }

    public void setIdentiryCard(String s)
    {
        identirycard = s;
    }

    public void setJob1(String s)
    {
        job1 = s;
    }

    public void setJob2(String s)
    {
        job2 = s;
    }

    public void setJob3(String s)
    {
        job3 = s;
    }

    public void setLeaveReason(String s)
    {
        leavereason = s;
    }

    public void setLike(String s)
    {
        like = s;
    }

    public void setLinkMan(String s)
    {
        linkman = s;
    }

    public void setLinkTel(String s)
    {
        linktel = s;
    }

    public void setMarriage(String s)
    {
        marriage = s;
    }

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

    public void setPersGender(String s)
    {
        persgender = s;
    }

    public void setPersName(String s)
    {
        persname = s;
    }

    public void setPersNumb(String s)
    {
        persnumb = s;
    }

    public void setPhone(String s)
    {
        phone = s;
    }

    public void setPicture(byte abyte0[])
    {
        picture = abyte0;
    }

    public void setPictureName(String s)
    {
        picturename = s;
    }

    public void setRelation1(String s)
    {
        relation1 = s;
    }

    public void setRelation2(String s)
    {
        relation2 = s;
    }

    public void setRelation3(String s)
    {
        relation3 = s;
    }

    public void setSchool1(String s)
    {
        school1 = s;
    }

    public void setSchool2(String s)
    {
        school2 = s;
    }

    public void setSchool3(String s)
    {
        school3 = s;
    }

    public void setSelectSQL01(String s)
    {
        selectSQL01 = s;
    }

    public void setSkill(String s)
    {
        skill = s;
    }

    public void setSpecialty1(String s)
    {
        specialty1 = s;
    }

    public void setSpecialty2(String s)
    {
        specialty2 = s;
    }

    public void setSpecialty3(String s)
    {
        specialty3 = s;
    }

    public void setStaraDate1(String s)
    {
        staradate1 = s;
    }

    public void setStaraDate2(String s)
    {
        staradate2 = s;
    }

    public void setStaraDate3(String s)
    {
        staradate3 = s;
    }

    public void setStatus(String s)
    {
        status = s;
    }

    public void setTechnica(String s)
    {
        technica = s;
    }

    public void setUpdateSQL01(String s)
    {
        updateSQL01 = s;
    }

    public void update01(int i)
        throws Exception
    {
        try
        {
            initUpdate01(i);
            updateStatement01.execute();
            setStatusCode(3115);
            setStatusMessage("成功更新员工资料信息");
        }
        catch(DataException dataexception)
        {
            setStatusCode(3116);
            setStatusMessage("更新员工资料失败" + dataexception.getMessage());
            throw new Exception(getStatusMessage());
        }
    }
}