addroomexamdbbean.java

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

        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("subarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("building", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("stair", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("floor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("checkman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("checkdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("checkitem", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("ceiling", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("wall", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("lfloor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("door", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doorlock", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("windows", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("antenna", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("light", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("lswitch", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("jack", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("casement", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cloaca", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("downcomer", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("pipe", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("dishpan", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("valve", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("tap", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("stool", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("gaspipe", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("gasmeter", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("watermeter", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("ammeter", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("powerbox", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("airswitch", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("interphone", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("doorbell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("gasnumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("waternumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("powernumber", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("useridea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("adminidea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("admin", 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("subarea", getSubArea());
        insertStatement01.setParameter("building", getBuilding());
        insertStatement01.setParameter("stair", getStair());
        insertStatement01.setParameter("floor", getFloor());
        insertStatement01.setParameter("cell", getCell());
        insertStatement01.setParameter("checkman", getCheckman());
        insertStatement01.setParameter("checkdate", getCheckdate());
        insertStatement01.setParameter("checkitem", getCheckitem());
        insertStatement01.setParameter("ceiling", getCeiling());
        insertStatement01.setParameter("wall", getWall());
        insertStatement01.setParameter("lfloor", getLfloor());
        insertStatement01.setParameter("door", getDoor());
        insertStatement01.setParameter("doorlock", getDoorlock());
        insertStatement01.setParameter("windows", getWindows());
        insertStatement01.setParameter("antenna", getAntenna());
        insertStatement01.setParameter("light", getLight());
        insertStatement01.setParameter("lswitch", getLswitch());
        insertStatement01.setParameter("jack", getJack());
        insertStatement01.setParameter("casement", getCasement());
        insertStatement01.setParameter("cloaca", getCloaca());
        insertStatement01.setParameter("downcomer", getDowncomer());
        insertStatement01.setParameter("pipe", getPipe());
        insertStatement01.setParameter("dishpan", getDishpan());
        insertStatement01.setParameter("valve", getValve());
        insertStatement01.setParameter("tap", getTap());
        insertStatement01.setParameter("stool", getStool());
        insertStatement01.setParameter("gaspipe", getGaspipe());
        insertStatement01.setParameter("gasmeter", getGasmeter());
        insertStatement01.setParameter("watermeter", getWatermeter());
        insertStatement01.setParameter("ammeter", getAmmeter());
        insertStatement01.setParameter("powerbox", getPowerbox());
        insertStatement01.setParameter("airswitch", getAirswitch());
        insertStatement01.setParameter("interphone", getInterphone());
        insertStatement01.setParameter("doorbell", getDoorbell());
        insertStatement01.setParameter("gasnumber", getGasnumber());
        insertStatement01.setParameter("waternumber", getWaternumber());
        insertStatement01.setParameter("powernumber", getPowernumber());
        insertStatement01.setParameter("useridea", getUseridea());
        insertStatement01.setParameter("adminidea", getAdminidea());
        insertStatement01.setParameter("admin", getAdmin());
        insertStatement01.setParameter("delflag", getDelFlag());
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertStatement01.execute();
            setStatusCode(0x72e49);
            setStatusMessage("插入数据库成功");
        }
        catch(DataException dataexception)
        {
            setStatusMessage("插入数据库出错");
            setStatusCode(0x72e4a);
            throw dataexception;
        }
    }

    public void setAdmin(String s)
    {
        admin = s;
    }

    public void setAdminidea(String s)
    {
        adminidea = s;
    }

    public void setAirswitch(String s)
    {
        airswitch = s;
    }

    public void setAmmeter(String s)
    {
        ammeter = s;
    }

    public void setAntenna(String s)
    {
        antenna = s;
    }

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

    public void setCasement(String s)
    {
        casement = s;
    }

    public void setCeiling(String s)
    {
        ceiling = s;
    }

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

    public void setCheckdate(String s)
    {
        if(s.length() != 10)
            checkdate = null;
        else
            checkdate = Date.valueOf(s);
    }

    public void setCheckitem(String s)
    {
        checkitem = s;
    }

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

    public void setCloaca(String s)
    {
        cloaca = s;
    }

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

    public void setDishpan(String s)
    {
        dishpan = s;
    }

    public void setDoor(String s)
    {
        door = s;
    }

    public void setDoorbell(String s)
    {
        doorbell = s;
    }

    public void setDoorlock(String s)
    {
        doorlock = s;
    }

    public void setDowncomer(String s)
    {
        downcomer = s;
    }

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

    public void setGasmeter(String s)
    {
        gasmeter = s;
    }

    public void setGasnumber(String s)
    {
        if(s.equals(""))
            gasnumber = null;
        else
            gasnumber = new Integer(s);
    }

    public void setGaspipe(String s)
    {
        gaspipe = s;
    }

    public void setInsertSQL01(String s)
    {
        insertSQL01 = s;
    }

    public void setInterphone(String s)
    {
        interphone = s;
    }

    public void setJack(String s)
    {
        jack = s;
    }

    public void setLfloor(String s)
    {
        lfloor = s;
    }

    public void setLight(String s)
    {
        light = s;
    }

    public void setLswitch(String s)
    {
        lswitch = s;
    }

    public void setPipe(String s)
    {
        pipe = s;
    }

    public void setPowerbox(String s)
    {
        powerbox = s;
    }

    public void setPowernumber(String s)
    {
        if(s.equals(""))
            powernumber = null;
        else
            powernumber = new Integer(s);
    }

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

    public void setStool(String s)
    {
        stool = s;
    }

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

    public void setTap(String s)
    {
        tap = s;
    }

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

    public void setValve(String s)
    {
        valve = s;
    }

    public void setWall(String s)
    {
        wall = s;
    }

    public void setWatermeter(String s)
    {
        watermeter = s;
    }

    public void setWaternumber(String s)
    {
        if(s.equals(""))
            waternumber = null;
        else
            waternumber = new Integer(s);
    }

    public void setWindows(String s)
    {
        windows = s;
    }
}