📄 countwaterfeedbbean.java
字号:
for(int i = 0; i < result.getNumRowsInCache(); i++)
{
result.setCurrentRow(i + 1);
vecZ1.addElement(result.getColumnValueToString("meterdata").trim());
}
}
catch(DataException dataexception)
{
setStatusCode(8693);
setStatusMessage("从水表抄表记录获取本周期前水表抄表读数最大数时出错");
throw new Exception(getStatusMessage() + dataexception);
}
finally
{
closeResultSet();
}
}
public void getDataFromResult10()
throws Exception
{
try
{
for(int i = 0; i < result.getNumRowsInCache(); i++)
{
result.setCurrentRow(i + 1);
vecS1.addElement(result.getColumnValueToString("number").trim());
vecS2.addElement(result.getColumnValueToString("flag2").trim());
vecS3.addElement(result.getColumnValueToString("value1").trim());
}
}
catch(DataException dataexception)
{
setStatusCode(8697);
setStatusMessage("从分摊项目表获取本期水费分摊项目信息时出错");
throw new Exception(getStatusMessage() + dataexception);
}
finally
{
closeResultSet();
}
}
public void getDataFromResult15()
throws Exception
{
try
{
for(int i = 0; i < result.getNumRowsInCache(); i++)
{
result.setCurrentRow(i + 1);
vecCount.addElement(result.getColumnValueToString("number").trim());
}
}
catch(DataException dataexception)
{
setStatusCode(8711);
setStatusMessage("保存检索水费基本表结果数据时出错");
throw new Exception(getStatusMessage() + dataexception);
}
finally
{
closeResultSet();
}
}
public String getDelflag()
{
return delflag;
}
public String getDoornumb()
{
return doornumb;
}
public String getFeecycle()
{
return feecycle;
}
public String getFeename()
{
return feename;
}
public String getFlag1()
{
return flag1;
}
public String getFloornumb()
{
return floornumb;
}
public String getInsertSQL01()
{
return insertSQL01;
}
public String getInsertSQL02()
{
return insertSQL02;
}
public String getInsertSQL03()
{
return insertSQL03;
}
public String getItemfee()
{
return itemfee;
}
public String getItemnum()
{
return itemnum;
}
public String getMeterdata()
{
return meterdata;
}
public String getMeternum()
{
return meternum;
}
public String getOtherfee()
{
return otherfee;
}
public String getSelectSQL01()
{
return selectSQL01;
}
public String getSelectSQL02()
{
return selectSQL02;
}
public String getSelectSQL03()
{
return selectSQL03;
}
public String getSelectSQL04()
{
return selectSQL04;
}
public String getSelectSQL05()
{
return selectSQL05;
}
public String getSelectSQL06()
{
return selectSQL06;
}
public String getSelectSQL07()
{
return selectSQL07;
}
public String getSelectSQL08()
{
return selectSQL08;
}
public String getSelectSQL09()
{
return selectSQL09;
}
public String getSelectSQL10()
{
return selectSQL10;
}
public String getSelectSQL15()
{
return selectSQL15;
}
public String getSubareanumb()
{
return subareanumb;
}
public String getUpdate01()
{
return updateSQL01;
}
protected void initInsert01()
throws DataException, IOException
{
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("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("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addParameter("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("basefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("flag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("cashflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
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("subareanumb", getSubareanumb());
insertStatement01.setParameter("buildingnumb", getBuildingnumb());
insertStatement01.setParameter("doornumb", getDoornumb());
insertStatement01.setParameter("floornumb", getFloornumb());
insertStatement01.setParameter("cellnumb", getCellnumb());
insertStatement01.setParameter("cyclenum", new Integer(getFeecycle()));
insertStatement01.setParameter("meterdata", new Double(getMeterdata()));
insertStatement01.setParameter("basefee", new Double(getBasefee()));
insertStatement01.setParameter("flag", getFlag1());
insertStatement01.setParameter("cashflag", getCashflag());
insertStatement01.setParameter("delflag", getDelflag());
}
protected void initInsert02()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
insertStatement02 = new SQLStatement();
insertStatement02.setConnection(connBean);
statementmetadata = insertStatement02.getMetaData();
statementmetadata.setSQL(getInsertSQL02());
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("basefeenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addParameter("itemnum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addParameter("itemfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
insertStatement02.setParameter("number", new Integer(getNumber()));
insertStatement02.setParameter("basefeenum", new Integer(getBasefeenum()));
insertStatement02.setParameter("itemnum", new Integer(getItemnum()));
insertStatement02.setParameter("itemfee", new Double(getItemfee()));
insertStatement02.setParameter("delflag", getDelflag());
}
protected void initInsert03()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
insertStatement03 = new SQLStatement();
insertStatement03.setConnection(connBean);
statementmetadata = insertStatement03.getMetaData();
statementmetadata.setSQL(getInsertSQL03());
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("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("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addParameter("meterdata", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("basefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("flag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("cashflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
insertStatement03.setParameter("number", new Integer(getNumber()));
insertStatement03.setParameter("subareanumb", getSubareanumb());
insertStatement03.setParameter("buildingnumb", getBuildingnumb());
insertStatement03.setParameter("doornumb", getDoornumb());
insertStatement03.setParameter("floornumb", getFloornumb());
insertStatement03.setParameter("cellnumb", getCellnumb());
insertStatement03.setParameter("meternum", getMeternum());
insertStatement03.setParameter("cyclenum", new Integer(getFeecycle()));
insertStatement03.setParameter("meterdata", new Double(getMeterdata()));
insertStatement03.setParameter("basefee", new Double(getBasefee()));
insertStatement03.setParameter("flag", getFlag1());
insertStatement03.setParameter("cashflag", getCashflag());
insertStatement03.setParameter("delflag", getDelflag());
}
public void initSelect01()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement01 = new SelectStatement();
selectStatement01.setConnection(connBean);
statementmetadata = selectStatement01.getMetaData();
statementmetadata.setSQL(getSelectSQL01());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("feename", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement01.setParameter("feename", getFeename());
statementmetadata.addColumn("feestandard", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
}
public void initSelect02()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement02 = new SelectStatement();
selectStatement02.setConnection(connBean);
statementmetadata = selectStatement02.getMetaData();
statementmetadata.setSQL(getSelectSQL02());
statementmetadata.addTable(getTableName());
statementmetadata.addColumn("subarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("building", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("stair", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("floor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("cell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
}
public void initSelect03()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement03 = new SelectStatement();
selectStatement03.setConnection(connBean);
statementmetadata = selectStatement03.getMetaData();
statementmetadata.setSQL(getSelectSQL03());
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);
selectStatement03.setParameter("subareanumb", getSubareanumb());
selectStatement03.setParameter("buildingnumb", getBuildingnumb());
selectStatement03.setParameter("doornumb", getDoornumb());
selectStatement03.setParameter("floornumb", getFloornumb());
selectStatement03.setParameter("cellnumb", getCellnumb());
selectStatement03.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 initSelect04()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement04 = new SelectStatement();
selectStatement04.setConnection(connBean);
statementmetadata = selectStatement04.getMetaData();
statementmetadata.setSQL(getSelectSQL04());
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -