📄 modifycelldbbean.java
字号:
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("floortype", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("use", 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("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("direction", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("bedroom", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("hall", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("loo", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cookroom", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("balcony", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("else", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("addfixture", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("candr", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("crdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("useflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("price", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("paymentway", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("paycontent", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("enterdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("fitment", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("owner", 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("cellnumb", getCellnumb());
updateStatement01.setParameter("floortype", getFloortype());
updateStatement01.setParameter("floornumb", getFloornumb());
updateStatement01.setParameter("doornumb", getDoornumb());
updateStatement01.setParameter("buildingnumb", getBuildingnumb());
updateStatement01.setParameter("subareanumb", getSubareanumb());
updateStatement01.setParameter("use", getUse());
updateStatement01.setParameter("structure", getStructure());
updateStatement01.setParameter("architecturearea", getArchitecturearea());
updateStatement01.setParameter("usingarea", getUsingarea());
updateStatement01.setParameter("direction", getDirection());
updateStatement01.setParameter("bedroom", getBedroom());
updateStatement01.setParameter("hall", getHall());
updateStatement01.setParameter("loo", getLoo());
updateStatement01.setParameter("cookroom", getCookroom());
updateStatement01.setParameter("balcony", getBalcony());
updateStatement01.setParameter("else", getElseroom());
updateStatement01.setParameter("addfixture", getAddfixture());
updateStatement01.setParameter("candr", getCandr());
updateStatement01.setParameter("crdate", getCrdate());
updateStatement01.setParameter("useflag", getUseflag());
updateStatement01.setParameter("price", getPrice());
updateStatement01.setParameter("paymentway", getPaymentway());
updateStatement01.setParameter("paycontent", getPaycontent());
updateStatement01.setParameter("enterdate", getEnterdate());
updateStatement01.setParameter("fitment", getFitment());
updateStatement01.setParameter("owner", getOwner());
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(1046);
setStatusMessage("修改单元资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1047);
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(1101);
} else
{
setStatusCode(1102);
setStatusMessage("你所修改的单元资料已存在，请验证后再操作！");
}
}
catch(DataException dataexception)
{
setStatusCode(1068);
setStatusMessage("检索单元资料失败！" + dataexception.getMessage());
}
}
public void setAddfixture(String s)
{
addfixture = s;
}
public void setArchitecturearea(String s)
{
architecturearea = s;
}
public void setBalcony(String s)
{
balcony = s;
}
public void setBedroom(String s)
{
bedroom = s;
}
public void setBuildingnumb(String s)
{
buildingnumb = s;
}
public void setCandr(String s)
{
candr = s;
}
public void setCellnumb(String s)
{
cellnumb = s;
}
public void setCookroom(String s)
{
cookroom = s;
}
public void setCrdate(String s)
{
crdate = s;
}
public void setDeleteSQL04(String s)
{
deleteSQL04 = s;
}
public void setDirection(String s)
{
direction = s;
}
public void setDoornumb(String s)
{
doornumb = s;
}
public void setElseroom(String s)
{
elseroom = s;
}
public void setEnterdate(String s)
{
enterdate = s;
}
public void setFileName(String s)
{
fileName = s;
}
public void setFileNumber(String s)
{
fileNumber = s;
}
public void setFilePath(String s)
{
filePath = s;
}
public void setFitment(String s)
{
fitment = s;
}
public void setFloornumb(String s)
{
floornumb = s;
}
public void setFloortype(String s)
{
floortype = s;
}
public void setHall(String s)
{
hall = s;
}
public void setInsertSQL03(String s)
{
insertSQL03 = s;
}
public void setLoo(String s)
{
loo = s;
}
public void setNumber1(String s)
{
number1 = s;
}
public void setOwner(String s)
{
owner = s;
}
public void setPaycontent(String s)
{
paycontent = s;
}
public void setPaymentway(String s)
{
paymentway = s;
}
public void setPicdescribe(String s)
{
picdescribe = s;
}
public void setPicture(byte abyte0[])
{
picture = abyte0;
}
public void setPrice(String s)
{
price = s;
}
public void setRemark(String s)
{
remark = s;
}
public void setSelectSQL01(String s)
{
selectSQL01 = s;
}
public void setStructure(String s)
{
structure = s;
}
public void setSubareanumb(String s)
{
subareanumb = s;
}
public void setUpdContent(String s)
{
updContent = s;
}
public void setUpdateSQL01(String s)
{
updateSQL01 = s;
}
public void setUpdateSQL02(String s)
{
updateSQL02 = s;
}
public void setUse(String s)
{
use = s;
}
public void setUseflag(String s)
{
useflag = s;
}
public void setUsingarea(String s)
{
usingarea = s;
}
public void update01()
throws Exception
{
try
{
initUpdate01();
updateStatement01.execute();
setStatusCode(1046);
setStatusMessage("修改单元资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1047);
setStatusMessage("修改单元资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage());
}
}
public void update02()
throws Exception
{
try
{
initUpdate02();
updateStatement02.execute();
setStatusCode(1046);
setStatusMessage("修改单元资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1047);
setStatusMessage("修改单元资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage() + dataexception);
}
}
public void update04()
throws Exception
{
try
{
initDelete04();
deleteStatement04.execute();
setStatusCode(1046);
setStatusMessage("修改单元资料成功");
}
catch(DataException dataexception)
{
setStatusCode(1047);
setStatusMessage("修改单元资料失败" + dataexception.getMessage());
throw new Exception(getStatusMessage() + dataexception);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -