📄 modifyroomexamdbbean.java
字号:
}
protected void initUpdate01()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
updateStatement01 = new SQLStatement();
updateStatement01.setConnection(connBean);
statementmetadata = updateStatement01.getMetaData();
statementmetadata.setSQL(getUpdateSQL01());
statementmetadata.addTable(getTableName());
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("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
updateStatement01.setParameter("subarea", getSubArea());
updateStatement01.setParameter("building", getBuilding());
updateStatement01.setParameter("stair", getStair());
updateStatement01.setParameter("floor", getFloor());
updateStatement01.setParameter("cell", getCell());
updateStatement01.setParameter("checkman", getCheckman());
updateStatement01.setParameter("checkdate", getCheckdate());
updateStatement01.setParameter("checkitem", getCheckitem());
updateStatement01.setParameter("ceiling", getCeiling());
updateStatement01.setParameter("wall", getWall());
updateStatement01.setParameter("lfloor", getLfloor());
updateStatement01.setParameter("door", getDoor());
updateStatement01.setParameter("doorlock", getDoorlock());
updateStatement01.setParameter("windows", getWindows());
updateStatement01.setParameter("antenna", getAntenna());
updateStatement01.setParameter("light", getLight());
updateStatement01.setParameter("lswitch", getLswitch());
updateStatement01.setParameter("jack", getJack());
updateStatement01.setParameter("casement", getCasement());
updateStatement01.setParameter("cloaca", getCloaca());
updateStatement01.setParameter("downcomer", getDowncomer());
updateStatement01.setParameter("pipe", getPipe());
updateStatement01.setParameter("dishpan", getDishpan());
updateStatement01.setParameter("valve", getValve());
updateStatement01.setParameter("tap", getTap());
updateStatement01.setParameter("stool", getStool());
updateStatement01.setParameter("gaspipe", getGaspipe());
updateStatement01.setParameter("gasmeter", getGasmeter());
updateStatement01.setParameter("watermeter", getWatermeter());
updateStatement01.setParameter("ammeter", getAmmeter());
updateStatement01.setParameter("powerbox", getPowerbox());
updateStatement01.setParameter("airswitch", getAirswitch());
updateStatement01.setParameter("interphone", getInterphone());
updateStatement01.setParameter("doorbell", getDoorbell());
updateStatement01.setParameter("gasnumber", getGasnumber());
updateStatement01.setParameter("waternumber", getWaternumber());
updateStatement01.setParameter("powernumber", getPowernumber());
updateStatement01.setParameter("useridea", getUseridea());
updateStatement01.setParameter("adminidea", getAdminidea());
updateStatement01.setParameter("admin", getAdmin());
updateStatement01.setParameter("number", new Integer(getNumber1()));
}
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 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 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 setMagicindex(String s)
{
magicindex = s;
}
public void setNumber1(String s)
{
number1 = s;
}
public void setPagecount(String s)
{
pagecount = s;
}
public void setPageindex(String s)
{
pageindex = 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 setRetrievecom(String s)
{
retrievecom = s;
}
public void setRetrievecon(String s)
{
retrievecon = s;
}
public void setRetrieveindex(String s)
{
retrieveindex = s;
}
public void setSelectnum(String s)
{
selectnum = 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 setUpdateSQL01(String s)
{
updateSQL01 = 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;
}
public void update01()
throws Exception
{
try
{
initUpdate01();
updateStatement01.execute();
setStatusCode(0x72f11);
setStatusMessage("修改成功");
}
catch(DataException dataexception)
{
setStatusCode(0x72f12);
setStatusMessage("修改失败");
switch(dataexception.getErrorCode())
{
default:
throw dataexception;
case 214:
break;
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -