addpersondbbean.java

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

    {
        return insertSQL01;
    }

    public String getJob1()
    {
        return job1;
    }

    public String getJob2()
    {
        return job2;
    }

    public String getJob3()
    {
        return job3;
    }

    public String getLeaveReason()
    {
        return leavereason;
    }

    public String getLike()
    {
        return like;
    }

    public String getLinkMan()
    {
        return linkman;
    }

    public String getLinkTel()
    {
        return linktel;
    }

    public String getMarriage()
    {
        return marriage;
    }

    public String getNation()
    {
        return nation;
    }

    public String getPersGender()
    {
        return persgender;
    }

    public String getPersName()
    {
        return persname;
    }

    public String getPersNumb()
    {
        return persnumb;
    }

    public String getPersonPower()
    {
        return personpower;
    }

    public String getPhone()
    {
        return phone;
    }

    public byte[] getPicture()
    {
        return picture;
    }

    public String getPictureName()
    {
        return picturename;
    }

    public String getRelation1()
    {
        return relation1;
    }

    public String getRelation2()
    {
        return relation2;
    }

    public String getRelation3()
    {
        return relation3;
    }

    public String getSchool1()
    {
        return school1;
    }

    public String getSchool2()
    {
        return school2;
    }

    public String getSchool3()
    {
        return school3;
    }

    public String getSelectSQL01()
    {
        return selectSQL01;
    }

    public String getSelectSQL02()
    {
        return selectSQL02;
    }

    public String getSkill()
    {
        return skill;
    }

    public String getSpecialty1()
    {
        return specialty1;
    }

    public String getSpecialty2()
    {
        return specialty2;
    }

    public String getSpecialty3()
    {
        return specialty3;
    }

    public String getStaraDate1()
    {
        return staradate1;
    }

    public String getStaraDate2()
    {
        return staradate2;
    }

    public String getStaraDate3()
    {
        return staradate3;
    }

    public String getStatus()
    {
        return status;
    }

    public String getTableName2()
    {
        return tablename2;
    }

    public String getTechnica()
    {
        return technica;
    }

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

    public void initSelect01()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement01 = new SelectStatement();
        selectStatement01.setConnection(connBean);
        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());
    }

    public void initSelect02()
        throws DataException
    {
        StatementMetaData statementmetadata = null;
        selectStatement02 = new SelectStatement();
        selectStatement02.setConnection(connBean);
        statementmetadata = selectStatement02.getMetaData();
        statementmetadata.setSQL(getSelectSQL02());
        statementmetadata.addTable(getTableName2());
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        selectStatement02.setParameter("delflag", getDelFlag());
        statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("powername", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("powercode", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertStatement01.execute();
            setStatusCode(3027);
            setStatusMessage("增加数据到 personnelinfo 表操作成功！");
        }
        catch(DataException dataexception)
        {
            setStatusCode(3028);
            setStatusMessage("插入数据到 personnelinfo 表时发生：" + dataexception.getMessage());
            throw dataexception;
        }
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            result.firstRow();
            setStatusCode(3029);
        }
        catch(DataException dataexception)
        {