📄 countgasfeedbbean.java
字号:
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("subareanumb", 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("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cycle", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement04.setParameter("subareanumb", getSubareanumb());
selectStatement04.setParameter("buildingnumb", getBuildingnumb());
selectStatement04.setParameter("doornumb", getDoornumb());
selectStatement04.setParameter("floornumb", getFloornumb());
selectStatement04.setParameter("cellnumb", getCellnumb());
selectStatement04.setParameter("cycle", new Integer(getFeecycle()));
statementmetadata.addColumn("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect05()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement05 = new SelectStatement();
selectStatement05.setConnection(connBean);
statementmetadata = selectStatement05.getMetaData();
statementmetadata.setSQL(getSelectSQL05());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("subareanumb", 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("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cycle", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement05.setParameter("subareanumb", getSubareanumb());
selectStatement05.setParameter("buildingnumb", getBuildingnumb());
selectStatement05.setParameter("doornumb", getDoornumb());
selectStatement05.setParameter("floornumb", getFloornumb());
selectStatement05.setParameter("cellnumb", getCellnumb());
selectStatement05.setParameter("cycle", new Integer(getFeecycle()));
statementmetadata.addColumn("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect06()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement06 = new SelectStatement();
selectStatement06.setConnection(connBean);
statementmetadata = selectStatement06.getMetaData();
statementmetadata.setSQL(getSelectSQL06());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("subareanumb", 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("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement06.setParameter("subareanumb", getSubareanumb());
selectStatement06.setParameter("buildingnumb", getBuildingnumb());
selectStatement06.setParameter("doornumb", getDoornumb());
selectStatement06.setParameter("floornumb", getFloornumb());
selectStatement06.setParameter("cellnumb", getCellnumb());
statementmetadata.addColumn("apparatus", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
}
public void initSelect07()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement07 = new SelectStatement();
selectStatement07.setConnection(connBean);
statementmetadata = selectStatement07.getMetaData();
statementmetadata.setSQL(getSelectSQL07());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cycle", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement07.setParameter("meternum", getMeternum());
selectStatement07.setParameter("cycle", new Integer(getFeecycle()));
statementmetadata.addColumn("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect08()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement08 = new SelectStatement();
selectStatement08.setConnection(connBean);
statementmetadata = selectStatement08.getMetaData();
statementmetadata.setSQL(getSelectSQL08());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cycle", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement08.setParameter("meternum", getMeternum());
selectStatement08.setParameter("cycle", new Integer(getFeecycle()));
statementmetadata.addColumn("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect09()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement09 = new SelectStatement();
selectStatement09.setConnection(connBean);
statementmetadata = selectStatement09.getMetaData();
statementmetadata.setSQL(getSelectSQL09());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cycle", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement09.setParameter("meternum", getMeternum());
selectStatement09.setParameter("cycle", new Integer(getFeecycle()));
statementmetadata.addColumn("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect10()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement10 = new SelectStatement();
selectStatement10.setConnection(connBean);
statementmetadata = selectStatement10.getMetaData();
statementmetadata.setSQL(getSelectSQL10());
statementmetadata.addTable(getTableName());
statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addColumn("flag2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addColumn("value1", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect15()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement15 = new SelectStatement();
selectStatement15.setConnection(connBean);
statementmetadata = selectStatement15.getMetaData();
statementmetadata.setSQL(getSelectSQL15());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement15.setParameter("cyclenum", new Integer(getFeecycle()));
statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
}
protected void initUpdate01()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
updateStatement01 = new SQLStatement();
updateStatement01.setConnection(connBean);
statementmetadata = updateStatement01.getMetaData();
statementmetadata.setSQL(getUpdate01());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("otherfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("allfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
updateStatement01.setParameter("otherfee", new Double(getOtherfee()));
updateStatement01.setParameter("allfee", new Double(getAllfee()));
updateStatement01.setParameter("number", new Integer(getBasefeenum()));
}
public void insert01()
throws Exception
{
try
{
initInsert01();
insertStatement01.execute();
setStatusMessage("插入数据库gasbasefeelog成功");
setStatusCode(8782);
}
catch(Exception exception)
{
setStatusMessage("插入数据库gasbasefeelog时发生错误--" + exception.getMessage());
setStatusCode(8783);
throw exception;
}
}
public void insert02()
throws Exception
{
try
{
initInsert02();
insertStatement02.execute();
setStatusMessage("插入数据库gasotherfeelog成功");
setStatusCode(8784);
}
catch(Exception exception)
{
setStatusMessage("插入数据库gasotherfeelog时发生错误--" + exception.getMessage());
setStatusCode(8785);
throw exception;
}
}
public void insert03()
throws Exception
{
try
{
initInsert03();
insertStatement03.execute();
setStatusMessage("插入数据库gasbasefeelog成功");
setStatusCode(8786);
}
catch(Exception exception)
{
setStatusMessage("插入数据库gasbasefeelog时发生错误--" + exception.getMessage());
setStatusCode(8787);
throw exception;
}
}
public void select01()
throws Exception
{
try
{
initSelect01();
selectStatement01.execute();
result = selectStatement01.getResult();
result.firstRow();
setStatusMessage("检索收费项目表成功");
setStatusCode(8732);
}
catch(DataException dataexception)
{
setStatusMessage("检索收费项目表出错");
setStatusCode(8733);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有煤气费每收费单位收取费用");
setStatusCode(8734);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select02()
throws Exception
{
try
{
initSelect02();
selectStatement02.execute();
result = selectStatement02.getResult();
result.firstRow();
setStatusMessage("检索入住记录表成功");
setStatusCode(8737);
}
catch(DataException dataexception)
{
setStatusMessage("检索入住记录表出错");
setStatusCode(8738);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("入住记录表住户入住信息");
setStatusCode(8739);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select03()
throws Exception
{
try
{
initSelect03();
selectStatement03.execute();
result = selectStatement03.getResult();
result.firstRow();
setStatusMessage("检索煤气表抄表记录本单元抄表记录成功");
setStatusCode(8743);
}
catch(DataException dataexception)
{
setStatusMessage("检索煤气表抄表记录本单元抄表记录出错");
setStatusCode(8744);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有本单元煤气表抄表记录");
setStatusCode(8745);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select04()
throws Exception
{
try
{
initSelect04();
selectStatement04.execute();
result = selectStatement04.getResult();
result.firstRow();
setStatusMessage("检索煤气表抄表记录本周期抄表读数成功");
setStatusCode(8748);
}
catch(DataException dataexception)
{
setStatusMessage("检索煤气表抄表记录本周期抄表读数出错");
setStatusCode(8749);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有煤气表抄表记录本周期抄表读数");
setStatusCode(8751);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select05()
throws Exception
{
try
{
initSelect05();
selectStatement05.execute();
result = selectStatement05.getResult();
result.firstRow();
setStatusMessage("检索煤气表抄表记录本周期前煤气表抄表读数最大数成功");
setStatusCode(8754);
}
catch(DataException dataexception)
{
setStatusMessage("检索煤气表抄表记录本周期前煤气表抄表读数最大数出错");
setStatusCode(8755);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有煤气表抄表记录本周期前煤气表抄表读数最大数");
setStatusCode(8756);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select06()
throws Exception
{
try
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -