📄 modifybuilddbbean.java
字号:
statementmetadata.addParameter("buildingname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("btype", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("buse", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("doorcount", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("structure", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("height", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("floorcount", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("startdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("enddate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("developer", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("architecture", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("takearea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("architecturearea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("usingarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("virescencearea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cellcount", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("salerate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("hirerate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("handover", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("handoverdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("handoverman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("remark", 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("buildingnumb", getBuildingnumb());
updateStatement01.setParameter("subareanumb", getSubareanumb());
updateStatement01.setParameter("buildingname", getBuildingname());
updateStatement01.setParameter("btype", getBtype());
updateStatement01.setParameter("buse", getBuse());
updateStatement01.setParameter("doorcount", getDoorcount());
updateStatement01.setParameter("structure", getStructure());
updateStatement01.setParameter("height", getHeight());
updateStatement01.setParameter("floorcount", getFloorcount());
updateStatement01.setParameter("startdate", getStartdate());
updateStatement01.setParameter("enddate", getEnddate());
updateStatement01.setParameter("developer", getDeveloper());
updateStatement01.setParameter("architecture", getArchitecture());
updateStatement01.setParameter("takearea", getTakearea());
updateStatement01.setParameter("architecturearea", getArchitecturearea());
updateStatement01.setParameter("usingarea", getUsingarea());
updateStatement01.setParameter("virescencearea", getVirescencearea());
updateStatement01.setParameter("cellcount", getCellcount());
updateStatement01.setParameter("salerate", getSalerate());
updateStatement01.setParameter("hirerate", getHirerate());
updateStatement01.setParameter("handover", getHandover());
updateStatement01.setParameter("handoverdate", getHandoverdate());
updateStatement01.setParameter("handoverman", getHandoverman());
updateStatement01.setParameter("remark", getRemark());
updateStatement01.setParameter("number", new Integer(getNumber1()));
}
protected void initUpdate02()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
updateStatement02 = new SQLStatement();
updateStatement02.setConnection(connBean);
statementmetadata = updateStatement02.getMetaData();
statementmetadata.setSQL(getUpdateSQL02());
statementmetadata.addTable(getTableName());
if(getUpdContent().trim().equals("1"))
{
statementmetadata.addParameter("piccontent", array$B == null ? (array$B = class$("[B")) : array$B, -4);
statementmetadata.addParameter("picname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
}
statementmetadata.addParameter("picdescribe", 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);
if(getUpdContent().trim().equals("1"))
{
updateStatement02.setParameter("piccontent", getPicture());
updateStatement02.setParameter("picname", getFileName());
}
updateStatement02.setParameter("picdescribe", getPicdescribe());
updateStatement02.setParameter("number", new Integer(getFileNumber()));
}
public void insert03()
throws Exception
{
try
{
initInsert03();
insertStatement03.execute();
setStatusCode(1044);
setStatusMessage("修改楼宇资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1045);
setStatusMessage("修改楼宇资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage() + dataexception);
}
}
public void select01()
throws Exception
{
try
{
initSelect01();
selectStatement01.execute();
result = selectStatement01.getResult();
if(result.getColumnValueToString(1) == null)
{
setStatusCode(1020);
} else
{
setStatusCode(1019);
setStatusMessage("你所修改的楼宇编号已存在，请验证后再操作！");
}
}
catch(DataException dataexception)
{
setStatusCode(1060);
setStatusMessage("检索楼宇资料失败！" + dataexception.getMessage());
}
}
public void setArchitecture(String s)
{
architecture = s;
}
public void setArchitecturearea(String s)
{
architecturearea = s;
}
public void setBtype(String s)
{
btype = s;
}
public void setBuildingname(String s)
{
buildingname = s;
}
public void setBuildingnumb(String s)
{
buildingnumb = s;
}
public void setBuse(String s)
{
buse = s;
}
public void setCellcount(String s)
{
cellcount = s;
}
public void setDeleteSQL04(String s)
{
deleteSQL04 = s;
}
public void setDeveloper(String s)
{
developer = s;
}
public void setDoorcount(String s)
{
doorcount = s;
}
public void setEnddate(String s)
{
enddate = s;
}
public void setFileName(String s)
{
fileName = s;
}
public void setFileNumber(String s)
{
fileNumber = s;
}
public void setFilePath(String s)
{
filePath = s;
}
public void setFloorcount(String s)
{
floorcount = s;
}
public void setHandover(String s)
{
handover = s;
}
public void setHandoverdate(String s)
{
handoverdate = s;
}
public void setHandoverman(String s)
{
handoverman = s;
}
public void setHeight(String s)
{
height = s;
}
public void setHirerate(String s)
{
hirerate = s;
}
public void setInsertSQL03(String s)
{
insertSQL03 = s;
}
public void setNumber1(String s)
{
number1 = s;
}
public void setPicdescribe(String s)
{
picdescribe = s;
}
public void setPicture(byte abyte0[])
{
picture = abyte0;
}
public void setRemark(String s)
{
remark = s;
}
public void setSalerate(String s)
{
salerate = s;
}
public void setSelectSQL01(String s)
{
selectSQL01 = s;
}
public void setStartdate(String s)
{
startdate = s;
}
public void setStrcuture(String s)
{
structure = s;
}
public void setSubareanumb(String s)
{
subareanumb = s;
}
public void setTakearea(String s)
{
takearea = s;
}
public void setUpdContent(String s)
{
updContent = s;
}
public void setUpdateSQL01(String s)
{
updateSQL01 = s;
}
public void setUpdateSQL02(String s)
{
updateSQL02 = s;
}
public void setUsingarea(String s)
{
usingarea = s;
}
public void setVirescencearea(String s)
{
virescencearea = s;
}
public void update01()
throws Exception
{
try
{
initUpdate01();
updateStatement01.execute();
setStatusCode(1044);
setStatusMessage("修改楼宇资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1045);
setStatusMessage("修改楼宇资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage());
}
}
public void update02()
throws Exception
{
try
{
initUpdate02();
updateStatement02.execute();
setStatusCode(1044);
setStatusMessage("修改楼宇资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1045);
setStatusMessage("修改楼宇资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage() + dataexception);
}
}
public void update04()
throws Exception
{
try
{
initDelete04();
deleteStatement04.execute();
setStatusCode(1044);
setStatusMessage("修改楼宇资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1045);
setStatusMessage("修改楼宇资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage() + dataexception);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -