📄 countelectricfeedbbean.java
字号:
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("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("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("otherfee", new Double(getOtherfee()));
insertStatement03.setParameter("allfee", new Double(getAllfee()));
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());
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("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
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 initSelect11()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement11 = new SelectStatement();
selectStatement11.setConnection(connBean);
statementmetadata = selectStatement11.getMetaData();
statementmetadata.setSQL(getSelectSQL11());
statementmetadata.addTable(getTableName());
statementmetadata.addColumn("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("flag1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
}
public void initSelect12()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement12 = new SelectStatement();
selectStatement12.setConnection(connBean);
statementmetadata = selectStatement12.getMetaData();
statementmetadata.setSQL(getSelectSQL12());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement12.setParameter("meternum", getMeternum());
statementmetadata.addColumn("lmeternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
}
public void initSelect13()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement13 = new SelectStatement();
selectStatement13.setConnection(connBean);
statementmetadata = selectStatement13.getMetaData();
statementmetadata.setSQL(getSelectSQL13());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement13.setParameter("meternum", getMeternum());
statementmetadata.addColumn("flag1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
}
public void initSelect14()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement14 = new SelectStatement();
selectStatement14.setConnection(connBean);
statementmetadata = selectStatement14.getMetaData();
statementmetadata.setSQL(getSelectSQL14());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("meternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement14.setParameter("meternum", getMeternum());
statementmetadata.addColumn("lmeternum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
}
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);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -